From: | brian <brian(at)zijn-digital(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: missing cache data for cache id 27 |
Date: | 2007-01-24 18:42:22 |
Message-ID: | 45B7A88E.5010708@zijn-digital.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
> brian <brian(at)zijn-digital(dot)com> writes:
>
>>Tom Lane wrote:
>>
>>>Need a newer phpPGAdmin, perhaps? It'd be unsurprising for pre-8.1 code
>>>to fail to notice the OUT parameters, since it'd not know about the new
>>>columns in pg_proc ...
>
>
>>phpPgAdmin 4.0.1 (4.1 is latest). But i was under the impression that it
>>simply makes a call to pg_dump, so wasn't expecting the problem lay in
>>the front end.
>
>
> Um, but what pg_dump is it invoking? ISTR that phpPgAdmin uses the -i
> option to pg_dump, so that you wouldn't find out if the pg_dump was too
> old. In my book using that option by default verges on being a war
> crime, but I'm sure they think it's a good idea.
>
Right. I'd done:
$ /usr/bin/pg_dump --version
pg_dump (PostgreSQL) 8.1.4
but a quick glance at phpPGAdmin's config reminds me that it has its own
version:
$ /usr/bin/phpPgAdmin/pg_dump --version
pg_dump (PostgreSQL) 8.0.4
I'll upgrade to 4.1, dump the db, and see how it recreates the function
(whether it includes the OUT params). Thanks for the heads-up, Tom!
b
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Haile | 2007-01-24 18:51:52 | Stats collector frozen? |
Previous Message | Tom Lane | 2007-01-24 18:31:50 | Re: missing cache data for cache id 27 |