Re: length(columnname), solved
| От | Andreas Fitzner |
|---|---|
| Тема | Re: length(columnname), solved |
| Дата | |
| Msg-id | 20020115104254.A8568@jazz.informatik.hu-berlin.de обсуждение исходный текст |
| Ответ на | Re: length(columnname), solved ("Christopher" <christopher@chronofish.com>) |
| Ответы |
PL/PGSQL
|
| Список | pgsql-novice |
Hi Christopher, On Mon, Jan 14, 2002 at 07:31:49AM -0500, Christopher wrote: > I am a novice so maybe this is not the right response, but couldn't you > have also quoted your table name? this wouldn't save me against the truncation to 31 characters! > create table > "ThisIsAReallyReallyReallyReallyReallyReallyReallyReallyReallyReallyReal > lyReallyLongTableName" (test int); > > I also noticed that you are using capitals in your name and I know you > would have to quote for that reason (at least in the version of Postgres > that I'm using) you're right. > Recompiling the source code seems > like a dangerous way to go - i.e. what happens when the database is > moved to a different system? What if you don't have permission to > rebuild Postgres? yes, you're right. recompiling has serveral drawbacks. anyhow, it works for now, and i can have my reallyreallylongtablenames. :-) best wishes, Andreas
В списке pgsql-novice по дате отправления: