Re: [BUGS] Bug #581: Sequence cannot be deleted
От | Tom Innes |
---|---|
Тема | Re: [BUGS] Bug #581: Sequence cannot be deleted |
Дата | |
Msg-id | 000001c1b414$303834a0$6901a8c0@TGIDesktopW20 обсуждение исходный текст |
Ответ на | Re: [BUGS] Bug #581: Sequence cannot be deleted (Ian Barwick <barwick@gmx.net>) |
Список | pgsql-hackers |
I have a similar problem. Where I have both long table names and long column names. Has the increase of the NAMEDATALEN been targeted for a release? From my perspective, I would prefer if the algorithm to determine the sequence name was more of a function on the table name rather than a combination of the table name and column name, as I have never created a table that has more than one sequence in it. I would also welcome the ability to have the drop table command drop the sequence as well. Tom -----Original Message----- From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Ian Barwick Sent: February 12, 2002 4:58 PM To: Tom Lane; pgsql-hackers@postgresql.org Cc: nbazin@ingenico.com.au; Brent Verner Subject: Re: [HACKERS] [BUGS] Bug #581: Sequence cannot be deleted On Tuesday 12 February 2002 21:48, Tom Lane wrote: > I believe that the surprising-name problem will largely go away anyway > as soon as we get around to increasing the default NAMEDATALEN. With > a decent name length no one would ever see truncation in practice. Sorry to butt in here, but I would second this suggestion. One of my databases has rather long-winded table and field names (mostly in German, which doesn't help much ;-). There aren't any which exceed 31 characters on their own, but sequences can get scarily long, so I always build with NAMEDATALEN set to 128, just to be on the safe side. Is there any reason for the default value (31 characters?), or are there any performance issues associated with longer values? > Also, of course, what we really want is for SERIAL sequences to get > dropped by themselves when the parent table is dropped, and then users > don't need to know what the generated sequence name is ... This would be nice. Yours Ian Barwick ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
В списке pgsql-hackers по дате отправления: