From verrier@oneworldsolution2by2.mb.ca Sat Sep 4 01:52:34 1999 Received: from alien.wpcusrgrp.org (alien.wpcusrgrp.org [205.200.158.11]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA30233 for ; Fri, 3 Sep 1999 21:52:34 -0400 (EDT) (envelope-from verrier@oneworldsolution2by2.mb.ca) Received: from oneworldsolution2by2.mb.ca (port4.wpcusrgrp.org [205.200.158.54]) by alien.wpcusrgrp.org (8.8.7/8.8.7) with ESMTP id TAA03696 for ; Fri, 3 Sep 1999 19:49:59 -0500 Message-ID: <37D07D6C.6034BF55@oneworldsolution2by2.mb.ca> Date: Fri, 03 Sep 1999 21:01:16 -0500 From: Roland N Verrier 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 Subject: [INTERFACES] PGACCESS formdemo.sql Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Question for the Masters
This maybe a simple question, but how do you activate the sample demo, formdemo.sql in PgAccess.
~~~~~~
I have install on my Linux machine,
Red Hat 6.0
PostgreSQL v 6.4.2-6
PgAccess v 0.98, nice improvement
~~~~~~
Postmaster running, PgAccesss running
PgAccess v 0.98 is in /usr/local/pgaccess
Off the Web site it says, Create an empty database and psql your database <formdemo.sql
I have the template1 and other databases in /var/lib/pgsql/base
How do I make the connection with formdemo.sql and the base dir., if I create a new database, opened in PgAccess?
~~~~~~
Thanks, for Being Creators and Helpers From teo@flex.ro Sat Sep 4 06:09:40 1999 Received: from flex.flex.ro (IDENT:root@[193.230.255.4]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA73563 for ; Sat, 4 Sep 1999 02:09:40 -0400 (EDT) (envelope-from teo@flex.ro) Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3]) by flex.flex.ro (8.9.3/8.9.3) with ESMTP id JAA02949; Sat, 4 Sep 1999 09:10:22 +0300 Sender: teo@flex.flex.ro Message-ID: <37D0B92E.A9A00170@flex.ro> Date: Sat, 04 Sep 1999 06:16:14 +0000 From: Constantin Teodorescu Organization: FLEX Consulting Braila X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.12 i586) X-Accept-Language: en MIME-Version: 1.0 To: Roland N Verrier CC: PostgreSQL PgAccess Subject: Re: [INTERFACES] PGACCESS formdemo.sql References: <37D07D6C.6034BF55@oneworldsolution2by2.mb.ca> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Roland N Verrier wrote: > > Postmaster running, PgAccesss running > PgAccess v 0.98 is in /usr/local/pgaccess > Off the Web site it says, Create an empty database and psql your > database I have the template1 and other databases in /var/lib/pgsql/base > How do I make the connection with formdemo.sql and the base dir., if I > create a new database, opened in PgAccess? Let's say you are the Linux user roland on your computer. There is a postgres user , the master of PostgreSQL database server as the system administrator. Don't know the password for postgres user but you should assign one as root and then log in as postgres user. Then create a PostgreSQL user with the following command: $ createuser roland and follow the instructions there. Now you have a PostgreSQL user roland and you may create databases , other users and so on. As postgres linux user (or as roland) create and fill the formdemo database : $ createdb formdemo $ psql formdemo \d Then run PgAccess as : $ pgaccess formdemo or simply run PgAccess without parameter and the from the Database/Open menu, specify formdemo as your database, localhost to host, 5432 as port. Username and password may not be supplied if you are connecting to localhost. Enjoy, -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA From verrier@oneworldsolution2by2.mb.ca Sat Sep 4 15:25:48 1999 Received: from alien.wpcusrgrp.org (alien.wpcusrgrp.org [205.200.158.11]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA11028 for ; Sat, 4 Sep 1999 11:25:48 -0400 (EDT) (envelope-from verrier@oneworldsolution2by2.mb.ca) Received: from oneworldsolution2by2.mb.ca (port4.wpcusrgrp.org [205.200.158.54]) by alien.wpcusrgrp.org (8.8.7/8.8.7) with ESMTP id JAA26129 for ; Sat, 4 Sep 1999 09:23:31 -0500 Message-ID: <37D13CA1.F84081BF@oneworldsolution2by2.mb.ca> Date: Sat, 04 Sep 1999 10:37:05 -0500 From: Roland N Verrier 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 Subject: Re: [INTERFACES] PGACCESS formdemo.sql References: <37D07D6C.6034BF55@oneworldsolution2by2.mb.ca> <37D0B92E.A9A00170@flex.ro> Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Help
Concerning the the sample formdemo, ( formdemo.sql )
This demo file is in the ( /usr/local/pgaccess/demo/formdemo.sql ) directory, from the upgrade v 0.98.
Or you can download the ( formdemo.sql ) file only, from the PgAccess web site.
My question is, which directory do you put the ( formdemo.sql ) file.
So when you type
$ createdb formdemo
$ psql formdemo <formdemo.sql
I get no such file or directory
Thanks, Roland
 
 
Roland N Verrier wrote:
>
> Postmaster running, PgAccesss running
> PgAccess v 0.98 is in /usr/local/pgaccess
> Off the Web site it says, Create an empty database and psql your
> database <formdemo.sql
> I have the template1 and other databases in /var/lib/pgsql/base
> How do I make the connection with formdemo.sql and the base dir., if I
> create a new database, opened in PgAccess?
Constantin Teodorescu wrote:

Let's say you are the Linux user roland on your computer.

There is a postgres user , the master of PostgreSQL database server as
the system administrator.
Don't know the password for postgres user but you should assign one as
root and then log in as postgres user.
Then create a PostgreSQL user with the following command:

$ createuser roland

and follow the instructions there. Now you have a PostgreSQL user roland
and you may create databases , other users and so on.

As postgres linux user (or as roland) create and fill the formdemo
database :

$ createdb formdemo
$ psql formdemo <formdemo.sql

Now database formdemo should exist, check it with :

$ psql formdemo
formdemo=> \d

Then run PgAccess as :

$ pgaccess formdemo

or simply run PgAccess without parameter and the from the Database/Open
menu, specify formdemo as your database, localhost to host, 5432 as
port. Username and password may not be supplied if you are connecting to
localhost.

Enjoy,
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

From verrier@oneworldsolution2by2.mb.ca Sun Sep 5 01:14:14 1999 Received: from alien.wpcusrgrp.org ([205.200.158.11]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA77533 for ; Sat, 4 Sep 1999 21:14:14 -0400 (EDT) (envelope-from verrier@oneworldsolution2by2.mb.ca) Received: from oneworldsolution2by2.mb.ca (port6.wpcusrgrp.org [205.200.158.56]) by alien.wpcusrgrp.org (8.8.7/8.8.7) with ESMTP id TAA08705 for ; Sat, 4 Sep 1999 19:09:56 -0500 Message-ID: <37D1C5D5.153ED2FA@oneworldsolution2by2.mb.ca> Date: Sat, 04 Sep 1999 20:22:29 -0500 From: Roland N Verrier 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 Subject: Re: [INTERFACES] PGACCESS formdemo.sql Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Help
Concerning the the sample formdemo, ( formdemo.sql )
This demo file is in the ( /usr/local/pgaccess/demo/formdemo.sql ) directory, from the upgrade v 0.98.
Or you can download the ( formdemo.sql ) file only, from the PgAccess web site.
My question is, in which directory do you put the ( formdemo.sql ) database file in.
So when you type
# su - roland
$ createdb formdemo
$ psql formdemo <formdemo.sql
I get
bash: formdemo.sql: No such file or directory
~~~~~~~~~
I do get when I type
$ psql formdemo
Welcome etc.
formdemo=> \d
Then I get a table
~~~~~~
The formdemo.sql does not show up in PgAccess
I have other databases, tables and forms working in PgAccess?
Thanks, Roland

Constantin Teodorescu wrote:

Let's say you are the Linux user roland on your computer.

There is a postgres user , the master of PostgreSQL database server as
the system administrator.
Don't know the password for postgres user but you should assign one as
root and then log in as postgres user.
Then create a PostgreSQL user with the following command:

$ createuser roland

and follow the instructions there. Now you have a PostgreSQL user roland
and you may create databases , other users and so on.

As postgres linux user (or as roland) create and fill the formdemo
database :

$ createdb formdemo
$ psql formdemo <formdemo.sql

Now database formdemo should exist, check it with :

$ psql formdemo
formdemo=> \d

Then run PgAccess as :

$ pgaccess formdemo

or simply run PgAccess without parameter and the from the Database/Open
menu, specify formdemo as your database, localhost to host, 5432 as
port. Username and password may not be supplied if you are connecting to
localhost.

Enjoy,
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

Roland N Verrier wrote:

Question for the Masters
This maybe a simple question, but how do you activate the sample demo, formdemo.sql in PgAccess.

~~~~~~
I have install on my Linux machine,
Red Hat 6.0
PostgreSQL v 6.4.2-6
PgAccess v 0.98, nice improvement
~~~~~~
Postmaster running, PgAccesss running
PgAccess v 0.98 is in /usr/local/pgaccess
Off the Web site it says, Create an empty database and psql your database <formdemo.sql
I have the template1 and other databases in /var/lib/pgsql/base
How do I make the connection with formdemo.sql and the base dir., if I create a new database,
opened in PgAccess?
~~~~~~
Thanks, for Being Creators and Helpers ************ From mgascherma@wpcusrgrp.org Wed Sep 8 05:14:03 1999 Received: from alien.wpcusrgrp.org (alien.wpcusrgrp.org [205.200.158.11]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA61853 for ; Wed, 8 Sep 1999 01:14:03 -0400 (EDT) (envelope-from mgascherma@wpcusrgrp.org) Received: from default (port7.wpcusrgrp.org [205.200.158.57]) by alien.wpcusrgrp.org (8.8.7/8.8.7) with SMTP id XAA02016; Tue, 7 Sep 1999 23:19:34 -0500 Message-ID: <000701bef9b9$1bb89460$399ec8cd@default> From: "Mark Gaschermann" To: "Roland N Verrier" , "PostgreSQL PgAccess" Subject: Re: [INTERFACES] PGACCESS formdemo.sql Date: Wed, 8 Sep 1999 00:12:55 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3155.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 >This maybe a simple question, but how do you activate the sample demo, formdemo.sql in PgAccess. >~~~~~~ > I have also had a problem getting the demo to work. I followed the steps outlined by Constantin in his reply, but for some reason I keep getting errors when I psql formdemo; Wed, 8 Sep 1999 02:16:51 -0400 (EDT) (envelope-from teo@flex.ro) Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3]) by flex.flex.ro (8.9.3/8.9.3) with ESMTP id JAA07926; Wed, 8 Sep 1999 09:17:23 +0300 Sender: teo@flex.flex.ro Message-ID: <37D600DB.215685C0@flex.ro> Date: Wed, 08 Sep 1999 06:23:23 +0000 From: Constantin Teodorescu Organization: FLEX Consulting Braila X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.12 i586) X-Accept-Language: en MIME-Version: 1.0 To: Mark Gaschermann CC: Roland N Verrier , PostgreSQL PgAccess Subject: Re: [INTERFACES] PGACCESS formdemo.sql References: <000701bef9b9$1bb89460$399ec8cd@default> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Mark Gaschermann wrote: > > >This maybe a simple question, but how do you activate the sample demo, > formdemo.sql in PgAccess. > >~~~~~~ > > > > I have also had a problem getting the demo to work. I followed the steps > outlined by Constantin in his reply, but for some reason I keep getting > errors when I psql formdemo > The phonebook table is created OK, but when it gets to the cities table I > get the errors: > > pg_aclcheck:class ""cities_id_seq"" not found > pg_ownercheck:class "cities" not found > error: cities: table does not exist Get a new fresh copy of formdemo.sql from http://www.flex.ro/pgaccess/formdemo.sql or http://speedy.flex.ro/pgaccess/formdemo.sql I checked it right now and it worked just fine! Hope it's ok now. Teo From reedstrm@wallace.ece.rice.edu Wed Sep 8 15:26:33 1999 Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA52479 for ; Wed, 8 Sep 1999 11:26:33 -0400 (EDT) (envelope-from reedstrm@wallace.ece.rice.edu) Received: by wallace.ece.rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-interfaces@postgreSQL.org; Wed, 8 Sep 1999 10:26:30 -0500 (CDT) Date: Wed, 8 Sep 1999 10:26:30 -0500 From: "Ross J. Reedstrom" To: Mark Gaschermann Cc: Roland N Verrier , PostgreSQL PgAccess Subject: Re: [INTERFACES] PGACCESS formdemo.sql Message-ID: <19990908102630.C24655@wallace.ece.rice.edu> References: <000701bef9b9$1bb89460$399ec8cd@default> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i In-Reply-To: <000701bef9b9$1bb89460$399ec8cd@default>; from Mark Gaschermann on Wed, Sep 08, 1999 at 12:12:55AM -0500 On Wed, Sep 08, 1999 at 12:12:55AM -0500, Mark Gaschermann wrote: > > I have also had a problem getting the demo to work. I followed the steps > outlined by Constantin in his reply, but for some reason I keep getting > errors when I psql formdemo > The phonebook table is created OK, but when it gets to the cities table I > get the errors: > > pg_aclcheck:class ""cities_id_seq"" not found > pg_ownercheck:class "cities" not found > error: cities: table does not exist > > After starting pgAccess I can open forms, see the phonebook table and it's > data, etc, but when I try to open the Schema, I get the error that cities > table does not exist. > > Any ideas? I'm using the formdemo.sql that came with the downloaded v 0.98 > What version of PostgreSQL are you using? > Mark G > > -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005 From mgascherma@wpcusrgrp.org Wed Sep 8 23:18:47 1999 Received: from alien.wpcusrgrp.org (alien.wpcusrgrp.org [205.200.158.11]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA28140 for ; Wed, 8 Sep 1999 19:18:47 -0400 (EDT) (envelope-from mgascherma@wpcusrgrp.org) Received: from wpcusrgrp.org (port5.wpcusrgrp.org [205.200.158.55]) by alien.wpcusrgrp.org (8.8.7/8.8.7) with ESMTP id RAA10534; Wed, 8 Sep 1999 17:24:10 -0500 Sender: markg@alien.wpcusrgrp.org Message-ID: <37D6EE7B.900F50B4@wpcusrgrp.org> Date: Wed, 08 Sep 1999 18:17:15 -0500 From: Mark Gaschermann X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.5-15 i686) X-Accept-Language: en MIME-Version: 1.0 To: "Ross J. Reedstrom" CC: Roland N Verrier , PostgreSQL PgAccess Subject: Re: [INTERFACES] PGACCESS formdemo.sql References: <000701bef9b9$1bb89460$399ec8cd@default> <19990908102630.C24655@wallace.ece.rice.edu> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > > pg_aclcheck:class ""cities_id_seq"" not found > > pg_ownercheck:class "cities" not found > > error: cities: table does not exist > > > > After starting pgAccess I can open forms, see the phonebook table and it's > > data, etc, but when I try to open the Schema, I get the error that cities > > table does not exist. > > > > Any ideas? I'm using the formdemo.sql that came with the downloaded v 0.98 > > > > What version of PostgreSQL are you using? I'm using the version that came on RedHat 6.0 , postgres 6.4.2-3. I was fiddling around with the formdemo.sql file and found that if I removed the double quotes from around all occurences of "cities_id_seq" the tables were created properly. ie. changed CREATE SEQUENCE "cities_id_seq" to CREATE SEQUENCE cities_id_seq and SELECT nextval ('"cities_id_seq"'); to SELECT nextval ('cities_id_seq'); I'm guessing maybe it's due to my having an older version of Postgres??? Mark G From verrier@oneworldsolution2by2.mb.ca Thu Sep 9 02:43:36 1999 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 ; 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 ; 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 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 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 Mark,
Ross,
I have Red Hat 6.0 and I've installed PostgreSQL 6.4.2-6, and have the same problem as Mark?
So, I guess we need PostgreSQL 6.5.1, or is there a different correction?
Roland

