Actually this database has been carried forward since the "postgres95"
days, so you are definitely right in your analysis..
Would another (perhaps safer?) way of doing this is to remove the "CREATE
SEQUENCE" and "SELECT pg_catalog.setval", and replace the "DEFAULT
nextval" with "SERIAL" then rest
"Net Virtual Mailing Lists" <[EMAIL PROTECTED]> writes:
> When I do a "pgdump --schema=someschema somedatabase > something.dump",
> the results of the dump file look like this:
> CREATE TABLE emailtemplates (
> email_template_id integer DEFAULT
> nextval('"emailtemplate_email_templat_seq"'::te
Hello,
When I do a "pgdump --schema=someschema somedatabase > something.dump",
the results of the dump file look like this:
REVOKE ALL ON SCHEMA someschema FROM PUBLIC;
GRANT ALL ON SCHEMA someschema TO PUBLIC;
SET search_path = someschema, pg_catalog;
CREATE SEQUENCE emailtemplate_email_t
