Re: Shared Objects (Dynamic loading)

From: "Jasbinder Bali" <jsbali(at)gmail(dot)com>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Shared Objects (Dynamic loading)
Date: 2006-08-28 06:08:28
Message-ID: a47902760608272308k389edc97w632273cf063d00b7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Thanks for that reply Martijn,

Just wondering what is this SPI all about and where can i read up on that.
Any quick pointers please?

Thanks
~Jas

On 8/28/06, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
>
> On Mon, Aug 28, 2006 at 01:29:11AM -0400, Jasbinder Bali wrote:
> > Just wondering why would i need libpq here.
> > Doesn't DBD::pg has its own functions for database related activities.
> > I think i'm quite naive in this.
>
> DBD::Pg uses libpq to do the talking to the database. Think of it as
> the driver that interfaces DBI (the perl database interface) with
> libpq.
>
> Incidently, there is a DBD::PgPP (Pg Pure Perl) which tries to do the
> same without libpq, but I've never seen it in action.
>
> > Also, the triggers that i wrote in C are not all that elaborative. They
> are
> > pretty basic triggers. Also, I'm a rookie in perl but don't need to do
> > something hifi with it.
>
> What are you good at then. If you understand SQL, write them in
> pl/pgsql. Use what you're confortable with.
>
> And you don't need DBI or anything like that for writing triggers,
> that's what SPI is for.
>
> Have a nice day,
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> > From each according to his ability. To each according to his ability to
> litigate.
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (GNU/Linux)
>
> iD8DBQFE8oe4IB7bNG8LQkwRAkLsAKCF9Gr5m5YY+1QrgAZzD73h2GgoEwCdGcYx
> K2ofNm47/xUcEK6gI5m1TJM=
> =V5t3
> -----END PGP SIGNATURE-----
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-08-28 06:14:36 Re: Shared Objects (Dynamic loading)
Previous Message Martijn van Oosterhout 2006-08-28 06:05:44 Re: Shared Objects (Dynamic loading)

Browse pgsql-novice by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-08-28 06:14:36 Re: Shared Objects (Dynamic loading)
Previous Message Martijn van Oosterhout 2006-08-28 06:05:44 Re: Shared Objects (Dynamic loading)