[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 partition

[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 exec

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

[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 un

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

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; ALT

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 PROTECT