Data Type...

Started by Franck Martinalmost 26 years ago2 messagesgeneral
Jump to latest
#1Franck Martin
Franck@sopac.org.fj

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&gt;

#2John Henderson
jrh@is.com.fj
In reply to: Franck Martin (#1)
Re: Data Type...

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...

Show quoted text

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&gt;