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

2011-07-27 Thread Tom Lane
Julian Mehnle jul...@mehnle.net 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

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 jul...@mehnle.net 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

[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

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 jul...@mehnle.net 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

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 jul...@mehnle.net 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

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

2011-07-27 Thread Scott Mead
On Wed, Jul 27, 2011 at 11:19 AM, Nivas niva...@gmail.com 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

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

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)

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 rkott...@mpi-bremen.de wrote: On 07/18/2011 05:25 PM, Robert Haas wrote: On Tue, Jul 12, 2011 at 9:18 AM, Sandro Santilli s...@keybit.net wrote: Trying to exclude items from dumps of postgis-enabled databases we use pg_restore -l output and strip

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 peter.de.w...@casema.nl 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

[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

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

2011-07-27 Thread Tom Lane
Kurt Mielke k...@it-pilots.com 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