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

2017-06-14 Thread Neil Anderson
That's a great start, thanks! You should put a pointer to that page in the Pg wiki. I think the 1 thing that would really help it though is to show the actual connection/relations of the columns. For example, a line between pg_index and pg_class is not quite as informative as a line from

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

2017-06-13 Thread
Thomas Kellerer wrote: > kbran...@pwhome.com schrieb am 09.06.2017 um 20:57: > > Neil Anderson wrote: > > > >> I've been exploring the pg_catalog tables and pointed a couple of > >> tools at it to extract an ER diagram for a blog post. At first I > >> thought it was a

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

2017-06-11 Thread Neil Anderson
> > 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

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

2017-06-09 Thread Neil Anderson
On 9 Jun 2017 14:59, wrote: Neil Anderson wrote: > I've been exploring the pg_catalog tables and pointed a couple of tools at > it to extract an ER diagram for a blog post. At first I thought it was a bug > in the drawing tool but it appears that

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

2017-06-09 Thread Thomas Kellerer
kbran...@pwhome.com schrieb am 09.06.2017 um 20:57: Neil Anderson wrote: I've been exploring the pg_catalog tables and pointed a couple of tools at it to extract an ER diagram for a blog post. At first I thought it was a bug in the drawing tool but it appears that

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

2017-06-09 Thread
Neil Anderson wrote: > I've been exploring the pg_catalog tables and pointed a couple of tools at > it to extract an ER diagram for a blog post. At first I thought it was a bug > in the drawing tool but it appears that the relationships between the > pg_catalog tables

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

2017-06-08 Thread Neil Anderson
> The bigger picture here is that catalog changes are supposed to be > executed by C code in response to DDL commands, and it's the C code > that is charged with maintaining catalog consistency. Constraints > would be useful if we supported updating the catalogs with direct > SQL manipulations;

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

2017-06-07 Thread Tom Lane
Neil Anderson writes: > I've been exploring the pg_catalog tables and pointed a couple of > tools at it to extract an ER diagram for a blog post. At first I > thought it was a bug in the drawing tool but it appears that the > relationships between the pg_catalog tables