Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Marc G. Fournier
On Mon, 17 May 2004, Bruno Wolff III wrote: > On Mon, May 17, 2004 at 01:53:19 -0300, > "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > > > Not true ... you just have to fix your definition of what a feature is ... > > a feature is an improvement to the system, whether it be new > > functional

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Marc G. Fournier
On Mon, 17 May 2004, Bruce Momjian wrote: > Marc G. Fournier wrote: > > > Agreed, but you are a "me too", not a huge percentage of our userbase. > > > > How do you know? Have you polled our complete userbase? > > > > > Basically, after 6-7 months of development, I want more than a vacuum > > > pa

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Marc G. Fournier
On Mon, 17 May 2004, Bruce Momjian wrote: > See my recent email. You are stating that all features are of equal > significance. Basically, the important missing features are also the > ones the require the most work to complete. Agreed ... and the ones that require the most work to complete *wi

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Bruno Wolff III
On Mon, May 17, 2004 at 01:53:19 -0300, "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > Not true ... you just have to fix your definition of what a feature is ... > a feature is an improvement to the system, whether it be new > functionality, or improved performance ... I consider the work Tom

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Bruce Momjian
Marc G. Fournier wrote: > > Agreed, but you are a "me too", not a huge percentage of our userbase. > > How do you know? Have you polled our complete userbase? > > > Basically, after 6-7 months of development, I want more than a vacuum > > patch and a new cache replacement policy. I want somethi

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Bruce Momjian
Marc G. Fournier wrote: > On Mon, 17 May 2004, Bruce Momjian wrote: > > > Marc G. Fournier wrote: > > > On Sun, 16 May 2004, Bruce Momjian wrote: > > > > > > > I personally don't think Win32 is enough of a new feature either, but > > > > others disagree. > > > > > > Jan, correct me if I'm wrong ..

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Marc G. Fournier
On Mon, 17 May 2004, Bruce Momjian wrote: > Marc G. Fournier wrote: > > On Sun, 16 May 2004, Bruce Momjian wrote: > > > > > I personally don't think Win32 is enough of a new feature either, but > > > others disagree. > > > > Jan, correct me if I'm wrong ... Jan's point is that we have enough > > a

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Marc G. Fournier
On Sun, 16 May 2004, Bruce Momjian wrote: > Hannu Krosing wrote: > > > Sure, you can work around the lack of a Win32 port with Cygwin, and > > > maybe use replication in place of PITR, but the big question is are you > > > hitting a large precentage of users with an enhancement. > > > > I'm not su

Re: [HACKERS] enabling tcpip_socket by default

2004-05-16 Thread Tatsuo Ishii
> Tatsuo Ishii wrote: > > Is there any security risk if we enable tcpip_socket by default? We > > restrict connection from localhost only by default so I think enabling > > tcpip_socket adds no security risk. Please correct me if I am wrong. > > Right, and 7.5 will ship with tcp and localhost enab

Re: [HACKERS] enabling tcpip_socket by default

2004-05-16 Thread Bruce Momjian
Tatsuo Ishii wrote: > Is there any security risk if we enable tcpip_socket by default? We > restrict connection from localhost only by default so I think enabling > tcpip_socket adds no security risk. Please correct me if I am wrong. Right, and 7.5 will ship with tcp and localhost enabled. --

Re: [HACKERS] Email data type

2004-05-16 Thread Bruno Wolff III
On Sun, May 16, 2004 at 04:36:55 +0200, Gaetano Mendola <[EMAIL PROTECTED]> wrote: > > The type is indexable and provide also conversion methods: > > text <--> email > and the operator >>, is possible use it in select like: When you are converting between text and email data, what format are t

[HACKERS] enabling tcpip_socket by default

