Re: [HACKERS] New version of money type

2006-09-28 Thread D';Arcy J.M. Cain
s that numeric is better and parsing/storing/displaying than money. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end

Re: [HACKERS] New version of money type

2006-09-28 Thread D';Arcy J.M. Cain
currency symbol but I have received complaints about that. It should probably go back just because it is outside of the scope of the primary change. That can be dealt with later. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a

Re: [HACKERS] New version of money type

2006-10-12 Thread D';Arcy J.M. Cain
than one major change at a time. The one issue I have with my existing patch though is the removal of the currency symbol from the output. There have been many suggestions that that just gets in the way but, following up on my own statement above, this is two changes, not one, and perhaps should

Re: [HACKERS] New version of money type

2006-10-12 Thread D';Arcy J.M. Cain
e patch? Should I add the currency symbol back in and commit or should I resubmit the patch to hackers for further review? -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP)

Re: [HACKERS] New version of money type

2006-10-12 Thread D';Arcy J.M. Cain
On Thu, 12 Oct 2006 14:17:33 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" writes: > > Cool. So what do I do with the patch? Should I add the currency > > symbol back in and commit or should I resubmit the patch to hackers for > >

[HACKERS] Mailing list

2005-07-08 Thread D';Arcy J.M. Cain
can be fixed? -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 2: D

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread D';Arcy J.M. Cain
at the point of pg_autovacuum would be to run 24/7 so that there is never big hit on the system. Perhaps it could be designed to throttle itself based on current system usage though. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]|vex}.net> | Democracy is three wolves http://www.druid.net/darc

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread D';Arcy J.M. Cain
On Fri, 23 Apr 2004 13:08:30 -0400 (EDT) Bruce Momjian <[EMAIL PROTECTED]> wrote: > D'Arcy J.M. Cain wrote: > > It seems to me that the point of pg_autovacuum would be to run 24/7 > > so that there is never big hit on the system. Perhaps it could be > > desi

Re: [HACKERS] monetary bug

2004-08-22 Thread D';Arcy J.M. Cain
t in a 64 bit integer. Perhaps I should submit it as a patch to the existing money type instead. I have fixed up a few other issues while I was at it. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a

[HACKERS] Two serial numbers in one table

2003-10-27 Thread D';Arcy J.M. Cain
what I am trying to do? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]|vex}.net> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. --

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread D';Arcy J.M. Cain
On December 9, 2003 12:15 pm, Neil Conway wrote: > P.S. While we're contemplating pies-in-the-sky, I'd personally love to > rewrite PostgreSQL in Objective Caml. I vote for InterCal. :-) -- D'Arcy J.M. Cain <[EMAIL PROTECTED]|vex}.net> | Democracy is three wolves

Re: [HACKERS] PostgreSQL Anniversary Summit, Call for Contributions

2006-03-02 Thread D';Arcy J.M. Cain
ssibilities. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 4: Have

Re: [HACKERS] PostgreSQL Anniversary Summit, Call for Contributions

2006-03-09 Thread D';Arcy J.M. Cain
lp > with the many on-the-ground things that are likely needed to be done, > and will be available to do so, I eagerly solicit your help. Please > contact me off list in that case. What type of things will you be needing? I can probably spare some time. -- D'Arcy J.M. Cain |

Re: [HACKERS] PostgreSQL Anniversary Summit, Call for Contributions

2006-03-09 Thread D';Arcy J.M. Cain
On Thu, 9 Mar 2006 16:18:43 -0500 "D'Arcy J.M. Cain" wrote: > What type of things will you be needing? I can probably spare some time. Doh! Sorry about that. I did reply instead of reply all thinking it would only go to Andrew. I didn't meant to send to the list

Re: [HACKERS] Slony-I for circular replication

2006-03-30 Thread D';Arcy J.M. Cain
rules. There is no way to make it generic. At least, that was the conclusion we came to. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---

