Sender: markg@alien.wpcusrgrp.org
Message-ID: <37D6EE7B.900F50B4@wpcusrgrp.org>
Date: Wed, 08 Sep 1999 18:17:15 -0500
From: Mark Gaschermann <mgascherma@wpcusrgrp.org>
MIME-Version: 1.0
To: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
CC: Roland N Verrier <verrier@oneworldsolution2by2.mb.ca>,
	PostgreSQL PgAccess <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] PGACCESS formdemo.sql
References: <000701bef9b9$1bb89460$399ec8cd@default>
	<19990908102630.C24655@wallace.ece.rice.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


> > pg_aclcheck:class ""cities_id_seq"" not found
> > pg_ownercheck:class "cities" not found
> > error: cities: table does not exist
> >
> > After starting pgAccess I can open forms, see the phonebook table and it's
> > data, etc, but when I try to open the Schema, I get the error that cities
> > table does not exist.
> >
> > Any ideas?  I'm using the formdemo.sql that came with the downloaded v 0.98
> >
> 
> What version of PostgreSQL are you using?

I'm using the version that came on RedHat 6.0 , postgres 6.4.2-3.

I was fiddling around with the formdemo.sql file and found that if I
removed the double quotes from around all occurences of "cities_id_seq"
the tables were created properly.
ie. changed CREATE SEQUENCE "cities_id_seq" to  CREATE SEQUENCE
cities_id_seq 
and SELECT nextval ('"cities_id_seq"'); to SELECT nextval
('cities_id_seq'); 

I'm guessing maybe it's due to my having an older version of Postgres???

Mark G