Re: Odd messages on reloading DB table

2019-02-11 Thread Steve Wampler
On 2/7/19 3:24 PM, David G. Johnston wrote: On Thursday, February 7, 2019, Steve Wampler mailto:swamp...@nso.edu>> wrote:    (1) the table already exist and the immediately doesn't exist?    (2) report ERROR on UPDATE when there are no UPDATES in the input file Most

Odd messages on reloading DB table

2019-02-07 Thread Steve Wampler
ABLE public.targets OWNER TO atst; -- -- Data for Name: targets; Type: TABLE DATA; Schema: public; Owner: atst -- COPY public.targets (time_stamp, modified, id, targets, marked, collectable, proposalid) FROM stdin; === -- Steve Wampler -- swamp...@nso.edu The gods that smiled on your birth are now laughing out loud.

Re: Odd messages on reloading DB table

2019-02-07 Thread Steve Wampler
On 2/7/19 9:28 AM, Steve Wampler wrote: With PostgreSQL 9.5.15, I ran:    pg_dump -t targets -d atst.experimentdb >nT.db then I ran:    psql -h langley atst.experimentdb ...    ERROR:  relation "targets" already exists    ALTER TABLE    ERROR:  relation "targe