From: Michael Richards <michael@fastmail.ca>
To: jlapham@gandalf.bioqmed.ufrj.br
Cc: pgsql-sql@postgresql.org
Subject: Re: on line numbers, drop table errors, and log files
Date: Wed, 2 Aug 2000 17:42:13 -0400 (EDT)
Message-ID: <398895B5.000093.16285@frodo.searchcanada.ca> (raw)
> As I mentioned earlier, your solution worked great. I am a bit
> puzzled about the syntax that is created by my old method, using
> "pg_dump -D -u -a". I wonder why it creates "create sequence ..."
> commands instead of "update sequence ..."?
That is a good question. I do not know the answer. Since it is
understood that you are dumping the data and not the schema, that
would imply to me that the schema (sequences included) should already
exist and need to be updated. Of course I feel that implicitly it
should be cleaning out the contents of the tables when this is done
as well.
Perhaps someone on the team could comment on this.
-Michael
_________________________________________________________________
http://fastmail.ca/ - Fast Free Web Email for Canadians
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: michael@fastmail.ca, jlapham@gandalf.bioqmed.ufrj.br
Subject: Re: on line numbers, drop table errors, and log files
In-Reply-To: <398895B5.000093.16285@frodo.searchcanada.ca>
References: <398895B5.000093.16285@frodo.searchcanada.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox