Re: [GENERAL] Re: nextval, sequences and sequencenames

2001-08-15 Thread Martijn van Oosterhout
On Wed, Aug 15, 2001 at 10:49:38AM +0200, Wieger Uffink wrote: > Hi, > > First of all thanks for the reactions, but I think I have probably not > made my problem clear enough. > > I know the sequence name will be some combination, usually as > 'tablename_columnname_seq', > when implicitly create

Re: [GENERAL] Re: nextval, sequences and sequencenames

2001-08-15 Thread Wieger Uffink
Hi, First of all thanks for the reactions, but I think I have probably not made my problem clear enough. I know the sequence name will be some combination, usually as 'tablename_columnname_seq', when implicitly created during table creation. But when I create my table 'maincompetencies' with ser

Re: [GENERAL] Re: nextval, sequences and sequencenames

2001-08-15 Thread Martijn van Oosterhout
On Wed, Aug 15, 2001 at 12:14:02PM +1000, Chris wrote: > >If it is very difficult finding that sequence name (I'm not sure) > >You may want to create the sequence yourself instead of using SERIAL. > >Then you would know the name. > > Not hard at all. > > csmith=# create table test (testid serial