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:
<blockquotetype="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
pgAccessI 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'musing the formdemo.sql that came with the downloaded v 0.98 <br />> > <br />> <br />> What version of
PostgreSQLare you using? <p>I'm using the version that came on RedHat 6.0 , postgres 6.4.2-3. <p>I was fiddling around
withthe 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'mguessing maybe it's due to my having an older version of Postgres??? <p>Mark G</blockquote>