Re: [GENERAL] Help with transactions

2005-03-22 Thread Michael Fuhr
On Mon, Mar 21, 2005 at 10:58:27AM -0500, Stephen Howie wrote: I've notice a couple things. I ran a couple test and at first I couldn't duplicate my error on some test tables. But I then added inheritance to one of the tables and thats when I got the error again. Are you aware that

Re: [GENERAL] Help with transactions

2005-03-21 Thread Stephen Howie
Thanks for the reply. I've notice a couple things. I ran a couple test and at first I couldn't duplicate my error on some test tables. But I then added inheritance to one of the tables and thats when I got the error again. It looks like there is an error when obtaining the seq id (nextval)

[GENERAL] Help with transactions

2005-03-18 Thread Stephen Howie
Hello all, I have a java program that excepts print streams and inserts in into a spool table as a bytea. This fires a pl/pgsql trigger that passes the bytea to a pl/perl function to process the bytea and spits the results as an array back. It then proceeds to insert the data into multiple

Re: [GENERAL] Help with transactions

2005-03-18 Thread Michael Fuhr
On Fri, Mar 18, 2005 at 09:22:52AM -0500, Stephen Howie wrote: I have a java program that excepts print streams and inserts in into a spool table as a bytea. This fires a pl/pgsql trigger that passes the bytea to a pl/perl function to process the bytea and spits the results as an array