Re: [HACKERS] Release notes

2006-09-09 Thread Joshua D. Drake
Bruce Momjian wrote: I know I promised the release notes for today/Saturday, but a few other things have taken my time. I will have a draft posted by Monday/Tuesday. Sorry. Thanks for the update. J -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4

Re: [HACKERS] ISBN/ISSN/ISMN/EAN13 module

2006-09-09 Thread Jeremy Kronuz
I also added other functionality to the module but I forgot to update the README... contrary to what it says in the README.isn, you do can cast from ean13 to other types, as long as the cast is valid (i.e. you can't cast a EAN13 of a UPC or a ISMN code to a ISBN number, for instance.) So, the

Re: [HACKERS] ISBN/ISSN/ISMN/EAN13 module

2006-09-09 Thread Tom Lane
"Jeremy Kronuz" <[EMAIL PROTECTED]> writes: > Tom, I've checked the version in the cvs and I had made significant changes > from that version. Hm, it sounds like I guessed wrong about which version was newer ... is there something flaky about your machine's system clock? The file timestamps in t

[HACKERS] Foreign keys

2006-09-09 Thread MAR - Secretariado Geral
Hi everybody,   First of all i'de like to apolagize cause my poor english. After this, i shuould say that i beleavee a year ago i brought this problem to the community but i donn't remember some answering about it. The problem is:   Every time a users misses a external refrenced key the PGSq

Re: [HACKERS] @ versus ~, redux

2006-09-09 Thread Michael Glaesemann
On Sep 10, 2006, at 5:21 , Tom Lane wrote: In the category of "egad", I found out that the tinterval datatype uses << for "contains"! This is simply bizarre --- whether you approve of the inet-like notation or not, surely the arrows are pointing the wrong way. Given that tinterval is depr

Re: [HACKERS] TODO item: GUID

2006-09-09 Thread Tom Lane
> On Sat, Sep 09, 2006 at 07:47:19PM +0200, Aleksandar Dezelin wrote: >> Using time based GUIDs in database tables is not a good choice for >> performance reasons because they can not be indexed properly - every newly >> created time-based GUID is guaranteed to be larger than all previously >> crea

[HACKERS] ISBN/ISSN/ISMN/EAN13 module

2006-09-09 Thread Jeremy Kronuz
>> I'm reviewing this for addition to contrib/ now. I notice that there is >> no clear license statement. Is it OK to put the following into the >> README file? > Tom, yes. Also, I just put copyright in the files that contain a significant > amount of code written by me. (i.e. isn.h and isn.

Re: [Pgsqlrpms-hackers] [HACKERS] Safer auto-initdb for RPM init

2006-09-09 Thread Lamar Owen
On Saturday 26 August 2006 22:08, Matthew T. O'Connor wrote: > Joshua D. Drake wrote: > > Matthew T. O'Connor wrote: > >> script. If we installed the datadir during the RPM install, it would > >> still be newbie friendly and would removed initdb from start script > >> solving that problem. > > in

Re: [HACKERS] TODO item: GUID

2006-09-09 Thread mark
On Sat, Sep 09, 2006 at 07:47:19PM +0200, Aleksandar Dezelin wrote: > Hello, > you just have to make random 128 bits and set version bits. And that's all. > This is the way this data type is implemented in Mono > (http://svn.myrealbox.com/source/trunk/mcs/class/corlib/System/Guid.cs). > > Using t

[HACKERS] Move completed ...

2006-09-09 Thread Marc G. Fournier
All the servers have been moved, and everything *appears* to have come up fine from what I can tell ... If anyone notices any problems, please let me know ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [EMAIL PROTECTED]

[HACKERS] Release notes

2006-09-09 Thread Bruce Momjian
I know I promised the release notes for today/Saturday, but a few other things have taken my time. I will have a draft posted by Monday/Tuesday. Sorry. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your back

Re: [HACKERS] large object regression tests

2006-09-09 Thread Lamar Owen
On Tuesday 05 September 2006 02:59, Jeremy Drake wrote: > I am considering, and I think that in order to get a real test of the > large objects, I would need to load data into a large object which would > be sufficient to be loaded into more than one block (large object blocks > were 1 or 2K IIRC)

Re: [HACKERS] Fixed length data types issue

2006-09-09 Thread Gregory Stark
Gregory Stark <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: > > > The performance costs of that seem pretty daunting, however, especially when > > you reflect that simply stepping over a varlena field would require > > memcpy'ing its length word to someplace. > > I think if

Re: [HACKERS] log_duration is redundant, no?

2006-09-09 Thread Martijn van Oosterhout
On Sat, Sep 09, 2006 at 06:33:10PM +0200, Peter Eisentraut wrote: > Alvaro Herrera wrote: > > Bruce Momjian wrote: > > > #2, I think, but I am confused if you don't know the query, how > > > valuable is the log_duration. > > > > Statistics? > > I doubt that there is a statistical merit to calculat

Re: [HACKERS] @ versus ~, redux

2006-09-09 Thread Tom Lane
[ just when you thought it was safe to go back in the water ... ] "Zeugswetter Andreas DCP SD" <[EMAIL PROTECTED]> writes: >> But maybe we should just stick with @> and <@ as per the ltree precedent, >> and not worry about leaving room for strict inclusion tests. > +1 OK, nobody objected to that

Re: [HACKERS] TODO item: GUID

2006-09-09 Thread Aleksandar Dezelin
Hello, you just have to make random 128 bits and set version bits. And that's all. This is the way this data type is implemented in Mono ( http://svn.myrealbox.com/source/trunk/mcs/class/corlib/System/Guid.cs). Using time based GUIDs in database tables is not a good choice for performance reasons

Re: [HACKERS] log_duration is redundant, no?

2006-09-09 Thread David Fetter
On Sat, Sep 09, 2006 at 06:33:10PM +0200, Peter Eisentraut wrote: > Alvaro Herrera wrote: > > Bruce Momjian wrote: > > > #2, I think, but I am confused if you don't know the query, how > > > valuable is the log_duration. > > > > Statistics? > > I doubt that there is a statistical merit to calculat

Re: [HACKERS] Proposal for GUID datatype

2006-09-09 Thread Stephan Szabo
On Sat, 9 Sep 2006, Jan de Visser wrote: > On Saturday 09 September 2006 01:33, [EMAIL PROTECTED] wrote: > > I don't think so. If it isn't 128 bits - and you want to fit it into > > 128 bits, it means padding. Where should the padding go? As application > > specific, it is up to the application to

Re: [HACKERS] log_duration is redundant, no?

2006-09-09 Thread Peter Eisentraut
Alvaro Herrera wrote: > Bruce Momjian wrote: > > #2, I think, but I am confused if you don't know the query, how > > valuable is the log_duration. > > Statistics? I doubt that there is a statistical merit to calculating aggregate values over the duration of an anonymous set of queries. -- Peter

[HACKERS] Schedualed Server Downtime

2006-09-09 Thread Marc G. Fournier
Should have sent this out last night, apologies ... in order to move our servers to a new rack (so that we can add more servers), the servers are going down this afternoon for a couple of hours. Will post as soon as they are back up again ... Marc G. Fournier Hub.Org Network

Re: [HACKERS] Fixed length data types issue

2006-09-09 Thread Gregory Stark
Tom Lane <[EMAIL PROTECTED]> writes: > The performance costs of that seem pretty daunting, however, especially when > you reflect that simply stepping over a varlena field would require > memcpy'ing its length word to someplace. I think if you give up on disk and in-memory representations being t

Re: [HACKERS] Proposal for GUID datatype

2006-09-09 Thread mark
On Sat, Sep 09, 2006 at 08:29:16AM -0400, [EMAIL PROTECTED] wrote: > On Sat, Sep 09, 2006 at 07:06:23AM -0400, Jan de Visser wrote: > > On Saturday 09 September 2006 01:33, [EMAIL PROTECTED] wrote: > > > I don't think so. If it isn't 128 bits - and you want to fit it into > > > 128 bits, it means p

Re: [HACKERS] Proposal for GUID datatype

2006-09-09 Thread mark
On Sat, Sep 09, 2006 at 07:06:23AM -0400, Jan de Visser wrote: > On Saturday 09 September 2006 01:33, [EMAIL PROTECTED] wrote: > > I don't think so. If it isn't 128 bits - and you want to fit it into > > 128 bits, it means padding. Where should the padding go? As application > > specific, it is up

Re: [HACKERS] Proposal for GUID datatype

2006-09-09 Thread Jan de Visser
On Saturday 09 September 2006 01:33, [EMAIL PROTECTED] wrote: > I don't think so. If it isn't 128 bits - and you want to fit it into > 128 bits, it means padding. Where should the padding go? As application > specific, it is up to the application to convert. I am not saying that. I am just saying