From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | andras(at)reea(dot)net, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Bug #852: Wrong sequence name generated |
Date: | 2002-12-20 17:43:45 |
Message-ID: | 200212201743.gBKHhkb17525@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2002-12-21 01:19:44 | Bug #853: Software unavailable on any US mirror |
Previous Message | Tom Lane | 2002-12-20 15:09:55 | Re: Bug #852: Wrong sequence name generated |