[BUGS] FW: clarification for generate join implied equalities

2012-04-18 Thread Amit Kapila
No need to reply the below mail. I am able to generate the scenario. One of them is basically when there is an expression involving relations on one side and Var on other side. Select * from t1,t2 where t1.c1 + t2.c2 = t1.c3; From: Amit Kapila [mailto:amit.kap...@huawei.com] Sent: Thursday

Re: [BUGS] BUG #6601: Inconsistent behavior of ALTER TABLE ADD COLUMN

2012-04-18 Thread Jon Plotky
On Wed, Apr 18, 2012 at 7:44 PM, Tom Lane wrote: > > jon.plo...@gmail.com writes: > > Issue: After adding one new column to each of two different tables, querying > > pg_attribute shows the new column in one table but not the other. > > This is a bit hard to believe, and your log extract certainly

Re: [BUGS] BUG #6601: Inconsistent behavior of ALTER TABLE ADD COLUMN

2012-04-18 Thread Tom Lane
jon.plo...@gmail.com writes: > Issue: After adding one new column to each of two different tables, querying > pg_attribute shows the new column in one table but not the other. This is a bit hard to believe, and your log extract certainly doesn't provide any evidence to support the statement. Coul

[BUGS] BUG #6601: Inconsistent behavior of ALTER TABLE ADD COLUMN

2012-04-18 Thread jon . plotky
The following bug has been logged on the website: Bug reference: 6601 Logged by: jon Email address: jon.plo...@gmail.com PostgreSQL version: 8.4.7 Operating system: RedHat Enterprise Linux 6.2 (Linux version 2.6.32) Description: Not sure if this is a bug or not. Woul

Re: [BUGS] BUG #6204: Using plperl functions generate crash

2012-04-18 Thread Robert Haas
On Tue, Apr 10, 2012 at 7:01 AM, Simon Willett wrote: > I'm running into the same issue here. > > After install postgresql 9.1.2 and Activestate perl 5.14.2 execute: > create function perl_test() returns void as > $$ > $$ > language plperl > > Generates server crash. > > PostgreSQL version string:

Re: [BUGS] BUG #6572: The example of SPI_execute is bogus

2012-04-18 Thread Robert Haas
On Sun, Apr 15, 2012 at 12:29 PM, Tom Lane wrote: >> I think it would be a good idea for UPDATE and DELETE to expose >> a LIMIT option, but I can't really see the virtue in making that >> functionality available only through SPI. > > FWIW, I'm not excited about that.  You can get well-defined beha

Re: [BUGS] BUG #6593: REASSIGN OWNED fails on extensions

2012-04-18 Thread Alvaro Herrera
Excerpts from emiliano.leporati's message of lun abr 16 06:21:53 -0300 2012: > failtest=# create extension citext; > CREATE EXTENSION > failtest=# create table foo(bar integer); > CREATE TABLE > failtest=# reassign owned by ubik to dev; > ERROR: unexpected classid 3079 Will fix. -- Álvaro Her