Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. ALTER TABLE package ADD CONSTRAINT unique_package_id UNIQUE (package_id);
  2.  
  3. CREATE UNIQUE INDEX CONCURRENTLY package_tmp_id_idx ON answer (package_id);
  4.  
  5. prod_db=> ALTER TABLE package ADD CONSTRAINT
  6. unique_package_id UNIQUE (package) USING INDEX package_tmp_id_idx;
  7.  
  8. ERROR: syntax error at or near "package_tmp_id_idx"
  9. LINE 1: ...T unique_package_id UNIQUE (answer_id) USING INDEX package_tmp_id_idx...
  10. ^
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement