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