From: Roland N Verrier <verrier@oneworldsolution2by2.mb.ca>
To: PostgreSQL PgAccess <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] PGACCESS formdemo.sql
Date: Wed, 08 Sep 1999 21:55:20 -0500
Message-ID: <37D72197.57403879@oneworldsolution2by2.mb.ca> (raw)
References: <000701bef9b9$1bb89460$399ec8cd@default>
<19990908102630.C24655@wallace.ece.rice.edu>
<37D6EE7B.900F50B4@wpcusrgrp.org>
<!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? 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 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>
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: verrier@oneworldsolution2by2.mb.ca
Subject: Re: [INTERFACES] PGACCESS formdemo.sql
In-Reply-To: <37D72197.57403879@oneworldsolution2by2.mb.ca>
* 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