Re: attislocal value changed with dump

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: attislocal value changed with dump
Date: 2005-11-03 20:40:46
Message-ID: 20051103204046.GC16266@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Hi Elein,

elein wrote:

> The problem is that after a dump and reload of
> a table hierarchy there are different values in
> pg_attribute.attislocal.
>
> A quick grep shows few references to attislocal.
> But I cannot say for sure it is unused since it is
> documented. However, I'm looking at a db diff
> tool and there it does matter.

It's not unused, though it's not a hot spot (it's only used to prevent
you from dropping an inherited column). I can't reproduce your problem
here though -- the dump comes out just like the tables I produced. Care
to provide the original SQL script?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rob Prowel 2005-11-03 23:36:48 is this a bug or do I not understand the query planner?
Previous Message elein 2005-11-03 17:59:17 attislocal value changed with dump