Re: length(columnname), solved - Mailing list pgsql-novice

From Christopher
Subject Re: length(columnname), solved
Date
Msg-id 000001c19cf7$70971810$6401a8c0@razorfish
Whole thread Raw
In response to length(columnname), solved  (Andreas Fitzner <fitzner@informatik.hu-berlin.de>)
Responses Re: length(columnname), solved  (Andreas Fitzner <fitzner@informatik.hu-berlin.de>)
List pgsql-novice
I am a novice so maybe this is not the right response, but couldn't you
have also quoted your table name?  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?

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)

- Christopher




-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Andreas Fitzner
Sent: Monday, January 14, 2002 6:39 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] length(columnname), solved

Hi,

I discovered src/include/postgres_ext.h, with the definition of
NAMEDATALEN.
problem solved.

thanks,
 Andreas


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-novice by date:

Previous
From: Dale Gilbert
Date:
Subject: Error compiling on SCO
Next
From: root
Date:
Subject: location for pgsql data