[GENERAL] problem with dblink and "drop owned by"

2012-07-18 Thread James W. Wilson
Hi, I'm using Postgresql 8.4.12-1 on Debian. I've installed 'dblink' from the contrib package (also 8.4.12-1) and am now running into a strange problem when I run "drop owned by". First, as the superuser I run 'dblink.sql' against the database I'll be using. Then I connect and do the following (th

Re: [GENERAL] problem with dblink and "drop owned by"

2012-07-18 Thread James W. Wilson
I'm stuck with 8.4 for now, unfortunately. James On Wed, Jul 18, 2012 at 6:14 PM, Tom Lane wrote: > "James W. Wilson" writes: >> Hi, I'm using Postgresql 8.4.12-1 on Debian. I've installed 'dblink' >> from the contrib package (also 8.4.12-1)

Re: [GENERAL] problem with dblink and "drop owned by"

2012-07-19 Thread James W. Wilson
OK, understood, thanks. On Wed, Jul 18, 2012 at 10:15 PM, Tom Lane wrote: > "James W. Wilson" writes: >> I'm confused. I thought foreign data wrappers were required to create >> database links from one Postgresql server to another. > > contrib/dblink do