[BUGS] BUG #5573: How can i add field inbetween in the table while creating

2010-07-27 Thread Vimi
The following bug has been logged online: Bug reference: 5573 Logged by: Vimi Email address: vimmip...@gmail.com PostgreSQL version: Ver 8.4.1 Operating system: Windows 7 Description:How can i add field inbetween in the table while creating Details: If i have

Re: [BUGS] BUG #5573: How can i add field inbetween in the table while creating

2010-07-27 Thread Joshua Tolley
On Tue, Jul 27, 2010 at 07:34:56AM +, Vimi wrote: If i have already crreated one table and i wan to add one more field into table but its ibetween imean if i have 4 fields are already created and if i want to add one more field aat 2nd index then how can i do in postgre. i tried in Navicat

Re: [BUGS] BUG #5573: How can i add field inbetween in the table while creating

2010-07-27 Thread Kevin Grittner
Vimi vimmip...@gmail.com wrote: How can i add field inbetween in the table while creating This is not a bug; in the future please post such questions to pgsql-general. While the feature you're requesting is likely to appear in a future release, current releases require that you create a new

[BUGS] BUG #5574: PANIC on hot-standby: heap_update_redo

2010-07-27 Thread Valentine Gogichashvili
The following bug has been logged online: Bug reference: 5574 Logged by: Valentine Gogichashvili Email address: val...@gmail.com PostgreSQL version: 9.0beta3 Operating system: RedHat Linux (2.4.21-53.ELsmp) Description:PANIC on hot-standby: heap_update_redo Details:

Re: [BUGS] failed to fetch tuple for EvalPlanQual recheck

2010-07-27 Thread Alvaro Herrera
Excerpts from Kenichiro Tanaka's message of dom jul 25 21:01:01 -0400 2010: This is a bug report. When I tested in PostgreSQL9 beta3,I got an error. == select * from part_bug where HIRENUM=4 for update; failed to fetch tuple for EvalPlanQual

Re: [BUGS] failed to fetch tuple for EvalPlanQual recheck

2010-07-27 Thread Andres Freund
On Tue, Jul 27, 2010 at 04:13:56PM -0400, Alvaro Herrera wrote: Excerpts from Kenichiro Tanaka's message of dom jul 25 21:01:01 -0400 2010: This is a bug report. When I tested in PostgreSQL9 beta3,I got an error. == select * from part_bug

Re: [BUGS] pg_upgrade issues

2010-07-27 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Excerpts from depstein's message of lun jul 26 08:05:24 -0400 2010: I just want to note that one reason regclass may be used in user tables (as opposed to, say, regtype) is that in PL/pgSQL trigger procedures there is a special variable

Re: [BUGS] failed to fetch tuple for EvalPlanQual recheck

2010-07-27 Thread Alvaro Herrera
Excerpts from Andres Freund's message of mar jul 27 17:20:37 -0400 2010: On Tue, Jul 27, 2010 at 04:13:56PM -0400, Alvaro Herrera wrote: Excerpts from Kenichiro Tanaka's message of dom jul 25 21:01:01 -0400 2010: This is a bug report. When I tested in PostgreSQL9 beta3,I got an error.

Re: [BUGS] BUG #5574: PANIC on hot-standby: heap_update_redo

2010-07-27 Thread Tom Lane
Valentine Gogichashvili val...@gmail.com writes: A hot-standby machine was recieving WAL files for 2 days now (omnipitr scripts), and then it crashed with the following error: 2010-07-27 15:26:09.759 CEST,,,22151,,4c49acba.5687,5697,,2010-07-23 16:52:42

Re: [BUGS] BUG #5574: PANIC on hot-standby: heap_update_redo

2010-07-27 Thread valgog
On Jul 27, 5:02 pm, val...@gmail.com (Valentine Gogichashvili) wrote: The following bug has been logged online: Bug reference:      5574 Logged by:          Valentine Gogichashvili Email address:      val...@gmail.com PostgreSQL version: 9.0beta3 Operating system:   RedHat Linux

Re: [BUGS] failed to fetch tuple for EvalPlanQual recheck

2010-07-27 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Excerpts from Andres Freund's message of mar jul 27 17:20:37 -0400 2010: I guess youve compiled with --enable-cassert and Kenchiro-san has not? Eh, of course. I'm just pointing out that this is a serious bug :-) I spent some time looking at

Re: [BUGS] BUG #5543: Poor performance - Index scan backwards not used for order by desc with partitioned tables

2010-07-27 Thread Robert Haas
On Tue, Jul 6, 2010 at 2:20 PM, Ranga Gopalan ranga_gopa...@hotmail.com wrote: The following bug has been logged online: Bug reference:      5543 Logged by:          Ranga Gopalan Email address:      ranga_gopa...@hotmail.com PostgreSQL version: 8.4.4 Operating system:   Linux x86-64

Re: [BUGS] BUG #5543: Poor performance - Index scan backwards not used for order by desc with partitioned tables

2010-07-27 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: Does it help if you put a CHECK (false) constraint on the parent table? It won't --- it'll still result in an append plan even if there's only one surviving child. This is one of many things that seem to me to not make sense to tackle until we have an

Re: [BUGS] BUG #5543: Poor performance - Index scan backwards not used for order by desc with partitioned tables

2010-07-27 Thread Robert Haas
On Tue, Jul 27, 2010 at 7:27 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Does it help if you put a CHECK (false) constraint on the parent table? It won't --- it'll still result in an append plan even if there's only one surviving child. This is one of