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 <nT.db
and got:
...
ERROR: relation "targets" already exists
ALTER TABLE
ERROR: relation "targets" does not exist
LINE 1: UPDATE targets SET time_stamp=new.time_stamp, ...
^
QUERY: UPDATE targets SET time_stamp=new.time_stamp, modified=new.modified,
id=new.id, targets=new.targets WHERE (id=new.id)
CONTEXT: PL/pgSQL function public.targets_insert_or_update() line 1 at SQL
statement
COPY targets, line 1: "2017-10-31 09:37:28.798152 t az_el_target
{"name":"AZ_EL_Targets","priority":10,"tags":["{\\"Tag.tag..."
ERROR: relation "id_id_targets" already exists
ERROR: relation "time_stamp_id_targets" already exists
ERROR: trigger "targets_trigger_insert" for relation "targets" already
exists
ERROR: trigger "targets_trigger_update" for relation "targets" already exists
REVOKE
REVOKE
GRANT
GRANT
Eh? It looks like it worked (maybe), but why:
(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?
I take it back. The content of the table was not restored to the values in
nT.db afterall.
--
Steve Wampler -- swamp...@nso.edu
The gods that smiled on your birth are now laughing out loud.
