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]

Reply via email to