Re: [SQL] FATAL 1

2002-07-24 Thread Ian Cass
L 1: fixrdesc: no pg_class entry for pg_class (repeat until I restart pg) nothing in /var/log/postgres.log -- Ian Cass - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Ian Cass" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wedn

[SQL] FATAL 1

2002-07-22 Thread Ian Cass
i May 3 11:45:59 UTC 2002 i686 unknown -- Ian Cass ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Help with function optimisation

2002-07-10 Thread Ian Cass
WHERE date = date_trunc(''hour'', NEW.logtime) AND client_id = NEW.client_id AND originator = NEW.originator; END IF; END IF; RETURN NEW; END; ' LANGUAGE 'plpgsql'; -- Ian Cass ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Quickest way to insert unique records?

2002-06-26 Thread Ian Cass
hat hit a duplicate, it would fail wouldn't it? Also, would this actually be any quicker than direct insertion from Perl DBI? -- Ian Cass ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Another postgres 'file not found' error

2002-06-13 Thread Ian Cass
e using this configuration whilst trying to find the problem, however I'll defer any future migrations though until I've got to the root of it. -- Ian Cass ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster