Thread: Re: pgaccess: I can't save a view

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'

sferac@bo.nettuno.it wrote:
>
> 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:

Hmmmmm.... strange

Send me a pg_dump on that table.
PostgreSQL version ? Tcl/Tk version ? PgAccess version ?

--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

sferac@bo.nettuno.it wrote:
>
> 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'
>            -----------------------------------------------

It is true.

A simple bug that has not been detected since now.
A new version that fixed that bug is available

http://www.flex.ro/pgaccess/pgaccess-0.84.tar.gz
ftp://ftp.flex.ro/pgaccess/pgaccess-0.84.tar.gz

In this distribution is also present a dumped database for demo called
formdemo.sql.
Create your own demo database :
$ createdb mydemo
$ psql -e mydemo <formdemo.sql

There is a query of that form that can be saved as a view, now.
Remember, since the view is a PostgreSQL object, it's name *MUST* have
no spaces inside.


Jose, thanks for your help,

--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA