Re: Bug #852: Wrong sequence name generated

It is clipping it because it needs to fit in the 32 character limit for
column names. 7.3 has a 64-character limit.

---------------------------------------------------------------------------

pgsql-bugs(at)postgresql(dot)org wrote:
> Andras Balogh (andras(at)reea(dot)net) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> Wrong sequence name generated
>
> Long Description
> When i create the following table:
> CREATE TABLE groups_events
> (
> group_event_id serial,
> event_id integer NOT NULL,
> group_id integer NOT NULL,
> PRIMARY KEY (group_event_id)
> );
>
> the sequence that postgres generates is: groups_events_group_event_i_seq
> It shouldn't be groups_events_group_event_id_seq ??
>
> My postgres version is 7.2.2.
>
>
> Sample Code
>
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073