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 mo

[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 po

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 o

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 table

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 woul

Re: [ADMIN] Syncing DBs prior to RServ replication

2003-06-20 Thread Michael A Nachbaur
Just a note to everyone. I finally managed to scrape enough time out of my tasklist (by staying late) so I could try this out. Besides some difficulty with having a RedHat 7.1 / PGSQL 7.2 box on one end and a Mandrake 9.1 / PGSQL 7.3 box on the other end, everything worked without a hitch. Th

Re: [ADMIN] postgreSQL 7.3.3 crashing on server with Itanium processor...

2003-06-20 Thread Taranjit Singh Lamba
Thanks, after installing all the updates, including newer (not new) kernel, it seems to work right. I suspect it was an old library problem. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:29 PM To: Taranjit Singh Lamba Cc: [EMAIL PROTECTED] Sub

[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 link