Skip site navigation (1) Skip section navigation (2)

Re: [SQL] Duplicate tuples with unique index

From: Palle Girgensohn <girgen(at)partitur(dot)se>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Patrik Kudo <kudo(at)partitur(dot)se>, "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] Duplicate tuples with unique index
Date: 2000-01-26 15:07:50
Message-ID: 388F0DC6.49A8C61@partitur.se (view raw or flat)
Thread:
Lists: pgsql-sql
Tom Lane wrote:
> 

Thanks for the info. Very interesting reading!

> Bruce thinks that the pg_upgrade script will ensure that the system-
> table tuples are all in frozen states (by VACUUMing them).  I don't
> trust it worth a dime, myself.  Maybe it will work, but it hasn't been
> proven in the field.  So, if you'd like to try it, by all means do so
> --- but make a pg_dump backup first!  And let us know whether you have
> problems or not!

I never tried it; I did an old fashion dump+initdb+restore. So, we will not know whether pg_upgrade is OK or not, at least for now. :(

Regards,
Palle

In response to

pgsql-sql by date

Next:From: Peter EisentrautDate: 2000-01-26 18:34:38
Subject: Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace
Previous:From: Kovacs Zoltan SandorDate: 2000-01-26 12:28:15
Subject: Re: [SQL] dumping groups and users

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group