pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTEXT field size
2+ messages / 2 participants
[nested] [flat]
* TEXT field size
@ 2001-06-26 11:32 Antti Linno <alligator@all.ee>
2001-06-26 13:34 ` Re: TEXT field size Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 2+ messages in thread
From: Antti Linno @ 2001-06-26 11:32 UTC (permalink / raw)
To: pgsql-sql
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.
Greetings,
Antti
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: TEXT field size
2001-06-26 11:32 TEXT field size Antti Linno <alligator@all.ee>
@ 2001-06-26 13:34 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2001-06-26 13:34 UTC (permalink / raw)
To: Antti Linno <alligator@all.ee>; pgsql-sql
From: "Antti Linno" <alligator@all.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-06-26 13:34 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-26 11:32 TEXT field size Antti Linno <alligator@all.ee>
2001-06-26 13:34 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox