| From: | Louis-David Mitterrand <cunctator(at)apartia(dot)ch> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | child table doesn't inherit PRIMARY KEY? |
| Date: | 2000-06-03 15:22:56 |
| Message-ID: | 20000603172256.A3435@styx |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general pgsql-hackers |
When creating a child (through CREATE TABLE ... INHERIT (parent)) it
seems the child gets all of the parent's contraints _except_ its PRIMARY
KEY. Is this normal? Should I add a PRIMARY KEY(id) statement each time
I create an inherited table?
Cheers,
--
Louis-David Mitterrand - ldm(at)apartia(dot)org - http://www.apartia.fr
If at first you don't succeed, redefine success.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Louis-David Mitterrand | 2000-06-03 15:51:56 | Re: child table doesn't inherit PRIMARY KEY? |
| Previous Message | Thomas Lockhart | 2000-06-02 04:18:07 | Re: Update web version of docs |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kari Lempiainen | 2000-06-03 15:51:25 | Any monitor programs? |
| Previous Message | Giles Lean | 2000-06-03 12:59:34 | Re: Industrial-Strength Logging |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Louis-David Mitterrand | 2000-06-03 15:51:56 | Re: child table doesn't inherit PRIMARY KEY? |
| Previous Message | Bruce Momjian | 2000-06-03 14:00:46 | Re: New warning code for missing FROM relations |