From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
---|---|
To: | <hartzell(at)alerce(dot)com>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #11176: Doc bug: New York City is *not* the capital of New York State. |
Date: | 2014-08-15 07:02:08 |
Message-ID: | 53EDB070.8030202@vmware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 08/15/2014 06:32 AM, hartzell(at)alerce(dot)com wrote:
> This example, in section 5.8, Inheritance, suggests that someone thinks that
> New York the city is the capital of New York the state.
>
>> INSERT INTO cities (name, population, altitude, state)
> VALUES ('New York', NULL, NULL, 'NY');
>> We might hope that the data would somehow be routed to the capitals table,
> but this does not happen: INSERT always inserts into exactly the table
> specified. In some cases it is possible to redirect the insertion using a
> rule (see Chapter 38). However that does not help for the above case because
> the cities table does not contain the column state, and so the command will
> be rejected before the rule can be applied.
>
> The example would make more sense if the city were Albany.
Fixed, thanks.
- Heikki
From | Date | Subject | |
---|---|---|---|
Next Message | Lou Picciano | 2014-08-15 12:31:58 | Re: BUG #11176: Doc bug: New York City is *not* the capital of New York State. |
Previous Message | Jov | 2014-08-15 05:29:24 | Re: BUG #11161: set kern.ipc.semmap on FreeBSD 9.0+ get error |