Re: [GENERAL] creating a temp table in a function

2008-04-04 Thread Andreas 'ads' Scherbaum
On Fri, 04 Apr 2008 21:22:17 +0100 Raymond O'Donnell wrote: > On 04/04/2008 20:47, Andreas 'ads' Scherbaum wrote: > > >> I have a function that creates a temp table and drops it on commit. If > >> I run the function twice in the same psql interactive session, I get an > >> error. If I run it tw

Re: [GENERAL] creating a temp table in a function

2008-04-04 Thread Alvaro Herrera
Raymond O'Donnell wrote: > On 04/04/2008 20:47, Andreas 'ads' Scherbaum wrote: > >>> I have a function that creates a temp table and drops it on commit. If >>> I run the function twice in the same psql interactive session, I get an >>> error. If I run it twice in two different psql sessions (usin

Re: [GENERAL] creating a temp table in a function

2008-04-04 Thread Raymond O'Donnell
On 04/04/2008 20:47, Andreas 'ads' Scherbaum wrote: I have a function that creates a temp table and drops it on commit. If I run the function twice in the same psql interactive session, I get an error. If I run it twice in two different psql sessions (using the -c flag), I get no error. Is th

Re: [GENERAL] creating a temp table in a function

2008-04-04 Thread Ivan Sergio Borgonovo
On Fri, 4 Apr 2008 09:13:18 -0700 "Shahaf Abileah" <[EMAIL PROTECTED]> wrote: > I have a function that creates a temp table and drops it on > commit. If I run the function twice in the same psql interactive > session, I get an error. If I run it twice in two different psql > sessions (using the

Re: [GENERAL] creating a temp table in a function

2008-04-04 Thread Andreas 'ads' Scherbaum
On Fri, 4 Apr 2008 09:13:18 -0700 Shahaf Abileah wrote: > I have a function that creates a temp table and drops it on commit. If > I run the function twice in the same psql interactive session, I get an > error. If I run it twice in two different psql sessions (using the -c > flag), I get no err

[GENERAL] creating a temp table in a function

2008-04-04 Thread Shahaf Abileah
I have a function that creates a temp table and drops it on commit. If I run the function twice in the same psql interactive session, I get an error. If I run it twice in two different psql sessions (using the -c flag), I get no error. Is this expected behavior? If so, why? You are now conn