Re: [SQL] Persistent Connects (pg_pconnect)

2000-11-28 Thread Colleen Williams
} } function fetchrow($ind ){ return pg_fetch_row($this->query,$ind); } function fetcharray($ind ){ return pg_fetch_array($this->query,$ind); } } Cheers, Colleen. Colleen Williams

[SQL] Persistent Connects (pg_pconnect)

2000-11-21 Thread Colleen Williams
connections are in existence and then Linux tells me there are too many connections! Sometimes I believe existing connections are reused but not often! Has anyone else had this sort of experience with persistent connections? It is driving me mad so I would appreciate any help or pointer

[SQL] SQL to retrieve foreign keys

2000-10-11 Thread Colleen Williams
Hi, I would like to write some SQL to extend the phpPgAdmin tool where it only displays primary keys related to a table. I have looked at the programmers doco and searched the discussions on foreign keys but was not able to decipher how to write the SQL. It is probably really trivial for someo