0

I am trying to alter a table in a database with (postgres 10.6)

ALTER TABLE xyz REPLICA IDENTITY FULL;

However, the command does not return. Is there any way to diagnose what the issue is, or any suggestions ?

  • Are you using psql tool to execute the command ? – Luan Huynh Mar 15 at 9:29
  • Yes I am using 'psql' – avrono Mar 16 at 17:53
  • After executing, did you get any error ? Can you check \d+ xyz ? – Luan Huynh Mar 16 at 18:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.