Re: [HACKERS] Slony-I for circular replication

2006-03-31 Thread D';Arcy J.M. Cain
On Fri, 31 Mar 2006 09:35:31 -0600 "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > On Thu, Mar 30, 2006 at 10:15:21AM -0500, D'Arcy J.M. Cain wrote: > > I had to do multi-master replication for a major project and we wound > > up writing our own replication syste

Re: [HACKERS] vacuum, performance, and MVCC

2006-06-22 Thread D';Arcy J.M. Cain
like a loss to me. Some things just make more sense in the framework of the business rules. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for di

Re: [HACKERS] POWER vs. POW ???

2005-11-24 Thread D';Arcy J.M. Cain
so it controls the width. It is five so add a padding space on each end and you get seven, one more than the first. Check these out. test=# SELECT POW(2,-2) AS REALLY_BIG_LABEL; really_big_label -- 0.25 (1 row) test=# SELECT POWER(2,-2) AS X; x -- 0.25 (1 row

Re: [HACKERS] psql & readline & win32

2006-01-02 Thread D';Arcy J.M. Cain
On Mon, 2 Jan 2006 16:27:48 -0600 (CST) "Andrew Dunstan" <[EMAIL PROTECTED]> wrote: > Our BSD license is recognised as a GPL-compatible license. Recognized by who? The only two entities that I can think of that matter would be GNU itself or the courts. -- D'Arcy J.M. Ca

Re: [HACKERS] Thesis on PostgreSQL

2004-09-04 Thread D';Arcy J.M. Cain
s 3GL (SQL) and plpgsql might be 4GL. Progress is a 4GL. I'm not sure that's a feature though. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212

[HACKERS] PostgreSQL 7.4 runs slower than 7.3

2004-09-21 Thread D';Arcy J.M. Cain
e)) Filter: (certrans_active = true) -> Subquery Scan "*SELECT* 2" (cost=81223.37..81223.38 rows=1 width=10) -> Aggregate (cost=81223.37..81223.37 rows=1 width=10) -> Index Sca

Re: [HACKERS] PostgreSQL 7.4 runs slower than 7.3

2004-09-21 Thread D';Arcy J.M. Cain
On Tue, 21 Sep 2004 11:00:33 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > I had previously mentioned that queries run much different depending > > on whether a VACUUM ANALYZE is done or just a plain ANALYZE

[HACKERS] PostgreSQL 7.4 runs slower than 7.3

