Postgres Pro
Downloads
Home   >   mailing lists

Re: currval() without specifying the sequence name - Mailing list pgsql-sql

From ow
Subject Re: currval() without specifying the sequence name
Date
Msg-id 20040309145359.79236.qmail@web60805.mail.yahoo.com
Whole thread Raw
In response to Re: currval() without specifying the sequence name  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: currval() without specifying the sequence name
Re: currval() without specifying the sequence name
List pgsql-sql
Tree view 
--- 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 you�re looking for faster
http://search.yahoo.com

pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: currval() without specifying the sequence name
Next
From: Michael Glaesemann
Date:
Subject: Re: Trying to make efficient "all vendors who can provide all items"