Thread: HELP: language option software package not installed

HELP: language option software package not installed

From
"Allan C. Huffman"
Date:
Hello Everyone,

It has been sometime since I have installed PostgreSQL.  It has been
running great with no crashes for like a year!  But alas, my faithful
Sparc 20 turned belly-up.  It is sad to loose an old friend @* | *@

I now have a Ultra10 :o)  I've loaded Solaris 8 with the companion disk
that loaded Perl5.  Everything appears to be loaded into
/usr/Perl5/5.00503.  It looks OK to me but this happens:

./configure --with-perl --enable-odbc --enable-syslog --enable-cassert

Then during the gmake:

cp Pg.pm blib/lib/Pg.pm
AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg)
/usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503
/usr/perl5/5.00503/ExtUtils/xsubpp -typemap
/usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs >xstmp.c &&
mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend
-DVERSION=\"1.8.0\" -DXS_VERSION=\"1.8.0\" -KPIC
-I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c
/usr/ucb/cc:  language optional software package not installed
gmake[4]: *** [Pg.o] Error 1
gmake[4]: Leaving directory
'/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
gmake[3]: *** [Install] Error 2
gmake[3]: Leaving directory
'/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
gmake[2]: *** [Install] Error 2
gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces'

gmake[1]: *** [Install] Error 2
gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src'
gmake: *** [Install] Error 2




Re: HELP: language option software package not installed

From
GB Clark
Date:
On Mon, 14 Jan 2002 18:11:59 +0100
"Allan C. Huffman" <huffmana@ppc.pims.org> wrote:

> Hello Everyone,
>
> It has been sometime since I have installed PostgreSQL.  It has been
> running great with no crashes for like a year!  But alas, my faithful
> Sparc 20 turned belly-up.  It is sad to loose an old friend @* | *@
>
> I now have a Ultra10 :o)  I've loaded Solaris 8 with the companion disk
> that loaded Perl5.  Everything appears to be loaded into
> /usr/Perl5/5.00503.  It looks OK to me but this happens:
>
> ./configure --with-perl --enable-odbc --enable-syslog --enable-cassert
>
> Then during the gmake:
>
> cp Pg.pm blib/lib/Pg.pm
> AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg)
> /usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503
> /usr/perl5/5.00503/ExtUtils/xsubpp -typemap
> /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs >xstmp.c &&
> mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend
> -DVERSION=\"1.8.0\" -DXS_VERSION=\"1.8.0\" -KPIC
> -I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c
> /usr/ucb/cc:  language optional software package not installed
> gmake[4]: *** [Pg.o] Error 1
> gmake[4]: Leaving directory
> '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
> gmake[3]: *** [Install] Error 2
> gmake[3]: Leaving directory
> '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
> gmake[2]: *** [Install] Error 2
> gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces'
>
> gmake[1]: *** [Install] Error 2
> gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src'
> gmake: *** [Install] Error 2
Hi,

You don't have a C compiler installed.  Or if you do, it is not picking
it up.

This is a OS problem.  It looks like it has not changed since the SunOS 5.X
days...:(

GB


--
GB Clark II             | Roaming FreeBSD Admin
gclarkii@VSServices.COM | General Geek
           CTHULU for President - Why choose the lesser of two evils?

Re: HELP: language option software package not installed

From
"Heather Johnson"
Date:
It looks like the user you are when you install postgres does not know the
path to your compiler. Try installing gcc and use it instead of cc to
compile postgres. Make sure your user's .profile has the path to gcc before
installing.

Heather

----- Original Message -----
From: "Allan C. Huffman" <huffmana@ppc.pims.org>
To: <pgsql-admin@postgresql.org>; <shuttr@pims.org>
Sent: Monday, January 14, 2002 12:11 PM
Subject: [ADMIN] HELP: language option software package not installed


> Hello Everyone,
>
> It has been sometime since I have installed PostgreSQL.  It has been
> running great with no crashes for like a year!  But alas, my faithful
> Sparc 20 turned belly-up.  It is sad to loose an old friend @* | *@
>
> I now have a Ultra10 :o)  I've loaded Solaris 8 with the companion disk
> that loaded Perl5.  Everything appears to be loaded into
> /usr/Perl5/5.00503.  It looks OK to me but this happens:
>
> ./configure --with-perl --enable-odbc --enable-syslog --enable-cassert
>
> Then during the gmake:
>
> cp Pg.pm blib/lib/Pg.pm
> AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg)
> /usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503
> /usr/perl5/5.00503/ExtUtils/xsubpp -typemap
> /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs >xstmp.c &&
> mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend
> -DVERSION=\"1.8.0\" -DXS_VERSION=\"1.8.0\" -KPIC
> -I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c
> /usr/ucb/cc:  language optional software package not installed
> gmake[4]: *** [Pg.o] Error 1
> gmake[4]: Leaving directory
> '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
> gmake[3]: *** [Install] Error 2
> gmake[3]: Leaving directory
> '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
> gmake[2]: *** [Install] Error 2
> gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces'
>
> gmake[1]: *** [Install] Error 2
> gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src'
> gmake: *** [Install] Error 2
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


