Re: [HACKERS] Re: 7.2 items

2001-06-27 Thread Philip Warner
At 23:55 27/06/01 +0200, Peter Eisentraut wrote: >Hannu Krosing writes: > >> > > Is there an ISO/ANSI SQL interface to BLOB's defined someplace ? >> > >> > It's basically no different from regular character strings, i.e., >> > substring(), position(), ||, etc. >> >> So no standard seek/read/write

Re: [HACKERS] Re: 7.2 items

2001-06-27 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> What for/why bother? A toastable bytea column would do just as well. > There's still a 1 or 2 GB limit for data stored in that. 1 Gb, I believe ... but LOs are not a lot better; they'd max out at 2 or at most 4 Gb, depending on

Re: [HACKERS] Re: 7.2 items

2001-06-27 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Bruce Momjian writes: > Please, consider a BLOB column type without having to do lo_import, > lo_export. >> >> Yep, big needed item. > Maybe we could make the BLOB type a wrapper around the lo_* functions? > The BLOB value would only store the oid.

Re: [HACKERS] Re: 7.2 items

2001-05-14 Thread Tom Lane
Franck Martin <[EMAIL PROTECTED]> writes: > The uuidgen program creates a new universally unique identifier (UUID) > using the libuuid(3) >library. The new UUID can reasonably be considered unique among all > UUIDs created on the >local system, and among UUIDs created on othe

[HACKERS] Re: 7.2 items

2001-05-11 Thread Thomas F. O'Connell
Bruce Momjian wrote: > Here is a small list of big TODO items. I was wondering which ones > people were thinking about for 7.2? > > * Allow inherited tables to inherit index, UNIQUE constraint, and primary key > [inheritance] i was wondering if there was any thought still being given to Oliv