Re: [Fwd: Make psql use all pretty print options]

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [Fwd: Make psql use all pretty print options]
Дата
Msg-id 3F8638CA.7010209@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: [Fwd: Make psql use all pretty print options]  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [Fwd: Make psql use all pretty print options]  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-patches
> Uh, I can't apply this to 7.4 unless you can get others to agree it
> should be added.  Sorry.

OK, for reviewers.  Note the index predicate and the check constraint in
particular.

With patch:

test=# \d example
                           Table "public.example"
  Column |  Type   |                       Modifiers
--------+---------+--------------------------------------------------------
  a      | integer | not null default nextval('public.example_a_seq'::text)
  b      | integer |
  c      | integer |
  d      | boolean |
Indexes:
     "example_pkey" PRIMARY KEY, btree (a)
     "example_b_key" UNIQUE, btree (b)
     "example_idx" btree (abs(a)) WHERE c > 11
Check constraints:
     "example_d" CHECK (d)
Foreign-key constraints:
     "$1" FOREIGN KEY (c) REFERENCES parent(a)
Rules:
     example_rule AS
     ON INSERT TO example DO INSTEAD NOTHING

Without patch:

test=# \d example
                           Table "public.example"
  Column |  Type   |                       Modifiers
--------+---------+--------------------------------------------------------
  a      | integer | not null default nextval('public.example_a_seq'::text)
  b      | integer |
  c      | integer |
  d      | boolean |
Indexes:
     "example_pkey" primary key, btree (a)
     "example_b_key" unique, btree (b)
     "example_idx" btree (abs(a)) WHERE (c > 11)
Check constraints:
     "example_d" CHECK d
Foreign-key constraints:
     "$1" FOREIGN KEY (c) REFERENCES parent(a)
Rules:
     example_rule AS ON INSERT TO example DO INSTEAD NOTHING



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

Предыдущее
От: Dennis Bjorklund
Дата:
Сообщение: Re: [Fwd: Make psql use all pretty print options]
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: [Fwd: Make psql use all pretty print options]