deleteConnection(conname);

pfree(rcon);

}

persistent_conn=NULL;

PG_RETURN_TEXT_P(GET_TEXT("OK"));

}

OK

(1 row)

-- should generate "noconnectionto the server" error

-- should generate "connectionnot available" error

SELECT *

FROM dblink('SELECT * FROM foo') AS t(a int, b text, c text[])

WHERE t.a > 7;

ERROR: sql error

DETAIL: no connection to the server

ERROR: connection not available

-- put more data into our slave table, first using arbitrary connection syntax

-- but truncate the actual return value so we can use diff to check for success

SELECT substr(dblink_exec('dbname=regression','INSERT INTO foo VALUES(10,''k'',''{"a10","b10","c10"}'')'),1,6);

SELECT dblink_disconnect();

FROM dblink('SELECT * FROM foo')AS t(aint, btext, ctext[])

WHEREt.a>7;