Re: Table name lengths...
От | Ron Johnson |
---|---|
Тема | Re: Table name lengths... |
Дата | |
Msg-id | 1062536263.7342.244.camel@haggis обсуждение исходный текст |
Ответ на | Re: Table name lengths... (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
On Tue, 2003-09-02 at 12:47, Tom Lane wrote: > Ron Johnson <ron.l.johnson@cox.net> writes: > > No matter how long PostgreSQL lets you make table names, I'd stick > > with ANSI standard 31 characters. > > "ANSI standard"? SQL92 specifies that names can be up to 128 characters > long. Perhaps there was a shorter limit in SQL89, but that ranks as > ancient history now. > > (In fact, I just now realized that it says *characters*, not *bytes*, > which means that in a multibyte encoding you could need quite a bit more > than 128 bytes to meet the spec's requirement...) Ok, color me erroneous. The 31 octet length is on Rdb/VMS, and was picked because that's how long VMS file names were/are. Also, Oracle has an object limit of 30 characters. -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA Regarding war zones: "There's nothing sacrosanct about a hotel with a bunch of journalists in it." Marine Lt. Gen. Bernard E. Trainor (Retired)
В списке pgsql-general по дате отправления: