[BUGS] psql \i command with a missing file name doesn't rollback the transaction

2013-09-20 Thread Alexey Klyukin
Hi, We've discovered a surprising behavior of psql \i command. What we sometimes to add new tables to the database is: begin; \i /path/to/table/definitions/table1.sql \i /path/to/table/definitions/table2.sql ... \i /path/to/table/definitions/tableN.sql commit; What we discovered that some files

Re: [BUGS] Known issues for PostgreSQL server 8.1.19

2013-09-20 Thread Dashputre, Anurag (GE Healthcare)
Hi Andres, Thanks for your reply. We can't upgrade to newer version as of now. We just want to know list of known issues on 8.1.19. We will just note them down and do some impact analysis. Regards, Anurag Dashputre -Original Message- From: Andres Freund [mailto:and...@2ndquadrant.com]

Re: [BUGS] Known issues for PostgreSQL server 8.1.19

2013-09-20 Thread Thomas Kellerer
Dashputre, Anurag (GE Healthcare) wrote on 20.09.2013 08:39: Thanks for your reply. We can't upgrade to newer version as of now. We just want to know list of known issues on 8.1.19. We will just note them down and do some impact analysis. You will need to go through the release notes for every

Re: [BUGS] Known issues for PostgreSQL server 8.1.19

2013-09-20 Thread John R Pierce
On 9/20/2013 10:05 AM, Thomas Kellerer wrote: Dashputre, Anurag (GE Healthcare) wrote on 20.09.2013 08:39: Thanks for your reply. We can't upgrade to newer version as of now. We just want to know list of known issues on 8.1.19. We will just note them down and do some impact analysis. You will

[BUGS] Installing/Upgrading PostgreSQL 9.1.6 to 9.3 known bugs?

2013-09-20 Thread fburgess
1.) During our prior upgrade process we used pg_upgrade to move from pg 8.4.3 to 9.1.6 using the hard links install option, we also have our data spread across disk storage mediums; fiber, nas. Are there any known issues, bugs with using pg_upgrade to move from 9.1.6 to pg 9.3?2.) We also have to s

Re: [BUGS] Installing/Upgrading PostgreSQL 9.1.6 to 9.3 known bugs?

2013-09-20 Thread John R Pierce
On 9/20/2013 1:51 PM, fburg...@radiantblue.com wrote: 1.) During our prior upgrade process we used pg_upgrade to move from pg 8.4.3 to 9.1.6 using the hard links install option, we also have our data spread across disk storage mediums; fiber, nas. Are there any known issues, bugs with using pg_

[BUGS] BUG #8464: Update with subquery with limit occasionally updates too many rows

2013-09-20 Thread jturkel
The following bug has been logged on the website: Bug reference: 8464 Logged by: Joel Turkel Email address: jtur...@salsify.com PostgreSQL version: 9.2.4 Operating system: Ubunutu 12.04 (64-bit)/Kernel version 3.2 Description: An update statement in my application tha