Re: Increasing Table Column Size in 7.0 Syntax

From: oberpwd(at)anubis(dot)network(dot)com (Wade D(dot) Oberpriller)
To: jatwood(at)bwanazulia(dot)com (J(dot) Atwood)
Cc: pgsql-general(at)postgresql(dot)org (general-help postgresql)
Subject: Re: Increasing Table Column Size in 7.0 Syntax
Date: 2000-11-01 17:53:29
Message-ID: 200011011753.LAA04213@truck.network.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This requires you to change NAMEDATALEN in src/include/postgres_ext.h.

Note this requires a recompile, initdb, createdb, etc.

Also note that databases with different NAMEDATALEN's can't interoperate.

Wade
>
> Hello,
>
> Looking at the docs for pgsql I have only found stuff on altering a table
> for default and renaming a column but nothing on changing the size. I want
> to increase the size of a field from 2048 to 4096.
>
> What is the syntax for this?
>
> Thanks,
> J
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Poole 2000-11-01 18:00:37 Re: Newbie Question
Previous Message Igor Roboul 2000-11-01 17:48:53 Re: Increasing Table Column Size in 7.0 Syntax