From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: On hardcoded type aliases and typmod for user types |
Date: | 2005-09-01 16:08:55 |
Message-ID: | 21187.1125590935@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> On Thu, Sep 01, 2005 at 08:50:27AM -0400, Tom Lane wrote:
>> varchar could do something like using 24 bits for the length
>> and 8 bits for an encoded indication of the charset.
> With the unfortunate effect that strings are limited to 16Mb instead of
> 1Gb.
No, only that you can't declare a specific maxlength for a varchar that
exceeds 16Mb ... and guess what, there is already a smaller limit than
that, on the grounds that if a user writes varchar(1000000000) he needs
a cluebat anyway. I think you might have momentarily confused typmod
with the varlena length word of an individual value.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2005-09-01 16:09:59 | Re: Minimally avoiding Transaction Wraparound in VLDBs |
Previous Message | Tom Lane | 2005-09-01 16:03:24 | Re: TODO item: set proper permissions on non-system schemas |