Обсуждение: Bug #852: Wrong sequence name generated
Andras Balogh (andras@reea.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
pgsql-bugs@postgresql.org writes: > the sequence that postgres generates is: groups_events_group_event_i_seq This is the expected behavior. > It shouldn't be groups_events_group_event_id_seq ?? No, because that identifier is too long. regards, tom lane
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@postgresql.org wrote: > Andras Balogh (andras@reea.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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073