Re: extensions are hitting the ceiling

2019-04-21 Thread Noah Misch
On Tue, Apr 16, 2019 at 04:24:20AM -0500, Eric Hanson wrote: > On Tue, Apr 16, 2019 at 12:47 AM Noah Misch wrote: > > https://www.postgresql.org/message-id/20180710014308.ga805...@rfd.leadboat.com > > > > The @DEPNAME_schema@ thing was trivial to implement, but I shelved it. > > I'm attaching the

Re: extensions are hitting the ceiling

2019-04-16 Thread Jiří Fejfar
Hi all! I am sending our comments to mentioned issues. I was trying to send it month ago (https://www.postgresql.org/message-id/CA%2B8wVNUOt2Bh4x7YQEVoq5BfP%3DjM-F6cDYKxJiTODG_VCGhUVQ%40mail.gmail.com), but it somehow doesn't append in the "thread" (sorry, I am new in mailing list practice...).

Re: extensions are hitting the ceiling

2019-04-16 Thread Eric Hanson
On Tue, Apr 16, 2019 at 4:47 AM Eric Hanson wrote: > We would probably be wise to learn from what has gone (so I hear) terribly > wrong with the Node / NPM packaging system (and I'm sure many before it), > namely versioning. What happens when two extensions require different > versions of the sa

Re: extensions are hitting the ceiling

2019-04-16 Thread Eric Hanson
On Tue, Apr 16, 2019 at 4:24 AM Eric Hanson wrote: > > > On Tue, Apr 16, 2019 at 12:47 AM Noah Misch wrote: > >> On Mon, Mar 18, 2019 at 09:38:19PM -0500, Eric Hanson wrote: >> > I have heard talk of a way to write extensions so that they dynamically >> > reference the schema of their dependenci

Re: extensions are hitting the ceiling

2019-04-16 Thread Eric Hanson
On Tue, Apr 16, 2019 at 12:47 AM Noah Misch wrote: > On Mon, Mar 18, 2019 at 09:38:19PM -0500, Eric Hanson wrote: > > I have heard talk of a way to write extensions so that they dynamically > > reference the schema of their dependencies, but sure don't know how that > > would work if it's possibl

Re: extensions are hitting the ceiling

2019-04-15 Thread Noah Misch
On Mon, Mar 18, 2019 at 09:38:19PM -0500, Eric Hanson wrote: > #1: Dependencies > > Let's say we have two extensions, A and B, both of which depend on a third > extension C, let's just say C is hstore. A and B are written by different > developers, and both contain in their .control file the line

Re: extensions are hitting the ceiling

2019-03-19 Thread Eric Hanson
On Mon, Mar 18, 2019 at 11:56 PM Chapman Flack wrote: > On 03/18/19 22:38, Eric Hanson wrote: > > rows are really second class citizens: They aren't tracked with > > pg_catalog.pg_depend, they aren't deleted when the extension is dropped, > > etc. > > This. You have other interests as well, but

Re: extensions are hitting the ceiling

2019-03-19 Thread Jiří Fejfar
Hi all! We are also facing some issues when using extensions. We are using them quite intensively as a tool for maintaining our custom "DB applications" with versioning, all tables, data, regression tests... We find extensions great! We do not need other tool like flyway. My colleague already post

Re: extensions are hitting the ceiling

2019-03-18 Thread Chapman Flack
On 03/19/19 00:56, Chapman Flack wrote: > Nobody ever chimed in to say how numerous they did or didn't think the > problems would be. I was actually thinking recently about sitting down > and trying to write that patch, as no one had exactly stood up to say > "oh heavens no, don't write that." Of

Re: extensions are hitting the ceiling

2019-03-18 Thread Chapman Flack
On 03/18/19 22:38, Eric Hanson wrote: > rows are really second class citizens: They aren't tracked with > pg_catalog.pg_depend, they aren't deleted when the extension is dropped, > etc. This. You have other interests as well, but this is the one I was thinking about a few years ago in [1] (starti