Thread: Data Type...

Data Type...

From
Franck Martin
Date:
I would like to know if postgresql contains the varbinary type, and if the
record length is still limited to 8kB.

What are the plans to change it ? Postgresql 7.0 or 8.0 ?

Cheers..

Franck Martin
Network and Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
Fiji
E-mail: franck@sopac.org.fj <mailto:franck@sopac.org.fj>
Web site: www.sopac.org.fj <http://www.sopac.org.fj>


Re: Data Type...

From
"John Henderson"
Date:
Frank,
I don't know about varbinary. The 8k limit is expected to disappear in
version 7.1. The strategy to do this is known as TOAST. You might search the
archives for more details if you want them.
John Henderson

-----Original Message-----
From: Franck Martin <Franck@sopac.org.fj>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Saturday, April 15, 2000 12:39
Subject: [GENERAL] Data Type...


>I would like to know if postgresql contains the varbinary type, and if the
>record length is still limited to 8kB.
>
>What are the plans to change it ? Postgresql 7.0 or 8.0 ?
>
>Cheers..
>
>Franck Martin
>Network and Database Development Officer
>SOPAC South Pacific Applied Geoscience Commission
>Fiji
>E-mail: franck@sopac.org.fj <mailto:franck@sopac.org.fj>
>Web site: www.sopac.org.fj <http://www.sopac.org.fj>
>
>