Re: [GENERAL] Can postgres supports Chinese GB18030?

2003-07-28 Thread Weiping He
LitelWang wrote: It is useful for me to use Chinese tone sort order . Any version on Cygwin? Thanks for any advice . I never try GB18030 in Cygwin, but in Linux or other Unix system, you may use gb18030 as client side encoding and use UNICODE as backend encoding, and it's pretty good. regar

[GENERAL] compile error on slackware 9.0 while --enable-thread-safety

2003-08-09 Thread Weiping He
while remove --enable-thread-safety everything ok. what's the matter? the error output: ---8<- make[2]: Entering directory `/usr/laser/postgresql-7.4beta1/src/port' gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-de

[GENERAL] how to group by a joined query?

2003-09-01 Thread Weiping He
suppose I've got two table: laser_uni=# \d t1 Table "public.t1" Column | Type | Modifiers +--+--- name | text | addr | text | laser_uni=# \d t2 Table "public.t2" Column | Type | Modifiers +-+--- name | text| len| integer | of

Re: [GENERAL] how to group by a joined query?

2003-09-01 Thread Weiping He
Weiping He wrote: suppose I've got two table: laser_uni=# \d t1 Table "public.t1" Column | Type | Modifiers +--+--- name | text | addr | text | laser_uni=# \d t2 Table "public.t2" Column | Type | Modifiers +-+-

Re: [GENERAL] A simple question about Read committed isolation level

2004-04-16 Thread weiping he
Tom Lane дµÀ: weiping he <[EMAIL PROTECTED]> writes: txn1: txn2: begin; begin; update table_a set col= col + 1; update table_a set col = col + 1; end; end; if two transaction begin at exact the same time, what's the result of 'col' after both transactions commit

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Weiping He
Martin Marques wrote: On Vie 04 Jul 2003 03:52, Weiping He wrote: Hi, all, I've met a wierd problem on a Solaris 8/sparc box with postgresql 7.3.3: the server would automatically shutdown after a period of time of not operating. The log show something like this: pmdie 2 an

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Weiping He
Tom Lane wrote: Weiping He <[EMAIL PROTECTED]> writes: I've met a wierd problem on a Solaris 8/sparc box with postgresql 7.3.3: the server would automatically shutdown after a period of time of not operating. The log show something like this: pmdie 2 Assuming

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

2003-07-04 Thread Weiping He
Tom Lane wrote: Weiping He <[EMAIL PROTECTED]> writes: Later I use: pg_ctl start >pgrun.log 2>&1 to start the program, and it runs ok. but, then the pmdie 2... Hm. My first thought was that you needed a We should check the theory though. After you start the postmaster