On Feb 12, 2014, at 2:21 AM, Dave Page <dp...@pgadmin.org> wrote: > Much as PostgreSQL only changes catalogs and on disk format in major > releases, pgAgent only changes its schema in X releases (in the X.Y.Z > numbering scheme). My point is that there is no need to have upgrade > scripts from 3.3.0 - 3.4.0 or even 3.3 - 3.4 because there will never > be any such changes, and using that numbering is likely to confuse > users because the existence of a 3.4.0 script implies that there also > should be one for 3.4.1 or 3.5.0 in the future, when in actual fact, > there will only be one needed for 4(.x.x). > > Therefore, I believe the correct option is actually to have > "pgagent--unpackaged--3.sql" and later "pgagent--3--4.sql" for > upgrades.
Yeah, but if the version is 3.4.0, and that's what's in pgagent.spec, then Postgres will never find the upgrade script if it’s not named "pgagent--unpackaged--3.4.0.sql". The name in the file must be the same as in the spec file. Best, David -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers