plpq

Started by Darko Prenosilover 23 years ago4 messageshackers

Jump to latest

Darko Prenosil

darko.prenosil@finteh.hr

over 23 years ago

Tree weeks later than I promised, but it is finished (I hope).

In attachment are files:
dblink.c
dblink.h
dblink.sql.in
pqtest.sql

In file pqtest.sql is sample queries and results. It seem OK to me.

There are two reasons why I did not make a diff.

1. The source I started from is 7.3b1, not the latest.
2. I would like You to check the code, especially the part that touches memory
management.
I can say that it works, but I do not know exactly why, and this can be
dangerous. With my knowledge of postgres internals this is
as far I can go at the moment. And once more sorry for bad English !

Regards !

Bruce Momjian

bruce@momjian.us

over 23 years ago

In reply to: Darko Prenosil (#1)

Re: plpq

Would you tell us exactly what this is.

---------------------------------------------------------------------------

Darko Prenosil wrote:

Tree weeks later than I promised, but it is finished (I hope).

In attachment are files:
dblink.c
dblink.h
dblink.sql.in
pqtest.sql

In file pqtest.sql is sample queries and results. It seem OK to me.

There are two reasons why I did not make a diff.

1. The source I started from is 7.3b1, not the latest.
2. I would like You to check the code, especially the part that touches memory
management.
I can say that it works, but I do not know exactly why, and this can be
dangerous. With my knowledge of postgres internals this is
as far I can go at the moment. And once more sorry for bad English !

Regards !

[ Attachment, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Darko Prenosil

darko.prenosil@finteh.hr

over 23 years ago

In reply to: Bruce Momjian (#2)

Re: plpq

It is wrapper about libpq client library functions for use in PL/PSQL.
I agreed with Joe Conway that it may fit within dblink, because dblink is much
more easy to work with than the libpq, but sometimes it is Just not enough.
So, the idea is to re-implement all important libpq functions like
PQConnectdb,
PQExec ... and make one postgres server become just a client for another (or
another's) postgres server. As You know, dblink still does not support
simultaneous connections to two different databases, but with this it can !
I agreed with Joe that when he is back from holiday he will take a look.

Regards !

Show quoted text

On Monday 28 October 2002 20:35, Bruce Momjian wrote:

Would you tell us exactly what this is.

---------------------------------------------------------------------------

Darko Prenosil wrote:

Tree weeks later than I promised, but it is finished (I hope).

In attachment are files:
dblink.c
dblink.h
dblink.sql.in
pqtest.sql

In file pqtest.sql is sample queries and results. It seem OK to me.

There are two reasons why I did not make a diff.

1. The source I started from is 7.3b1, not the latest.
2. I would like You to check the code, especially the part that touches
memory management.
I can say that it works, but I do not know exactly why, and this can be
dangerous. With my knowledge of postgres internals this is
as far I can go at the moment. And once more sorry for bad English !

Regards !

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Bruce Momjian

bruce@momjian.us

over 23 years ago

In reply to: Darko Prenosil (#3)

Re: plpq

Darko Prenosil wrote:

It is wrapper about libpq client library functions for use in PL/PSQL.
I agreed with Joe Conway that it may fit within dblink, because dblink is much
more easy to work with than the libpq, but sometimes it is Just not enough.
So, the idea is to re-implement all important libpq functions like
PQConnectdb,
PQExec ... and make one postgres server become just a client for another (or
another's) postgres server. As You know, dblink still does not support
simultaneous connections to two different databases, but with this it can !
I agreed with Joe that when he is back from holiday he will take a look.

Brilliant idea. I assume you added those functions and rewrote dblink
to use them. dblink already is great, but by adding libpq inside
plpgsql, all sorts of other things become possible.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

plpq

Attachments: