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
