mycolumn int4 DEFAULT nextval("'mycolumn_seq'"::text) NOT NULL
^^ ^^ this is the error -> ' " and correct it should be: mycolumn int4 DEFAULT nextval('myschema.mycolumn_seq'::text) NOT NULL
^^ ^^ The difference -> only '
No, the correct format is this:
mycolumn int4 DEFAULT nextval('"myschema"."mycolumn_seq"'::text) NOT NULL
Chris
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]