Re: [GENERAL] pg_catalog tables don't have constraints?

Поиск
Список
Период
Сортировка
От Neil Anderson
Тема Re: [GENERAL] pg_catalog tables don't have constraints?
Дата
Msg-id CAEKCySvyEhwqBuDkDVr-gi68q6G3wBFdUTqaUpOgFHdkasQ6dg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] pg_catalog tables don't have constraints?  (Neil Anderson <neil@postgrescompare.com>)
Список pgsql-general
>
> Of course. My plan is to copy the catalogs into a new schema so I can add fk
> constraints and then get something like navicat or datagrip to draw it.
>

Hi. I made some progress on this and I've added all the diagrams and
documentation I've been able to produce so far for v10beta as well as
the tools used here:

https://www.postgrescompare.com/2017/06/11/pg_catalog_constraints.html

I would like to try SchemaSpy but it doesn't seem to like constraints
on oid columns too much so I'll have to work around it somehow. Might
be worth it though since it seems to have a new lease of life at
schemaspy.org

Neil


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] Inconsistent performance with LIKE and bind variable onlong-lived connection
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100