2004-09-23 Thread D';Arcy J.M. Cain
3.37..81223.38 rows=1 width=10) -> Aggregate (cost=81223.37..81223.37 rows=1 width=10) -> Index Scan using certrans_certrans_active on certrans (cost=0.00..81219.41 rows=790 width=10) Index Cond: (certrans_a

[HACKERS] Nice vacuums

2004-10-22 Thread D';Arcy J.M. Cain
this strategy likely to improve my transaction processing? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what&#

[HACKERS] View pg_stat_activity slow to get up to date

2004-11-08 Thread D';Arcy J.M. Cain
nection drops I can grab the lock. Right now I am modifying my lock class (It's in Python) to add a 1 second sleep before trying to grab an existing session. That seems to work but I hope I can do better. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wo

Re: [HACKERS] View pg_stat_activity slow to get up to date

2004-11-08 Thread D';Arcy J.M. Cain
On Mon, 08 Nov 2004 12:56:57 -0500 Jan Wieck <[EMAIL PROTECTED]> wrote: Hi Jan. > On 11/8/2004 12:03 PM, D'Arcy J.M. Cain wrote: > > > I checked the FAQ and docs but haven't found anything definitive. > > This is my SQL test script: > > > &

Re: [HACKERS] View pg_stat_activity slow to get up to date

2004-11-08 Thread D';Arcy J.M. Cain
On Mon, 08 Nov 2004 13:07:34 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > I checked the FAQ and docs but haven't found anything definitive. > > This is my SQL test script: > > > SELECT pg_ba

[HACKERS] Trouble with plpgsql on 7.4.6

2004-11-18 Thread D';Arcy J.M. Cain
8 11:49:21 panther cert198[1332]: [60-1] LOG: 0: database system is ready Nov 18 11:49:21 panther cert198[1332]: [60-2] LOCATION: StartupXLOG, xlog.c:2946 -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a s

Re: [HACKERS] Trouble with plpgsql on 7.4.6

2004-11-18 Thread D';Arcy J.M. Cain
On Thu, 18 Nov 2004 14:25:41 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > Has anyone else had any problem installing plpgsql into a 7.4.6 > > database? When I try (on NetBSD 2.0RC5) I get the followin

Re: [Plperlng-devel] Re: [HACKERS] Concern about new PL/Perl

2004-11-19 Thread D';Arcy J.M. Cain
is Nov 11 ... > > I don't even know what Rememberance Day is ;) It's what we call Veteran's Day and yes, Marc, it is on the same day as us. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and

Re: [HACKERS] Trouble with plpgsql on 7.4.6

2004-11-23 Thread D';Arcy J.M. Cain
On Sat, 20 Nov 2004 11:17:48 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > I thought that this would have sent everything to both the log and > > the screen but I found that the syslog has much more detail.

Re: [HACKERS] Trouble with plpgsql on 7.4.6

2004-11-24 Thread D';Arcy J.M. Cain
On Tue, 23 Nov 2004 07:25:17 -0500 "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> wrote: > > #0 0x483cafeb in kill () from /usr/lib/libc.so.12 > #1 0x483cd0af in __libc_mutex_catchall_stub (m=1212478892) > at /usr/src/lib/libc/thread-stub/thread-stub.c:112 > #2

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-13 Thread D';Arcy J.M. Cain
rbitrary business rules is guaranteed to be complex and still not handle everyone's requirements. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for di

Re: [HACKERS] ARC patent

2005-01-19 Thread D';Arcy J.M. Cain
he patent will be granted. 8.0.1 fits in no matter what and it doesn't sound like we are going backwards. 2. From a marketing standpoint it is easier to sell our bosses/clients that 8.0.1 is exactly the same as they have running and tested but without a legal constraint than 8.1 which soun

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-20 Thread D';Arcy J.M. Cain
fire once per > transaction with the number of modified rows as a parameter? I don't believe that such a facility exists but before dismissing it you should test it out. I think that you will find that disk buffering (the system's as well as PostgreSQL's) will effect

Re: [HACKERS] win32 performance - fsync question

2005-02-17 Thread D';Arcy J.M. Cain
information gets journalled but in any case, journalling only helps if you have a journalled file system. Not everyone does. This is not to say that fsync is always required, just that it solves a different problem than all those other tools. -- D'Arcy J.M. Cain | Democracy i

Re: [HACKERS] Interesting NetBSD annual report

2005-02-25 Thread D';Arcy J.M. Cain
ierarchy gets in the way of doing things. I think that in any organization the people get stuff done regardless of what structure is in place. It depends more on the people than the structure. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/

[HACKERS] WaitOnLock

2000-10-04 Thread D';Arcy J.M. Cain
A client just got this error. Anyone know why I suddenly get this? The program has been working flawlessly for months before this. WaitOnLock: error on wakeup - Aborting this transaction -- D'Arcy J.M. Cain| Democracy is three wolves http://www.druid.net/darcy/|

[HACKERS] Re: [ANNOUNCE] Announce: Release of PyGreSQL version 3.0

2000-10-05 Thread D';Arcy J.M. Cain
Thus spake Bruce Momjian > I have installed this in the current source tree, ready for 7.1. > > I have installed > > > Announce: Release of PyGreSQL version 3.0 When is 7.1 being locked down? I may be releasing 3.1 with a few small fixes and changes very soon. --

<    1   2   3