Re: [SQL] Column name's length

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pham, Thinh" <tpham(at)mail(dot)priority(dot)net>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] Column name's length
Date: 1999-06-01 21:31:56
Message-ID: 23795.928272716@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Pham, Thinh" <tpham(at)mail(dot)priority(dot)net> writes:
>> You will need to do an initdb --- you are making an incompatible change
>> in the format of the database. pg_dump with old code, initdb and reload
>> with new.

> I did all of those and still it gave me that problem.

Hmm, that probably means that Zalman hasn't found all the dependencies
on NAMEDATALEN after all :-(. Which version are you using, exactly?

> I just want to minimize the change
> as much as possible w/o touching the frontend.

I think you missed the point I made earlier: this sort of change will
require a frontend recompile because NAMEDATALEN is visible in frontend
apps.

regards, tom lane

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robert Chalmers 1999-06-01 21:44:00 Standard SQL commands - are they in 6.5?
Previous Message Pham, Thinh 1999-06-01 20:25:48 datetime function