Foreign key constraint accepted even when not same data type

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема Foreign key constraint accepted even when not same data type
Дата
Msg-id 3F6EF483.8040807@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: Foreign key constraint accepted even when not same  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: Foreign key constraint accepted even when not same  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-general
Is it right for postgres to accept a foreign key constraint when the
type of the field is not the same as that of the foreign key?

For example:

# Create table a (id int primary key);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'a_pkey'
for table 'a'
CREATE TABLE
# Create table b (id2 text references a(id));

NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
CREATE TABLE

# \d a
        Table "public.a"
  Column |  Type   | Modifiers
--------+---------+-----------
  id     | integer | not null
Indexes: a_pkey primary key btree (id)

# \d b
      Table "public.b"
  Column | Type | Modifiers
--------+------+-----------
  id2    | text |
Foreign Key constraints: $1 FOREIGN KEY (id2) REFERENCES a(id) ON UPDATE
NO ACTION ON DELETE NO ACTION


Jean-Christian Imbeault




В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Welty
Дата:
Сообщение: Re: PostgreSQL versus MySQL
Следующее
От: Jean-Christian Imbeault
Дата:
Сообщение: Foreign key constraint accepted even when not same data type