| 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) |