Re: [ADMIN] Problems with pg_restore (plpgsql already exists)

2012-02-25 Thread Guillaume Lelarge
On Fri, 2012-02-24 at 22:12 -0500, Brian Weaver wrote: > So when did the installation of PL/PgSQL into all databases become standard > operating procedure? It wasn't standard (or at least it didn't choke) on > the installation of versions 8.3 and 8.4 that I have used on CentOS 5. > > Seems like a

Re: [ADMIN] Problems with pg_restore (plpgsql already exists)

2012-02-25 Thread Brian Weaver
Guillaume, Thanks for the pointer. Is it just me that finds it the behavior of pg_restore odd? If the default installation since 9.0 has PL/PgSQL installed then why does pg_restore still emit statements to create the language? As a developer by trade it smells like a bug. -- Brian Sent from

Re: [ADMIN] Problems with pg_restore (plpgsql already exists)

2012-02-25 Thread Scott Ribe
On Feb 25, 2012, at 9:18 AM, Brian Weaver wrote: > Thanks for the pointer. Is it just me that finds it the behavior of > pg_restore odd? If the default installation since 9.0 has PL/PgSQL installed > then why does pg_restore still emit statements to create the language? As a > developer by trad

Re: [ADMIN] Problems with pg_restore (plpgsql already exists)

2012-02-25 Thread Guillaume Lelarge
On Sat, 2012-02-25 at 09:23 -0700, Scott Ribe wrote: > On Feb 25, 2012, at 9:18 AM, Brian Weaver wrote: > > > Thanks for the pointer. Is it just me that finds it the behavior of > > pg_restore odd? If the default installation since 9.0 has PL/PgSQL > > installed then why does pg_restore still em

Re: [ADMIN] Problems with pg_restore (plpgsql already exists)

2012-02-25 Thread Brian Weaver
Thank you all for the explanation. I'll work around the issue. It's nice to understand the thought process even though I might disagree with it. -- Brian Sent from my iPhone On Feb 25, 2012, at 13:10, Guillaume Lelarge wrote: > On Sat, 2012-02-25 at 09:23 -0700, Scott Ribe wrote: >> On Feb 2