Re: [ADMIN] Latest transcation

2003-06-20 Thread Anagha Joshi
Yes...I'm aware of that and have tried also by maintaining extra table. But how to to the following: 1. If insertion takes place, I want to return to the client the values (with field names of course) which are inserted into the tables. In each case table might be different. 2. If

[ADMIN] pg_ctl reload makes postmaster read enviroment variables again??

2003-06-20 Thread Lucas Brasilino
Hi Folks: I was searching around in archives and Google but I didn't find the answer. Does pg_clt reload makes postmaster also read enviroment variables (env) again ?!?! I'm creating databases in an alternative directory so storing it's path in a enviroment variable that

Re: [ADMIN] Latest transcation

2003-06-20 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 20 June 2003 01:27, Anagha Joshi wrote: Yes...I'm aware of that and have tried also by maintaining extra table. But how to to the following: 1.If insertion takes place, I want to return to the client the values (with field names of

Re: [ADMIN] pgsql function doesn't work

2003-06-20 Thread Mel Jamero
taking queue from Stephan, this would achieve what you want to do though it i don't find it too 'neat': DROP FUNCTION drop_table_if_exists(TEXT); CREATE FUNCTION drop_table_if_exists(TEXT) RETURNS BOOLEAN AS ' DECLARE str_tmp text; BEGIN SELECT INTO str_tmp tablename FROM pg_tables WHERE

Re: [ADMIN] Syncing DBs prior to RServ replication

2003-06-20 Thread Andrew Sullivan
On Mon, Jun 09, 2003 at 03:24:32PM -0700, Michael A Nachbaur wrote: I'm looking at syncronizing two database servers with RServ (production / hot standby), and I'm trying to figure out a way to get the initial database on the slave server syncronized with the master. Normally, I would 1)

[ADMIN] archives.postgresql.org is not working

2003-06-20 Thread P G
Is anyone else having problems searching the archives at archives.postgresql.org? It searches for a bit and returns: Search Time: 10.375 Search results: disconnect : 0 / 0, other : 0 / 0, users : 50 / 50 Displaying Documents: 0-0 The problem is that is does not display any results, i.e. no