On Apr 23, 2011, at 1:03 PM, Dimitri Fontaine wrote: > Daniele Varrazzo <daniele.varra...@gmail.com> writes: >> For my extension I'm less concerned by having the install sql named in >> different ways or by the upgrade sql as all these files are generated >> by scripts. You may find useful this one > > You can also generate that reliably in SQL. You install your extension > with CREATE EXTENSION then run the query over pg_depend and you have it > all. Then you can test this upgrade script you just got in SQL. Tom > also has a version that does the necessary string replacements using sed > from a bash script rather than the SQL replace() function. > > http://archives.postgresql.org/pgsql-hackers/2011-02/msg01208.php > http://archives.postgresql.org/pgsql-hackers/2011-02/msg01438.php
Nice. Did you and Tom ever work out the difference in results? http://archives.postgresql.org/pgsql-hackers/2011-02/msg01572.php I'd like to see this documented somewhere, perhaps in http://developer.postgresql.org/pgdocs/postgres/extend-extensions.html Thanks, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