2004-05-16 Thread Tatsuo Ishii
Is there any security risk if we enable tcpip_socket by default? We restrict connection from localhost only by default so I think enabling tcpip_socket adds no security risk. Please correct me if I am wrong. -- Tatsuo Ishii ---(end of broadcast)--- T

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Bruce Momjian
Marc G. Fournier wrote: > On Sun, 16 May 2004, Bruce Momjian wrote: > > > I personally don't think Win32 is enough of a new feature either, but > > others disagree. > > Jan, correct me if I'm wrong ... Jan's point is that we have enough > already to warrant a beta on June 1st, even without Win32

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Rod Taylor
On Sun, 2004-05-16 at 23:02, Marc G. Fournier wrote: > On Sun, 16 May 2004, Bruce Momjian wrote: > > > I personally don't think Win32 is enough of a new feature either, but > > others disagree. > > Jan, correct me if I'm wrong ... Jan's point is that we have enough > already to warrant a beta on

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Christopher Kings-Lynne
Jan, correct me if I'm wrong ... Jan's point is that we have enough already to warrant a beta on June 1st, even without Win32 ... Win32 (or any of the other stuff, like PITR/tablespaces) would be icing on the cake ... I think we're close enough on win32 to wait for it. It would look bad for us to

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Marc G. Fournier
On Sun, 16 May 2004, Bruce Momjian wrote: > I personally don't think Win32 is enough of a new feature either, but > others disagree. Jan, correct me if I'm wrong ... Jan's point is that we have enough already to warrant a beta on June 1st, even without Win32 ... Win32 (or any of the other stuff,

Re: [HACKERS] add server include files to default installation?

2004-05-16 Thread Bruce Momjian
Marc G. Fournier wrote: > > > As an illustration, the apache software installs by default all > > > necessary includes and even a special tailored command (apxs) so as > > > to help extension modules to be compiled, installed and even configured > > > easilly. > > > > > > Is there any opposition to

Re: [HACKERS] Rough draft for Unicode-aware

2004-05-16 Thread Tatsuo Ishii
> initdb could even emit a warning if the --encoding option was > used without also specifying --no-locale. Please don't do that. Most Asian chasets does not work with locale enabled PostgreSQL installation. i.e. it returns WRONG SELECT results. I've been telling this to Japanese users for hundred

Re: [HACKERS] add server include files to default installation?

2004-05-16 Thread Marc G. Fournier
On Sat, 15 May 2004, Bruce Momjian wrote: > Fabien COELHO wrote: > > > > Dear hackers, > > > > I wish to submit a small patch so that server includes and > > all necessary configuration files could be installed *by default*. > > > > The current status is that server includes files are only install

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Bruce Momjian
Hannu Krosing wrote: > > Sure, you can work around the lack of a Win32 port with Cygwin, and > > maybe use replication in place of PITR, but the big question is are you > > hitting a large precentage of users with an enhancement. > > I'm not sure that the initial version of PITR will be a good rep

Re: [HACKERS] Rough draft for Unicode-aware UPPER()/LOWER()/INITCAP()

2004-05-16 Thread Marko Karppinen
Marko Karppinen wrote: I think this interaction between the locale and server_encoding is confusing. Is there any use case for running an incompatible mix? If not, would it not make sense to fetch initdb's default database encoding with nl_langinfo(CODESET) instead of using SQL_ASCII? Peter Eisentr

Re: [HACKERS] Email data type

2004-05-16 Thread Gaetano Mendola
Gaetano Mendola wrote: Hi all, this is the alpha version for the new email data type, is not written as built in type but as plug in, Tome Lane and others drove me in this direction. The type is indexable and provide also conversion methods: text <--> email and the operator >>, is possible use it i

Re: [HACKERS] Rough draft for Unicode-aware UPPER()/LOWER()/INITCAP()

