Help with Toast.

From: "Alexis Maldonado" <alex(at)ctc-disted(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Help with Toast.
Date: 2001-11-19 19:20:40
Message-ID: 00e801c1712f$47410690$14818b0a@ctcd.cc.tx.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need help..

I dont know how to use Toast..
i have created an email client that i built from scratch in cold fusion
that works with all mayor databases (access,mssql,oracle, and mysql).
i am currently trying to port it to postgresql..
everything works EXEPT.. when i try to insert a record
that hase a huge message text. i get a Query too large error message..
the "message" field is text type.

is toast atomatic? should it be working as soon as i set up any table with
a
text type of field or is it a different field type..??..

i've been looking for help everywhere on the net but i couldnt
find a howto on how to use Toast..
i am using Postgresql 7.1 and i know it has toast but i dont have an idea
on
how to make it work at all..

frustrated..
HEEELP.. :(

Alex,

Browse pgsql-general by date

  From Date Subject
Next Message anodos 2001-11-19 19:53:25 Good configuration?
Previous Message Tom Lane 2001-11-19 19:10:59 Re: Packages for RH7.2