Re: [GENERAL] Thousands of users using one schema -> ERROR: row is too big

2011-03-01 Thread Magnus Reftel
On Mar 1, 2011, at 21:57 , Bill Moran wrote: > In response to Magnus Reftel : >> >> I'm working on a database that will have a very large number of users, and >> I'm running in to a problem: when I grant more than about 2500 users access >> to a schema

[GENERAL] Thousands of users using one schema -> ERROR: row is too big

2011-03-01 Thread Magnus Reftel
a table instead of as elements in an array, but I'm definitely not qualified to comment on PostgreSQL implementation issues. Do you agree with linuxpoet's fix? If so, when do you think it is reasonable to include it? Best Regards Magnus Reftel -- Sent via pgsql-general ma

Re: [GENERAL] Redirect sequence access to different schema

2010-07-26 Thread Magnus Reftel
On Jul 25, 2010, at 23:13 , Joe Conway wrote: > On 07/25/2010 12:01 PM, Magnus Reftel wrote: >> create view myseq as select * from other_schema.foo_id_seq; >> >> but when I run "select nextval('myseq');" I get an error saying that >> myseq &q

[GENERAL] Redirect sequence access to different schema

2010-07-25 Thread Magnus Reftel
that also possible for sequences somehow? I tried creating a view like so: create view myseq as select * from other_schema.foo_id_seq; but when I run "select nextval('myseq');" I get an error saying that myseq "is not a sequence". What other options are there? B