- Thank you received: 0
problem with delete
- CEDPIERI
- Topic Author
- Offline
- User
-
Less
More
5 years 6 months ago #14461
by CEDPIERI
problem with delete was created by CEDPIERI
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
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.
- admin
- Offline
- Admin
-
Less
More
- Thank you received: 8
5 years 6 months ago #14463
by admin
Replied by admin on 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]
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.152 seconds