Re: [BUGS] pg_restore silently chokes on object comments/descriptions ending in a backslash

2011-07-27 Thread Tom Lane
Julian Mehnle writes: > If the comment/description of a database object (table, function, etc.) > ends in a backslash (which generally works fine otherwise), then > pg_restore is unable to completely restore a custom-format dump of the > schema. Reproduced here against HEAD. The problem seems to

Re: [BUGS] pg_restore silently chokes on object comments/descriptions ending in a backslash

2011-07-27 Thread Julian Mehnle
I'm subscribed to the pgsql-bugs list, so no need to CC me. :-) Tom Lane wrote: > Reproduced here against HEAD. The problem seems to be that > pg_backup_db.c's _sendSQLLine() contains a mini SQL lexer that is not > cognizant of standard_conforming_strings. Oh, right, I forgot to mention I have

Re: [BUGS] pg_restore silently chokes on object comments/descriptions ending in a backslash

2011-07-27 Thread Tom Lane
Julian Mehnle writes: > I'm subscribed to the pgsql-bugs list, so no need to CC me. :-) cc to people in the thread is the established practice on these lists. It provides a bit more robustness when the lists are busy or slow. You can set your subscription so the listserv won't send you an extra c

[BUGS] BUG #6132: Cannot install rpm files

2011-07-27 Thread Nivas
The following bug has been logged online: Bug reference: 6132 Logged by: Nivas Email address: niva...@gmail.com PostgreSQL version: 9.0 Operating system: Fedora 15 Description:Cannot install rpm files Details: Hi I cannot install postgresql on Fedora 15, please pro

Re: [BUGS] pg_restore silently chokes on object comments/descriptions ending in a backslash

2011-07-27 Thread Julian Mehnle
Tom Lane wrote: > Julian Mehnle writes: > > I'm subscribed to the pgsql-bugs list, so no need to CC me. :-) > > cc to people in the thread is the established practice on these lists. > It provides a bit more robustness when the lists are busy or slow. Got it. I'll try to remember that and CC ot

Re: [BUGS] pg_restore silently chokes on object comments/descriptions ending in a backslash

2011-07-27 Thread Alvaro Herrera
Excerpts from Julian Mehnle's message of miƩ jul 27 13:28:21 -0400 2011: > Tom Lane wrote: > > > Julian Mehnle writes: > > > I'm subscribed to the pgsql-bugs list, so no need to CC me. :-) > > > > cc to people in the thread is the established practice on these lists. > > It provides a bit more ro

Re: [BUGS] BUG #6132: Cannot install rpm files

2011-07-27 Thread Scott Mead
On Wed, Jul 27, 2011 at 11:19 AM, Nivas wrote: > > The following bug has been logged online: > > Bug reference: 6132 > Logged by: Nivas > Email address: niva...@gmail.com > PostgreSQL version: 9.0 > Operating system: Fedora 15 > Description:Cannot install rpm files >

Re: [BUGS] pg_restore silently chokes on object comments/descriptions ending in a backslash

2011-07-27 Thread Julian Mehnle
Alvaro Herrera wrote: > Note that CCing others is customary but obviously not mandatory. For the record, CCing posters who haven't explicitly requested it is frowned upon on the Debian mailing lists , but apparently those have a lower latency than the Pg ones. :-) I'll shut up now since this i

Re: [BUGS] BUG #6132: Cannot install rpm files

2011-07-27 Thread John R Pierce
On 07/27/11 10:56 AM, Scott Mead wrote: I cannot install postgresql on Fedora 15, please provide the installation procedure for Fedora 15. A) Where did you download them from (exact URL) ? B) What is the error you are getting? C) http://wiki.postgresql.org/wiki/Guide_to_reporting_pr

Re: [BUGS] Ambiguos OPERATOR items in pg_restore manifest file

2011-07-27 Thread Robert Haas
On Wed, Jul 20, 2011 at 8:24 AM, Renzo Kottmann wrote: > On 07/18/2011 05:25 PM, Robert Haas wrote: >> On Tue, Jul 12, 2011 at 9:18 AM, Sandro Santilli wrote: >>> Trying to exclude items from dumps of postgis-enabled databases >>> we use pg_restore -l output and strip what we think belong to Post

Re: [BUGS] BUG #5953: pgadmin sql-query text pad doesn't work

2011-07-27 Thread Robert Haas
On Mon, Jul 25, 2011 at 6:43 AM, p.de.waal wrote: > Is there already a fix for this, I just installed pgadmin version 1.12.3 on > windows 7. And I also have a problem with the SQL window. I can open it, but > can't type any query. > > On my XP system it worked fine. Try your question here: http:

[BUGS] BUG #6133: -lpq frees unallocated memory on exit

2011-07-27 Thread Kurt Mielke
The following bug has been logged online: Bug reference: 6133 Logged by: Kurt Mielke Email address: k...@it-pilots.com PostgreSQL version: 8.4.8 + 9.0.4 Operating system: Centos X86_64 5.5 & 6.0 Description:-lpq frees unallocated memory on exit Details: x.c: is a ve

Re: [BUGS] BUG #6133: -lpq frees unallocated memory on exit

2011-07-27 Thread Tom Lane
"Kurt Mielke" writes: > PostgreSQL version: 8.4.8 + 9.0.4 > Operating system: Centos X86_64 5.5 & 6.0 > x.c: is a very simple c-program: > main() { } > When compiled with > gcc -o x -lpq x.c > valgrind ./x > says "invalid free ... Address 0x4029508 is not stack'd, malloc'd or > (recently)