| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: COPY does not work with regproc and aclitem |
| Date: | 2006-10-23 20:46:38 |
| Message-ID: | 453D2A2E.6040500@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Zdenek Kotala wrote:
> Tom Lane wrote:
>
>> The right way to implement pg_upgrade is to transfer the catalog data
>> at the SQL-command level of abstraction, ie, "pg_dump -s" and reload.
>
> I'm not sure if it is important, but I think that preserve OID is
> important and SQL level does not allow set OID.
>
>
Does it matter in any case other than where it refers to an on-disk
object? And does that need anything other than a fixup to
pg_class::relfilenode?
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | richard-pgodbc | 2006-10-23 20:48:36 | Re: Tsearch2 index size |
| Previous Message | Zdenek Kotala | 2006-10-23 20:31:37 | Re: COPY does not work with regproc and aclitem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas H. | 2006-10-23 20:49:37 | Re: BUG #2712: could not fsync segment: Permission |
| Previous Message | Zdenek Kotala | 2006-10-23 20:31:37 | Re: COPY does not work with regproc and aclitem |