Thread: [INTERFACES] PGACCESS formdemo.sql
Question for the Masters <br />This maybe a simple question, but how do you activate the sample demo, formdemo.sql in PgAccess.<br />~~~~~~ <br />I have install on my Linux machine, <br />Red Hat 6.0 <br />PostgreSQL v 6.4.2-6 <br />PgAccessv 0.98, nice improvement <br />~~~~~~ <br />Postmaster running, PgAccesss running <br />PgAccess v 0.98 is in /usr/local/pgaccess<br />Off the Web site it says, Create an empty database and psql your database <formdemo.sql <br />Ihave the template1 and other databases in /var/lib/pgsql/base <br />How do I make the connection with formdemo.sql andthe base dir., if I create a new database, opened in PgAccess? <br />~~~~~~ <br />Thanks, for Being Creators and Helpers
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? 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
Help <br />Concerning the the sample formdemo, ( formdemo.sql ) <br />This demo file is in the ( /usr/local/pgaccess/demo/formdemo.sql) directory, from the upgrade v 0.98. <br />Or you can download the ( formdemo.sql )<u>file only</u>, from the PgAccess web site. <br />My question is, which directory do you put the ( formdemo.sql ) file.<br />So when you type <br />$ createdb formdemo <br />$ psql formdemo <formdemo.sql <br />I get no such file ordirectory <br />Thanks, Roland <br /> <br /> <blockquote type="CITE">Roland N Verrier wrote: <br />> <br />> Postmasterrunning, PgAccesss running <br />> PgAccess v 0.98 is in /usr/local/pgaccess <br />> Off the Web site itsays, Create an empty database and psql your <br />> database <formdemo.sql <br />> I have the template1 and otherdatabases in /var/lib/pgsql/base <br />> How do I make the connection with formdemo.sql and the base dir., if I <br/>> create a new database, opened in PgAccess?</blockquote><blockquote type="CITE">Constantin Teodorescu wrote: <p>Let'ssay you are the Linux user roland on your computer. <p>There is a postgres user , the master of PostgreSQL databaseserver as <br />the system administrator. <br />Don't know the password for postgres user but you should assign oneas <br />root and then log in as postgres user. <br />Then create a PostgreSQL user with the following command: <p>$ createuserroland <p>and follow the instructions there. Now you have a PostgreSQL user roland <br />and you may create databases, other users and so on. <p>As postgres linux user (or as roland) create and fill the formdemo <br />database :<p>$ createdb formdemo <br />$ psql formdemo <formdemo.sql <p>Now database formdemo should exist, check it with : <p>$psql formdemo <br />formdemo=> \d <p>Then run PgAccess as : <p>$ pgaccess formdemo <p>or simply run PgAccess withoutparameter and the from the Database/Open <br />menu, specify formdemo as your database, localhost to host, 5432 as<br />port. Username and password may not be supplied if you are connecting to <br />localhost. <p>Enjoy, <br />-- <br/>Constantin Teodorescu <br />FLEX Consulting Braila, ROMANIA</blockquote>
Help <br />Concerning the the sample formdemo, ( formdemo.sql ) <br />This demo file is in the ( /usr/local/pgaccess/demo/formdemo.sql) directory, from the upgrade v 0.98. <br />Or you can download the ( formdemo.sql )file only, from the PgAccess web site. <br /><u>My question is, in which directory do you put the ( formdemo.sql ) databasefile in.</u><br />So when you type <br /># su - roland <br />$ createdb formdemo <br />$ psql formdemo <formdemo.sql<br />I get <br />bash: formdemo.sql: No such file or directory <br />~~~~~~~~~ <br />I do get when I type<br />$ psql formdemo <br />Welcome etc. <br />formdemo=> \d <br />Then I get a table <br />~~~~~~ <br />The formdemo.sqldoes not show up in PgAccess <br />I have other databases, tables and forms working in PgAccess? <br />Thanks,Roland <p><u>Constantin Teodorescu wrote:</u><p>Let's say you are the Linux user roland on your computer. <p>Thereis a postgres user , the master of PostgreSQL database server as <br />the system administrator. <br />Don't knowthe password for postgres user but you should assign one as <br />root and then log in as postgres user. <br />Then createa PostgreSQL user with the following command: <p>$ createuser roland <p>and follow the instructions there. Now youhave a PostgreSQL user roland <br />and you may create databases , other users and so on. <p>As postgres linux user (oras roland) create and fill the formdemo <br />database : <p>$ createdb formdemo <br />$ psql formdemo <formdemo.sql<p>Now database formdemo should exist, check it with : <p>$ psql formdemo <br />formdemo=> \d <p>Thenrun PgAccess as : <p>$ pgaccess formdemo <p>or simply run PgAccess without parameter and the from the Database/Open<br />menu, specify formdemo as your database, localhost to host, 5432 as <br />port. Username and passwordmay not be supplied if you are connecting to <br />localhost. <p>Enjoy, <br />-- <br />Constantin Teodorescu <br/>FLEX Consulting Braila, ROMANIA <p><u>Roland N Verrier wrote:</u><p>Question for the Masters <br />This maybe a simplequestion, but how do you activate the sample demo, formdemo.sql in PgAccess. <p>~~~~~~ <br />I have install on my Linuxmachine, <br />Red Hat 6.0 <br />PostgreSQL v 6.4.2-6 <br />PgAccess v 0.98, nice improvement <br />~~~~~~ <br />Postmasterrunning, PgAccesss running <br />PgAccess v 0.98 is in /usr/local/pgaccess <br />Off the Web site it says, Createan empty database and psql your database <formdemo.sql <br />I have the template1 and other databases in /var/lib/pgsql/base<br />How do I make the connection with formdemo.sql and the base dir., if I create a new database, <br/>opened in PgAccess? <br />~~~~~~ <br />Thanks, for Being Creators and Helpers ************
>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<formdemo.sql. 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 Mark G
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<formdemo.sql. > > 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
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<formdemo.sql. > > 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., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
> > 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
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>
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., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
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., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005