From: | sferac(at)bo(dot)nettuno(dot)it |
---|---|
To: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: pgaccess: I can't save a view |
Date: | 1998-03-13 17:33:11 |
Message-ID: | Pine.LNX.3.96.980313173258.1783F-100000@nero |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hi,
There's an error generated by parser when I try to save a view as:
SELECT * FROM table_name WHERE column_name = 'VALUE'
If I push <Save query definition> button I have this error message:
-----------------------------------------------
error defining view
ERROR: parser: parse error at or near 'VALUE'
-----------------------------------------------
If I push <Execute query> button it works, but I can't save it as a view
... it saves views with only if is not present the WHERE clause, like this:
SELECT comlumn_1 FROM table_name
Ciao, Jose'
From | Date | Subject | |
---|---|---|---|
Next Message | Constantin Teodorescu | 1998-03-13 19:27:16 | Re: [INTERFACES] Re: pgaccess: I can't save a view |
Previous Message | The Hermit Hacker | 1998-03-13 13:07:45 | Re: [QUESTIONS] PostgreSQL 6.3 |