Date: Fri, 20 Apr 2001 18:58:30 +0200
From: Ludek Finstrle <xfinstrl@informatics.muni.cz>
To: "Prof. L M Patnaik" <lalit@micro.iisc.ernet.in>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Postgres problem
Message-ID: <20010420185830.C23123@anxur.fi.muni.cz>
References: <Pine.SGI.4.10.10104191831150.839-100000@micro.iisc.ernet.in>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2i
In-Reply-To: <Pine.SGI.4.10.10104191831150.839-100000@micro.iisc.ernet.in>;
	from lalit@micro.iisc.ernet.in on Thu, Apr 19, 2001 at 06:33:07PM
	-0700

Prof. L M Patnaik napsal(a):
> 
> Hello:
> 
> I am having problem interfacing the postgres database with the 
> frontend(libpq),i.e using C.Database runs fine.
> 
>  PROBLEMS ARE:
>             1)When compiling the C-program given in the 
>              example for connecting the database to the
>              frontend using
>        $gcc -I /home/guest/pgsql/include test.c

Try something like this
        $gcc -I /home/guest/pgsql/include -L /home/guest/pgsql/lib -lpq test.c

I think that postgres libraries are stored in /home/guest/pgsql/lib.

> ...............................................................
>             
>             2)When I want to use the command
>               $createlang c (dbname)
>             OUTPUT:
>                    createlang:missing required argument PGLIB directory.            

You don't have specified the path to PGLIB. createlang can't find them.
Try set environment variable PGLIB (e.g. in bash:
export PGLIB=/home/guest/pgsql/lib). Or append this path to environment
variable LD_LIBRARY_PATH.

Regards

Luf