Re: [HACKERS] TODO, FAQs to Wiki?

2008-06-07 Thread Alvaro Herrera
Actually, now that I try it, it seems that the MediaWiki markup is not completely helpful here -- right now, on some items we have a one-line "header" and then possibly a longer description, and it seems the only way to do that in MediaWiki is like this: * Set proper permissions on non-system sche

Re: [PATCHES] [HACKERS] TRUNCATE TABLE with IDENTITY

2008-06-07 Thread Alvaro Herrera
Tom Lane wrote: > 2. I had first dismissed Neil's idea of transactional sequence updates > as impossible, but on second look it could be done. Suppose RESTART > IDENTITY does this for each sequence; > > * obtain AccessExclusiveLock; > * assign a new relfilenode; > * insert a se

Re: [HACKERS] math error or rounding problem Money type

2008-06-07 Thread Mark Kirkwood
Justin wrote: yes. The question is why are the to sides not equal anymore Take this Select '2', round(sum( beginBalance ),6) as beginbalance, round(sum( negative ),6) as debit, round(sum( positive ),6) as credit, round(sum( difference ),6) as difference, round(sum( endb

Re: [HACKERS] math error or rounding problem Money type

2008-06-07 Thread Justin
Tom Lane wrote: Justin <[EMAIL PROTECTED]> writes: I believe i have found a math bug/rounding problem with Money type when its used with SUM()... Postgresql 8.3.1 You do know that money only stores two fractional digits? regards, tom lane yes. The quest

Re: [HACKERS] math error or rounding problem Money type

2008-06-07 Thread Tom Lane
Justin <[EMAIL PROTECTED]> writes: > I believe i have found a math bug/rounding problem with Money type when > its used with SUM()... Postgresql 8.3.1 You do know that money only stores two fractional digits? regards, tom lane -- Sent via pgsql-hackers mailing list (pg

[HACKERS] math error or rounding problem Money type

2008-06-07 Thread Justin
I believe i have found a math bug/rounding problem with Money type when its used with SUM()... Postgresql 8.3.1 --- Background on the Problem We have gl_trans table with 92,000 rows with one column containing the positive and negative entries. In order to mak

Re: [HACKERS] TODO, FAQs to Wiki?

2008-06-07 Thread Magnus Hagander
Alvaro Herrera wrote: > Magnus Hagander wrote: >> Alvaro Herrera wrote: > >>> Discussion with you and Magnus indicated that you were both committed to >>> having the TODO on the wiki, but each was waiting on the other for >>> anything to happen. Now that the PGCon dust has been settled for quite

Re: [HACKERS] TODO, FAQs to Wiki?

2008-06-07 Thread Alvaro Herrera
Magnus Hagander wrote: > Alvaro Herrera wrote: > > Discussion with you and Magnus indicated that you were both committed to > > having the TODO on the wiki, but each was waiting on the other for > > anything to happen. Now that the PGCon dust has been settled for quite > > a while, should we proc

Re: [HACKERS] pg_dump restore time and Foreign Keys

2008-06-07 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > Perhaps we need a GUC that says expert_mode = on. ... Another idea > might be to make such command options superuser only, to ensure the > power is available, yet only in the hands of, by-definition, the trusted > few. This all seems pretty useless, as th

Re: [HACKERS] TODO, FAQs to Wiki?

2008-06-07 Thread Magnus Hagander
Alvaro Herrera wrote: > Bruce Momjian wrote: > >> Magnus has started moving the Developer's FAQ to a wiki. I am thinking >> we should move the main FAQ and the TODO list to a wiki as well if the >> community is in agreement. > > Discussion with you and Magnus indicated that you were both committ

Re: [HACKERS] pg_dump restore time and Foreign Keys

2008-06-07 Thread Andrew Dunstan
Simon Riggs wrote: On Sat, 2008-06-07 at 13:08 -0400, Robert Treat wrote: On Thursday 05 June 2008 08:56:35 Simon Riggs wrote: On Thu, 2008-06-05 at 07:57 -0400, Andrew Dunstan wrote: Heh, I would have argued that the idea should go the other way and just make this part o

Re: [HACKERS] pg_dump restore time and Foreign Keys

2008-06-07 Thread Simon Riggs
On Sat, 2008-06-07 at 13:08 -0400, Robert Treat wrote: > On Thursday 05 June 2008 08:56:35 Simon Riggs wrote: > > On Thu, 2008-06-05 at 07:57 -0400, Andrew Dunstan wrote: > Heh, I would have argued that the idea should go the other way and > just make this part of the normal syntax. Oracle DBA's

Re: [HACKERS] pg_dump restore time and Foreign Keys

2008-06-07 Thread Robert Treat
On Thursday 05 June 2008 08:56:35 Simon Riggs wrote: > On Thu, 2008-06-05 at 07:57 -0400, Andrew Dunstan wrote: > > Simon Riggs wrote: > > > pg_dump restore times can be high when they include many ALTER TABLE > > > ADD FORIEGN KEY statements, since each statement checks the data to see > > > if it

Re: [HACKERS] We have a launch abort ... PG update releases will be delayed

2008-06-07 Thread Tom Lane
I wrote: > (The exact new release date isn't determined yet.) Just FYI, the agreed plan is to slip the release schedule 3 days; public announcement will be Thursday not Monday. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To mak