Re: Bug in Inherit feature

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Bug in Inherit feature
Date: 2008-10-01 20:03:43
Message-ID: 48E3D79F.10100@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

Obe, Regina a écrit :
> I was using the inherit feature in snapshot build 9/8 rev: 7457:7458
>
> It works fine if the table I am inheriting from is in the public schema,
> but if its in any other schema, it seems to quote the schema incorrectly
> so it fails to find the table.
>
> Example
>
> ALTER TABLE census_ma_2006.arealandmarks INHERIT
> "census_2006.arealandmarks";
>
> so then I have to manually change the statement to
>
> ALTER TABLE census_ma_2006.arealandmarks INHERIT
> "census_2006"."arealandmarks";
>

You're right, this was a bug in my previous patch. I fixed it.

Thanks.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Ryan Daniels 2008-10-02 12:58:47 PGAdmin Auto-commits?
Previous Message Denis Rykov 2008-10-01 16:20:50 Geometries cannot be displayed