Re: Bug #743: pg_dump -a -c without DELETE FROM

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: psztoch(at)interia(dot)pl, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #743: pg_dump -a -c without DELETE FROM
Date: 2002-08-27 20:39:04
Message-ID: 200208272039.g7RKd4413560@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following patch disables use of -a and -c together. This will
appear in the next release.

---------------------------------------------------------------------------

pgsql-bugs(at)postgresql(dot)org wrote:
> Przemyslaw Sztoch (psztoch(at)interia(dot)pl) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> pg_dump -a -c without DELETE FROM
>
> Long Description
> In my opinion "pg_dump -a -c" should generate "DELETE FROM <table>" before COPY statement.
> Options:
> -a, --data-only dump only the data, not the schema
> -c, --clean clean (drop) schema prior to create
> TIA for answer or your opinions.
>
> Sample Code
>
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Attachment Content-Type Size
unknown_filename text/plain 732 bytes

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2002-08-27 21:24:48 Re: cube bug accepting -.1
Previous Message Peter Eisentraut 2002-08-27 18:26:56 Re: Bug #741: postgresql and cygwin