Guest User

Untitled

a guest
Oct 22nd, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. CREATE TABLE Actual_Table(ID serial not null, Name varchar, primary key (id))
  2.  
  3. INSERT INTO Actual_Table (name) VALUES ('AHMAD');
  4. INSERT INTO Actual_Table (name) VALUES ('MAHMOOD');
  5.  
  6. CREATE FOREIGN TABLE Foreign_Table (ID serial, name varchar) server some_server options(schema_name 'public', table_name 'Actual_Table')
  7.  
  8. INSERT INTO Foreign_Table (name) VALUES ('John');
  9.  
  10. ERROR: duplicate key value violates unique constraint "to_copy_pkey"
  11. DETAIL: Key (id)=(2) already exists.
  12. CONTEXT: Remote SQL command: INSERT INTO public.to_copy(id, name) VALUES ($1, $2)
  13.  
  14. {
  15. CREATE FOREIGN TABLE Foreign_Table (name varchar) server
  16. some_server options(schema_name 'public', table_name 'Actual_Table')
  17. }
Add Comment
Please, Sign In to add comment