[BUGS] BUG #8215: pg_dump includes table out of order in SQL dump

2013-06-06 Thread ijmorlan
The following bug has been logged on the website: Bug reference: 8215 Logged by: Isaac Morland Email address: ijmor...@uwaterloo.ca PostgreSQL version: 9.2.4 Operating system: Server: Ubuntu 12.04; Client: Mac OS X 10.5.8 Description: My understanding is that pg_dump

Re: [BUGS] BUG #8198: ROW() literals not supported in an IN clause

2013-06-06 Thread Rafał Rzepecki
On Wed, Jun 5, 2013 at 7:58 AM, Amit Kapila wrote: > On Wednesday, June 05, 2013 5:34 AM Rafał Rzepecki wrote: >> On Tue, Jun 4, 2013 at 12:35 PM, Amit Kapila >> wrote: >> > On Saturday, June 01, 2013 9:37 PM >> > >> >> Row type literals constructed with ROW() cause an error when used in >> >> an

Re: [BUGS] BUG #8192: On very large tables the concurrent update with vacuum lag the hot_standby replica

2013-06-06 Thread Jeff Janes
On Tue, Jun 4, 2013 at 5:57 AM, Federico Campoli wrote: > > I'm sorry, just guessing it could be a loop. > The read remains stuck on the same segment. > On my testbox I have at least 1 minute to 20 Mb/s. > On the live system the peak is 124 Mb/s for 2 to 3 minutes without any > progress in the wal

Re: [BUGS] BUG #8192: On very large tables the concurrent update with vacuum lag the hot_standby replica

2013-06-06 Thread Jeff Janes
On Tue, Jun 4, 2013 at 8:36 AM, Federico Campoli wrote: > > This is the gprof output for the profile. > This looks to me like the gprof of a process that is either idle, or completely IO bound. I'd probably approach this with a combination of "strace -T -ttt -p " and "lsof -p " on the PID of the

Re: [BUGS] BUG #8215: pg_dump includes table out of order in SQL dump

2013-06-06 Thread Tom Lane
ijmor...@uwaterloo.ca writes: > My understanding is that pg_dump is supposed to include tables in SQL dumps > in alphabetical order by table name. That's the default behavior as long as there are no ordering constraints that would dictate doing something else. You haven't provided enough info to

[BUGS] BUG #8216: TO_DATE does not support th format provided

2013-06-06 Thread sunitha . mudumba
The following bug has been logged on the website: Bug reference: 8216 Logged by: Sunitha Mudumba Email address: sunitha.mudu...@blss.com.au PostgreSQL version: 9.2.4 Operating system: Windows Description: To_date does not throw an error when an invalid date is provide