Re: [BUGS] BUG #6461: "-t" deletes primary key

2012-02-19 Thread Peter Eisentraut
On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote: > lenka.piy...@gmail.com writes: > > when i restore a particular table using pg_restore (using option "-t") it > > doesn't restore my primary key... > > This is not a bug. -t selects the table only, not associated indexes. But from a user's per

Re: [BUGS] BUG #6461: "-t" deletes primary key

2012-02-19 Thread Boszormenyi Zoltan
2012-02-19 09:30 keltezéssel, Peter Eisentraut írta: > On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote: >> lenka.piy...@gmail.com writes: >>> when i restore a particular table using pg_restore (using option "-t") it >>> doesn't restore my primary key... >> This is not a bug. -t selects the tabl

Re: [BUGS] BUG #6461: "-t" deletes primary key

2012-02-19 Thread Tom Lane
Peter Eisentraut writes: > On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote: >> lenka.piy...@gmail.com writes: >>> when i restore a particular table using pg_restore (using option "-t") it >>> doesn't restore my primary key... >> This is not a bug. -t selects the table only, not associated ind

[BUGS] [Bug fix] postmaster always crashes on a debug version of Windows

2012-02-19 Thread MauMau
Hello Let me also post this here at pgsql-bugs just in case, though I post it pgsql-hackers on Feb 16. -- Hello I encountered a bug which always causes PostgreSQL to crash on Windows. Attached is a patch that fixes it. Please review it and include it in the upcoming minor releases of

Re: [BUGS] BUG #6459: logging_collector=off but log_filename set inhibits logoutpu

2012-02-19 Thread Christoph Anton Mitterer
Hi. On Tue, 2012-02-14 at 18:45 -0500, Tom Lane wrote: > cales...@scientia.net writes: > > http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html > > claims that log_filename is only used when logging_collector is enabled. > > That is a true statement, as can easily be proven by lo

Re: [BUGS] BUG #6459: logging_collector=off but log_filename set inhibits logoutpu

2012-02-19 Thread Tom Lane
Christoph Anton Mitterer writes: > On Tue, 2012-02-14 at 18:45 -0500, Tom Lane wrote: >> cales...@scientia.net writes: >>> http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html >>> claims that log_filename is only used when logging_collector is enabled. >> That is a true statement