Thread: length(columnname), solved

Hi,

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

thanks,
 Andreas

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

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

Is there any way to pass messages containing a payload between two
PL/PGSQL stored procedures? (aka DBMS_PIPE in Oracle)

--------------------[-- burra@colorado.edu --]--------------------------