Обсуждение: INDEX_MAX_KEYS and pg_dump

Поиск
Список
Период
Сортировка

INDEX_MAX_KEYS and pg_dump

От
Mike Mascari
Дата:
Hello,

I grabbed last nights snapshot to come up with a diff for
pg_dump to generate COMMENT ON statements for user-defined
descriptions. However, I believe pg_dump is currently in a
broken state with respect to the dumping of indexes,
possibly related to the current work done with
INDEX_MAX_KEYS. Can anyone confirm this?

Thanks for any info,

Mike Mascari




Re: [HACKERS] INDEX_MAX_KEYS and pg_dump

От
Bruce Momjian
Дата:
> Hello,
> 
> I grabbed last nights snapshot to come up with a diff for
> pg_dump to generate COMMENT ON statements for user-defined
> descriptions. However, I believe pg_dump is currently in a
> broken state with respect to the dumping of indexes,
> possibly related to the current work done with
> INDEX_MAX_KEYS. Can anyone confirm this?

I just looked and I don't see any problems.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: [HACKERS] INDEX_MAX_KEYS and pg_dump

От
Tom Lane
Дата:
>> descriptions. However, I believe pg_dump is currently in a
>> broken state with respect to the dumping of indexes,
>> possibly related to the current work done with
>> INDEX_MAX_KEYS. Can anyone confirm this?

> I just looked and I don't see any problems.

It was broken --- I committed fixes for it at about 11PM EST.

(The same problem as for func args --- it wasn't coping with
zero suppression in oidvectorout/int2vectorout.)
        regards, tom lane


Re: [HACKERS] INDEX_MAX_KEYS and pg_dump

От
Bruce Momjian
Дата:
> >> descriptions. However, I believe pg_dump is currently in a
> >> broken state with respect to the dumping of indexes,
> >> possibly related to the current work done with
> >> INDEX_MAX_KEYS. Can anyone confirm this?
> 
> > I just looked and I don't see any problems.
> 
> It was broken --- I committed fixes for it at about 11PM EST.
> 
> (The same problem as for func args --- it wasn't coping with
> zero suppression in oidvectorout/int2vectorout.)

Thanks.  I missed that.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026