Advertisement
Guest User

Untitled

a guest
Apr 6th, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. SELECT xyz.*
  2. FROM PUBLIC.DBLINK ('dbname=LiveDB port=5432 host=127.0.0.1 user=postgres
  3. password=root','SELECT dblink_build_sql_delete(''"folderstatus"'', ''1'', 1,
  4. ''{"1"}'')')
  5. as xyz (id int);
  6.  
  7. ERROR: invalid input syntax for integer: "DELETE FROM folderstatuslu WHERE
  8. id = '1'"
  9.  
  10. DELETE FROM folderstatuslu WHERE id <= '1' --> (in the place of 1, I will
  11. pass a variable.)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement