Re: sequence aliases?

--- Martijn van Oosterhout <kleptog@svana.org> wrote:

> On Sun, Nov 06, 2005 at 12:15:45AM -0500, Greg Stark
> wrote:
> >
> > Tom Lane <tgl@sss.pgh.pa.us> writes:
> >
> > > My advice to the Rails people would be to fix
> whatever it is in their
> > > code that is assuming a particular sequence
> name, or indeed assuming
> > > a sequence at all...
> >
> > Well how else do you find the id of the last
> inserted record without assuming
> > a sequence?
>
> I suppose using something like:
>
> select currval( pg_get_serial_sequence(
> 'table','col' ) );

I like that better than the current 'table_col_seq'.
Perhaps just currval('table', 'col'). Or perhaps
tables could be made to have a default sequence (one
that's associated with the primary key).

CSN



>
> That avoids hardcoding the sequence id. Not assuming
> a sequences at all
> may be trickier.
>
> Have a nice day,
> --
> Martijn van Oosterhout   <kleptog@svana.org>
> http://svana.org/kleptog/
> > Patent. n. Genius is 5% inspiration and 95%
> perspiration. A patent is a
> > tool for doing 5% of the work and then sitting
> around waiting for someone
> > else to do the other 95% so you can sue them.
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com