Re: [BUGS] pg_restore ignores -C when using a restore list -L

2010-05-13 Thread Russell Smith
On 13/05/10 03:39, Tom Lane wrote: Russell Smith mr-r...@pws.com.au writes: pg_restore silently ignores the inclusion of -C when you do use a restore list. It would work as you expect if you use -C when creating the list file. The reason for this is that -C basically means don't

Re: [BUGS] pg_restore ignores -C when using a restore list -L

2010-05-13 Thread Russell Smith
On 13/05/10 19:26, Russell Smith wrote: On 13/05/10 03:39, Tom Lane wrote: Russell Smith mr-r...@pws.com.au writes: pg_restore silently ignores the inclusion of -C when you do use a restore list. It would work as you expect if you use -C when creating the list

Re: [BUGS] BUG #5447: VPATH install postgres.bki

2010-05-13 Thread Peter Eisentraut
On tis, 2010-05-04 at 22:46 +0300, Peter Eisentraut wrote: On tis, 2010-05-04 at 10:49 -0400, Tom Lane wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Graham wrote: Build with VPATH works well upto installing postgresql-9.0beta1/src/backend/catalog/postgres.bki which is in

Re: [BUGS] BUG #5460: Search path not being used in function return type

2010-05-13 Thread Tom Lane
Karl Walbrecht kwalbre...@cghtech.com writes: Description:Search path not being used in function return type Works as expected for me ... $ psql psql (8.4.3) Type help for help. regression=# create schema security; CREATE SCHEMA regression=# create type security.entities as enum

Re: [BUGS] Giant TOAST tables due to many almost empty pages

2010-05-13 Thread Rumko
On Thursday 13. of May 2010 17:24:47 Tom Lane wrote: Rumko rum...@gmail.com writes: Tom Lane wrote: There's something extremely wacko about that vacuum output. Regarding storage paramaters, you mean ALTER TABLE x SET STORAGE...? Then no. No, I was wondering about ALTER TABLE ... SET