From: | "Michael Richards" <michael(at)fastmail(dot)ca> |
---|---|
To: | jlapham(at)gandalf(dot)bioqmed(dot)ufrj(dot)br |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: on line numbers, drop table errors, and log files |
Date: | 2000-08-02 21:42:13 |
Message-ID: | 398895B5.000093.16285@frodo.searchcanada.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-08-02 21:54:36 | Re: on line numbers, drop table errors, and log files |
Previous Message | JavierG | 2000-08-02 20:20:29 | postgresql and java2 |