Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: enum types and binary queries
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Gregory Stark <stark(at)enterprisedb(dot)com>
- Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>
- Subject: Re: enum types and binary queries
- Date: Fri, 31 Aug 2007 10:37:12 -0400
Gregory Stark escribió: > I think it would be ok only if a pg_dump/pg_restore reliably restored the same > oid->enum value mapping. Otherwise a binary dump is useless. But as I > understand it that's the case currently, is it? That doesn't work if the dump is restored on a database that already has those OIDs used for another enum. The easy workaround would be to "rewrite" the data to use the new OID, but believe me, you don't want to go down that route, lest madness await you at the end. -- Alvaro Herrera http://www.advogato.org/person/alvherre "Uno puede defenderse de los ataques; contra los elogios se esta indefenso"
- Follow-Ups:
- Re: enum types and binary queries
- From: Gregory Stark
- Re: enum types and binary queries
- References:
- enum types and binary queries
- From: Merlin Moncure
- Re: enum types and binary queries
- From: Tom Lane
- Re: enum types and binary queries
- From: Merlin Moncure
- Re: enum types and binary queries
- From: Gregory Stark
- enum types and binary queries
- Prev by Date: Re: enum types and binary queries
- Next by Date: Re: enum types and binary queries
- Previous by thread: Re: enum types and binary queries
- Next by thread: Re: enum types and binary queries
- Indexes: