pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (5+ messages)  latest in thread

Message-ID: <398895B5.000093.16285@frodo.searchcanada.ca>
Permalink:  ../398895B5.000093.16285@frodo.searchcanada.ca/
Also on:    postgresql.org/message-id/398895B5.000093.16285@frodo.searchcanada.ca

 · 

reply

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