See comments below.. >On Sun, Nov 21, 2004 at 12:27:11AM -0700, Net Virtual Mailing Lists wrote: > >> I am having one problem I just can't figure out.... In my dump file I >> have something like: >> CREATE SEQUENCE testschema.industries_industry_id_seq >> INCREMENT BY 1 >> NO MAXVALUE >> NO MINVALUE >> CACHE 1; >> ); > >The closing parenthesis is a syntax error. Did you cut and paste >this or type it by hand? >
Yeha, sorry, I cut and pasted but fumbled.. The ); is not there - the sequence did get created correctly... >> CREATE TABLE testschema.industries ( >> industry_id integer DEFAULT nextv >> al('"testschema.industries_industry_id_seq"'::text) NOT NULL, >> industry character varying(80) NOT NULL, >> entered_dt timestamp with time zone, >> updated_dt timestamp with time zone >> ); >> >> When I try to insert a value into schema.industries it complains about >> testschema.industries_industry_id_seq not existing, yet I can execute >> "nextval" against that very schema.... Any idea what might be going >> wrong here?... > >I think you mean that you can execute nextval() against the sequence, >not the schema. Anyway, it looks like whatever created the dump >file incorrectly added double quotes around the sequence name in >the nextval() expression. What created that dump? > 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. - Greg >-- >Michael Fuhr >http://www.fuhr.org/~mfuhr/ > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly