HELP: language option software package not installed
HELP: language option software package not installed
От:
"Allan C. Huffman" <huffmana@ppc.pims.org>
Дата:
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
От:
GB Clark <postgres@vsservices.com>
Дата:
On Mon, 14 Jan 2002 18:11:59 +0100
"Allan C. Huffman" 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
От:
"Heather Johnson" <hjohnson@nypost.com>
Дата:
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" To: ; 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
От:
Randall Shutt <randall@cscc.net>
Дата:
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"
>To: ;
>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
От:
"Dong Meng" <eddy@securities.com>
Дата:
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
От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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
От:
bangh <banghe@baileylink.net>
Дата:
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 some table/view? > > thank you > > Eddy > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html