pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedtutorial section
3+ messages / 2 participants
[nested] [flat]
* tutorial section
@ 2001-02-21 19:35 Lonnie Cumberland <lonnie_cumberland@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Lonnie Cumberland @ 2001-02-21 19:35 UTC (permalink / raw)
To: 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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: tutorial section
@ 2001-02-21 19:51 Tom Lane <tgl@sss.pgh.pa.us>
parent: Lonnie Cumberland <lonnie_cumberland@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2001-02-21 19:51 UTC (permalink / raw)
To: Lonnie Cumberland <lonnie_cumberland@yahoo.com>; +Cc: pgsql-interfaces
Lonnie Cumberland <lonnie_cumberland@yahoo.com> writes:
> psql:complex.sql:32: ERROR: stat failed on file '/home/lonnie/postgresql-7.0.3
> /src/tutorial/complex.so': Permission denied
I would guess that some directory in that path is not readable by the
postgres backend. Don't forget it's (probably) not running under the
same userid as you.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: tutorial section
@ 2001-02-21 20:19 Lonnie Cumberland <lonnie_cumberland@yahoo.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Lonnie Cumberland @ 2001-02-21 20:19 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-interfaces
Thanks Tom,
I moved everything out into another directory that has general access and
things seem to be running just fine.
Cheers,
Lonnie
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Lonnie Cumberland <lonnie_cumberland@yahoo.com> writes:
> > psql:complex.sql:32: ERROR: stat failed on file
> '/home/lonnie/postgresql-7.0.3
> > /src/tutorial/complex.so': Permission denied
>
> I would guess that some directory in that path is not readable by the
> postgres backend. Don't forget it's (probably) not running under the
> same userid as you.
>
> regards, tom lane
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-02-21 20:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-21 19:35 tutorial section Lonnie Cumberland <lonnie_cumberland@yahoo.com>
2001-02-21 19:51 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-02-21 20:19 ` Lonnie Cumberland <lonnie_cumberland@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox