pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Eric Ridge <eebbrr@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Regina Obe <lr@pcorp.us>
Cc: strk@kbt.io, Regina Obe <r@pcorp.us>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: [PATCH] Support % wildcard in extension upgrade filenames
Date: Mon, 01 May 2023 16:24:30 -0400
Message-ID: <2297723.1682972670@sss.pgh.pa.us> (raw)
In-Reply-To: <86875FF7-0592-4F76-8CBA-8B5AE632F1B2@gmail.com>
References: <YgakFklJyM5pNdt+@c19>
	<20221117095734.igldlk6kngr6ogim@c19>
	<166914379479.1121.7549798686571352890.pgcf@coridan.postgresql.org>
	<55512.1673304709@sss.pgh.pa.us>
	<20230110205259.htcuhg3t7shd367d@c19>
	<387183.1673394631@sss.pgh.pa.us>
	<CA+TgmobDy0sasmzOFkCcKXC3XeQZzRNwbaQRJ752tF1i11BRKQ@mail.gmail.com>
	<20230308122736.e2mx4e3paxbabcnw@c19>
	<CA+TgmoYqK6nfP15SjuyO6t5jOmymG=qO7JOOVJdTOj96L0XJ1Q@mail.gmail.com>
	<20230313122210.r7mnwawjhfklcp7w@c19>
	<003201d955dc$7770af60$66520e20$@pcorp.us>
	<F2820A88-F29B-4F0A-9430-7D9AE33E953C@gmail.com>
	<CA+TgmobhF+VOCLETv3ewNTdP6Y04V1Lh5jy1N45VRJoNER8PNw@mail.gmail.com>
	<86875FF7-0592-4F76-8CBA-8B5AE632F1B2@gmail.com>

Eric Ridge <eebbrr@gmail.com> writes:
> FWIW, outside of major ZDB releases, most of those have little-to-zero schema changes.  But that doesn't negate the fact each release needs its own upgrade.sql script. I'm working on a point release right this moment and it won't have any schema changes but it'll have an upgrade.sql script.

Hmm ... our model for the in-core extensions has always been that you
don't need a new upgrade script unless the SQL declarations change.

Admittedly, that means that the script version number isn't a real
helpful guide to which version of the .so you're dealing with.
We expect the .so's own minor version number to suffice for that,
but I realize that that might not be the most user-friendly answer.

			regards, tom lane





view thread (78+ messages)  latest in thread

Message-ID: <2297723.1682972670@sss.pgh.pa.us>
Permalink:  ../2297723.1682972670@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2297723.1682972670@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, eebbrr@gmail.com, robertmhaas@gmail.com, lr@pcorp.us, r@pcorp.us, pgsql-hackers@lists.postgresql.org
  Subject: Re: [PATCH] Support % wildcard in extension upgrade filenames
  In-Reply-To: <2297723.1682972670@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox