On Jun 2, 2007, at 10:32 AM, sajish wrote:
The following bug has been logged online:
Bug reference: 3331
Logged by: sajish
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.3
Operating system: Redhad Linux
Description: Database Restoring problem
Details:
Get errors on Restore database via Pg_Restore or psql
Error: Relation 'table name' already exist
i want to over write all tables when attempt to restore a
database
look at the -c (--clean) option to pg_restore (assuming you are
dealing with a -Fc dump).
---------------------------(end of
broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: [EMAIL PROTECTED]
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
