1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. pgnp cannot determine output columns for procedure

pgnp cannot determine output columns for procedure

More
9 years 4 months ago #9880 by qqq123890
pgnp cannot determine output columns for procedure was created by qqq123890
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
9 years 4 months ago #9892 by Moderator
Replied by Moderator on 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
9 years 4 months ago #9893 by qqq123890
Replied by qqq123890 on 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
9 years 4 months ago #9894 by Moderator
Replied by Moderator on 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.

  1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. pgnp cannot determine output columns for procedure
Time to create page: 0.057 seconds
Powered by Kunena Forum