Is the size limit 8K for 'text' field types as well?
----- Original Message -----
From: "Guy Fraser" <guy@incentre.net>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, September 10, 2003 9:40 AM
Subject: Re: [GENERAL] Picture with Postgres and Delphi
> What is the size limit of bytea, I thought it was 8K?
>
> How do you dump your database when you have bytea, do you need to do a
> binary dump?
>
> What are you using to insert the binary data?
>
> Thank you in advance.
>
> Guy
>
> Jonathan Bartlett wrote:
>
> >>For the education of me and maybe others too, why was
> >>that? i.e. what problems did you run into, that bytea avoids?
> >>
> >>
> >>
> >
> >Compared to the filesystem, bytea provides data integrity.
> >
> >Bytea gives you remote access, which you can cache if needed.
> >
> >Bytea gives you the same permissions as anything else in Postgres, so you
> >don't have to worry about that separately.
> >
> >Compared to BLOBs, bytea's are just simpler. You can select them with a
> >single statement, you don't have to worry about leaving unreferenced
> >BLOBs, and, after 4 billion inserts, byteas are still meaningful while
> >BLOBs might not be. (due to OID problems).
> >
> >Jon
> >
> >
> >
> >
> >>__________________________________
> >>Do you Yahoo!?
> >>Yahoo! SiteBuilder - Free, easy-to-use web site design software
> >>http://sitebuilder.yahoo.com
> >>
> >>
> >>
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faqs/FAQ.html
> >
> >
> >
> >
>
> --
> Guy Fraser
> Network Administrator
> The Internet Centre
> 780-450-6787 , 1-888-450-6787
>
> There is a fine line between genius and lunacy, fear not, walk the
> line with pride. Not all things will end up as you wanted, but you
> will certainly discover things the meek and timid will miss out on.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
