Re: Duplicate Data entry problem

James Hall <James.Hall@RadioShack.com> writes:
> If I run: EXPLAIN SELECT "PrintOrder" from "acpower"; I get:
> NOTICE: QUERY PLAN

> Result (cost-0.00..3.27 rows=28 width=12)
>   ->  Append  (cost=0.00..3.27 rows=28 width=12)
>         ->  Seq Scan on acpower  (cost=0.00..1.13 rows=13 width=12)
>         ->  Seq Scan on template2 acpower  (cost=0.00..0.00 rows=1 width=12)
>         ->  Seq Scan on General Requirements acpower  (cost=0.00..1.11
> rows=11 width=12)
>         ->  Seq Scan on workmanship acpower  (cost0.00..1.03 rows=3
> width=12)

Looks to me like you created those other tables as subclasses
(inheritance children) of acpower.  See
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/ddl-inherit.html

            regards, tom lane