pgnp cannot determine output columns for procedure

[qqq123890]

In postgres i've function with returned declared type.
When I try to call the function using linked server or in dtsx package:

Code: Select all

SELECT * FROM OPENQUERY(LINKEDSERVER_NAME,'SELECT * FROM function()')

I get the error:
pgnp cannot determine output columns for procedure schema_name.function_name

I try

Code: Select all

EXEC('pgnp_refreshmetadata('''',''schema_name.function_name'')') AT LINKEDSERVER_NAME

It did not help.

This function works fine in pgadmin

I've pgnp 1.3.0.2252

[Moderator]

This was a defect in the older versions of the provider. Please upgrade the product to the latest version.

[qqq123890]

This error is only on one database. I have test db in the same version postgres and provider and this dataflow works fine.

[Moderator]

There should be a reason. Most likely it could be metadata cache. If that is the case, then restarting the client OS, or executing following command from SSIS could help:

Code: Select all

EXEC('pgnp_refreshmetadata(''schema_name'',''function_name'')') AT LINKEDSERVER_NAME