Re: table name size
От | Neil Conway |
---|---|
Тема | Re: table name size |
Дата | |
Msg-id | 1038434663.3556.24.camel@tokyo обсуждение исходный текст |
Ответ на | table name size (Felipe Schnack <felipes@ritterdosreis.br>) |
Список | pgsql-general |
On Wed, 2002-11-27 at 14:02, Felipe Schnack wrote: > I created a table named (in portuguese, sorry) > "questionariosAgrupamentosQuestoes". No problems. When I try to insert > data on it, using "insert into questionariosAgrupamentosQuestoes values > (...)" i get an error telling me that "questionariosAgrupamentosQuesto" > does not exists. Why pgsql is truncating the name of a table it created > successfully? How can I circumvent that? In releases prior to PostgreSQL 7.3, identifier names (e.g. the names of tables) are limited to 31 characters. You can change this by changing NAMEDATALEN in src/include/postgres_ext.h and recompiling (rememeber to do a 'make clean' first -- you'll also have to re-initdb). In PostgreSQL 7.3, the default NAMEDATALEN setting is 64, which allows identifier names up to 63 characters. Cheers, Neil -- Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
В списке pgsql-general по дате отправления: