Rumko writes:
> On Thursday 13. of May 2010 17:24:47 Tom Lane wrote:
>> You might want to think about collapsing all those standalone bigint
>> columns into an array.
> The current design is not final yet, but for now it has proven (with the
> exception of the 2 tables that have giant toast tabl
On Thursday 13. of May 2010 17:24:47 Tom Lane wrote:
> Rumko 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 (fil
Rumko 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 (fillfactor = n).
It would be worth checking to see if you get a nonnull re
"Karl Walbrecht" 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 ('a','b');
CREATE TYPE
r
On May 13, 1:55 pm, kwalbre...@cghtech.com ("Karl Walbrecht") wrote:
(...)
> -- This does not
> CREATE OR REPLACE FUNCTION sec_authorization_check_all(
> v_entity_name varchar
> ) RETURNS setof entities AS
>
> psql:./functions/sec_authorization_check_all.sql:41: ERROR: type "entities"
> does n
The following bug has been logged online:
Bug reference: 5460
Logged by: Karl Walbrecht
Email address: kwalbre...@cghtech.com
PostgreSQL version: 8.4.3
Operating system: Solaris x86 64 bit
Description:Search path not being used in function return type
Details:
# sho
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 writes:
> > > Graham wrote:
> > >> Build with VPATH works well upto installing
> > >> postgresql-9.0beta1/src/backend/catalog/postgres.bki
> > >> which is in the sourc
On 13/05/10 19:26, Russell Smith wrote:
> On 13/05/10 03:39, Tom Lane wrote:
>
>> Russell Smith 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 f
On 13/05/10 03:39, Tom Lane wrote:
> Russell Smith 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 skip the DA
