CREATE TABLE t(a INT);
  ALTER TABLE t ADD CONSTRAINT "s""s" CHECK(a>0);
  ALTER TABLE t DROP CONSTRAINT "s""s";

errors with no such constraint: "s""s"

similar to this but embedded quotes.

i am assuming this below behaviour is by design!? as there appears to be tests for this on HEAD(please correct me if i am wrong.)

create table t(a int,constraint "test");
alter table drop constraint "test"; 

EDIT:sorry about the edit if anyone got notified. i didn't knew that if i write a statement right after quotes its not visible..

thanks.