Re: PostgreSQL Missing Function Error

2006-10-13 Thread Roberto C. Sanchez
On Fri, Oct 13, 2006 at 07:17:28PM +1000, Duncan McDonald wrote: > Hi Roberto, > > Thanks for the reply. > > No I didn't use the 'createlang' command, isn't that for adding new > languages to postgreSQL? > > The earth distance functions are installed as standard with the main > package and bot

Re: PostgreSQL Missing Function Error

2006-10-13 Thread Duncan McDonald
Original Message - From: "Roberto C. Sanchez" <[EMAIL PROTECTED]> To: Sent: Friday, October 13, 2006 6:02 PM Subject: Re: PostgreSQL Missing Function Error Did you enable the target language using createlang(1) on the new server? Regards, -Roberto -- Roberto C. Sanchez htt

Re: PostgreSQL Missing Function Error

2006-10-13 Thread Roberto C. Sanchez
On Fri, Oct 13, 2006 at 11:42:40AM +1000, Duncan McDonald wrote: > Hi All. I was wondering whether someone could help me explain a weird > PostgreSQL error I've encountered. > > I have two machines running Sarge stable, the first has been operating as a > database server for some time and the ot

PostgreSQL Missing Function Error

2006-10-12 Thread Duncan McDonald
Hi All. I was wondering whether someone could help me explain a weird PostgreSQL error I've encountered. I have two machines running Sarge stable, the first has been operating as a database server for some time and the other I have just set up identically to run as a backup database. Both mach