Hi Tom,
Here is the output from 'select version()'
PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2
Cheers
Rudi.
Tom Lane wrote:
>Rudi Starcevic <[EMAIL PROTECTED]> writes:
>
>
>>Just a quick one on the length of the name of a sequence.
>>...
>>However the sequence created is nam
> > However the sequence created is named :
> > eselect_maincategory_maincat_id ( the '_seq' is lopped off )
>
> What version are you running? Anything recent will keep the '_seq'
> and lop elsewhere.
Not if he's manually creating a sequence name that's too long - it will just
truncate it me
Rudi Starcevic <[EMAIL PROTECTED]> writes:
> Just a quick one on the length of the name of a sequence.
> ...
> However the sequence created is named :
> eselect_maincategory_maincat_id ( the '_seq' is lopped off )
What version are you running? Anything recent will keep the '_seq'
and lo
:
create table blah (
maincat_id SERIAL
);
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Rudi Starcevic
> Sent: Wednesday, 17 July 2002 10:39 AM
> To: [EMAIL PROTECTED]
> Subject: [SQL] Sequence name length
>
>
&g
Hi,
Just a quick one on the length of the name of a sequence.
I have some table with long(ish) names like : eselect_maincategory
The primary key is named : maincat_id
When I create the table the sequence sql looks like
nextval('"eselect_maincategory_maincat_id_seq"'::text)
Howeve
