From: Constantin Teodorescu <teo@flex.ro>
To: sferac@bo.nettuno.it
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] pgaccess: I can't save a view
Date: Sat, 14 Mar 1998 14:23:54 +0200
Message-ID: <350A76DA.5F7A9B0A@flex.ro> (raw)
References: <Pine.LNX.3.96.980313173258.1783F-100000@nero>
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.gzftp://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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: teo@flex.ro, sferac@bo.nettuno.it
Subject: Re: [INTERFACES] pgaccess: I can't save a view
In-Reply-To: <350A76DA.5F7A9B0A@flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox