On Apr 23, 2011, at 1:03 PM, Dimitri Fontaine wrote:
> Daniele Varrazzo <daniele.varrazzo@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