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

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-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