| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Net Virtual Mailing Lists" <mailinglists(at)net-virtual(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Join between databases or (???) |
| Date: | 2004-11-21 23:18:13 |
| Message-ID: | 18694.1101079093@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Net Virtual Mailing Lists" <mailinglists(at)net-virtual(dot)com> writes:
> CREATE TABLE testschema.industries (
> industry_id integer DEFAULT nextval('"testschema.industries_industry_id_seq"'::text) NOT NULL,
> pg_dump created it with the double quotes, I have been modifying the dump
> to make it so appropriate things get created inside the schema, so I
> added in the testschema. part of it in this example.
Ah-hah. You put the testschema. part in the wrong place then. Correct
is
nextval('"testschema"."industries_industry_id_seq"'::text)
Or you could leave out the double quotes.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dawid Kuroczko | 2004-11-21 23:47:16 | Re: COMMIT within function? |
| Previous Message | Pierre-Frédéric Caillaud | 2004-11-21 23:16:07 | Re: COMMIT within function? |