Re: [GENERAL] Large Object questions...

1999-08-09 Thread John Huttley
-Original Message- From: Howie <[EMAIL PROTECTED]> To: John Huttley <[EMAIL PROTECTED]> > >the one thing i miss is the ability to determine a lo's size ( >hinthintnudgenudgewinkwink ). Here's a snippet of code lo_lseek(cntl.conn, lo_fax,0, SEEK_END); length = lo_tell(cntl.conn,lo_f

Re: [GENERAL] Large Object questions...

1999-08-09 Thread Howie
On Fri, 30 Jul 1999, John Huttley wrote: > > You just haven't met the right application yet. > > in the manual there is a discussion on other methods that were previosly > used. > > The PG system is good, with minor limitations in the lo* API. > > I'm busy writing a faxserver application whe

Re: [GENERAL] Large Object questions...

1999-08-01 Thread Herouth Maoz
At 08:31 +0300 on 30/07/1999, John Huttley wrote: > I'm busy writing a faxserver application where all the fax page data is > stored as a blob. > > Its just so easy to use... How will you be backing it up? pg_dump never dumped large objects. IMO, if you need a specialized backup script, plus a

Re: [GENERAL] Large Object questions...

1999-07-29 Thread John Huttley
You just haven't met the right application yet. in the manual there is a discussion on other methods that were previosly used. The PG system is good, with minor limitations in the lo* API. I'm busy writing a faxserver application where all the fax page data is stored as a blob. Its just so e

Re: [GENERAL] Large Object questions...

1999-07-29 Thread William Drury
I have never understood why people would store binary data in an SQL database. Am I missing something? On Fri, 30 Jul 1999, Howie wrote: > > im in the process of converting a client from mysql to postgres. this > client has been storing images ( jpegs, gifs ) in their mysql database in > a B

[GENERAL] Large Object questions...

1999-07-29 Thread Howie
im in the process of converting a client from mysql to postgres. this client has been storing images ( jpegs, gifs ) in their mysql database in a BLOB field. the image is then shown to their staff via the web. oddly enough, no, its not porn. so, in the process of doing all these massive impor