encodings. You should do either:
1) Make sure that your termical encoding is EUC_KR.
2) set client_encoding = 'uhc';
> Even the SELECT statement displays something different. I am not able to
> understand why?
>
> korean=# SELECT * FROM tbl;
> doc
>
>
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > In the last SELECT I exepcted j = 0, rather than j = 1 since I use DO
> > INSTEAD in the rule and the default value for j is 0. Am I missing
> > something?
>
> > CREATE rule t1_ins AS ON INSERT TO t1
>
INSERT TO t1
WHERE (EXISTS (SELECT 1 FROM t1
WHERE i = new.i))
DO INSTEAD UPDATE t1 SET j = j + 1
WHERE i = new.i;
CREATE RULE
INSERT INTO t1 VALUES (1);
INSERT 1690668 1
SELECT * FROM t1;
i | j
---+---
1 | 1
(1 row)
--
Tatsuo Ishii
tered file
> system with decent performance? Any and all ideas are welcome.
We are selling Lifekeeper (a hot-standby cluster software) +
PostgreSQL adapter software for Lifekeeper + support combo package
called "PostgreSQL HA package" in Japan. This req
s in
postgresql.conf. As you have ~8GB database, probably you need to
set max_fsm_pages to: 8*1024*1024*1024/8192 = 1048576. It will
need about 7MB more shmem, but it would not be too much for modern
PC.
(2) if that's 7.1.x, or earlier, you need to vacuum and reindex more
> or just simply browse the database as usual?
I'm afraid you are forced initdb.
I think postmaster coming with PostgreSQL 7.1 or later won't start up
if locale is enabled and the specified locale is different from the
initdb time (if locale is not enabled in PostgreSQL, the
to enable locale support. MB support does nothing with the
sort order.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
's not a bug but a feature invented by Michael Stonebraker. Write
to him why do you think that is a bug:-)
--
Tatsuo Ishii
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
I found below is very valuable. I hope this would be included in the
7.1 docs.
--
Tatsuo Ishii
From: Roberto Mello <[EMAIL PROTECTED]>
Subject: [SQL] PL/SQL-to-PL/PgSQL-HOWTO beta Available
Date: Sat, 17 Feb 2001 17:34:22 -0700
Message-ID: <[EMAIL PROTECTED]>
> Hi al
he
problem in the backend. However this problem was hard to reproduce, I
have not tackled it yet. If someone has a reproducible data, please
let us know...
--
Tatsuo Ishii
OM my_table ORDER BY sort_field )
>
> I receive strange error: the rows that begin with ascii symbols are ordered while
>all other - are not!
I guess this is because UTF-8 strings are sorted in the order of the
physical representation. Can you show me sample data and its desired
order?
--
Tatsuo Ishii
11 matches
Mail list logo
