[GENERAL] table column information

does not list every table I have created. Not sure what that is. The books I have do not say much if anything about such system tables. Any help or pointers would be appreciated. -- Scot L. Harris <[EMAIL PROTECTED]> ---(end of broadcast)--

Re: [GENERAL] table column information

but I am using php 4.2.2 not java for this application. -- Scot L. Harris <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] How to identify which column in a table is the primary key

that table has or every had a primary key. So given the table name is there a way to identify the column defined as the primary key for that table? -- Scot L. Harris <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 7: don't forget

Re: [GENERAL] row access

ere LOCK, but I don't know > how. > > Please help > > Bambero You can set permissions on a per table basis. But to implement per row permissions I think you will have to roll your own. Probably need to add a column for who owns the row and the check that when you per

[GENERAL] Multiple databases on seperate drives/file systems?

n for the postmaster service. I looked in the init.d/postgresql startup script and can see where PGDATA is checked for and setup. I take it that the environment variables from postgres user are not used? Is there a way to set databases in different file systems using a single postmaster service?

Re: [GENERAL] Multiple databases on seperate drives/file systems?

r the new database. From looking at the startup script in init.d it looks like it has PGDATA hard coded and I did not see any place in the other config files to specify additional database locations. It seems like I am missing a piece of the puzzle. -- Scot L. Harris [EMAIL PROTECTED] If you

[GENERAL] Installing 7.4.2

postgresql-perl-7.2.4-5.80 I built the 7.4.2 version with tcl, perl, and tk support so I am assuming that takes care of the packages listed above. Thanks in advance for your suggestions and recommendations. -- Scot L. Harris [EMAIL PROTECTED] Nothing is easier than to denounce the evildoer

Re: [GENERAL] Installing 7.4.2

://www.pgaccess.org does not appear to exist anymore. Are there other similar utilities available and currently maintained? And thanks to all those that responded with suggestions and pointers regarding the upgrade process from 7.2.4 to 7.4.2. On Fri, 2004-06-11 at 13:20, Scot L. Harris wrote: > I have b

Re: [GENERAL] File System Restore

ed all my tables and loaded the data. Very easy and clean. Not sure you can just copy the file systems around like you describe. -- Scot L. Harris [EMAIL PROTECTED] After an instrument has been assembled, extra components will be found on the bench. ---(end of

[GENERAL] Building pgadmin on Fedora core 2

defined reference to `_gtk_accel_group_detach' collect2: ld returned 1 exit status I saw similar errors described in the archives but I did not see any fixes posted. Does anyone have any ideas regarding these errors? Had no problems building this under Red Hat 8.0. -- Scot L. Harris [EMA

Re: [pgadmin-support] [GENERAL] Building pgadmin on Fedora core 2

lied into postgresql-7.4.2 since the pgadmin make file appear to be unable to deal with not having ssl support included. So what versions of these packages did you get to compile under FC2 without problems? -- Scot L. Harris [EMAIL PROTECTED] Tomorrow, this will be part of the unchangeable past but

Re: [GENERAL] postgresql perl connectivity

> or perhaps the capitalisation of 'pg' isn't right. > Available drivers: ExampleP, Pg, Proxy, Sponge, mysql. > at psqldb.pl line 10 > > > thanks > jay I have not done much perl programming but it looks like you need to install the CPAN DBD package. --

Re: [GENERAL] connection parameters

a php script to connect with the same parameters that I can use > using telnet and 'psql'. > You probably need to modify your postgresql.conf file to allow TCP socket connections and also modify the pg_hba.conf file to permit users from other IP addresses to connect. -- Scot L. Harris