[HACKERS] SQL/PSM prototype is available

2006-12-17 Thread Pavel Stehule
Hello, Now, you can test prototype or work on it. All details are on http://postgresql.interweb.cz/index.php/SQL/PSM . This version needs patched core files http://postgresql.interweb.cz/index.php/SQL/PSM#Patches_for_core You can find supported functionality on

[HACKERS] todo list management

2006-12-17 Thread Lukas Kahwe Smith
Hi, PostgreSQL 8.2 is out of the door. Unfortunately the plans for a more detailed todo list have not come into reality yet to assist in for the next 8.3 release. A couple people have replied to my earlier request to form a little team willing to work on this, but unfortunately people seem

Re: [HACKERS] SQL/PSM prototype is available

2006-12-17 Thread Jonah H. Harris
On 12/17/06, Pavel Stehule [EMAIL PROTECTED] wrote: Now, you can test prototype or work on it. Cool. Good work Pavel. I'll play with it and some of my PSM code. I'll try and contact you via IM as to things I'd like to help with. -- Jonah H. Harris, Software Architect | phone: 732.331.1324

Re: [HACKERS] development environment of postgres

2006-12-17 Thread Chris Browne
[EMAIL PROTECTED] (dakotali kasap) writes: I want to ask, which development environment should I use to add new features to postgresql. Is Eclipse CDT (C/C++ Development Tool) suitable for this, or are you using another environment, or just using pico, vi, etc.? I can't speak for you. I find

Re: [HACKERS] development environment of postgres

2006-12-17 Thread Andrew Dunstan
Chris Browne wrote: [EMAIL PROTECTED] (dakotali kasap) writes: I want to ask, which development environment should I use to add new features to postgresql. Is Eclipse CDT (C/C++ Development Tool) suitable for this, or are you using another environment, or just using pico, vi, etc.? I can't

Re: [HACKERS] development environment of postgres

2006-12-17 Thread dakotali kasap
I am also usually working with a simple editor and command line, but because the postgresql project is too big for a person who is looking at the source code for the first time, I thought it will be simpler using a tool like CDT, because jumping directly to a function definition that he wants

Re: [HACKERS] development environment of postgres

2006-12-17 Thread Tom Lane
dakotali kasap [EMAIL PROTECTED] writes: --0-1517433147-1166375569=:82897 Content-Type: text/plain; charset=ascii Content-Transfer-Encoding: quoted-printable I am also usually working with a simple editor and command line, but becaus= e the postgresql project is too big for a person who is

Re: [PATCHES] [HACKERS] psql commandline conninfo

2006-12-17 Thread Bruce Momjian
Andrew Dunstan wrote: Bruce Momjian wrote: I assume this patch will still allow a database name with an equals sign, right? psql dbname='a=b' Yes. In fact, reading the code it looks like the quotes are not necessary in this case. OK, good to know. Does the patch need

Re: [PATCHES] [HACKERS] psql commandline conninfo

2006-12-17 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: OK, good to know. Does the patch need documentation too? Certainly. Are we deprecating the psql options now duplicated by the new functionality, like host/port/username/password? I'd vote not. This is just another way to do it.

Re: [PATCHES] [HACKERS] psql commandline conninfo

2006-12-17 Thread Andrew Dunstan
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: OK, good to know. Does the patch need documentation too? Certainly. That's why I haven't committed it yet. I intend to put info in the psql manual as well as in the libpq reference. Are we deprecating the psql

Re: [HACKERS] Security leak with trigger functions?

2006-12-17 Thread Florian G. Pflug
Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: The trigger never runs as the owner of the table AIUI, only ever as the definer of the function or as session user. Yeah. This might itself be seen as a bug: I think you could make a reasonable case that the default behavior

Re: [HACKERS] Security leak with trigger functions?

2006-12-17 Thread Tom Lane
Florian G. Pflug [EMAIL PROTECTED] writes: Is this true for on-select rules too? In that case, couldn't any user run his code as postmaster by creating an appropriate on-select rule and waiting until somebody/cron backups the database using pg_dump? I don't see any issue for views' on-select

Re: [HACKERS] [COMMITTERS] pgsql: Put JST back into the default set of timezone abbreviations; was

2006-12-17 Thread Hiroshi Saito
Hi Tom-san. I'm sorry in a very late reaction... I can't talk a lot for the reasons of not specialist. However, Everything seems to be helped by your patches. It functions certainly now.:-) Thanks!! P.S) I supplied the windows package of Slony-I Ver 1.2.2 for the reasons the problem was

Re: [HACKERS] development environment of postgres

2006-12-17 Thread Carlos Chacon
Hi, To modify postgres, i use kwrite... then make and make install that's all But i use this web site to navegate inside the postgres code, i found it very useful http://www.mcknight.de/pgsql-doxygen/cvshead/html/ (of course, this web site may be don't have the recent realease of

[HACKERS] Dirty pages in freelist cause WAL stuck

2006-12-17 Thread ITAGAKI Takahiro
Hello, I'm testing the recently changes of WAL entries for freezing-tuples. VACUUM FREEZE took more time. The cause seems to be flushing WAL buffers. Vacuuming processes free buffers into freelist. The buffers in freelist is preferentially used on next allocation of buffers. Then, if the buffer

[HACKERS] Is there any limitation on the size of a mail?

2006-12-17 Thread Takayuki Tsunakawa
Hello, Sorry for this noisy mail. If there is more appropriate address to send to, please tell me. I sent one mail about load-distributed checkpoint three times on the following dates as I couldn't see the mail on the ML: 2006/12/16 17:53 2006/12/18 9:07 2006/12/18 12:10 But none has appeared

Re: [HACKERS] Is there any limitation on the size of a mail?

2006-12-17 Thread Tom Lane
Takayuki Tsunakawa [EMAIL PROTECTED] writes: But none has appeared on pgsql-hackers ML yet. What's wrong? One thing I worry about is the size. The size of my mail is 42KB. It has only text and no attachment. Is there any limitation on size? Yes. Consider gzip ... or if appropriate, post

Re: [HACKERS] Is there any limitation on the size of a mail?

2006-12-17 Thread Takayuki Tsunakawa
Hello, Mr. Lane Takayuki Tsunakawa [EMAIL PROTECTED] writes: But none has appeared on pgsql-hackers ML yet. What's wrong? One thing I worry about is the size. The size of my mail is 42KB. It has only text and no attachment. Is there any limitation on size? Yes. Consider gzip ... or if