Re: pl/pgSQL sequence question - Mailing list pgsql-novice

From Tom Lane
Subject Re: pl/pgSQL sequence question
Date
Msg-id 12158.1073583513@sss.pgh.pa.us
Whole thread Raw
In response to pl/pgSQL sequence question  ("Stephen Shorrock" <smsh@bas.ac.uk>)
List pgsql-novice
"Stephen Shorrock" <smsh@bas.ac.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
goodtip. 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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql 7.0 recovery to 7.4
Next
From: Bruno Wolff III
Date:
Subject: Re: partial index on varchar-coloumn in 7.4.1