[BUGS] BUG #4271: dropped columns conflict with returning rules

2008-06-29 Thread Alexey Bashtanov
The following bug has been logged online: Bug reference: 4271 Logged by: Alexey Bashtanov Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: linux Description:dropped columns conflict with returning rules Details: I have created a

[BUGS] BUG #4272: No password can CREATE DROP database!!

2008-06-29 Thread y.y.chen
The following bug has been logged online: Bug reference: 4272 Logged by: y.y.chen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 8.3 Operating system: Server Fedora3 ,client WIN-XP Description:No password can CREATE DROP database!! Details: I can

Re: [BUGS] BUG #4271: dropped columns conflict with returning rules

2008-06-29 Thread Tom Lane
Alexey Bashtanov [EMAIL PROTECTED] writes: I have created a partitioned table cache with partitions cache_id_g_4184088 and cache_id_le_4184088 those inherit cache. I provided insert by the following rule: CREATE RULE cache_partic AS ON INSERT TO cache DO INSTEAD INSERT INTO cache_id_g_4184088

[BUGS] BUG #4274: uuid returns duplicate values

2008-06-29 Thread eric melbardis
The following bug has been logged online: Bug reference: 4274 Logged by: eric melbardis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: windows xp sp3 Description:uuid returns duplicate values Details: the uuid functions do not return

Re: [BUGS] BUG #4271: dropped columns conflict with returning rules

2008-06-29 Thread Tom Lane
Alexey Bashtanov [EMAIL PROTECTED] writes: What did you do *exactly*? Here's the example of command sequence that lead to this error: luh=# create table foo(a int); CREATE TABLE luh=# alter TABLE foo add column b int; ALTER TABLE luh=# alter TABLE foo drop column b; ALTER TABLE luh=#

Re: [BUGS] BUG #4271: dropped columns conflict with returning rules

2008-06-29 Thread Alexey Bashtanov
Hello, Tom! What did you do *exactly*? Here's the example of command sequence that lead to this error: luh=# create table foo(a int); CREATE TABLE luh=# alter TABLE foo add column b int; ALTER TABLE luh=# alter TABLE foo drop column b; ALTER TABLE luh=# alter TABLE foo add column c int;

Re: [BUGS] BUG #4274: uuid returns duplicate values

2008-06-29 Thread Hiroshi Saito
Hi. I'm sorry delaying release bugfix was not included in pg8.3.3. Please try this. http://winpg.jp/~saito/pg_work/OSSP_win32/ Regards, Hiroshi Saito The following bug has been logged online: Bug reference: 4274 Logged by: eric melbardis Email address: [EMAIL PROTECTED]