| From: | "Richard Huxton" <dev(at)archonet(dot)com> |
|---|---|
| To: | "Antti Linno" <alligator(at)all(dot)ee>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: TEXT field size |
| Date: | 2001-06-26 13:34:58 |
| Message-ID: | 007701c0fe44$cbe09c20$1001a8c0@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
From: "Antti Linno" <alligator(at)all(dot)ee>
> Hallo.
>
> Maybe its not the right list, but does the Postgres 7.1 support now
> unlimited text field? In previous versions it was limited to max 31k, or
> even less, depending on the compilation etc.
Yes - look for details of TOAST in the docs. Text fields can be effectively
unlimited and IIRC might even get compressed if circumstances look good.
There were some issues with old clients (ODBC/JDBC etc) not knowing this and
enforcing the old 8KB rule but I think they're probably updated now.
- Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bhuvan A | 2001-06-26 13:54:17 | ConnecDB() -- couldn't send SSL negotiation packet: |
| Previous Message | Richard Huxton | 2001-06-26 13:32:55 | Re: Plsql Function with error: No space left on device. |