[BUGS] BUG #8091: No permissions on the table file causing recovery failure

2013-04-18 Thread haribabu . kommi
The following bug has been logged on the website: Bug reference: 8091 Logged by: Hari Babu Email address: haribabu.ko...@huawei.com PostgreSQL version: 9.2.4 Operating system: Linux Description: During the testing of fixed old defect with some altered scenario leads t

[BUGS] BUG #8092: pg_dump need sur quoting schema name

2013-04-18 Thread xavier . mouton-dubosc
The following bug has been logged on the website: Bug reference: 8092 Logged by: Xavier Mouton-Dubosc Email address: xavier.mouton-dub...@notalus.fr PostgreSQL version: 9.2.4 Operating system: Linux Ubuntu 12.10 Description: When I dump "default" schema pg_dump -s --

Re: [BUGS] BUG #8092: pg_dump need sur quoting schema name

2013-04-18 Thread Alvaro Herrera
xavier.mouton-dub...@notalus.fr wrote: > works well. But when I try to dump "other" schema > pg_dump -s --schema="other" [...] > > I have this error: > pg_dump: No matching schemas were found > > I have to surquote schema name to have it working > pg_dump -s --schema="\"other\"" [...] > > see

Re: [BUGS] BUG #8025: PostgreSQL crash (>= 9.1 64 bit)

2013-04-18 Thread Jeff Janes
I've bisected this down to this commit: commit 0f61d4dd1b4f95832dcd81c9688dac56fd6b5687 Author: Tom Lane Date: Fri Nov 19 17:31:50 2010 -0500 Improve relation width estimation for subqueries. And looking at the core dump, #0 make_rel_from_joinlist (root=0xee4fb8, joinlist=) at allpaths.

[BUGS] BUG #8094: psql prompt variable and command substitution broken

2013-04-18 Thread nyetter
The following bug has been logged on the website: Bug reference: 8094 Logged by: Noah Yetter Email address: nyet...@gmail.com PostgreSQL version: 9.2.4 Operating system: Linux (Amazon AMI Linux x64, kernel 3.2.39) Description: My psql PROMPT1, set through /etc/sysconf

Re: [BUGS] BUG #8094: psql prompt variable and command substitution broken

2013-04-18 Thread Tom Lane
nyet...@gmail.com writes: > My psql PROMPT1, set through /etc/sysconfig/pgsql/psqlrc, is the following: > h:%M%040d:%/%040U:%n%040AC:%:AUTOCOMMIT:%040TX:%x%012%R%#%040 You did not show us exactly how you set that, but I speculate that you weren't bothering to quote it. 9.2 is more consistent than

Re: [BUGS] BUG #8025: PostgreSQL crash (>= 9.1 64 bit)

2013-04-18 Thread Tom Lane
Jeff Janes writes: > I've bisected this down to this commit: > commit 0f61d4dd1b4f95832dcd81c9688dac56fd6b5687 Oh, that's fixed already --- it went in just in time for the last set of minor releases. See d931ac0ec et al. regards, tom lane -- Sent via pgsql-bugs mailin

Re: [BUGS] BUG #8094: psql prompt variable and command substitution broken

2013-04-18 Thread Noah Yetter
Thanks, quoting does indeed fix it. It's worth noting that comparing the 9.1 and 9.2 documentation, there is no hint that quoting/substitution behavior changed. Or put another way, the docs say very little about quoting/substitution behavior in general, aside from one highly confusing "Note:" blo

Re: [BUGS] BUG #8092: pg_dump need sur quoting schema name

2013-04-18 Thread Xavier Mouton-Dubosc
Yes. structure is kind of [a-zA-Z0-9\-_]{4,} Le 18/04/2013 17:00, Alvaro Herrera a écrit : xavier.mouton-dub...@notalus.fr wrote: works well. But when I try to dump "other" schema pg_dump -s --schema="other" [...] I have this error: pg_dump: No matching schemas were found I have to surquote

[BUGS] BUG #8093: After starting postgres, any attempt to connect generate a core dump and unable to login

2013-04-18 Thread bmohareb
The following bug has been logged on the website: Bug reference: 8093 Logged by: Beshoy Email address: bmoha...@gmail.com PostgreSQL version: 9.0.4 Operating system: redhat 5 64bit Description: $ psql seo psql (9.0.4) Type "help" for help. *** glibc detected *** psql

[BUGS] BUG #8095: postgres acquiring lock on a table when not in transaction

2013-04-18 Thread vaiayand
The following bug has been logged on the website: Bug reference: 8095 Logged by: Nachiket Vaidya Email address: vaiay...@gmail.com PostgreSQL version: 9.2.4 Operating system: ubuntu Description: Issue: -- We investigated one issue and found the following: postgres

[BUGS] BUG #8096: unable to create language PLl/TCL

2013-04-18 Thread visionsw
The following bug has been logged on the website: Bug reference: 8096 Logged by: Wimal Email address: visio...@sltnet.lk PostgreSQL version: 9.2.0 Operating system: Windows XP Description: createlanguage command gives DLL error on pltcl.dll -- Sent via pgsql-bugs