Hi,
I can easily crash the backend of current- postgres on current- FreeBSD with
loading a database with test.sql and test.dmp an executing the script x.sql.
Anyone else?
Bye!
----
Michael Reifenberger
Plaut Software GmbH, R/3 Basis
CREATE TABLE b (begt datetime, kid int4);
CREATE TABLE a (kid int4);
CREATE TABLE c (a int4, b varchar(30), c int4);
CREATE INDEX b_0 on b using btree ( begt datetime_ops );
CREATE INDEX b_1 on b using btree ( kid int4_ops );
CREATE INDEX a_0 on a using btree ( kid int4_ops );
COPY b FROM stdin;
\.
COPY a FROM stdin;
\.
COPY c FROM stdin;
1 foo 1
2 foo bar 2
3 \N 3
4 \\serverla 4
\.
explain SELECT a.kid as foo
FROM a, b WHERE
a.kid = b.kid AND
( b.kid = 23 OR
b.kid = 36 );