Re: [BUGS] Dropped index on table preventing rule creation

2011-09-10 Thread Tom Lane
Thom Brown writes: > I don't use rules, but in a bit of experimentation on Git master, I > discovered the following behaviour: > CREATE TABLE test1 (id serial primary key, things text); > CREATE TABLE test2 (id serial primary key, things text); > ALTER TABLE test1 DROP CONSTRAINT test1_pkey; > AL

[BUGS] BUG #6202: type of union column selection bug

2011-09-10 Thread Roman
The following bug has been logged online: Bug reference: 6202 Logged by: Roman Email address: zo...@oe-it.ru PostgreSQL version: 9.0.4 Operating system: Win7x64 Description:type of union column selection bug Details: Query select null union select 4 is Ok but select

[BUGS] Dropped index on table preventing rule creation

2011-09-10 Thread Thom Brown
Hi, I don't use rules, but in a bit of experimentation on Git master, I discovered the following behaviour: CREATE TABLE test1 (id serial primary key, things text); CREATE TABLE test2 (id serial primary key, things text); ALTER TABLE test1 DROP CONSTRAINT test1_pkey; ALTER TABLE test2 DROP CONSTR