Re: [HACKERS] v10beta pg_catalog diagrams

2017-06-15 5:06 GMT+02:00 Andres Freund : > On 2017-06-14 20:02:27 -0700, Andres Freund wrote: > > On June 14, 2017 7:53:05 PM PDT, Pavel Stehule > wrote: > > >2017-06-14 19:49 GMT+02:00 Andres Freund : > > >> > These constraints

Re: [HACKERS] v10beta pg_catalog diagrams

On 2017-06-14 20:02:27 -0700, Andres Freund wrote: > On June 14, 2017 7:53:05 PM PDT, Pavel Stehule > wrote: > >2017-06-14 19:49 GMT+02:00 Andres Freund : > >> > These constraints can slowdown creating/dropping database objects - > >> mainly > >> >

Re: [HACKERS] v10beta pg_catalog diagrams

2017-06-15 5:02 GMT+02:00 Andres Freund : > > > On June 14, 2017 7:53:05 PM PDT, Pavel Stehule > wrote: > >2017-06-14 19:49 GMT+02:00 Andres Freund : > > > >> On 2017-06-14 06:05:24 +0200, Pavel Stehule wrote: > >> > 2017-06-14

Re: [HACKERS] v10beta pg_catalog diagrams

On June 14, 2017 7:53:05 PM PDT, Pavel Stehule wrote: >2017-06-14 19:49 GMT+02:00 Andres Freund : > >> On 2017-06-14 06:05:24 +0200, Pavel Stehule wrote: >> > 2017-06-14 5:53 GMT+02:00 Peter Eisentraut < >> peter.eisentr...@2ndquadrant.com >> > >: >>

Re: [HACKERS] v10beta pg_catalog diagrams

2017-06-14 19:49 GMT+02:00 Andres Freund : > On 2017-06-14 06:05:24 +0200, Pavel Stehule wrote: > > 2017-06-14 5:53 GMT+02:00 Peter Eisentraut < > peter.eisentr...@2ndquadrant.com > > >: > > > > > On 6/13/17 17:08, Andres Freund wrote: > > > > I wondered before if we shouldn't

Re: [HACKERS] v10beta pg_catalog diagrams

On 2017-06-14 06:05:24 +0200, Pavel Stehule wrote: > 2017-06-14 5:53 GMT+02:00 Peter Eisentraut >: > > > On 6/13/17 17:08, Andres Freund wrote: > > > I wondered before if we shouldn't introduce "information only" > > > unenforced foreign key constraints for the

Re: [HACKERS] v10beta pg_catalog diagrams

2017-06-14 5:53 GMT+02:00 Peter Eisentraut : > On 6/13/17 17:08, Andres Freund wrote: > > I wondered before if we shouldn't introduce "information only" > > unenforced foreign key constraints for the catalogs. We kind of > > manually do that via oidjoins, it'd

Re: [HACKERS] v10beta pg_catalog diagrams

On 6/13/17 17:08, Andres Freund wrote: > I wondered before if we shouldn't introduce "information only" > unenforced foreign key constraints for the catalogs. We kind of > manually do that via oidjoins, it'd be nicer if we'd a function > rechecking fkeys, and the fkeys were in the catalog... I

Re: [HACKERS] v10beta pg_catalog diagrams

Hi, On 2017-06-12 11:28:39 -0400, Neil Anderson wrote: > I'm cross posting from general. I did some work to diagram the relationships > in pg_catalog for v10. I would like to add it to the developer FAQ here >

Re: [HACKERS] v10beta pg_catalog diagrams

On Tue, Jun 13, 2017 at 3:14 PM, Neil Anderson wrote: > There were a few relationships that I couldn't capture. Like where in > pg_extension extconfig is an array of oids that refer to pg_class or where > pg_depends could refer to basically any other system catalog, but

Re: [HACKERS] v10beta pg_catalog diagrams

On 2017-06-13 1:22 PM, Bruce Momjian wrote: On Mon, Jun 12, 2017 at 04:07:35PM -0400, Peter Eisentraut wrote: On 6/12/17 11:28, Neil Anderson wrote: I'm cross posting from general. I did some work to diagram the relationships in pg_catalog for v10. I would like to add it to the developer FAQ

Re: [HACKERS] v10beta pg_catalog diagrams

On Mon, Jun 12, 2017 at 04:07:35PM -0400, Peter Eisentraut wrote: > On 6/12/17 11:28, Neil Anderson wrote: > > I'm cross posting from general. I did some work to diagram the > > relationships in pg_catalog for v10. I would like to add it to the > > developer FAQ here > >

Re: [HACKERS] v10beta pg_catalog diagrams

On 6/12/17 11:28, Neil Anderson wrote: > I'm cross posting from general. I did some work to diagram the > relationships in pg_catalog for v10. I would like to add it to the > developer FAQ here >

[HACKERS] v10beta pg_catalog diagrams

Hi, I'm cross posting from general. I did some work to diagram the relationships in pg_catalog for v10. I would like to add it to the developer FAQ here https://wiki.postgresql.org/wiki/Developer_FAQ#Is_there_a_diagram_of_the_system_catalogs_available.3F but I thought I should check if