Re: Extension Packaging

On Apr 23, 2011, at 1:03 PM, Dimitri Fontaine wrote:

> Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)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