pg_dump: relation "..." already exists warning

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_dump: relation "..." already exists warning
Date: 2005-09-17 15:01:40
Message-ID: 20050917150140.GB6635@deby.ei.hnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,
[Using postgres (PostgreSQL) 7.4.7 on GNU/Linux/Debian-Sarge]

running the command:
$ pg_dump finanz -t ult_qq | psql finanza ennio ult.qq

I can see that table 'ult_qq' is regularly created in 'finanza' and
continues to exist in 'finanz', although pg is firing this warning:

SET
SET
SET
SET
ERROR: relation "ult_qq" already exists
SET
ERROR: relation "ult_qq" already exists
SET
SET

which I'm unable to explain. Could it be related to unresolved bug #1379
or am I doing anything wrong?

Thanks for your attention.
Regards,
Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-09-17 22:05:19 Re: pg_dump: relation "..." already exists warning
Previous Message Greg T. 2005-09-16 13:15:10 Very simple cgi perl connect & select script