From: ow <oneway_111@yahoo.com>
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: currval() without specifying the sequence name
Date: Tue, 9 Mar 2004 06:53:59 -0800 (PST)
Message-ID: <20040309145359.79236.qmail@web60805.mail.yahoo.com> (raw)
In-Reply-To: <Pine.LNX.4.44.0403091610190.32587-100000@matrix.gatewaynet.com>
--- Achilleus Mantzios <achill@matrix.gatewaynet.com> wrote:
>
> You could use the same sequence in many tables.
>
I guess I could but then:
1) I'd still have to know the sequence name. When integrating pgSql with 3party
frameworks I'd either have to pass it there (could be a very difficult task) or
make some assumptions (also not very good).
2) There may be a need to have different sequences being used in an app.
3) If one sequence is used, in many cases it'll have to be of type int8 and
pgSql does not handle searches with int8 very nicely.
Thanks
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster
http://search.yahoo.com
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: oneway_111@yahoo.com, achill@matrix.gatewaynet.com
Subject: Re: currval() without specifying the sequence name
In-Reply-To: <20040309145359.79236.qmail@web60805.mail.yahoo.com>
* 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