Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Shared Objects (Dynamic loading)

From: "Jasbinder Bali" <jsbali(at)gmail(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [GENERAL] Shared Objects (Dynamic loading)
Date: 2006-08-29 04:44:21
Message-ID: a47902760608282144y30779a36i8ee14c1d360617fa@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
Well, I'm using C because later on i'll have to do socket programing for the
same project (opening a socket between postgresql database and unix server,
though am not sure at all how I'm or any1 else is goin to do it) and thats
something i'll do in C. So to keep things pretty straight and stick to one
single programing language due to other factors, I have no choice but to use
C. Thats one of the design decisions taken for our project.

Now, for version 1 code, i think i'll have to write it in pgc code. right?
And using version 1 conventions only i'll be able to pass and read right
values back and forth from DB to shared object. right?

Thanks,
~Jas


On 8/28/06, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
>
> On Mon, Aug 28, 2006 at 03:26:55PM -0400, Jasbinder Bali wrote:
> > Do I include this Version 1 syntax in the .pgc file or C file that i get
> > after doing ECPG to the .pgc file?
>
> You shouldn't modify the .c file that ecpg generates; the .pgc file
> is the source code.  However, as Martijn and I have pointed out,
> you should probably be using SPI instead of ECPG.  And as Tom and
> I have mentioned, you probably shouldn't be using C at all because
> everything you've said you're doing would be easier in other languages
> like PL/pgSQL and PL/Perl.
>
> --
> Michael Fuhr
>

In response to

Responses

pgsql-novice by date

Next:From: Shane AmblerDate: 2006-08-29 05:30:04
Subject: Re: Difference between char and varchar
Previous:From: Michael FuhrDate: 2006-08-29 02:19:15
Subject: Re: [GENERAL] Shared Objects (Dynamic loading)

pgsql-general by date

Next:From: Patrick TJ McPheeDate: 2006-08-29 05:55:39
Subject: Deathly slow performance on SMP red-hat system
Previous:From: CSNDate: 2006-08-29 02:25:25
Subject: Re: database files are incompatible with server, after computer restart

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group