From: PFC <lists@boutiquenumerique.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: lmeadors@apache.org
Cc: pgsql-sql@postgresql.org
Subject: Re: getting back autonumber just inserted
Date: Fri, 08 Jul 2005 05:03:37 +0200
Message-ID: <op.stkqsbzith1vuj@localhost> (raw)
In-Reply-To: <20050708014950.GA3339@winnie.fuhr.org>
References: <42CD6B58.6060508@techevolution.be>
<20050707201433.94901.qmail@web41013.mail.yahoo.com>
<20050707203715.GA26528@winnie.fuhr.org>
<a10a823c05070713473add03d7@mail.gmail.com>
<20050707205725.GA28200@winnie.fuhr.org>
<op.stkdygr8th1vuj@localhost>
<20050707224452.GA50696@winnie.fuhr.org>
<op.stkh4cegth1vuj@localhost>
<20050708014950.GA3339@winnie.fuhr.org>
> 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...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lists@boutiquenumerique.com, mike@fuhr.org, lmeadors@apache.org
Subject: Re: getting back autonumber just inserted
In-Reply-To: <op.stkqsbzith1vuj@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox