Question/problem with create view and restore a backup with such a view

From: Franz(dot)Rasper(at)izb(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: Question/problem with create view and restore a backup with such a view
Date: 2005-10-14 16:06:14
Message-ID: D30121FCD4ADD51181D10002A587391608A04902@M0000S0E
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

i have following situation:

Postgres 7.2.1 (Debian woody)

I created a view (look into the attached file, the file was converted with
nedit from unix to windows )
and if I paste it into psql it works. I can also do a select on this view
(it works and is correct).

But if a want to restore a backup of this view it doesnt work.
(backup was done with pg_dump, restore with pg_restore or cat file | psql
database ).

So i decided to look at the definition of this view with \d viewname and try
to put this
output into psql and I got the following error message:

ERROR: parser: parse error at or near "SELECT"

I already wrote an small awk programme and relpaced " " by "\n" removed
all empty lines and compared the two output files with vimdiff, but I have
not found the error.

What is the best way to compare such sql statement in postgres ?
Any very special DEBUG switch at psql or statement in the postgresql.conf ?

Thanks in advance.
Best regards,

-Franz

<<createview.sql>>

Attachment Content-Type Size
createview.sql application/octet-stream 4.3 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-10-14 16:16:36 Re: On "multi-master"
Previous Message Andrew Sullivan 2005-10-14 15:54:36 Re: On "multi-master"