problem with delete

More
1 year 1 week ago #14461 by CEDPIERI
CEDPIERI created the topic: problem with delete
Hello,
a couple of days ago we've purchased the latest 1.4.0.3516 PgOleDB SE version. Installation and creation of a new Linked Server in SQL SERVER2012 were fine.
But we've a big problem with the delete.
If we try to make:
DELETE from [PGLINKED].[public].mypgtable where key1 in (select WKEY1 from sqltable where updated_flag = true)

no row is deleted and 0 rows are affected.

If we do the same query with a SELECT * from mypgtable… it returns the n rows that have to be deleted.
We've mailed support but still have no answer...
Someone can help?

Thanks In Advance

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

More
1 year 1 week ago #14463 by admin
admin replied the topic: problem with delete
Please run PGNProfiler as Administrator, and collect trace from the linked server queries. Then save the trace as *.pgl file and send to us. We need details for troubleshooting.

Also, please send CREATE TABLE for the table(s). I will try to reproduce the issue.

As a temporary workaround consider using OPENQUERY or EXEC syntax, e.g.
EXEC('delete FROM [public].[dfanagr] where df_ana_key_host in (123546)') AT [TEST_PGNP]

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

Time to create page: 0.064 seconds
Powered by Kunena Forum