Re: pl/pgSQL sequence question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pl/pgSQL sequence question
Дата
Msg-id 12158.1073583513@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pl/pgSQL sequence question  ("Stephen Shorrock" <smsh@bas.ac.uk>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgsql 7.0 recovery to 7.4
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: partial index on varchar-coloumn in 7.4.1