Thread: BUG #11176: Doc bug: New York City is *not* the capital of New York State.
BUG #11176: Doc bug: New York City is *not* the capital of New York State.
From
hartzell@alerce.com
Date:
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.
Re: BUG #11176: Doc bug: New York City is *not* the capital of New York State.
From
Heikki Linnakangas
Date:
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
Re: BUG #11176: Doc bug: New York City is *not* the capital of New York State.
From
Lou Picciano
Date:
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
Re: BUG #11176: Doc bug: New York City is *not* the capital of New York State.
From
Christopher Browne
Date:
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?"