Skip site navigation (1) Skip section navigation (2)

Re: DBMigration-Wizard & Access 2002

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Albin Blaschka <Albin(dot)Blaschka(at)bal(dot)bmlfuw(dot)gv(dot)at>
Cc: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>,Reinhard Resch <Reinhard(dot)Resch(at)bal(dot)bmlfuw(dot)gv(dot)at>,Wilhelm Graiss <Wilhelm(dot)Graiss(at)bal(dot)bmlfuw(dot)gv(dot)at>
Subject: Re: DBMigration-Wizard & Access 2002
Date: 2003-10-29 01:40:22
Message-ID: 3F9F1A86.2050401@familyhealth.com.au (view raw or flat)
Thread:
Lists: 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



In response to

pgadmin-support by date

Next:From: Trevor McGingDate: 2003-10-29 16:10:07
Subject: Constraint Bug
Previous:From: Andreas PflugDate: 2003-10-28 17:34:58
Subject: Re: Problem in pgAdmin III with paste

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group