X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 32C3952A06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Jul 2005 10:27:24 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 24764-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Jul 2005 13:27:22 +0000 (GMT)
Received: from wolff.to (wolff.to [66.93.197.194])
	by svr1.postgresql.org (Postfix) with SMTP id 55B2D5298A
	for <pgsql-sql@postgresql.org>; Fri,  8 Jul 2005 10:27:21 -0300 (ADT)
Received: (qmail 20116 invoked by uid 500); 8 Jul 2005 13:27:46 -0000
Date: Fri, 8 Jul 2005 08:27:46 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: PFC <lists@boutiquenumerique.com>
Cc: Michael Fuhr <mike@fuhr.org>, lmeadors@apache.org,
 pgsql-sql@postgresql.org
Subject: Re: getting back autonumber just inserted
Message-ID: <20050708132746.GA18363@wolff.to>
Mail-Followup-To: Bruno Wolff III <bruno@wolff.to>,
	PFC <lists@boutiquenumerique.com>, Michael Fuhr <mike@fuhr.org>,
	lmeadors@apache.org, pgsql-sql@postgresql.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>
	<op.stkqsbzith1vuj@localhost>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <op.stkqsbzith1vuj@localhost>
User-Agent: Mutt/1.5.6i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200507/66
X-Sequence-Number: 22044

On Fri, Jul 08, 2005 at 05:03:37 +0200,
  PFC <lists@boutiquenumerique.com> wrote:
> 
> 	It's the first time I see a MySQLism in postgres !

This has meaning in more ways than one.

> 	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) ?

More likely people will shoot themselves in the foot with this feature and come
to the mailing list with questions that take even more time to figure out
than telling them how to use currval(pg_get_serial_sequence().

IMO it is a bad idea to include this feature and that no sane developer will
make use of it in applications.