Обсуждение: Can't install pltcl

I am currently trying to install pltcl on my Win32 8.0 version of PG, and am
receiving the incredibly generic message:

createlang: language installation failed: ERROR:  could not load library
"C:/Pro
gram Files/PostgreSQL/8.0/lib/pltcl.dll": dynamic load error

The postgres user has read permissions on the tcl bin directory. I also ran
depends.exe on the pltcl dll, and everything appeared to checkout. Where do
I go from here in trying to determine what is wrong?

Thanks,
Steve

> I am currently trying to install pltcl on my Win32 8.0
> version of PG, and am receiving the incredibly generic message:
>
> createlang: language installation failed: ERROR:  could not
> load library "C:/Pro gram
> Files/PostgreSQL/8.0/lib/pltcl.dll": dynamic load error
>
> The postgres user has read permissions on the tcl bin
> directory. I also ran depends.exe on the pltcl dll, and
> everything appeared to checkout. Where do I go from here in
> trying to determine what is wrong?

Did you run depends logged in as yourself or as the postgres user?
(runas may be enough there) Could be different environments and/or
permissions.

//Magnus

>
> Did you run depends logged in as yourself or as the postgres user?
> (runas may be enough there) Could be different environments and/or
> permissions.

I originally ran it logged in as myself, but even when I used runas with the
postgres user everything checked out. I opened up a command line to verify
that c:\tcl\bin is in the path, and it is. While looking at that though, I
noticed the path had c:\program files\postgresql\8.0\bin, but no path entry
for lib/, is that correct?

Steve

> Did you run depends logged in as yourself or as the postgres user?
> (runas may be enough there) Could be different environments and/or
> permissions.

I don't know if it matters, but I'm using the ActiveState Tcl binaries
8.4.9, and not the source distribution.

Steve

>> Did you run depends logged in as yourself or as the postgres user?
>> (runas may be enough there) Could be different environments and/or
>> permissions.
>
>I don't know if it matters, but I'm using the ActiveState Tcl binaries
>8.4.9, and not the source distribution.

Nope, that should work fine. It's the same one I use :-) (at least I use
8.4, can't remember which subversion ATM, and I do use the binary
distribution of it)

//Magnus

> >I don't know if it matters, but I'm using the ActiveState Tcl binaries
> >8.4.9, and not the source distribution.
>
> Nope, that should work fine. It's the same one I use :-) (at least I use
> 8.4, can't remember which subversion ATM, and I do use the binary
> distribution of it)

Did you see my message from last night about depends as the postgres user?
Do you have any ideas as to what I should try doing now?

Thanks,
Steve

> > Did you run depends logged in as yourself or as the postgres user?
> > (runas may be enough there) Could be different environments and/or
> > permissions.
>
> I originally ran it logged in as myself, but even when I used
> runas with the postgres user everything checked out. I opened
> up a command line to verify that c:\tcl\bin is in the path,
> and it is. While looking at that though, I noticed the path
> had c:\program files\postgresql\8.0\bin, but no path entry
> for lib/, is that correct?

Hm. Yes, that's now it normally is.

I'm kind of lost on this :'( I've never seen a case where "depends"
works when running as postgresql, but not the backend itself. I think
you will need to hack up some better error messages for the dynamic
loader to get further.
(i was going to do that eventually, but I haven't had the time to look
into it yet)


//Magnus

>
> I'm kind of lost on this :'( I've never seen a case where "depends"
> works when running as postgresql, but not the backend itself. I think
> you will need to hack up some better error messages for the dynamic
> loader to get further.
> (i was going to do that eventually, but I haven't had the time to look
> into it yet)

Well I'm assuming these are written in C, and I really have no clue about
reading/writing C code(let alone good C code).

Steve

> > I'm kind of lost on this :'( I've never seen a case where "depends"
> > works when running as postgresql, but not the backend itself. I think
> > you will need to hack up some better error messages for the dynamic
> > loader to get further.
> > (i was going to do that eventually, but I haven't had the time to look
> > into it yet)
>
> Well I'm assuming these are written in C, and I really have no clue about
> reading/writing C code(let alone good C code).

I just upgraded to 8.0.2 today, and createlang for pltclu worked just fine.
Any ideas what changed that may have caused it to work Magnus?

Steve

> > > I'm kind of lost on this :'( I've never seen a case where
> "depends"
> > > works when running as postgresql, but not the backend itself. I
> > > think you will need to hack up some better error messages for the
> > > dynamic loader to get further.
> > > (i was going to do that eventually, but I haven't had the time to
> > > look into it yet)
> >
> > Well I'm assuming these are written in C, and I really have no clue
> > about reading/writing C code(let alone good C code).
>
> I just upgraded to 8.0.2 today, and createlang for pltclu
> worked just fine.
> Any ideas what changed that may have caused it to work Magnus?

Nothing that I can think of, really...

//Magnus