- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- pgnp cannot determine output columns for procedure
pgnp cannot determine output columns for procedure
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:I get the error:
pgnp cannot determine output columns for procedure schema_name.function_name
I tryIt did not help.
This function works fine in pgadmin
I've pgnp 1.3.0.2252
When I try to call the function using linked server or in dtsx package:
SELECT * FROM OPENQUERY(LINKEDSERVER_NAME,'SELECT * FROM function()')
pgnp cannot determine output columns for procedure schema_name.function_name
I try
EXEC('pgnp_refreshmetadata('''',''schema_name.function_name'')') AT LINKEDSERVER_NAME
This function works fine in pgadmin
I've pgnp 1.3.0.2252
Please Log in or Create an account to join the conversation.
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.
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.
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.
- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- pgnp cannot determine output columns for procedure
Time to create page: 0.057 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- pgnp cannot determine output columns for procedure