Re: pl/pgSQL sequence question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Stephen Shorrock" <smsh(at)bas(dot)ac(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pl/pgSQL sequence question
Date: 2004-01-08 17:38:33
Message-ID: 12158.1073583513@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Stephen Shorrock" <smsh(at)bas(dot)ac(dot)uk> writes:
> Thanks for your response Tom,
> I thought that you might like to know I've implemented you idea of using idcol SERIAL PRIMARY KEY, which is a really good tip. Although not in a function as I am unable to remove this durring the function call:
> ERROR: RelationForgetRelation: relation 47527448 is still open

I think this could only happen in pre-7.3 Postgres. Consider updating.

regards, tom lane

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2004-01-08 18:48:30 Re: partial index on varchar-coloumn in 7.4.1
Previous Message Stephen Shorrock 2004-01-08 17:27:43 Re: pl/pgSQL sequence question