Date: Thu, 9 Sep 1999 00:01:13 -0500
From: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
To: Mark Gaschermann <mgascherma@wpcusrgrp.org>
Cc: Roland N Verrier <verrier@oneworldsolution2by2.mb.ca>,
	PostgreSQL PgAccess <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] PGACCESS formdemo.sql
Message-ID: <19990909000113.C3982@wallace.ece.rice.edu>
References: <000701bef9b9$1bb89460$399ec8cd@default>
	<19990908102630.C24655@wallace.ece.rice.edu>
	<37D6EE7B.900F50B4@wpcusrgrp.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
In-Reply-To: <37D6EE7B.900F50B4@wpcusrgrp.org>;
	from Mark Gaschermann on Wed, Sep 08, 1999 at 06:17:15PM -0500

On Wed, Sep 08, 1999 at 06:17:15PM -0500, Mark Gaschermann wrote:
> 
> > > 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'); 

This one's it. The processing of class names when passed as arguments
to a function changed, to deal with the MiXeDCase problem.  The CREATE
SEQUENCE should work fine either way.

Ross
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005