On 12/23/06, Stuart Grimshaw <[EMAIL PROTECTED]> wrote:
berble=# select * from headlines ;
ERROR: could not access status of transaction 1668180339
DETAIL: could not open file "pg_clog/0636": No such file or directory
Using Postgres 8.1.5 from Debian unstable, I got the ab
berble=# select * from headlines ;
ERROR: could not access status of transaction 1668180339
DETAIL: could not open file "pg_clog/0636": No such file or directory
Using Postgres 8.1.5 from Debian unstable, I got the above error, and
I have no idea what it means?
--
-S
Sports Photography in Sou
On 10/25/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Stuart Grimshaw" <[EMAIL PROTECTED]> writes:
> I've installed the postgresql-contrib8.1 deb package to get at the
> earthdistance function, but it doesn't seem to be recognised, even
> after a restart
Hi,
I've installed the postgresql-contrib8.1 deb package to get at the
earthdistance function, but it doesn't seem to be recognised, even
after a restart of the server.
Is there a final step I need to take after using apt-get to install?
--
-S
Sports Photography in South Yorkshire & Derbyshire
When I try and create a new database I get the following error:
ERROR: checkpoint request failed
HINT: Consult the server log for details.
but the error log (/var/log/postgresql/postgresql-8.1-main.log) just
repeats the same error message.
This is Postgres 8.1, from Debian Unstable debs. Ther
On 2/26/06, Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
> Stuart Grimshaw <[EMAIL PROTECTED]> schrieb:
>
> > I'm writing a script to clean up some data in a table, the data I'm
> > using as the source is held in emails, so I've written a perl scri
reate or replace function get_client_id(text) returns integer as $$
SELECT intclientid FROM client WHERE vchname = '$1';
$$ LANGUAGE SQL;
However, when I do this:
select get_client_id('Stuart Grimshaw');
I get no results, yet:
SELECT intclientid FROM client WHERE vchname = 'Stu
