pgnp cannot determine output columns for procedure

More
7 years 1 month ago #9880 by qqq123890
qqq123890 created the topic: pgnp cannot determine output columns for procedure
In postgres i've function with returned declared type.
When I try to call the function using linked server or in dtsx package:
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
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

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #9892 by Moderator
Moderator replied the topic: Re: pgnp cannot determine output columns for procedure
This was a defect in the older versions of the provider. Please upgrade the product to the latest version.

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #9893 by qqq123890
qqq123890 replied the topic: Re: pgnp cannot determine output columns for procedure
This error is only on one database. I have test db in the same version postgres and provider and this dataflow works fine.

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #9894 by Moderator
Moderator replied the topic: Re: pgnp cannot determine output columns for procedure
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:
EXEC('pgnp_refreshmetadata(''schema_name'',''function_name'')') AT LINKEDSERVER_NAME

Please Log in or Create an account to join the conversation.

Time to create page: 0.085 seconds
Powered by Kunena Forum