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

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,

[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

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

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

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 clea

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

Re: [HACKERS] Security leak with trigger functions?

2006-12-17 Thread Florian G. Pflug
Tom Lane wrote: Martijn van Oosterhout 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 ought to be to run a

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 opti

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

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 wh

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 to

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

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 f

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

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

[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 http://postgresql.interweb.cz/in