On Fri, 6 Apr 2001, Aarmel wrote:
> We want to insert text into a table. Large amounts of text.
>
> The limit on the version we have at the moment is around 9000 characters.
> I'd estimate we'd need to be able to insert around 20,000 to 50,000
> characters.
>
> Does Version 7.0.3 have a limit, is 7.1 the only version with no limit.
7.0.3 has a limit of 8KB by default. Version 7.1 does not have any limit.
>
> Are there confiuration settings in postgres to set a limit? or do I just
> have to use blobs and lobs :(
I wouldn't recommende blobs/lobs. You can recompile 7.0.3 with a BLOCKSIZE
of 32KB instead of 8KB or you can use version 7.1RC2 which you can find in
ftp://ftp.postgresql.org/pub/dev
The 7.1 Release Candidate 2 is quite stable.
HTH,
Poul L. Christiansen