Re: Problems with transactions and sequences

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with transactions and sequences
Date: 2003-08-28 15:40:19
Message-ID: 3F4E6FBB.6692.A31C87@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-08-28 15:42:00 Re: left outer join terrible slow compared to inner join
Previous Message Dennis Gearon 2003-08-28 15:38:16 Re: Functions have 32 args limt ???