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