ALTER TABLE INHERIT vs collations
| От | Tom Lane |
|---|---|
| Тема | ALTER TABLE INHERIT vs collations |
| Дата | |
| Msg-id | 9826.1302992604@sss.pgh.pa.us обсуждение исходный текст |
| Ответы |
Re: ALTER TABLE INHERIT vs collations
Re: ALTER TABLE INHERIT vs collations Re: ALTER TABLE INHERIT vs collations |
| Список | pgsql-hackers |
Right at the moment, ALTER INHERIT doesn't verify that collations match
in a proposed inheritance child. So you can do this:
regression=# create table foo (f1 text collate "C");
CREATE TABLE
regression=# create table bar (f1 text collate "POSIX");
CREATE TABLE
regression=# alter table bar inherit foo;
ALTER TABLE
but then the planner whines about it:
regression=# select * from foo;
ERROR: attribute "f1" of relation "bar" does not match parent's collation
Does anyone think it's not a bug that ALTER TABLE lets this through?
If so, what do you think the querying semantics ought to be?
regards, tom lane
В списке pgsql-hackers по дате отправления: