Re: Sequence name length - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: Sequence name length
Date
Msg-id GNELIHDDFBOCMGBFGEFOOEDACDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Sequence name length  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
> > 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 methinks...

Chris



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sequence name length
Next
From: Rudi Starcevic
Date:
Subject: Re: Sequence name length