2004-05-16 Thread Peter Eisentraut
Marko Karppinen wrote: > I think this interaction between the locale and server_encoding is > confusing. Is there any use case for running an incompatible mix? > If not, would it not make sense to fetch initdb's default database > encoding with nl_langinfo(CODESET) instead of using SQL_ASCII? This

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Hannu Krosing
Bruce Momjian kirjutas P, 16.05.2004 kell 22:45: > Jan Wieck wrote: > > We have ARC, the background writer and vacuum delay, and people even ask > > me for backports of that (I have one for vacuum delay, but refuse to > > make one for the others). How long do you want to delay that being ready >

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Bruce Momjian
Jan Wieck wrote: > We have ARC, the background writer and vacuum delay, and people even ask > me for backports of that (I have one for vacuum delay, but refuse to > make one for the others). How long do you want to delay that being ready > for production? Do you really think people that are suff

Re: [HACKERS] Rough draft for Unicode-aware UPPER()/LOWER()/INITCAP()

2004-05-16 Thread Marko Karppinen
Tom Lane wrote: This code will only work if the database is running under an LC_CTYPE setting that implies the same encoding specified by server_encoding. However, I don't see that as a fatal objection, because in point of fact the existing upper/lower code assumes the same thing. I think this int

Re: [HACKERS] Call for 7.5 feature completion

2004-05-16 Thread Jan Wieck
Bruce Momjian wrote: Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > On Thu, 29 Apr 2004, Tom Lane wrote: >> In the first place it's unfair to other developers to make schedule >> slips at the last moment, and especially to *plan* to do so. > Isn't it equally unfair to slip the sch

Re: [HACKERS] CatCache state reversing

2004-05-16 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > What I'm currently thinking is that for each entry in the cache, we'll > save the current refcount at subtransaction start, and then restore it > at subtransaction abort. At subtransaction commit, the parent's > refcount will be updated with the subtran

Re: [HACKERS] add server include files to default installation?

2004-05-16 Thread Bruce Momjian
Fabien COELHO wrote: > > Dear hackers, > > I wish to submit a small patch so that server includes and > all necessary configuration files could be installed *by default*. > > The current status is that server includes files are only installed > if explicitly required (make install-all-headers).

Re: [HACKERS] add server include files to default installation?

2004-05-16 Thread Thomas Hallgren
Fabien COELHO wrote: Dear hackers, I wish to submit a small patch so that server includes and all necessary configuration files could be installed *by default*. The current status is that server includes files are only installed if explicitly required (make install-all-headers). The idea is that ex

Re: [HACKERS] Bogus permissions display in 7.4

2004-05-16 Thread Tom Lane
Fabien COELHO <[EMAIL PROTECTED]> writes: >> 4. I think that the system ACL entry should be "hidden" and not >> displayed by ACL-list printing. I'm not quite sure yet how to make >> that happen. It would be nicer if the owner ID could be passed to >> recursive_revoke out-of-band, instead of being

Re: [HACKERS] add server include files to default installation?

2004-05-16 Thread Tom Lane
Fabien COELHO <[EMAIL PROTECTED]> writes: > I wish to submit a small patch so that server includes and > all necessary configuration files could be installed *by default*. There is a reason why install-all-headers is not the default. It is that it shouldn't be the default: most people do not need

[HACKERS] Email data type

2004-05-16 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, this is the alpha version for the new email data type, is not written as built in type but as plug in, Tome Lane and others drove me in this direction. The type is indexable and provide also conversion methods: text <--> email and the operator >

Re: [HACKERS] relcache refcount

2004-05-16 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Regarding the lock mechanism, I simply added some code to LockReleaseAll > so it gets the array of committed child Xids; on subtransaction abort, > the whole lock struct is scanned just like it's done on main transaction > abort; only those locks affilia

Re: [HACKERS] Bogus permissions display in 7.4

2004-05-16 Thread Tom Lane
I wrote: > I think the correct solution involves having recursive_revoke look to > see if D still has the rights from somewhere else before it goes off to > recursively revoke D's grants. This makes it correctly implement the > notion that one always has the union of the rights granted by anyone.

[HACKERS] email data type first release

2004-05-16 Thread Gaetano Mendola
I already post this message using [EMAIL PROTECTED] with attached a binary file but I guess the newsgroup not accept binary file. The following was almost the message, now the file is on pg_foundry ( now it's working ). = Hi all, t