From: | "Pavel PaJaSoft Janousek" <janousek(at)fonet(dot)cz> |
---|---|
To: | "PgSQL Interfaces" <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | ECPG & 'exec sql connect to' question |
Date: | 1999-03-04 16:01:05 |
Message-ID: | 003601be6658$78d78ce0$2685d4c2@server.fonet2.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
Hi all,
I've one big problem. Last month I saw in this mailing-list one example, where was this line:
'exec sql connect to unix:postgresql://localhost:5432/mm; '
I thought, that this example is for ECPG, but....
I'm using PostgreSQL 6.4.2 - ECPG is from this release (without other patches, which are distributed in this mailing-list). I try compile my program, but I got always the same error: <source>:<line>: parse error at or near 'postgresql'.
So, I write small example:
All described this I make by psql monitor... I create database 'test'. Database 'test' is created by unix user 'paja' ('paja' is postgres user too). I create new postgres user 'petr' with password 'petr'. As 'paja', I connect to database 'test' and create table 'pom' with some cols, then execute this: 'grant insert on pom to petr;'. All is OK, but now, I want connect to database 'test' by user 'petr'... of course, I cant' use simple command:
'exec sql connect 'test';', because I want have only rights as user 'petr' (only inserting rows).
My problem is, that I don't know, how I can connect to database (on local system or remote...) with specifiing user and his password.
I know, that I can use libpq directly, but I want do this by ECPG, not by using the PostgreSQL C library.
Thank you for any ideas....
Pavel PaJaSoft Janousek
FoNet, spol. s r.o.
PS: A wrote this question in november 1998, but I didn't got some answer. Of course, I specify my question rather diferent...
From | Date | Subject | |
---|---|---|---|
Next Message | Jens Niehaus | 1999-03-04 16:07:55 | Problem - Error: Cannot create table |
Previous Message | Thomas G. Lockhart | 1999-03-04 14:53:32 | Re: PostgreSQL 6.4.2 on AIX 4.3.2: typeidTypeRelid error |
From | Date | Subject | |
---|---|---|---|
Next Message | Viktor A. | 1999-03-04 17:14:34 | Re: [INTERFACES] libpq++ - copy - default values |
Previous Message | Tom Lane | 1999-03-04 14:59:40 | Re: [INTERFACES] Postgre Perl on WIN NT |