Re: [GENERAL] temp tables and sequences in functions

2007-09-05 Thread A. Kretschmer
am Wed, dem 05.09.2007, um 6:58:30 -0700 mailte Rob folgendes: > What is the proper why to deal with temp tables and sequences? Why aren't they > being dropped after the function ends? Why do I get OID errors if I delete the > temp table/sequence at the end of the function and then try to rerun t

[GENERAL] temp tables and sequences in functions

2007-09-05 Thread Rob
Postgres v8.2 I'm having a problem with using temporary tables and sequences in a function. It seems that the temp tables are not being removed once the function has completed. I'm also running into OID conflicts when I run the function in another session. I've had to do things like this to be