Re: [GENERAL] Duplication to External Server

2003-12-18 Thread Keith C. Perry
Quoting David Hofmann <[EMAIL PROTECTED]>: > I'm setting up 2 database servers. The first is on our local network which > is our staging server. The second is an external server setup at my hosting > company. On a nightly bases I want to copy all the data from the local > Postgre database to th

[GENERAL] PostgreSQL speakers needed for OSCON 2004

2003-12-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The call for participation has been issued for the 2004 O'Reilly Open Source convention, and once again, PostgreSQL has a track: http://conferences.oreillynet.com/cs/os2004/create/e_sess Proposals are due on February 9, 2004, and it would be ni

Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-18 Thread Thomas Kellerer
Paul Ganainm schrieb: ANSI SQL compliant X FB does not support inline views/derived tables, e.g.: SELECT count(*) FROM (SELECT col1, col2 FROM table) Thomas ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appr

Re: [GENERAL] functions returning sets

2003-12-18 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > OK -- this one is a good bit simpler. Any more comments? Looks good to me. Please apply to 7.4 and HEAD. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list

Re: [GENERAL] functions returning sets

2003-12-18 Thread Joe Conway
Tom Lane wrote: You may not even need to add any fields to FuncCallContext --- consider passing the fcinfo pointer to the callback, rather than passing the FuncCallContext pointer. Dept. of second thoughts: better pass the flinfo pointer, instead. fcinfo might point to temporary space on the stack.

Re: [GENERAL] md5 function

2003-12-18 Thread Reece Hart
On Wed, 2003-12-17 at 06:30, Jon Earle wrote: Is there a way to, when I add a record to a table, have the md5 hash computed and stored in the same table and then returned to the calling program? I recommend that you write a trigger to compute the md5 and shove that into a column. There are

Re: [GENERAL] automatic verifications

2003-12-18 Thread Bruno Wolff III
On Thu, Dec 18, 2003 at 17:05:30 -0500, Melanie Bergeron <[EMAIL PROTECTED]> wrote: > Hi! > > I am new with PostgreSQL and I want to know if this database give the > possibility to verify automatically, each night, if some records are > too old (by example, if session_date is older than a mon

Re: [GENERAL] automatic verifications

2003-12-18 Thread Doug McNaught
Melanie Bergeron <[EMAIL PROTECTED]> writes: > Hi! > > I am new with PostgreSQL and I want to know if this database give the > possibility to verify automatically, each night, if some records are > too old (by example, if session_date is older than a month) and if so > delete them. That's not re

Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-18 Thread Rick Gigger
I've never actually used them but I'm guessing that this is what your looking for. Can anyone verify this? http://us2.php.net/ibase rg - Original Message - From: "Robert Treat" <[EMAIL PROTECTED]> To: "Paul Ganainm" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 1

Re: [GENERAL] functions returning sets

2003-12-18 Thread Tom Lane
> You may not even need to add any fields to FuncCallContext --- consider > passing the fcinfo pointer to the callback, rather than passing the > FuncCallContext pointer. Dept. of second thoughts: better pass the flinfo pointer, instead. fcinfo might point to temporary space on the stack.

Re: [GENERAL] functions returning sets

2003-12-18 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > Any comment on the patch? It seems like a bad idea to change the contents of the SRF_XXX() macros for 7.4.1; if we do that, any existing already-compiled-for-7.4 user SRFs will be broken, and there's no easy way to catch the problem. We don't normally requi

Re: [GENERAL] param max_connections

2003-12-18 Thread Richard Huxton
On Thursday 18 December 2003 08:34, [EMAIL PROTECTED] wrote: > Hallo, > I am using PostgreSQL 7.4 on UltraSparc machine and I have a touble with > max_connections param. > I must set only max_connections to 8, when I set more, I got error for > shared memory. > Is this param familiar or I have a p

Partial Indexes, was Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-18 Thread Richard Huxton
On Thursday 18 December 2003 03:53, Paul Ganainm wrote: > [EMAIL PROTECTED] says... > > > Now an index can be used on customer when searching for only unbilled > > things whereas normally it would also have to search for all historical > > things as well. > > > > So, you get the benefit of a small

[GENERAL] param max_connections

2003-12-18 Thread konf
Hallo, I am using PostgreSQL 7.4 on UltraSparc machine and I have a touble with max_connections param. I must set only max_connections to 8, when I set more, I got error for shared memory. Most connection is from J2EE application server and here is no problem, I am using connection pooling and I h

Re: [GENERAL] Excel, OpenOffice and Postgres

2003-12-18 Thread Janning Vygen
Am Donnerstag, 18. Dezember 2003 00:15 schrieb Matthew: > Try this link to OpenOffice and its postgres-sdbc-driver. > > http://dba.openoffice.org/drivers/postgresql/ > > I have Installed OO on RedHat and tested that I can connect > postgres - which it does without any dramas, but I havent done much

Re: [GENERAL] Replication

2003-12-18 Thread John Sidney-Woollett
Andrew Thanks for the info. Can you detail more fully the changes you made to eRServer - v1.2, and will your patched version work with 7.4? John Andrew Rawnsley said: > > On Dec 17, 2003, at 3:15 AM, John Sidney-Woollett wrote: > >> Apologies if this is a double post - I'm sure I sent a similar