Re: [SQL] Using the extract() function in plpgsql

Richard Huxton <[EMAIL PROTECTED]> writes: > 2. bad oid reference - even if we did recreate the table, the reference > to it is compiled in after the first run. Don't see a way around this one. You could work around that by making all the queries referencing the temp table be built up as strings

Re: [SQL] Storing image contents in TEXT fields

On Wed, Jun 27, 2001 at 11:17:28AM -0400, Jan Wieck wrote: > Jerome Alet wrote: > > Hi, > > > > I wanted to know if it's possible to store an image content in a TEXT field, > > or if another type is needed (in this case, then which one ?). > > > > I don't want to use BLOBs, because I modify an exi

Re: [SQL] Plsql Function with error: No space left on device.

"David M. Richter" <[EMAIL PROTECTED]> writes: > FATAL 2: ZeroFill(/usr/local/pgsql/data/pg_xlog/xlogtemp.30164) failed: > No such file or directory You ran out of disk space. Yes, the error message is misleading. That's fixed in current sources. See also http://www.ca.postgresql.org/mhonarc/