Re: [GENERAL] Shared Objects (Dynamic loading)

On Mon, Aug 28, 2006 at 02:08:28AM -0400, Jasbinder Bali wrote: > 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? The documentation is a good start, http://www.postgresql.org/docs/8.1/interactive/spi.html

Re: [GENERAL] Shared Objects (Dynamic loading)

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 ~JasOn 8/28/06, Martijn van Oosterhout wrote: On Mon, Aug 28, 2006 at 01:29:11AM -0400, Jasbinder Bali wrote:> Just wondering why would i ne

Re: [GENERAL] Shared Objects (Dynamic loading)

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

Re: [GENERAL] Perl language creation failed

am Mon, dem 28.08.2006, um 1:25:51 -0400 mailte Harpreet Dhaliwal folgendes: > Hi, > I'm trying the following > > CREATE LANGUAGE plperl > before executing my functions written in perl > but get the follwing error > > ERROR: could not access file "$libdir/plperl": No such file or directory >

Re: [GENERAL] Shared Objects (Dynamic loading)

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.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 somethi

[GENERAL] Perl language creation failed

Hi,I'm trying the followingCREATE LANGUAGE plperlbefore executing my functions written in perlbut get the follwing errorERROR:  could not access file "$libdir/plperl": No such file or directory Can anyone tell me how to fix this?Thanks~Harpreet

Re: [GENERAL] Shared Objects (Dynamic loading)

On Sun, Aug 27, 2006 at 09:41:39PM -0400, Jasbinder Bali wrote: > The actual scenario is like my perl code is on one computer and database > server is on the other computer. The perl code needs to connect to that > database server residing on a diff computer. > > I think client machine should also

Re: [GENERAL] Cutting the Gborg throat

In the last exciting episode, [EMAIL PROTECTED] ("Joshua D. Drake") wrote: > Greg Sabino Mullane wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >>> I have been looking at the migration of Gborg lately. It looks like the >>> only two active projects on that site are Slony, and pljava.

Re: [GENERAL] Cutting the Gborg throat

Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have been looking at the migration of Gborg lately. It looks like the only two active projects on that site are Slony, and pljava. Libpqxx has recently moved to their own Trac site. There are definitely more than that

Re: [GENERAL] [PATCHES] New variable server_version_num

On Sat, Jul 29, 2006 at 09:14:16PM -0400, Greg Sabino Mullane wrote: > Today on IRC David Fetter and some others were discussing version > numbers and we realized that although libpq now provides the version of > Postgres as a number, this is still a wheel that is being reinvented by > apps many ti

Re: [GENERAL] Shared Objects (Dynamic loading)

The actual scenario is like my perl code is on one computer and database server is on the other computer. The perl code needs to connect to that database server residing on a diff computer.   I think client machine should also have DBI module in it. right?   Also, how much of a change would it be

Re: [GENERAL] Shared Objects (Dynamic loading)

Michael Fuhr wrote: On Sun, Aug 27, 2006 at 05:13:25PM -0400, Jasbinder Bali wrote: Can you please give me pointers to how to establish clinet server model using PL/Perl. I mean how do i give the ip address of the database server in my Perl script running in another machine. DBI is a Perl modu

Re: [GENERAL] Cutting the Gborg throat

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I have been looking at the migration of Gborg lately. It looks like the > only two active projects on that site are Slony, and pljava. Libpqxx has > recently moved to their own Trac site. There are definitely more than that. > 1. We set a read on

Re: [GENERAL] Shared Objects (Dynamic loading)

On Sun, Aug 27, 2006 at 05:13:25PM -0400, Jasbinder Bali wrote: > Can you please give me pointers to how to establish clinet server model > using PL/Perl. > I mean how do i give the ip address of the database server in my Perl script > running in another machine. DBI is a Perl module for connectin

Re: [GENERAL] Shared Objects (Dynamic loading)

Hi,Can you please give me pointers to how to establish clinet server model using PL/Perl. I mean how do i give the ip address of the database server in my Perl script running in another machine.Regards,Jas On 8/26/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Sat, Aug 26, 2006 at 03:32:37PM -0400,

Re: [GENERAL] Cutting the Gborg throat

> -Original Message- > From: Joshua D. Drake [mailto:[EMAIL PROTECTED] > Sent: 27 August 2006 11:42 > To: Dave Page > Cc: [EMAIL PROTECTED]; PgSQL General > Subject: Re: [GENERAL] Cutting the Gborg throat > > > > >> Question: How is CVS handled on Gborg? Do they have their > own rep

Re: [GENERAL] speeding up big query lookup

"Silvela, Jaime \(Exchange\)" <[EMAIL PROTECTED]> writes: > I have a very big table that catalogs measurements of some objects over > time. Measurements can be of several (~10) types. It keeps the > observation date in a field, and indicates the type of measurement in > another field. > I often ne

Re: [GENERAL] Can't populate database using Copy

Try this:copy the file "FinalData.txt" to the 'bin' folder of pgsql where postgres binaries are located and then try doing the COPY usingcopy tabledaily from 'FinalData.txt ' with csv;and see if it solves the problem or not?-- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 8/27/06, Michael Fuhr <

Re: [GENERAL] Cutting the Gborg throat

Question: How is CVS handled on Gborg? Do they have their own repos? If so we can just move them to pgfoundry yes? Yes - rsync is our friend. Cool... so can you think of any other dependencies we are misisng? Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sale

Re: [GENERAL] Cutting the Gborg throat

-Original Message- From: [EMAIL PROTECTED] on behalf of Joshua D. Drake Sent: Sun 8/27/2006 5:22 AM To: [EMAIL PROTECTED]; PgSQL General Subject: [GENERAL] Cutting the Gborg throat > Question: How is CVS handled on Gborg? Do they have their own repos? If > so we can just move them to