Mark Gaschermann wrote:

> > pg_aclcheck:class ""cities_id_seq"" not found
> > pg_ownercheck:class "cities" not found
> > error: cities: table does not exist
> >
> > After starting pgAccess I can open forms, see the phonebook table and it's
> > data, etc, but when I try to open the Schema, I get the error that cities
> > table does not exist.
> >
> > Any ideas?  I'm using the formdemo.sql that came with the downloaded v 0.98
> >
>
> What version of PostgreSQL are you using?

I'm using the version that came on RedHat 6.0 , postgres 6.4.2-3.

I was fiddling around with the formdemo.sql file and found that if I
removed the double quotes from around all occurences of "cities_id_seq"
the tables were created properly.
ie. changed CREATE SEQUENCE "cities_id_seq" to  CREATE SEQUENCE
cities_id_seq
and SELECT nextval ('"cities_id_seq"'); to SELECT nextval
('cities_id_seq');

I'm guessing maybe it's due to my having an older version of Postgres???

Mark G

From reedstrm@wallace.ece.rice.edu Thu Sep 9 05:01:16 1999 Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA78129 for ; Thu, 9 Sep 1999 01:01:16 -0400 (EDT) (envelope-from reedstrm@wallace.ece.rice.edu) Received: by wallace.ece.rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-interfaces@postgresql.org; Thu, 9 Sep 1999 00:01:13 -0500 (CDT) Date: Thu, 9 Sep 1999 00:01:13 -0500 From: "Ross J. Reedstrom" To: Mark Gaschermann Cc: Roland N Verrier , PostgreSQL PgAccess Subject: Re: [INTERFACES] PGACCESS formdemo.sql Message-ID: <19990909000113.C3982@wallace.ece.rice.edu> References: <000701bef9b9$1bb89460$399ec8cd@default> <19990908102630.C24655@wallace.ece.rice.edu> <37D6EE7B.900F50B4@wpcusrgrp.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i In-Reply-To: <37D6EE7B.900F50B4@wpcusrgrp.org>; from Mark Gaschermann on Wed, Sep 08, 1999 at 06:17:15PM -0500 On Wed, Sep 08, 1999 at 06:17:15PM -0500, Mark Gaschermann wrote: > > > > pg_aclcheck:class ""cities_id_seq"" not found > > > pg_ownercheck:class "cities" not found > > > error: cities: table does not exist > > > > > > After starting pgAccess I can open forms, see the phonebook table and it's > > > data, etc, but when I try to open the Schema, I get the error that cities > > > table does not exist. > > > > > > Any ideas? I'm using the formdemo.sql that came with the downloaded v 0.98 > > > > > > > What version of PostgreSQL are you using? > > I'm using the version that came on RedHat 6.0 , postgres 6.4.2-3. > > I was fiddling around with the formdemo.sql file and found that if I > removed the double quotes from around all occurences of "cities_id_seq" > the tables were created properly. > ie. changed CREATE SEQUENCE "cities_id_seq" to CREATE SEQUENCE > cities_id_seq > and SELECT nextval ('"cities_id_seq"'); to SELECT nextval > ('cities_id_seq'); This one's it. The processing of class names when passed as arguments to a function changed, to deal with the MiXeDCase problem. The CREATE SEQUENCE should work fine either way. Ross -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005 From reedstrm@wallace.ece.rice.edu Thu Sep 9 05:11:27 1999 Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA79357 for ; Thu, 9 Sep 1999 01:11:27 -0400 (EDT) (envelope-from reedstrm@wallace.ece.rice.edu) Received: by wallace.ece.rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-interfaces@postgreSQL.org; Thu, 9 Sep 1999 00:11:25 -0500 (CDT) Date: Thu, 9 Sep 1999 00:11:25 -0500 From: "Ross J. Reedstrom" To: Roland N Verrier Cc: PostgreSQL PgAccess Subject: Re: [INTERFACES] PGACCESS formdemo.sql Message-ID: <19990909001125.D3982@wallace.ece.rice.edu> References: <000701bef9b9$1bb89460$399ec8cd@default> <19990908102630.C24655@wallace.ece.rice.edu> <37D6EE7B.900F50B4@wpcusrgrp.org> <37D72197.57403879@oneworldsolution2by2.mb.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i In-Reply-To: <37D72197.57403879@oneworldsolution2by2.mb.ca>; from Roland N Verrier on Wed, Sep 08, 1999 at 09:55:20PM -0500 Roland - Your message came over in HTML, so I'm having trouble replying easily: please make sure you sent plain text to the mailing lists. I think I say something about you also using 6.4.x. The other person's fix was in fact correct: just remove the _double_ quotes from around any table name that is the argument of a function (I think the only ones are all DEFAULT nextval type statements). If that is infact all that are the problem, Constantin could change the example to explicitly use the 'serial' shorthand: that works on both 6.4 and 6.5. There are a relatively large number of bug fixes and performance improvements in 6.5.1. You really should consider upgrading. Ross On Wed, Sep 08, 1999 at 09:55:20PM -0500, Roland N Verrier wrote: ???? -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005