Re: [SQL] Disk is full, what's cool to get rid of?

2006-07-27 Thread Wilkinson Charlie E
Won't help some of us, who set -m 0 on selected filesystems to begin with. But if we could get tune2fs -m -5 to work, then we could unreserve space that didn't previously exist. Think of the possibilties! I'll look into that as soon as I'm done modding my C compiler to handle the --force option

[SQL] VACUUM VERBOSE ANALYZE locking up?? Please help!

2001-10-10 Thread Wilkinson Charlie E
Title: VACUUM VERBOSE ANALYZE locking up?? Please help! Ok it doesn't kill the whole backend, but VACUUM... comes to a halt partway through and it's necessary to ^C out of the transaction in psql.  Sometimes trying again will work, mostly that doesn't work.  Restarting the backend and then do

RE: [SQL] List Concatination [warning]

2001-05-02 Thread Wilkinson Charlie E
Title: RE: [SQL] List Concatination [warning] A word of warning for the newbies... *Don't* create a function called textcat.  You *will* be sorry.  There's already a textcat builtin and you kinda need it for || and whatnot. (Yes, I found out the hard way...) There might be a better way to