Re: DBMigration-Wizard & Access 2002 - Mailing list pgadmin-support

From Christopher Kings-Lynne
Subject Re: DBMigration-Wizard & Access 2002
Date
Msg-id 3F9F1A86.2050401@familyhealth.com.au
Whole thread Raw
In response to DBMigration-Wizard & Access 2002  (Albin Blaschka <Albin.Blaschka@bal.bmlfuw.gv.at>)
List pgadmin-support
> 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




pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Problem in pgAdmin III with paste
Next
From: timothy.r.morley@kc.frb.org
Date:
Subject: Connnection to SSL enabled server