[GENERAL] exception handling support in pgSQL

2004-08-14 Thread Paramveer . Singh
Hi! I am a developer working for a company which typically deploys apps on Oracle. We would like to move to postgres for obvious reasons. However, most of  our legacy apps use the exception handling support provided by PL/SQL. Instead of porting each of these procedures by hand, we would like to a

Re: [GENERAL] idle processes

2004-08-14 Thread Robert Paulsen
On Saturday 14 August 2004 11:17 pm, CSN wrote: > I'm using regular pg_connect's. The processes > eventually went away - was just wondering why they'd > stick around. > Well, unless I misunderstand, when a script ends the connection should go away and I think that means the postgres process suppo

Re: [GENERAL] idle processes

2004-08-14 Thread CSN
I'm using regular pg_connect's. The processes eventually went away - was just wondering why they'd stick around. CSN On Saturday 14 August 2004 01:01 pm, CSN wrote: > 'ps axu' shows: > > postgres 1249 0.0 0.7 20200 7296 ?S > 11:50 0:00 postgres: user1 database1 127.0.0.1 idle > pos