Re: [GENERAL] Questions about Views, Rules and DBLink

2005-08-01 Thread Joao Afonso
Thanks for your help. But still, do you think there could be a way to alter the dblink_current_query() function so that it could return the right query? Or should I try to build the query in a function and send it through dblink instead of dblink_current_query()? I've also been told that oracle

Re: [GENERAL] Questions about Views, Rules and DBLink

2005-07-31 Thread Joe Conway
Tom Lane wrote: Joao Afonso <[EMAIL PROTECTED]> writes: So (finally), my question is why does this happen? Using instead on the users_util insert rule shouldn't discard the original query and rewrite it according to the specified on the rule?? Is this a problem of dblink? I hadn't noticed th

Re: [GENERAL] Questions about Views, Rules and DBLink

2005-07-31 Thread Tom Lane
Joao Afonso <[EMAIL PROTECTED]> writes: > So (finally), my question is why does this happen? Using instead on > the users_util insert rule shouldn't discard the original query and > rewrite it according to the specified on the rule?? Is this a problem > of dblink? I hadn't noticed the dblink_cur

[GENERAL] Questions about Views, Rules and DBLink

2005-07-31 Thread Joao Afonso
Hi! I'm using dblink with some DBs and i'm having a few problems, more precisely with the dblink_current_query() function. First I create the following views on a DB: - create or replace view users as select * from dblink('hostaddr=127.0.0.1 dbname=teste user=postgres password=postgres','se