Re: [GENERAL] Cutting the Gborg throat

2006-08-27 Thread Dave Page
-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

Re: [GENERAL] Cutting the Gborg throat

2006-08-27 Thread Joshua D. Drake
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. ===

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

2006-08-27 Thread Shoaib Mir
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] speeding up big query lookup

2006-08-27 Thread Tom Lane
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 need to

Re: [GENERAL] Cutting the Gborg throat

2006-08-27 Thread Dave Page
-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 repos? If so

Re: [GENERAL] Shared Objects (Dynamic loading)

2006-08-27 Thread Jasbinder Bali
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] Shared Objects (Dynamic loading)

2006-08-27 Thread Michael Fuhr
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 connecting

Re: [GENERAL] Cutting the Gborg throat

2006-08-27 Thread Greg Sabino Mullane
-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 only

Re: [GENERAL] Shared Objects (Dynamic loading)

2006-08-27 Thread Geoffrey
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

Re: [GENERAL] Shared Objects (Dynamic loading)

2006-08-27 Thread Jasbinder Bali
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] [PATCHES] New variable server_version_num

2006-08-27 Thread David Fetter
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 times

Re: [GENERAL] Cutting the Gborg throat

2006-08-27 Thread Joshua D. Drake
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

Re: [GENERAL] Cutting the Gborg throat

2006-08-27 Thread Christopher Browne
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. Libpqxx has

Re: [GENERAL] Shared Objects (Dynamic loading)

2006-08-27 Thread Michael Fuhr
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

[GENERAL] Perl language creation failed

2006-08-27 Thread Harpreet Dhaliwal
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)

2006-08-27 Thread Jasbinder Bali
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

Re: [GENERAL] Perl language creation failed

2006-08-27 Thread A. Kretschmer
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 Can