Re: Picture with Postgres and Delphi
От | Derrick Betts |
---|---|
Тема | Re: Picture with Postgres and Delphi |
Дата | |
Msg-id | 05a901c377b7$0de13790$e70a0a0a@BigOne обсуждение исходный текст |
Ответ на | Re: Picture with Postgres and Delphi (Jonathan Bartlett <johnnyb@eskimo.com>) |
Ответы |
Re: Picture with Postgres and Delphi
(Jonathan Bartlett <johnnyb@eskimo.com>)
Re: Picture with Postgres and Delphi ("scott.marlowe" <scott.marlowe@ihs.com>) Re: Picture with Postgres and Delphi (Richard Huxton <dev@archonet.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: