Обсуждение: "C" libpq-fe.h

Hi,

I', trying make a few "C" functions thats runs in server-side, with
Postgres superuser permissions.

The PL/PGSQL runs with the users permissions, and the functions that I
write in "C" using the SPI includes, also runs with the users
permissions.

I think that using the "ligpq-fe.h" I can reconect with the Postgres
user.

But all my sample doesn't works... Please, could you send-me any
exemple, the command line for the compiler, and the right directories of
the included files ?


regards,

Tulio Oliveira.

--
======================================================
AKACIA TECNOLOGIA
Desenvolvimento de sistemas para Internet
www.akacia.com.br

Is there a way I can do something like the following?

create table t1 (
t1id serial,
);

create table t2 (
t1id int[] references t1 (t1id)
);

I know this doesn't work because I get an error message when trying to
insert into t2.

I'd like to be able allow multiple references if possible.  Has anyone found
a way to make this work?

Also, how do I update an array field?

For example, t2.t1id = '{1,2,3}' and I want to add 4 to make it t2.t1id =
'{1,2,3,4}'.

Thanks.
Alan Young
Programmer/Analyst
IDIGlobal.com

On Wed, 20 Dec 2000, Alan Young wrote:

> Is there a way I can do something like the following?

Not really this way.  We've talked about possibly at some
point allowing this as an extension to the spec on foreign
keys, but there are some behavioral things that we haven't
really figured out (what if the key isn't a single value
and you want a two dimensional array with key sets in an
array, etc...)

> create table t1 (
> t1id serial,
> );
>
> create table t2 (
> t1id int[] references t1 (t1id)
> );
>
> I know this doesn't work because I get an error message when trying to
> insert into t2.
>
> I'd like to be able allow multiple references if possible.  Has anyone found
> a way to make this work?
>
> Also, how do I update an array field?
>
> For example, t2.t1id = '{1,2,3}' and I want to add 4 to make it t2.t1id =
> '{1,2,3,4}'.

Alan Young wrote:
>
> Is there a way I can do something like the following?
>
> create table t1 (
> t1id serial,
> );
>
> create table t2 (
> t1id int[] references t1 (t1id)
> );
>
> I know this doesn't work because I get an error message when trying to
> insert into t2.
>
> I'd like to be able allow multiple references if possible.  Has anyone found
> a way to make this work?
>
> Also, how do I update an array field?
>
> For example, t2.t1id = '{1,2,3}' and I want to add 4 to make it t2.t1id =
> '{1,2,3,4}'.
>
> Thanks.
> Alan Young
> Programmer/Analyst
> IDIGlobal.com

You must create T1 this form:

CREATE TABLE t1 (
    t1id SERIAL PRIMARY KEY
);


--
======================================================
AKACIA TECNOLOGIA
Desenvolvimento de sistemas para Internet
www.akacia.com.br