Re: [HACKERS] default enconding

2004-03-27 Thread Manuel Sugawara
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > I think we need to fix that as well. I do agreee, however, we have to start somewhere. Regards, Manuel. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] default enconding

2004-03-27 Thread Tatsuo Ishii
> Hi, I have found what I thing is a quite annoying behaviour of > Postgres (psql). When you type (and ask for complation) for some > string that has some characters not in the ASCII encoding it requires > a double quote on it, however if you don't put those double quotes > around it, you can still

Re: [HACKERS] default enconding

2004-03-27 Thread Manuel Sugawara
Tom Lane <[EMAIL PROTECTED]> writes: > Manuel Sugawara <[EMAIL PROTECTED]> writes: > > Hi, I have found what I thing is a quite annoying behaviour of > > Postgres (psql). When you type (and ask for complation) for some > > string that has some characters not in the ASCII encoding it requires > > a

Re: [HACKERS] default enconding

2004-03-27 Thread Manuel Sugawara
Tom Lane <[EMAIL PROTECTED]> writes: > ... in other words, it doesn't require the double quotes. I don't see > the value of being more restrictive. Why is this annoying? Note also that using iso-8859-1 is not more restrictive, but just the opposite. Using iso-8859-1 will be useful also for Engl

Re: [HACKERS] default enconding

2004-03-27 Thread Tom Lane
Manuel Sugawara <[EMAIL PROTECTED]> writes: > Hi, I have found what I thing is a quite annoying behaviour of > Postgres (psql). When you type (and ask for complation) for some > string that has some characters not in the ASCII encoding it requires > a double quote on it, however if you don't put th

[HACKERS] default enconding

2004-03-27 Thread Manuel Sugawara
Hi, I have found what I thing is a quite annoying behaviour of Postgres (psql). When you type (and ask for complation) for some string that has some characters not in the ASCII encoding it requires a double quote on it, however if you don't put those double quotes around it, you can still execute t

Re: [HACKERS] md5 function

2004-03-27 Thread Bruce Momjian
ivan wrote: > > can you create second md5 function like TEXT md5(TEXT string, VARCHAR > salt); ? , This is using in shadow passwords and give more combination of > this same password. Yes, please see src/contrib/pgcrypto. -- Bruce Momjian| http://candle.pha.pa.us [E

Re: [HACKERS] PostgreSQL block size vs. LVM2 stripe width

2004-03-27 Thread Manfred Koizar
Mark, how often did you run your tests? Are the results reproduceable? On Fri, 26 Mar 2004 14:00:01 -0800 (PST), [EMAIL PROTECTED] wrote: >Linux-2.6.3, LVM2 Stripe Width >(going across) >PostgreSQL >BLCKSZ >(going down)16 KB 32 KB 64 KB 1

[HACKERS] md5 function

2004-03-27 Thread ivan
can you create second md5 function like TEXT md5(TEXT string, VARCHAR salt); ? , This is using in shadow passwords and give more combination of this same password. thanks, bye ivan ---(end of broadcast)--- TIP 9: the planner will ignore your de

Re: [HACKERS] Timeline for 7.4.3?

2004-03-27 Thread Bruce Momjian
Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > We have many machines that run Solaris. I know that there are patches > > out there for some of the bugs in 7.4.2 for Solaris but I was wondering > > what the timeline for an official 7.4.3 was? > > Don't hold your breath ... 7.4.

Re: [HACKERS] A student research project on triggers

2004-03-27 Thread Bruce Momjian
Grace Mou wrote: > I'm currently working on a student research project that is supervised by a > professor from my university. This project duration is 2 semesters. The > topic is to implement the two missing SQL3 standard triggers functionalities > in Postgresql, ¡®triggers on columns¡¯ and ¡®refe

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-27 Thread Andreas Pflug
Fabien COELHO wrote: Ok. A more precise question is: on the client side, whether PHP or anything else, can you take advantage of the information available and provide some usable somehow "dedicated" interface that would make it easy to access the available informations? What would help for that p