On 5/5/2010 2:36 AM, Sim Zacks wrote:
I am using 8.2.14
I am trying to use a temp sequence in a function and I'm having a lot of
trouble.
I create the temp sequence and then I have to drop it at the end of the
function, because it stays alive for the whole session and not just the
function.
I wa
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I am trying to use a temp sequence in a function and I'm having a lot of
> trouble.
> I create the temp sequence and then I have to drop it at the end of the
> function, because it stays alive for the whole session and not just the
> functio
2010/5/5 Sim Zacks :
> I am using 8.2.14
>
> I am trying to use a temp sequence in a function and I'm having a lot of
> trouble.
> I create the temp sequence and then I have to drop it at the end of the
> function, because it stays alive for the whole session and not just the
> function.
> I want t
On 03/02/2008 06:39, Sim Zacks wrote:
I call the function once it works, when I call it a second time, it
gives me an error that the sequence already exists. When I restart the
application, I can call the function again.
Are you by any chance connecting via ODBC with connection pooling? If
s
On Saturday 02 February 2008 10:39 pm, Sim Zacks wrote:
> "PostgreSQL 8.2.4 on i386-pc-linux-gnu, compiled by GCC
> i386-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo 4.1.1)"
>
> I am creating a temporary sequence in a function and it seems like it is
> not going away after the function finishes.
> The fron
On Feb 3, 2008 1:39 AM, Sim Zacks <[EMAIL PROTECTED]> wrote:
> "PostgreSQL 8.2.4 on i386-pc-linux-gnu, compiled by GCC i386-pc-linux-gnu-gcc
> (GCC) 4.1.1 (Gentoo 4.1.1)"
>
> I am creating a temporary sequence in a function and it seems like it is not
> going away after the function finishes.
> The