Re: dblink inside plpgsql function

I created the following function<br /><br />CREATE OR REPLACE FUNCTION getReminderServices( varchar ) RETURNS SETOF
reminder_servicesAS'<br /> DECLARE r reminder_services%ROWTYPE;<br /> BEGIN<br />     SELECT
dblink_connect(''dbname=''||$1);<br/>     FOR r IN SELECT * FROM dblink(''SELECT * FROM reminder_services'')<br />
              AS columns( uid INT,<br />                                      theme_uid INT,<br />
                                    activity_MT_amount INT,<br />                                     
activity_min_daysINT,<br />                                      activity_max_months INT,<br />
                                    inactivity_days INT,<br />                                      limit_reminders
INT,<br/>                                      limit_months INT,<br />                                     
scanning_timeTIMESTAMP WITH TIME ZONE,<br />                                      reminder_time TIMESTAMP WITH TIME
ZONE,<br/>                                      message TEXT)<br />     LOOP<br />     RETURN NEXT r;<br />     END
LOOP;<br/>     SELECT dblink_disconnect($1);<br />     RETURN; <br /> END;<br /> ' LANGUAGE plpgsql; <br /><br /><br />
andI get the same errors. I think it is a problem with the dblink because<br /> the following function it works fine if
Icall SELECT * FROM getReminders().<br /><br /> CREATE OR REPLACE FUNCTION getReminders() RETURNS SETOF
reminder_servicesAS'<br /><br /> DECLARE r reminder_services%ROWTYPE;<br /><br /> BEGIN<br />     FOR r IN SELECT *
FROMreminder_services<br />     LOOP<br />     RETURN NEXT r;<br />     END LOOP;<br />     RETURN; <br /> END;<br /> '
LANGUAGEplpgsql; <br /><br /><br /><br /><br /><br />