Re: [GENERAL] URGENT - startup process (PID 29541) was terminated by signal 6

2006-10-07 Thread Emanuele Rocca
Hello Tom, * Tom Lane <[EMAIL PROTECTED]>, [2006-10-06 15:16 -0400]: > Um, were you running with full_page_writes off? Bad idea in 8.1 :-( ... The manual [1] says that full_page_writes is ignored and always treated as if it was set to on. Is it wrong? ciao, ema [1] http://www.postgresql.

Re: [GENERAL] UNIQUE constraints on function results

2006-10-05 Thread Emanuele Rocca
Hello Markus, * Markus Schiltknecht <[EMAIL PROTECTED]>, [2006-10-05 11:16 +0200]: > I've been trying to add a unique constraint on a row and a function > result of a row. I.e.: > > CREATE TABLE test ( > id SERIAL PRIMARY KEY, > t1 TEXT NOT NULL, > t2 TEXT NOT NULL, >