Hi,

I have a FC4 server running PostgreSQL 8.1.0 with no apparent problems.
I compiled from source and so far have experienced only minor issues
related to dumping databases from 7.4.6 and trying to get them working
on 8.1.0. My set returning functions were mangled and needed to be rebuilt.

I have downloaded the Admin81 code base for pgAdmin and installed in
/contrib as per the instructions, followed by make && make install. No
errors occurred. I then took the admin81.sql.in script and attempted to
run it from both the psql perspective on postgres and the pgAdmin
connection to postgres database. I encountered errors, specifically...

ERROR: could not access file "MODULE_PATHNAME": No such file or directory

I am not sure how to proceed with solving this problem. Is there
something I need to do different? I used my root account to make and
install.

Thanks

Dave

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On 17/1/06 18:49, "hunkybill@gmail.com" <hunkybill@gmail.com> wrote:

> Hi,
>
> I have a FC4 server running PostgreSQL 8.1.0 with no apparent problems.
> I compiled from source and so far have experienced only minor issues
> related to dumping databases from 7.4.6 and trying to get them working
> on 8.1.0. My set returning functions were mangled and needed to be rebuilt.
>
> I have downloaded the Admin81 code base for pgAdmin and installed in
> /contrib as per the instructions, followed by make && make install. No
> errors occurred. I then took the admin81.sql.in script and attempted to
> run it from both the psql perspective on postgres and the pgAdmin
> connection to postgres database. I encountered errors, specifically...
>
> ERROR: could not access file "MODULE_PATHNAME": No such file or directory
>
> I am not sure how to proceed with solving this problem. Is there
> something I need to do different? I used my root account to make and
> install.

Hi Dave

When you ran 'make install' it should have built a 'real' admin81.sql script
form admin81.sql.in and installed it under $PGDIR/share/contrib (iirc). You
need to execute that, not the .in source file.

Regards, Dave


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match