[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,

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.

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 affiliated

[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] 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

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 represented

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

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). The

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

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 scheduale

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

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

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 for

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] 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 in

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

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

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 installed if

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 hundreds

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 this move?

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] 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

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 June

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 ...

[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)---

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 the text

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] 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 enabled.

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 sure that the

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 already to

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 ... Jan's point is that

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 something big, in

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 did on

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

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 patch and a new

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 functionality, or