Re: pgaccess: I can't save a view - Mailing list pgsql-interfaces

From sferac@bo.nettuno.it
Subject Re: pgaccess: I can't save a view
Date
Msg-id Pine.LNX.3.96.980313173258.1783F-100000@nero
Whole thread Raw
List 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'



pgsql-interfaces by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [QUESTIONS] PostgreSQL 6.3
Next
From: Constantin Teodorescu
Date:
Subject: Re: [INTERFACES] Re: pgaccess: I can't save a view