On Mon, Nov 11, 2013 at 8:20 PM, Josh Berkus <j...@agliodbs.com> wrote: > > > [...] > > Well, then we just need pg_restore to handle the "role already exists" > error message gracefully. That's all. Or a "CREATE ROLE IF NOT EXISTS" > statement, and use that for roles. >
I'm working in a patch to add IF NOT EXISTS for all CREATE statements, including of course the CREATE ROLE statement. Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Timbira: http://www.timbira.com.br >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello