Re: [GENERAL] Sequence name with SERIAL type

2003-12-17 Thread Marek Lewczuk
Tom Lane wrote: Marek Lewczuk <[EMAIL PROTECTED]> writes: I'm curious if the default scheme for sequence name (which is created with SERIAL data type) can be changed -- currently all sequences are named like this: __seq -- can it be changed for e.g. seq ??? Sure ... just hack one or two

Re: [GENERAL] Sequence name with SERIAL type

2003-12-17 Thread Paul Thomas
On 17/12/2003 07:59 Marek Lewczuk wrote: I'm curious if the default scheme for sequence name (which is created with SERIAL data type) can be changed -- currently all sequences are named like this: __seq -- can it be changed for e.g. seq ??? You could try something like myfield integer

Re: [GENERAL] Sequence name with SERIAL type

2003-12-17 Thread Richard Huxton
On Wednesday 17 December 2003 07:59, Marek Lewczuk wrote: > I'm curious if the default scheme for sequence name (which is created > with SERIAL data type) can be changed -- currently all sequences are > named like this: __seq -- can it be changed for > e.g. seq ??? Your two options seem to be:

Re: [GENERAL] Sequence name with SERIAL type

2003-12-17 Thread Tom Lane
Marek Lewczuk <[EMAIL PROTECTED]> writes: > I'm curious if the default scheme for sequence name (which is created > with SERIAL data type) can be changed -- currently all sequences are > named like this: __seq -- can it be changed for > e.g. seq ??? Sure ... just hack one or two places in t

Re: [GENERAL] Sequence name with SERIAL type

2003-12-17 Thread Michael Fuhr
On Wed, Dec 17, 2003 at 08:59:03AM +0100, Marek Lewczuk wrote: > I'm curious if the default scheme for sequence name (which is created > with SERIAL data type) can be changed -- currently all sequences are > named like this: __seq -- can it be changed for > e.g. seq ??? You'd have to hack t

[GENERAL] Sequence name with SERIAL type

2003-12-17 Thread Marek Lewczuk
I'm curious if the default scheme for sequence name (which is created with SERIAL data type) can be changed -- currently all sequences are named like this: __seq -- can it be changed for e.g. seq ??? Thanks. ML ---(end of broadcast)--- TIP