Re: [GENERAL] Determining when a row was inserted

2005-06-03 Thread Wiebe de Jong
The way I do it is to add a timestamp field with a default value of now(). Unfortunately, this won't help with any records that have already been created. Wiebe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Terry Lee Tucker Sent: Thursday, June 02,

Re: [GENERAL] Determining when a row was inserted

2005-06-03 Thread Wiebe de Jong
03, 2005 11:55 AM To: Wiebe de Jong Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Determining when a row was inserted Reply at bottom... On Fri, 2005-06-03 at 12:53, Wiebe de Jong wrote: The way I do it is to add a timestamp field with a default value of now(). Unfortunately

[GENERAL] looking for connection leaks

2004-12-30 Thread Wiebe de Jong
I think I am having a problem with database connection leakage between PostgreSQL 7.3.4 on a Linux box and JBoss 2.4.3 on a separate Linux box What would be a good tool for monitoring connection usage and finding leaks? Wiebe de Jong

[GENERAL] trouble installing plpgsql

2004-10-04 Thread Wiebe de Jong
Hello, When I attempt to run createlang plpgsql template1 I get the following error: Error at or near createlang at character 1 Running psql 7.3.4 on redhat 9 Logged in as postgres Verified existence of /usr/lib/pgsql/plpgsql.so Any ideas on how to fix this problem? Wiebe de

[GENERAL] Cursors and JDBC

2004-10-04 Thread Wiebe de Jong
I am trying to implement cursors using JDBC connector version 7.1b5 (postgresql-7.1b5.jar), but cant get it to work. Could anybody suggest the proper way to do it, or even some source code? I am stuck with this version and cant change it. Thanks Wiebe de Jong