Обсуждение: BUG #11176: Doc bug: New York City is *not* the capital of New York State.

The following bug has been logged on the website:

Bug reference:      11176
Logged by:          George Hartzell
Email address:      hartzell@alerce.com
PostgreSQL version: 9.4beta2
Operating system:   any
Description:

Inheritance does not automatically propagate data from INSERT or COPY
commands to other tables in the inheritance hierarchy. In our example, the
following INSERT statement will fail:

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.

g.

On 08/15/2014 06:32 AM, hartzell@alerce.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

New York (City) may not be the capital of New York, but it is The Center of The Known Universe(!)
(Do the docs reflect this?)

(Lou Picciano)

----- Original Message -----
From: hartzell@alerce.com
To: pgsql-bugs@postgresql.org
Sent: Thursday, August 14, 2014 11:32:21 PM
Subject: [BUGS] BUG #11176: Doc bug: New York City is *not* the capital of New York State.

The following bug has been logged on the website:

Bug reference:      11176
Logged by:          George Hartzell
Email address:      hartzell@alerce.com
PostgreSQL version: 9.4beta2
Operating system:   any
Description:

Inheritance does not automatically propagate data from INSERT or COPY
commands to other tables in the inheritance hierarchy. In our example, the
following INSERT statement will fail:

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.

g.


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

On Fri, Aug 15, 2014 at 8:31 AM, Lou Picciano <loupicciano@comcast.net>
wrote:

> New York (City) may not be the capital of New York, but it is The Center
> of The Known Universe(!)
> (Do the docs reflect this?)
>

Douglas Hofstadter had a debate, in one of his books, about "what is the
Moscow of New York?"

It was broadly an AI question, surrounding meaning, and several answers
fall out, from various senses of the matter.
- NYC as "da big city" was an answer;
- There's a town called Moscow, NY;
- There's a neighborhood in NYC that gets called "Little Odessa" that could
fit;
- Albany is the capital of NY much as Moscow is the capital of Russia

There's an AI/meaning debate to be had to question which meaning best fits
what someone was asking.
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"