Re: HELP: language option software package not installed

From
Randall Shutt
Date:
     It's all good.....  The root of the problem lied in the fact that
the default perl install for Solaris8 was built using SUNWspro (Sun's
compiler), and therefore the Config.pm had flags/paths/arguments to
reflect that compiler....  However, we are using the sunfreeware
installs of GCC and associated tools....  The bottom line is that the
Config.pm had to be adjusted to use GCC instead of cc....  Thanks for
the help.

     --Randall

Heather Johnson wrote:

>It looks like the user you are when you install postgres does not know the
>path to your compiler. Try installing gcc and use it instead of cc to
>compile postgres. Make sure your user's .profile has the path to gcc before
>installing.
>
>Heather
>
>----- Original Message -----
>From: "Allan C. Huffman" <huffmana@ppc.pims.org>
>To: <pgsql-admin@postgresql.org>; <shuttr@pims.org>
>Sent: Monday, January 14, 2002 12:11 PM
>Subject: [ADMIN] HELP: language option software package not installed
>
>
>>Hello Everyone,
>>
>>It has been sometime since I have installed PostgreSQL.  It has been
>>running great with no crashes for like a year!  But alas, my faithful
>>Sparc 20 turned belly-up.  It is sad to loose an old friend @* | *@
>>
>>I now have a Ultra10 :o)  I've loaded Solaris 8 with the companion disk
>>that loaded Perl5.  Everything appears to be loaded into
>>/usr/Perl5/5.00503.  It looks OK to me but this happens:
>>
>>./configure --with-perl --enable-odbc --enable-syslog --enable-cassert
>>
>>Then during the gmake:
>>
>>cp Pg.pm blib/lib/Pg.pm
>>AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg)
>>/usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503
>>/usr/perl5/5.00503/ExtUtils/xsubpp -typemap
>>/usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs >xstmp.c &&
>>mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend
>>-DVERSION=\"1.8.0\" -DXS_VERSION=\"1.8.0\" -KPIC
>>-I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c
>>/usr/ucb/cc:  language optional software package not installed
>>gmake[4]: *** [Pg.o] Error 1
>>gmake[4]: Leaving directory
>>'/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
>>gmake[3]: *** [Install] Error 2
>>gmake[3]: Leaving directory
>>'/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
>>gmake[2]: *** [Install] Error 2
>>gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces'
>>
>>gmake[1]: *** [Install] Error 2
>>gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src'
>>gmake: *** [Install] Error 2
>>
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>


--
Randall S. Shutt
Systems Engineer
Computer Systems and Communications Corporation
A General Dynamics Company
randall@cscc.net
1-703-814-9105




A question about PG Authorization

From
"Dong Meng"
Date:
Dear Guys,

May I have a question about the authorization of psql?

By using '\z' in psql context, I can get the description of authorization about each table/view.


                  r -- SELECT
                  w -- UPDATE/DELETE
                  a -- INSERT
                  R -- RULE
               arwR -- ALL


Authoriztion switches are specified as above, but what should I do if I want to grant 'update' without 'delete' to some
table/view?


thank you



Eddy

Re: A question about PG Authorization

From
Peter Eisentraut
Date:
Dong Meng writes:

> Authoriztion switches are specified as above, but what should I do if
> I want to grant 'update' without 'delete' to some table/view?

Wait for release 7.2.

--
Peter Eisentraut   peter_e@gmx.net


Re: A question about PG Authorization

From
bangh
Date:
Eddy,

The command you need  is:
psql> grant update on table_name to username;

Banghe

Dong Meng wrote:

> Dear Guys,
>
> May I have a question about the authorization of psql?
>
> By using '\z' in psql context, I can get the description of authorization about each table/view.
>
>
>                   r -- SELECT
>                   w -- UPDATE/DELETE
>                   a -- INSERT
>                   R -- RULE
>                arwR -- ALL
>
> Authoriztion switches are specified as above, but what should I do if I want to grant 'update' without 'delete' to
sometable/view? 
>
> thank you
>
> Eddy
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html