<!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>