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 "is not a sequence". What other options are there?
>
> It
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 "is not a sequence". What other options are there?
It isn't clear (to me, at least) what you are trying to ac
Hi all,
I'm trying to inject some behavior via rules between an application and a table
schema, preferably without modifying either of them. Using views, I'm able to
have a query that is run with one schema as the search_path to actually run
against a table in a different schema. Is that also p
