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/pgsql-patches/2001-06/msg00061.html regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
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 and EXECUTE'd, rather than just writing them in-line in the plpgsql code. Pretty grotty but it might serve for now. Eventually plpgsql needs to have a way to discard query plans that have been obsoleted by DDL changes. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
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 existing application > > which also works with MySQL, and I can't update to postgresql-7.1.x > > (I don't admin this server) > > > > in a TEXT field the image seems to be truncated at the first nul byte. > > To have the highest portability across ALL databases, you > might be best off by converting it to/from base64 or similar > in the client application and store the string in a text or > varchar attribute. I think that I'll modify the app anyway, since I fear to hit the tuple max size with some postgresql versions. I think it's better to store images outside the database, but the original app developper didn't seem to think the same ;-) bye, and thanks to all Jerome Alet ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
