Обсуждение: [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