Re: trouble with the automatic indexes on CREATE TABLE - Mailing list pgsql-general

From Tom Lane
Subject Re: trouble with the automatic indexes on CREATE TABLE
Date
Msg-id 17324.990025206@sss.pgh.pa.us
Whole thread Raw
In response to trouble with the automatic indexes on CREATE TABLE  (Bill McGonigle <mcgonigle@medicalmedia.com>)
List pgsql-general
Bill McGonigle <mcgonigle@medicalmedia.com> writes:
> There is one discussion of NAMEDATALEN in the archives, pertaining to
> version 6.4.2.  That discussion brings up a few questions/assumptions
> related to getting this to work reliably.  I'd love to hear any
> comments/corrections/amplifications:

> 1) It was required that OIDNAMELEN be set to sizeof(Oid) + NAMEDATALEN.

OIDNAMELEN is long gone.  You don't have to change anything except
NAMEDATALEN.

> 3) Will psql from another machine fail to work if that machine's pgsql
> hasn't been compiled with the modified MAXDATALEN?  Is this the same
> question as (2)?

The reason NAMEDATALEN is in postgres_ext.h is that it's visible to (and
used by) clients as well as the backend.  So yes, you'd better recompile
everything.  I am not sure what problems you would have with mismatched
clients.  If you're lucky, they'll merely truncate your longer names,
and not coredump ...

            regards, tom lane

pgsql-general by date:

Previous
From: Bill McGonigle
Date:
Subject: Re: trouble with the automatic indexes on CREATE TABLE
Next
From: "Keith G. Murphy"
Date:
Subject: Re: Re: Which Front End for Postgresql