pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMissing Earth Distance Functions Under Debian
6+ messages / 4 participants
[nested] [flat]
* Missing Earth Distance Functions Under Debian
@ 2006-10-17 04:48 Duncan McDonald <duncan@gpats.com.au>
2006-10-17 13:37 ` Re: Missing Earth Distance Functions Under Debian Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Duncan McDonald @ 2006-10-17 04:48 UTC (permalink / raw)
To: pgsql-admin
Hi All. I was wondering whether someone could help me explain a weird
PostgreSQL error I've encountered.
I have two machines running Debian 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 machines used the default database setup
option during installation.
Some of my scripts rely on the earth distance functions contained in the
'postgresql-contrib' package, but for some reason the backup PostgreSQL
database does not recognise these functions. Eg. my latitude/longitude to
distance converter, which runs fine on the main machine, generates this
error message:
"ERROR: function ll_to_earth(numeric, numeric) does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts."
I've tried reinstalling the package in question but it had no effect. Does
anyone have a theory why it would run on one and not the other and/or how I
can get the earth distance functions working?
Regards,
-Duncan
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Missing Earth Distance Functions Under Debian
2006-10-17 04:48 Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
@ 2006-10-17 13:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-10-18 23:37 ` Re: Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2006-10-17 13:37 UTC (permalink / raw)
To: Duncan McDonald <duncan@gpats.com.au>; +Cc: pgsql-admin
"Duncan McDonald" <duncan@gpats.com.au> writes:
> "ERROR: function ll_to_earth(numeric, numeric) does not exist
> HINT: No function matches the given name and argument types. You may need
> to add explicit type casts."
> I've tried reinstalling the package in question but it had no effect.
I think you forgot to execute the earthdistance.sql script to define
the functions within the current database.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Missing Earth Distance Functions Under Debian
2006-10-17 04:48 Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
2006-10-17 13:37 ` Re: Missing Earth Distance Functions Under Debian Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-10-18 23:37 ` Duncan McDonald <duncan@gpats.com.au>
2006-10-19 14:19 ` Re: Missing Earth Distance Functions Under Debian Bricklen Anderson <banderson@presinet.com>
2006-10-19 15:09 ` Re: Missing Earth Distance Functions Under Debian Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 6+ messages in thread
From: Duncan McDonald @ 2006-10-18 23:37 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Hi Tom,
Thanks for the reply.
No I didn't run the earthdistance.sql script on the backup database, is this
included with the standard PostgreSQL package? If not, would you mind
letting me know how/where to obtain it?
I'm relatively new to PostgreSQL administration so I apologise in advance if
this is an obvious question.
Regards,
-Duncan
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Duncan McDonald" <duncan@gpats.com.au>
Cc: <pgsql-admin@postgresql.org>
Sent: Tuesday, October 17, 2006 11:37 PM
Subject: Re: [ADMIN] Missing Earth Distance Functions Under Debian
...
> I think you forgot to execute the earthdistance.sql script to define
> the functions within the current database.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Missing Earth Distance Functions Under Debian
2006-10-17 04:48 Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
2006-10-17 13:37 ` Re: Missing Earth Distance Functions Under Debian Tom Lane <tgl@sss.pgh.pa.us>
2006-10-18 23:37 ` Re: Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
@ 2006-10-19 14:19 ` Bricklen Anderson <banderson@presinet.com>
1 sibling, 0 replies; 6+ messages in thread
From: Bricklen Anderson @ 2006-10-19 14:19 UTC (permalink / raw)
To: Duncan McDonald <duncan@gpats.com.au>; +Cc: pgsql-admin
Duncan McDonald wrote:
> Hi Tom,
>
> Thanks for the reply.
>
> No I didn't run the earthdistance.sql script on the backup database, is this
> included with the standard PostgreSQL package? If not, would you mind
> letting me know how/where to obtain it?
>
> I'm relatively new to PostgreSQL administration so I apologise in advance if
> this is an obvious question.
>
> Regards,
>
> -Duncan
I think that it is in the postgresql-contrib-8.1 deb package available
via aptitude (or whichever package manager you are using).
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Missing Earth Distance Functions Under Debian
2006-10-17 04:48 Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
2006-10-17 13:37 ` Re: Missing Earth Distance Functions Under Debian Tom Lane <tgl@sss.pgh.pa.us>
2006-10-18 23:37 ` Re: Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
@ 2006-10-19 15:09 ` Peter Eisentraut <peter_e@gmx.net>
2006-10-20 00:08 ` Re: Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
1 sibling, 1 reply; 6+ messages in thread
From: Peter Eisentraut @ 2006-10-19 15:09 UTC (permalink / raw)
To: pgsql-admin; +Cc: Duncan McDonald <duncan@gpats.com.au>
Duncan McDonald wrote:
> No I didn't run the earthdistance.sql script on the backup database,
> is this included with the standard PostgreSQL package? If not, would
> you mind letting me know how/where to obtain it?
http://packages.debian.org/cgi-bin/search_contents.pl?word=earthdistance.sql&searchmode=searchfi...
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Missing Earth Distance Functions Under Debian
2006-10-17 04:48 Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
2006-10-17 13:37 ` Re: Missing Earth Distance Functions Under Debian Tom Lane <tgl@sss.pgh.pa.us>
2006-10-18 23:37 ` Re: Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
2006-10-19 15:09 ` Re: Missing Earth Distance Functions Under Debian Peter Eisentraut <peter_e@gmx.net>
@ 2006-10-20 00:08 ` Duncan McDonald <duncan@gpats.com.au>
0 siblings, 0 replies; 6+ messages in thread
From: Duncan McDonald @ 2006-10-20 00:08 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; pgsql-admin
Hi Peter,
That worked like a charm. Thanks for the help!
Regards,
-Duncan
----- Original Message -----
From: "Peter Eisentraut" <peter_e@gmx.net>
To: <pgsql-admin@postgresql.org>
Cc: "Duncan McDonald" <duncan@gpats.com.au>
Sent: Friday, October 20, 2006 1:09 AM
Subject: Re: [ADMIN] Missing Earth Distance Functions Under Debian
> Duncan McDonald wrote:
>> No I didn't run the earthdistance.sql script on the backup database,
>> is this included with the standard PostgreSQL package? If not, would
>> you mind letting me know how/where to obtain it?
>
> http://packages.debian.org/cgi-bin/search_contents.pl?word=earthdistance.sql&searchmode=searchfi...
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-10-20 00:08 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-17 04:48 Missing Earth Distance Functions Under Debian Duncan McDonald <duncan@gpats.com.au>
2006-10-17 13:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-10-18 23:37 ` Duncan McDonald <duncan@gpats.com.au>
2006-10-19 14:19 ` Bricklen Anderson <banderson@presinet.com>
2006-10-19 15:09 ` Peter Eisentraut <peter_e@gmx.net>
2006-10-20 00:08 ` Duncan McDonald <duncan@gpats.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox