Re: [BUGS] BUG #1294: Random errors (failed connection)

2004-10-25 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > Please consider changing the default for IRIX systems to select() instead of > poll(). Can you suggest a test for configure to determine that poll() is broken? I'm not particularly excited about assuming that every past and future IRIX version

Re: [BUGS] BUG #1295: Problem on trigger

2004-10-25 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > CREATE OR REPLACE FUNCTION _test_delete_and_drop() > RETURNS void AS $$ > BEGIN > DELETE FROM _test; > DROP TABLE _test; > RETURN; > END; > $$ LANGUAGE plpgsql; This will work fine the first time. When you recreate the "_test"

[BUGS] BUG #1295: Problem on trigger

2004-10-25 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1295 Logged by: shancheng Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Fedora2 Description:Problem on trigger Details: I have a table for test. CREATE TABLE _test(id int

Re: [BUGS] aggregates other than count accpet *

2004-10-25 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > PostgreSQL allows aggregates other than COUNT to accept * as the arugment. This is not a bug, it's extensibility ;-) regards, tom lane ---(end of broadcast)--- TIP 2: you can get of

[BUGS] aggregates other than count accpet *

2004-10-25 Thread Kris Jurka
PostgreSQL allows aggregates other than COUNT to accept * as the arugment. Combined with the transformation of * -> 1 you get odd results from SELECT MIN(*), MAX(*) FROM tab; instead of an error. Kris Jurka ---(end of broadcast)--- TIP 2: you ca

[BUGS] BUG #1294: Random errors (failed connection)

2004-10-25 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1294 Logged by: Stefanos Harhalakis Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.5 Operating system: IRIX 6.5.17 Description:Random errors (failed connection) Details: This bug is tested again