Re: PL argument max size, and doubt - Mailing list pgsql-sql

From Tom Lane
Subject Re: PL argument max size, and doubt
Date
Msg-id 14547.1195668326@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL argument max size, and doubt  (Martin Marques <martin@marquesminen.com.ar>)
Responses Re: PL argument max size, and doubt  (Martin Marques <martin@marquesminen.com.ar>)
List pgsql-sql
Martin Marques <martin@marquesminen.com.ar> writes:
> Rodrigo De León escribió:
>> "In any case, the longest possible character string that can be stored
>> is about 1 GB."
>> 
> I was asking about the limit in the argument. Is it the same as the 
> limits the types have in table definition?

Yeah, ultimately this is a palloc() restriction on the size of any one
data value.

> I have always heard that modification queries should be EXECUTED in PL. 
> AFAICR.

Run far away from whatever source gave you that advice...
        regards, tom lane


pgsql-sql by date:

Previous
From: Martin Marques
Date:
Subject: Re: PL argument max size, and doubt
Next
From: Andreas
Date:
Subject: update on join ?