-- this should fail because there is no open transaction

SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo');

ERROR: sql error

DETAIL: ERROR: DECLARE CURSORmay only be used in transaction blocks

DETAIL: ERROR: DECLARE CURSORcan only be used in transaction blocks

-- reset remote transaction state

SELECT dblink_exec('myconn','ABORT');

(SELECT * from dblink_get_result('dtest3') as t3(f1 int, f2 text, f3 text[]))

ORDER by f1;

SELECT dblink_get_connections();

dblink_get_connections

dblink_get_connections

------------------------

{dtest1,dtest2,dtest3}

(1 row)

ERROR: function is_point(earth) does not exist

LINE 1: SELECT is_point(ll_to_earth(0,0));

^

HINT: No function matches the given name and argument types. Youmay need to add explicit type casts.

HINT: No function matches the given name and argument types. Youmight need to add explicit type casts.

SELECT cube_dim(ll_to_earth(0,0)) <= 3;

?column?

----------

ERROR: function is_point(earth) does not exist

LINE 1: SELECT is_point(ll_to_earth(30,60));

^

HINT: No function matches the given name and argument types. Youmay need to add explicit type casts.

HINT: No function matches the given name and argument types. Youmight need to add explicit type casts.

SELECT cube_dim(ll_to_earth(30,60)) <= 3;

?column?

----------

ERROR: function is_point(earth) does not exist

LINE 1: SELECT is_point(ll_to_earth(60,90));

^

HINT: No function matches the given name and argument types. Youmay need to add explicit type casts.

HINT: No function matches the given name and argument types. Youmight need to add explicit type casts.

SELECT cube_dim(ll_to_earth(60,90)) <= 3;

?column?

----------

ERROR: function is_point(earth) does not exist

LINE 1: SELECT is_point(ll_to_earth(-30,-90));

^

HINT: No function matches the given name and argument types. Youmay need to add explicit type casts.

HINT: No function matches the given name and argument types. Youmight need to add explicit type casts.

SELECT cube_dim(ll_to_earth(-30,-90)) <= 3;

?column?

----------