| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "J(dot) 'FIK' Brand" <Jurgen(dot)Brand(at)tip(dot)nl> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Fieldname size ?? |
| Date: | 2001-12-08 19:25:22 |
| Message-ID: | 20011208112158.L48625-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, 8 Dec 2001, J. 'FIK' Brand wrote:
> I'm in the process of converting a database from MS to Postgres. In
> the database there is a table that as fieldnames that are longer that
> 32 characters. I can't change the client software.
>
> The problem is that Postgres does't support fieldnames that are long,
> is it possible to compile Postgres with fieldnames that can be 64
> characters ??
I believe if you change NAMEDATALEN (postgres_ext.h) you can change
the maximum length. I think you may need to initdb with the new settings.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-12-08 19:27:30 | Re: idle in transaction |
| Previous Message | Joshua -Poet- Drake | 2001-12-08 19:04:21 | Re: When do I Vacuum ? |