Re: [GENERAL] Using dblink to connect as non-superuser

2008-11-12 Thread Tom Lane
Robert Fitzpatrick <[EMAIL PROTECTED]> writes: > I try to use dblink_connect while logged into the database as the > superuser and it returns OK, but if I disconnect and use the same > command as follows, it give and error, password is required. Even if I > try to use the superuser login in the con

Re: [GENERAL] Using dblink to connect as non-superuser

2008-11-12 Thread Roderick A. Anderson
Robert Fitzpatrick wrote: I try to use dblink_connect while logged into the database as the superuser and it returns OK, but if I disconnect and use the same command as follows, it give and error, password is required. Even if I try to use the superuser login in the connect string below while con

[GENERAL] Using dblink to connect as non-superuser

2008-11-12 Thread Robert Fitzpatrick
I try to use dblink_connect while logged into the database as the superuser and it returns OK, but if I disconnect and use the same command as follows, it give and error, password is required. Even if I try to use the superuser login in the connect string below while connected as a non-superuser, I