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-17 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

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

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

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

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

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]

extensions are hitting the ceiling

2019-03-18 Thread Eric Hanson
Hi folks, After months and years of really trying to make EXTENSIONs meet the requirements of my machinations, I have come to the conclusion that either a) I am missing something or b) they are architecturally flawed. Or possibly both. Admittedly, I might be trying to push extensions beyond