Re: BUG #3331: Database Restoring problem

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:      sajishdaniel@yahoo.com
> 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: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893