Re: length(columnname), solved

From: Andreas Fitzner <fitzner(at)informatik(dot)hu-berlin(dot)de>
To: Christopher <christopher(at)chronofish(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: length(columnname), solved
Date: 2002-01-15 09:42:55
Message-ID: 20020115104254.A8568@jazz.informatik.hu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

  • PL/PGSQL at 2002-01-15 22:22:33 from Burra

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2002-01-15 10:18:42 Re: inheritance and audit columns
Previous Message Tom Lane 2002-01-15 01:22:59 Re: Error compiling on SCO