Re: Problems with transactions and sequences

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Problems with transactions and sequences
Дата
Msg-id 3F4E6FBB.6692.A31C87@localhost
обсуждение исходный текст
Ответ на Re: Problems with transactions and sequences  (Dennis Gearon <gearond@fireserve.net>)
Ответы Re: Problems with transactions and sequences  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
On 28 Aug 2003 at 8:22, Dennis Gearon wrote:

> if one gives a value for the seirial field, the trigger for the serial
> on that table doesn't generate another value?

If you are going to get sequence value first and insert it later, you can just
declare it int8 rather than serial..:-)

Would that solve problem?

Actually I have no idea if you can insert specific value in a serial field. I
wouldn't be surprised if it works as intended but don't have a postgresql
installation handy here. (Working in windows right now..)

Bye
 Shridhar

--
Immutability, Three Rules of:    (1)  If a tarpaulin can flap, it will.    (2)  If a
small boy can get dirty, he will.    (3)  If a teenager can go out, he will.


В списке pgsql-general по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Functions have 32 args limt ???
Следующее
От: Tom Lane
Дата:
Сообщение: Re: left outer join terrible slow compared to inner join