tutorial section - Mailing list pgsql-interfaces

From Lonnie Cumberland
Subject tutorial section
Date
Msg-id 20010221193501.44435.qmail@web12505.mail.yahoo.com
Whole thread Raw
In response to Re: Patches for libpq++  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: tutorial section  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
Hello all,

Well, I am slowly getting a feel for PostgreSQL and have even been able to get
some things to compile in the libpq++ examples section.

I was recently working in the "tutorial" section trying to run the demo
"complex" and "funcs" which by the way compiled fine after I made some path
corrections.

After I started up "psql -s" like the README says, I did "\i complex.sql" and
it started the complex script. The problem came when I got the loading the
"complex.so" file which is now resulting in "Permission denied" for some
reason, even though I have the correct file permissions set.

-----------------------------------------------------------------------
Type:  \copyright for distribution terms      \h for help with SQL commands      \? for help on internal slash commands
    \g or terminate with semicolon to execute query      \q to quit
 

lonnie=# \i complex.sql
***(Single step mode: Verify query)********************************************
*
CREATE FUNCTION complex_in(opaque)  RETURNS complex  AS '/home/lonnie/postgresql-7.0.3/src/tutorial/complex.so'
LANGUAGE'c';
 
***(press return to proceed or enter x and return to cancel)*******************
*

psql:complex.sql:32: ERROR:  stat failed on file '/home/lonnie/postgresql-7.0.3
/src/tutorial/complex.so': Permission denied
***(Single step mode: Verify query)********************************************
-------------------------------------------------------------------------------

does someone have an ideas as to what is going on here?

Cheers,
Lonnie


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/


pgsql-interfaces by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Patches for libpq++
Next
From: Tom Lane
Date:
Subject: Re: tutorial section