Re: getting back autonumber just inserted - Mailing list pgsql-sql

From PFC
Subject Re: getting back autonumber just inserted
Date
Msg-id op.stkqsbzith1vuj@localhost
Whole thread Raw
In response to Re: getting back autonumber just inserted  (Michael Fuhr <mike@fuhr.org>)
Responses Re: getting back autonumber just inserted
Re: getting back autonumber just inserted
List pgsql-sql
> On Fri, Jul 08, 2005 at 01:56:26AM +0200, PFC wrote:
>> >Do you mean with lastval()?  Here's what happens:
>>
>> Hm, interesting, you mean the return value of lastval() also depends
>> if  you set your constraints  to deferred or immediate ?
>
> My mind's ablank trying to contrive a situation where that would
> matter.  Can you provide an example?
It's rather perverse and farfetched, but what would stop one from putting  
some insert statements in a function that happens to be called somewhere  
inside of a check constraint... although one could agree that it's a bit  
shooting oneself in the foot...

> In any case, I simply meant to point out that 8.1's lastval() will
> be seductively convenient because you don't have to pass it a
> sequence name, but the value it returns might not be the value you
> want.
It's the first time I see a MySQLism in postgres !However I like it, cos it might subvert some MySQL users, and provide

 
easy answers to The Weekly Question on the mailing list (ie where is  
AUTO_INCREMENT) ?I've just noticed that I forgot a close() somewhere hence my data import  
files missed a few chunks at the end and MySQL said "3 warnings, 0 errors"  
(if it had failed I would have noticed it a week ago but no, more  
0000-00-00:00:00:00 hand pruning for me now). Uh oh, SHOW WARNINGS isn't  
implemented in that version. There are warnings, but I won't tell you  
where. Somewhere. Hm... grep logs ? yeah, but the error message doesn't  
mention the table name... nor what kind of warning it is that is not an  
error even though half of the row has stayed in an unclosed() file  
buffer...




pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Make COUNT(*) Faster?
Next
From: Michael Fuhr
Date:
Subject: Re: getting back autonumber just inserted