Received: from flex.flex.ro (flex.flex.ro [193.230.255.2]) by hub.org
	(8.8.8/8.7.5) with ESMTP id HAA06651 for
	<pgsql-interfaces@postgreSQL.org>;
	Sat, 14 Mar 1998 07:18:34 -0500 (EST)
Received: from flex.flex.ro (localhost [127.0.0.1]) by flex.flex.ro
	(8.8.8/8.7.3) with SMTP id OAA00726; Sat, 14 Mar 1998 14:23:55 +0200
Sender: teo@flex.flex.ro
Message-ID: <350A76DA.5F7A9B0A@flex.ro>
Date: Sat, 14 Mar 1998 14:23:54 +0200
From: Constantin Teodorescu <teo@flex.ro>
Organization: FLEX Consulting Braila
X-Mailer: Mozilla 3.04Gold (X11; I; Linux 2.0.32 i586)
MIME-Version: 1.0
To: sferac@bo.nettuno.it
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] pgaccess: I can't save a view
References: <Pine.LNX.3.96.980313173258.1783F-100000@nero>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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