to the new installation, where they could cause real
problems with any app that tries to use those fields, and a headache to debug.
> - Original Message -
> From: Rob Arnold
> To: Jeff Eckermann ; Miroslav Koncar
> Cc: [EMAIL PROTECTED]
> Sent: Thursday, August 2
I can make this happen consistently with Perl DBI by placing a
$dbh->disconnect() in the DESTROY subroutine of an object. I doubt the two
issues have much in common, but there's my $.02. You might post to the list
(not me, I'm ignorant) how you managed to make this happen.
--rob
- Original
The coalesce function can help with nulls. It takes a list of attributes or
literals and returns the first non-null value.
I use it like this:
select coalesce(numeric_attrib, 0) from some_table;
--rob
- Original Message -
From: "Bruno Wolff III" <[EMAIL PROTECTED]>
To: "postgresql" <[
I had a machine with a bad CPU that did that, but I don't know that this is
your case.
Perhaps a bad index?
Can you determine if only one table is the cause (i.e. Vacuum Analyze
).
Anything in the logs?
--rob
- Original Message -
From: "Dave Cramer" <[EMAIL PROTECTED]>
To: <[EMAIL PRO
