Matt Vanderpol wrote:
> There is a maximum of about 8k for each record in the table.
> There is a maximum of 4k for each varchar that you have.
> There is a maximum of 1k that can be passed in any one field on a select
> query.
> The first two points are documented and make sense. The combination of
> the latter two numbers don't make sense because what is the point of
> having a maximum length varchar of 4k if you can only populate it with
> 1k of data?
> Also, in psql the query buffer has a max length of 20,000 characters.
when you say passed in a select, you mean returning from the select as in
select reallylongfield from uselesstable;
or do you mean
select into otheruselesstable from uselesstable
where reallylongfield = 'xxxxxxxxxx............. <continues for 1k+ ....';
for the latter, using the copy command ought to do. for the former, is
your varchar field so unique that there isn't a regular expression which
could identify it??? just a thought.
regarding the 20K query bugger (er. i mean buffer) - it'd be on my wish
list that this just defaults to 20K but if someone wanted to increase that
for a psql session, it could be an option such as
psql -qbuffer 64m
just my $0.02.
steve doliov