| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | James Hall <James(dot)Hall(at)RadioShack(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Duplicate Data entry problem |
| Date: | 2003-04-09 16:04:32 |
| Message-ID: | 7829.1049904272@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
James Hall <James(dot)Hall(at)RadioShack(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-04-09 16:18:45 | Re: [SQL] Yet Another (Simple) Case of Index not used |
| Previous Message | Joshua Moore-Oliva | 2003-04-09 15:51:27 | Re: aaagh... postgres is segfaulting? -- fix |