Re: [INTERFACES] PGACCESS formdemo.sql - Mailing list pgsql-interfaces

From Roland N Verrier
Subject Re: [INTERFACES] PGACCESS formdemo.sql
Date
Msg-id 37D72197.57403879@oneworldsolution2by2.mb.ca
Whole thread Raw
In response to Re: [INTERFACES] PGACCESS formdemo.sql  ("Mark Gaschermann" <mgascherma@wpcusrgrp.org>)
Responses Re: [INTERFACES] PGACCESS formdemo.sql
List pgsql-interfaces
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> 

pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] firewall crashes backend
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: [INTERFACES] PGACCESS formdemo.sql