Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Tom Lane
Robert Haas writes: > On Sat, Dec 21, 2013 at 12:10 PM, Dimitri Fontaine > wrote: >> Stephen Frost writes: >>> That said, I'm starting to wonder about a few >>> different options that might be handy- having the extension be dumpable >>> (or maybe an option to pg_dump to dump them from the DB, or

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Robert Haas
On Sat, Dec 21, 2013 at 12:10 PM, Dimitri Fontaine wrote: > Stephen Frost writes: >> That said, I'm starting to wonder about a few >> different options that might be handy- having the extension be dumpable >> (or maybe an option to pg_dump to dump them from the DB, or not), and >> perhaps an op

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Stephen Frost
Dimitri, * Dimitri Fontaine (dimi...@2ndquadrant.fr) wrote: > Stephen Frost writes: > > That said, I'm starting to wonder about a few > > different options that might be handy- having the extension be dumpable > > (or maybe an option to pg_dump to dump them from the DB, or not), and > > perhaps

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Dimitri Fontaine
Stephen Frost writes: > That said, I'm starting to wonder about a few > different options that might be handy- having the extension be dumpable > (or maybe an option to pg_dump to dump them from the DB, or not), and > perhaps an option to have the version # included in the dump (or an > option t

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Stephen Frost
* Andrew Dunstan (and...@dunslane.net) wrote: > >That having been said, having a flag we can set to > >dump the extension contents normally rather than just dumping a CREATE > >EXTENSION statement seems completely reasonable to me. > > > >ALTER EXTENSION foo SET (dump_members = true/false); > > > >

Re: [HACKERS] SQL objects UNITs

2013-12-19 Thread Andrew Dunstan
On 12/19/2013 08:01 AM, Robert Haas wrote: On Wed, Dec 18, 2013 at 10:05 AM, Alvaro Herrera wrote: Stephen Frost escribió: * Dimitri Fontaine (dimi...@2ndquadrant.fr) wrote: Basically with building `UNIT` we realise with hindsight that we failed to build a proper `EXTENSION` system, and we s

Re: [HACKERS] SQL objects UNITs

2013-12-18 Thread Jim Nasby
On 12/18/13, 4:22 AM, Dimitri Fontaine wrote: ALTER UNIT name SET SCHEMA ; FWIW, with the "units" that we've developed we use schemas to differentiate between public objects and "internal" (private or protected) objects. So single-schema stuff becomes a PITA. Of course, since extensions