Re: [GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Alvaro Herrera
On Sat, Oct 18, 2003 at 01:40:04PM -0600, Robert Creager wrote: > But, I cannot turn of logging of the duration! It's set to > log_min_duration_statement = 0, but still logs the duration of every > statement. This didn't happen with 7.4b4... I've set it high to not > log most statements. The v

Re: [GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Robert Creager
When grilled further on (Sat, 18 Oct 2003 15:46:55 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > But, I cannot turn of logging of the duration! It's set to > > log_min_duration_statement = 0, > > -1 turns it off now. > Thanks. Didn't even thi

Re: [GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Tom Lane
Robert Creager <[EMAIL PROTECTED]> writes: > But, I cannot turn of logging of the duration! It's set to > log_min_duration_statement = 0, -1 turns it off now. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/rea

Re: [GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Robert Creager
When grilled further on (Sat, 18 Oct 2003 13:12:41 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > select * from test_table where field_1 = '1'; -- fails > > The last select fails with 'operator is not unique: test_domain = "unknown"' > > Works as

[GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Robert Creager
I'm using 7.4b4 with domains, and am having a problem with selecting without casting. create domain test_domain as integer check( (value notnull) and (value >= 1) ); create table test_table( field_1 test_domain, field_2 integer ); insert into test_table values( 1, 1 ); insert into test_table valu

Re: [GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Tom Lane
Robert Creager <[EMAIL PROTECTED]> writes: > select * from test_table where field_1 = '1'; -- fails > The last select fails with 'operator is not unique: test_domain = "unknown"' Works as expected in CVS tip ... regards, tom lane ---(end of broadca