>Number:         28351
>Category:       pkg
>Synopsis:       postgresql74 when linked with libpthread breaks
>Confidential:   no
>Severity:       critical
>Priority:       high
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Thu Nov 18 19:27:00 +0000 2004
>Originator:     User explorer
>Release:        NetBSD 2.99.10
>Organization:
>Environment:
System: NetBSD speedy.flame.org 2.99.10 NetBSD 2.99.10 (GENERIC.MP) #0: Mon Nov 8 13:34:20 PST 2004 explorer@speedy.flame.org:/sys/arch/i386/compile/GENERIC.MP i386
Architecture: i386
Machine: i386
>Description:
When the postgresql74 set of packages are installed, queries to many
databases involving the plpgsql language break.  Creating databases
and adding the language to them also breaks.

This problem does not happen if I remove the use of pthreads when
building postgresql74.

This is from a -current source kit 24 hours old, and a pkgsrc less than
24 hours old.
>How-To-Repeat:
% createdb foo
% createlang -d foo plpgsql
Note crash.
>Fix: