| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Trevor McGing | 2003-10-29 16:10:07 | Constraint Bug |
| Previous Message | Andreas Pflug | 2003-10-28 17:34:58 | Re: Problem in pgAdmin III with paste |