Re: [HACKERS] How ugly would this be? (ALTER DATABASE)

2014-10-25 Thread Greg Stark
On 24 Oct 2014 20:28, Robert Haas robertmh...@gmail.com wrote: You could perhaps try to create a command that would move a schema between two databases in the same cluster. It's fraught with practical difficulties because a single backend can't be connected to both databases at the same

[HACKERS] How ugly would this be? (ALTER DATABASE)

2014-10-24 Thread Joshua D. Drake
Hello, One of the things we run into quite a bit is customers who are using multiple databases when they should be using multiple schemas. I am sure other consultants run into this as well. This gets even more difficult as uptime requirements have become all but 100%. So my question is, what

Re: [HACKERS] How ugly would this be? (ALTER DATABASE)

2014-10-24 Thread Robert Haas
On Fri, Oct 24, 2014 at 2:06 PM, Joshua D. Drake j...@commandprompt.com wrote: One of the things we run into quite a bit is customers who are using multiple databases when they should be using multiple schemas. I am sure other consultants run into this as well. This gets even more difficult as

Re: [HACKERS] How ugly would this be? (ALTER DATABASE)

2014-10-24 Thread Jim Nasby
On 10/24/14, 1:28 PM, Robert Haas wrote: On Fri, Oct 24, 2014 at 2:06 PM, Joshua D. Drake j...@commandprompt.com wrote: One of the things we run into quite a bit is customers who are using multiple databases when they should be using multiple schemas. I am sure other consultants run into this

Re: [HACKERS] How ugly would this be? (ALTER DATABASE)

2014-10-24 Thread Robert Haas
On Fri, Oct 24, 2014 at 7:37 PM, Jim Nasby jim.na...@bluetreble.com wrote: ISTM that the multiple-databases-per-backend issue is the huge hang-up here. Maybe there's some way that could be hacked around if you're just re-jiggering a bunch of catalog stuff (assuming you lock users out of both