Received: from alien.wpcusrgrp.org (alien.wpcusrgrp.org [205.200.158.11])
	by hub.org (8.9.3/8.9.3) with ESMTP id WAA58629
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 8 Sep 1999 22:43:36 -0400 (EDT)
	(envelope-from verrier@oneworldsolution2by2.mb.ca)
Received: from oneworldsolution2by2.mb.ca (port11.wpcusrgrp.org
	[205.200.158.61])
	by alien.wpcusrgrp.org (8.8.7/8.8.7) with ESMTP id UAA16617
	for <pgsql-interfaces@postgreSQL.org>; Wed, 8 Sep 1999 20:49:07 -0500
Message-ID: <37D72197.57403879@oneworldsolution2by2.mb.ca>
Date: Wed, 08 Sep 1999 21:55:20 -0500
From: Roland N Verrier <verrier@oneworldsolution2by2.mb.ca>
Organization: http://www.OneWorldSolution2By2.MB.Ca
X-Mailer: Mozilla 4.5 [en]C-DIAL  (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
To: PostgreSQL PgAccess <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] PGACCESS formdemo.sql
References: <000701bef9b9$1bb89460$399ec8cd@default>
	<19990908102630.C24655@wallace.ece.rice.edu>
	<37D6EE7B.900F50B4@wpcusrgrp.org>
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Mark,
<br>Ross,
<br>I have Red Hat 6.0 and I've installed PostgreSQL 6.4.2-6, and have
the same problem as Mark?
<br>So, I guess we need PostgreSQL 6.5.1, or is there a different correction?
<br>Roland
<p>Mark Gaschermann wrote:
<blockquote TYPE=CITE>> > pg_aclcheck:class ""cities_id_seq"" not found
<br>> > pg_ownercheck:class "cities" not found
<br>> > error: cities: table does not exist
<br>> >
<br>> > After starting pgAccess I can open forms, see the phonebook table
and it's
<br>> > data, etc, but when I try to open the Schema, I get the error that
cities
<br>> > table does not exist.
<br>> >
<br>> > Any ideas?&nbsp; I'm using the formdemo.sql that came with the
downloaded v 0.98
<br>> >
<br>>
<br>> What version of PostgreSQL are you using?
<p>I'm using the version that came on RedHat 6.0 , postgres 6.4.2-3.
<p>I was fiddling around with the formdemo.sql file and found that if I
<br>removed the double quotes from around all occurences of "cities_id_seq"
<br>the tables were created properly.
<br>ie. changed CREATE SEQUENCE "cities_id_seq" to&nbsp; CREATE SEQUENCE
<br>cities_id_seq
<br>and SELECT nextval ('"cities_id_seq"'); to SELECT nextval
<br>('cities_id_seq');
<p>I'm guessing maybe it's due to my having an older version of Postgres???
<p>Mark G</blockquote>
</html>