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 committed
in Read committed
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 |
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
+-+---
name | text|
len
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
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.
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 signal 2 is SIGINT
Tom Lane wrote:
Weiping He [EMAIL PROTECTED] writes:
Later I use:
pg_ctl start pgrun.log 21
to start the program, and it runs ok. but, then the pmdie 2...
Hm. My first thought was that you needed a /dev/null in there too,
but it looks like pg_ctl does that for you. The other likely