[GENERAL] Curious situation - running program cannot seem to delete records.

2007-02-28 Thread Andrew Edson
I've been given a file to maintain, the purpose of which is to purge the database of records more than two years old. (Database setup is pg 8.1.3) The program (written in perl) enters postgres as the user 'postgres', and is supposed to select foreign-key records from all tables that link

Re: [GENERAL] Curious situation - running program cannot seem to delete records.

2007-02-28 Thread Alban Hertroys
Andrew Edson wrote: I've been given a file to maintain, the purpose of which is to purge the database of records more than two years old. (Database setup is pg 8.1.3) The program (written in perl) enters postgres as the user 'postgres', and is supposed to select foreign-key records

Re: [GENERAL] Curious situation - running program cannot seem to delete records.

2007-02-28 Thread Dreas Nielsen
On 2/28/07, Andrew Edson [EMAIL PROTECTED] wrote: I've been given a file to maintain, the purpose of which is to purge the database of records more than two years old. (Database setup is pg 8.1.3) The program (written in perl) enters postgres as the user 'postgres', and is supposed to select

Re: [GENERAL] Curious situation - running program cannot seem to delete records.

2007-02-28 Thread btober
Andrew Edson wrote: I've been given a file to maintain, the purpose of which is to purge the database of records more than two years old. (Database setup is pg 8.1.3) The program (written in perl) enters postgres as the user 'postgres', and is supposed to select foreign-key records from

Re: [GENERAL] Curious situation - running program cannot seem to delete records.

2007-02-28 Thread Arnaud Lesauvage
Andrew Edson a écrit : Does anyone know of anything in Postgres that might be causing this unusual behavior? Or should I check the perl mailing lists instead? Maybe you are beginning a transaction and that you are committing afterwards ? -- Arnaud ---(end of