From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: temp sequence |
Date: | 2008-02-03 18:40:34 |
Message-ID: | 47A60AA2.7030303@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
so, then the pooled connections remain open, which - as someone else has
explained - causes sessions to be maintained.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2008-02-03 18:43:29 | Re: PostgreSQL professionals group at LinkedIn.com |
Previous Message | vladimir konrad | 2008-02-03 17:49:54 | Re: [OT] "advanced" database design (long) |