Re: duplicates on primary key column

> > Tom Lane wrote:
> That's because you made "archives" inherit from "documents", so the scan
> includes the rows in "archives" that have docid=0.
I see. That's my first time with inheriting tables. I though that it 
would be something as C++, ie. structure inherit only.
> You could do "SELECT docid FROM ONLY documents" if you don't want the
> scan to include child tables.  But it's probably a bad idea to use
> inheritance for the archives table at all.
Why it's a bad idea? Some pointing out or links would be very
helpful.

Thanks for your kindness!
--
  Marcin Gil :: marcin.gil@xxxxxxxxxxxx
  OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
  tel (44) 7247530 w/22, 7244401 w/22 -- fax w/25

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings