Re: problema con dblink

Gente

OTra prueba.

select public.dblink_connect ('host=127.0.0.1 ... ' ::text );
select dblink_exec( ' perform update_or_insert_nacionalidades( ''22''
::text ,''Colombiana'' ::text ) ') ;
select dblink_disconnect();

y el error es:-
ERROR: syntax error at or near "perform"
CONTEXT: Error occurred on dblink connection named "unnamed": could not
execute command.

********** Error **********

ERROR: syntax error at or near "perform"
Estado SQL:42601
Contexto:Error occurred on dblink connection named "unnamed": could not
execute command.

saludos
jmdc

On Thu, Nov 15, 2012 at 3:12 PM, Juan <smalltalker(dot)marcelo(at)gmail(dot)com> wrote:

> Gente
>
>
> ahora probe en el pgadmin
>
>
>
>
> select public.dblink_connect ('host=127.0.0.1.....' ::text ); -> OK
> select dblink_exec( ' select update_or_insert_nacionalidades( ''22''
> ::text ,''Colombiana'' ::text ) into p ;') ;
>
> select dblink_disconnect(); --> OK
>
> ERROR: column "update_or_insert_nacionalidades" has pseudo-type void
> CONTEXT: Error occurred on dblink connection named "unnamed": could not
> execute command.
>
> ********** Error **********
>
> ERROR: column "update_or_insert_nacionalidades" has pseudo-type void
> Estado SQL:42P16
> Contexto:Error occurred on dblink connection named "unnamed": could not
> execute command.
>
>
> cualquier idea , será agradecida.
>
> saludos
>
> jmdc
>