Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-10 Thread Tatsuo Ishii
? In the SRA's code, the checkpoint thread opens each file (if it's not already open of course) which has been written then fsync() it. -- Tatsuo Ishii ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] A rough roadmap for internationalization fixes

2003-11-25 Thread Tatsuo Ishii
OK, I've been spreading rumours about fixing the internationalization problems, so let me make it a bit more clear. Here are the problems that need to be fixed: - Only one locale per process possible. - Only one gettext-language per process possible. - lc_collate and lc_ctype need to

Re: [HACKERS] A rough roadmap for internationalization fixes

2003-11-25 Thread Tatsuo Ishii
. Another gottcha with Unicode is the UTF-8 encoding (currently we use) consumes 3 bytes for each Kanji character, while other encodings consume only 2 bytes. IMO 3/2 storage ratio could not be neglected for database use. -- Tatsuo Ishii ---(end of broadcast

[HACKERS] aggregate + view + alias crash on 7.4 stable

2003-12-07 Thread Tatsuo Ishii
Hi, A problem related with view was reported from a user. I narrowed down the problem and found it was related to some usage of views: (note that with/without limit is not relevant) test=# select count(a.*) from pg_indexes a limit 10; server closed the connection unexpectedly This

Re: [HACKERS] aggregate + view + alias crash on 7.4 stable

2003-12-07 Thread Tatsuo Ishii
Tatsuo Ishii [EMAIL PROTECTED] writes: test=# select count(a.*) from pg_indexes a limit 10; server closed the connection unexpectedly Hmmm ... the crash is certainly UnGood, but is there any reason we should accept this query rather than generating an error? I don't think it's legal

[HACKERS] time zone?

2003-12-15 Thread Tatsuo Ishii
this? -- Tatsuo Ishii ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE r ...

2003-12-22 Thread Tatsuo Ishii
Are we going to regenerate the 7.4.1 tar ball? -- Tatsuo Ishii Peter Eisentraut - PostgreSQL wrote: CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/21 17:36:34 Modified files: doc/src/sgml : Tag: REL7_4_STABLE release.sgml

[HACKERS] documentation bug?

2004-01-05 Thread Tatsuo Ishii
I see following in the doc: Table 9-21. Template Patterns for Date/Time Formatting : : J Julian Day (days since January 1, 4712 BC) I think 4712 should be 4713. -- Tatsuo Ishii ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Encoding problems in PostgreSQL with XML data

2004-01-20 Thread Tatsuo Ishii
Merlin Moncure kirjutas E, 12.01.2004 kell 19:56: Hannu Krosing wrote: IIRC, the charset transformations are done as a separate step in the wire protocol _before_ any parser has chance transform or not. Yep. My point is that this is wrong. Of course :) We need this because our

[HACKERS] postgresql.org reverse lookup fail

2004-01-27 Thread Tatsuo Ishii
the log on powergres.sra.co.jp, it turns out that reverse look up for postgresql.org has been failed and this make it impossible to receive those mails from postgresql.org. Anyone can take care of this problem? -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] postgresql.org reverse lookup fail

2004-01-27 Thread Tatsuo Ishii
checking the log on powergres.sra.co.jp, it turns out that reverse look up for postgresql.org has been failed and this make it impossible to receive those mails from postgresql.org. Anyone can take care of this problem? -- Tatsuo Ishii Here is the more detailed info: It seems reverse look up

[HACKERS] rule and JDBC

2004-01-28 Thread Tatsuo Ishii
(AbstractJdbc1Statement.java:199) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:183) at test.main(test.java:10) I'm not sure whether the JDBC driver or PostgreSQL backend should be blamed though. -- Tatsuo Ishii Here is a test case: create table daily_log

Re: [HACKERS] rule and JDBC

2004-01-28 Thread Tatsuo Ishii
using executeQuery works, but won't if there isn't a rule. Perhaps using plain execute() would be the most appropriate thing to do. Kris Jurka Got it. With regard to this PostgreSQL JDBC driver confirms the JDBC spec. -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] [PATCHES] v7.4.1 text_position() patch

2004-01-30 Thread Tatsuo Ishii
to make a back patch for 7.3-stable if nobody objects. BTW, I'm interested in Korea PostgreSQL Users' Group since I myself am a bord member of Japan PostgreSQL Users' Group. Please let me know if both users group could make some collaboration, such as having a seminar in Korea or in Japan. -- Tatsuo

Re: [HACKERS] [PATCHES] v7.4.1 text_position() patch

2004-01-31 Thread Tatsuo Ishii
Tatsuo Ishii wrote: It's surprising that nobody noticed the bug until now. It seems it has been there since 7.3 days. I would like to make a back patch for 7.3-stable if nobody objects. It's my bug :( -- sorry about that. Here's a 7.3 patch per Tom's nearby advice. I'll apply if you'd

Re: [HACKERS] PITR Dead horse?

2004-02-03 Thread Tatsuo Ishii
Has this been beaten to death now? Just curious if PITR was in Dev tree yet. Been out of the loop. TIA. I and my co workers are very interested in implementing PITR. We will tackle this for 7.5 if no one objects. -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] PITR Dead horse?

2004-02-03 Thread Tatsuo Ishii
I and some other developers are also interested in. Do you think we can work together? Sure. Why not. I think it would be practical to decide who is the leader of this project, though. -- Tatsuo Ishii ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] 7.3.6 bundled ...

2004-03-02 Thread Tatsuo Ishii
2.4.22+glibc 2.2.4+gcc 2.95... -- Tatsuo Ishii ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Sigh, 7.3.6 rewrap not right

2004-03-04 Thread Tatsuo Ishii
. This is not the first time tarballs have been streamlined. I'm glad I hadn't built any RPMs yet. Sigh. I'm very uncomfortable with the existence of two versions of 7.3.6. Also the fact that I cannot get the right tar ball till it is copied to mirrors makes me uncomfortable too. -- Tatsuo Ishii

Re: [HACKERS] [PATCHES] NO WAIT ...

2004-03-08 Thread Tatsuo Ishii
If NOWAIT is the choice, I could live with it. If there's no objection, I will go with NOWAIT, not NO WAIT. -- Tatsuo Ishii Tatsuo Ishii [EMAIL PROTECTED] writes: LOCK TABLE table NO WAIT is OK for 7.5? If ok, I will make patches against current with some docs changes. Dept of minor

Re: [HACKERS] [PATCHES] NO WAIT ...

2004-03-08 Thread Tatsuo Ishii
It seems NOWAIT is the winner... -- Tatsuo Ishii Oracle uses NOWAIT so we should go for that one. Regards, Hans Tatsuo Ishii wrote: If NOWAIT is the choice, I could live with it. If there's no objection, I will go with NOWAIT, not NO WAIT. -- Tatsuo

Re: [HACKERS] [PATCHES] NO WAIT ...

2004-03-09 Thread Tatsuo Ishii
one checks my English grammer:-) -- Tatsuo Ishii It seems NOWAIT is the winner... -- Tatsuo Ishii Oracle uses NOWAIT so we should go for that one. Regards, Hans Tatsuo Ishii wrote: If NOWAIT is the choice, I could live with it. If there's

Re: [HACKERS] [PATCHES] NO WAIT ...

2004-03-09 Thread Tatsuo Ishii
Tatsuo Ishii [EMAIL PROTECTED] writes: Here is the patch I promised (against current). This is missing the necessary adjustments in backend/nodes/ (copy and equal funcs). Also the NOWAIT keyword must be added to the list of nonreserved keywords near the bottom of gram.y. Thanks

Re: [HACKERS] [PATCHES] NO WAIT ...

2004-03-09 Thread Tatsuo Ishii
This is missing the necessary adjustments in backend/nodes/ (copy and equal funcs). Also the NOWAIT keyword must be added to the list of nonreserved keywords near the bottom of gram.y. Thanks for the review. I'll work on this. Here is the revised patch. -- Tatsuo Ishii

Re: [HACKERS] client side syntax error localisation for psql (v1)

2004-03-11 Thread Tatsuo Ishii
of a mapping table between storage size and terminal size for each encoding. Note that this is not new problem, and sophiscated editors such as Emacs (mule) has already concur that. -- Tatsuo Ishii ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [HACKERS] client side syntax error localisation for psql (v1)

2004-03-12 Thread Tatsuo Ishii
Dear Tatsuo, Thanks for your reply, as I noticed from the source code that your name often appears when dealing with multi-byte issues;-) On Fri, 12 Mar 2004, Tatsuo Ishii wrote: As far as I understand your code, it will be broken on many multi byte encodings. 1) a character

Re: [HACKERS] client side syntax error localisation for psql (v1)

2004-03-12 Thread Tatsuo Ishii
and you can skip as many characters as PQmnlen returns 5) goto 1) if any characters remain ~~of course this should be 2) -- Tatsuo Ishii ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

Re: [HACKERS] client side syntax error localisation for psql (v1)

2004-03-12 Thread Tatsuo Ishii
, ok. Thanks for you reply, You are welcome! -- Tatsuo Ishii ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] client side syntax error localisation for psql (v1)

2004-03-12 Thread Tatsuo Ishii
Could you take a look at included screen shot? I haven't found it. However I've made a little bit of trying with my Oops. I have included this time. Maybe you could point me some source of information about display lengths of characters depending on the encoding? I could write

[HACKERS] try to find out the checkpoint record?

2004-03-13 Thread Tatsuo Ishii
checkpoint record. This may take considerable amount of time, but still better than giving up recovery IMO. Any reason we cannot do this? -- Tatsuo Ishii ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] try to find out the checkpoint record?

2004-03-14 Thread Tatsuo Ishii
. What's wrong with improving one of fragile parts of the system? -- Tatsuo Ishii ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] [GENERAL] unicode error and problem

2004-03-24 Thread Tatsuo Ishii
just isn't an encoding. Actually you can use UTF-8 instead of UNICODE when using PostgreSQL. However the primary name is still UNICODE, and I agree it's better to change to UTF-8 for the primary name. Maybe for 7.5? -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] default enconding

2004-03-27 Thread Tatsuo Ishii
in that it's not multibyte ware. I think we need to fix that as well. -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] locale

2004-04-07 Thread Tatsuo Ishii
no problem with encoding itself. -- Tatsuo Ishii ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] locale

2004-04-08 Thread Tatsuo Ishii
terminal encoding to E1, then SELECT the table. Point is you do not use set client_encoding or \encoding command. This will work as long as both E1 and E2 are single byte encodings. -- Tatsuo Ishii ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [HACKERS] Lexing with different charsets

2004-04-13 Thread Tatsuo Ishii
, like: ... WHERE field1 = _latin1'FooBar' and field2 = _utf8'Åäö' In my understanding this was removed as of SQL:1999. I'm not sure about SQL:2003 though. -- Tatsuo Ishii I can see that the lexer either needs to be taught about all the different charsets or this is not going to work very

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-11 Thread Tatsuo Ishii
/pgpool/pgpool-1.2.2.tar.gz -- Tatsuo Ishii ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-13 Thread Tatsuo Ishii
. This means that pgpool forces pgbench to fallback to V2 protocol (remember that pgpool does not support V3 yet), and the start up packet flys on the wire twice at the each connection statge. This actually makes the benchmark worse, still pgpool is better than direct connection however. -- Tatsuo

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-07 Thread Tatsuo Ishii
is nearly 10 times slower than UNIX socket. In the function there are 2 read()s to process the startup packet. I think I could enhance pool_read() so that it reduces the call to read() as little as possible... -- Tatsuo Ishii ---(end of broadcast)--- TIP 9

Re: [HACKERS] Plan for feature freeze?

2004-04-30 Thread Tatsuo Ishii
... IMO to justify those pains we need to give users major enhancements. Honestly I don't understand why we should rush the major version up. -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Rough draft for Unicode-aware

2004-05-16 Thread Tatsuo Ishii
of times when they ask me why SELECT returns results. If that kind of wanings are installed, I think more Japanese users will be confused. -- Tatsuo Ishii ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

[HACKERS] enabling tcpip_socket by default

2004-05-16 Thread Tatsuo Ishii
Is there any security risk if we enable tcpip_socket by default? We restrict connection from localhost only by default so I think enabling tcpip_socket adds no security risk. Please correct me if I am wrong. -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] enabling tcpip_socket by default

2004-05-16 Thread Tatsuo Ishii
Tatsuo Ishii wrote: Is there any security risk if we enable tcpip_socket by default? We restrict connection from localhost only by default so I think enabling tcpip_socket adds no security risk. Please correct me if I am wrong. Right, and 7.5 will ship with tcp and localhost enabled

Re: [HACKERS] enabling tcpip_socket by default

2004-05-17 Thread Tatsuo Ishii
Tatsuo Ishii wrote: Is there any security risk if we enable tcpip_socket by default? We restrict connection from localhost only by default so I think enabling tcpip_socket adds no security risk. Please correct me if I am wrong. Bruce Momjian wrote: Right, and 7.5 will ship with tcp

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Tatsuo Ishii
balancing, no failover. I'm interested in if Slony-I solves all these bad. I will try it when I have spare time. -- Tatsuo Ishii ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Tatsuo Ishii
to be. Above looks quite true for me too. -- Tatsuo Ishii ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Tatsuo Ishii
to be distributed as part of the core? At least in Japan PHP is much more popular than Python. If we have plpython in core, I see no reason we do not have plPHP in core at least from the popularity point of view. -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] [GENERAL] New PostgreSQL Tool available :

2002-09-25 Thread Tatsuo Ishii
to try -N option of pgbench. It avoids updates to branches and tellers tables. -- Tatsuo Ishii ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] unicode

2002-09-25 Thread Tatsuo Ishii
The actual checking is done in INSERT/UPDATE/COPY. However, the checking is currently very limited: every byte of a mutibyte character must be greater than 0x7f. Tatsuo, do I understand correctly that there is no checking for convertion between local charset and unicode in insert and

Re: [HACKERS] unicode

2002-09-26 Thread Tatsuo Ishii
and is correct from the standard's point of view... -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[HACKERS] 7.3 beta3 regression failure

2002-10-27 Thread Tatsuo Ishii
I'm seeing this on my Linux box (kernel 2.4.18, glibc 2.2.4): *** ./expected/horology.out Thu Sep 19 06:35:25 2002 --- ./results/horology.out Mon Oct 28 13:42:39 2002 *** *** 537,549 SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' -

Re: [HACKERS] 7.3 beta3 regression failure

2002-10-27 Thread Tatsuo Ishii
I'm seeing this on my Linux box (kernel 2.4.18, glibc 2.2.4): *** ./expected/horology.out Thu Sep 19 06:35:25 2002 --- ./results/horology.outMon Oct 28 13:42:39 2002 [snip] Sorry, this must be due to summer time... -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] How to store chinese using the Postgresql?

2002-10-28 Thread Tatsuo Ishii
on Linux. Define chinese. What character set for Chinese are you using? -- Tatsuo Ishii ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] CONVERT function is seriously broken

2002-11-02 Thread Tatsuo Ishii
are in an already-aborted transaction. Using a pg_conversion OID in stored rules isn't very acceptable either. Unfortunately, I don't see any way offhand to fix this without an initdb :-(. Sorry for the trouble and thanks for the fix. -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] the map file between gb18030 and utf8 is error

2002-11-11 Thread Tatsuo Ishii
will generate src/backend/utils/mb/Unicode/utf8_to_gb18030.map and src/backend/utils/mb/Unicode/gb18030_to_utf8.map (4) If they look good, rebuild PostgreSQL and test it. -- Tatsuo Ishii #! /usr/bin/perl # # Copyright 2002 by Bill Huang # # $Id: UCS_to_GB18030.pl,v 1.1 2002/06/13 08:28:55

Re: [HACKERS] RC1?

2002-11-12 Thread Tatsuo Ishii
Are we ready for RC1 yet? I'm waiting for jenny wang confirms the fix regarding GB18030 support. In the mean time, I'll commit the fix anyway since current GB183030 support is so badly broken (I have checked all regression tests have passed). -- Tatsuo Ishii ---(end

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Tatsuo Ishii
to turn on/off PREPARE/EXECUTE in pgbench so that we could see how PRPARE/EXECUTE could improve the performance... -- Tatsuo Ishii ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Tatsuo Ishii
afraid adding that switch into the code may make it messy. But one of the purposes of pgbench is examining performance on different environments, doesn't it? I'm afraid hard coded PREPARE/EXECUTE makes it harder. -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Tatsuo Ishii
. If that happens, keeping that switch would help examining the effect, no? -- Tatsuo Ishii ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Tatsuo Ishii
was just concerned that having both in there would be a maintenance headache and would perhaps double the amount of code and make it complicated. Let see what the author does and we can decide then. Ok. -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] Ideas needed: How to create and store collation

2002-11-18 Thread Tatsuo Ishii
it quickly enough for reasonable performance will be worse. Keep the problem out of the API and let each comparison function do what it needs to do internally. Agreed. That was the way I have been thinking about collation/create character stuff too. -- Tatsuo Ishii ---(end

[HACKERS] dbmirror

2002-11-25 Thread Tatsuo Ishii
. Global symbol $setResult2 requires explicit package name at DBMirror.pl line 140. Global symbol $setResult2 requires explicit package name at DBMirror.pl line 141. Execution of DBMirror.pl aborted due to compilation errors. This Linux and perl 5.6.1. -- Tatsuo Ishii ---(end

Re: [HACKERS] pg_conversion

2002-12-07 Thread Tatsuo Ishii
What do the columns conforencoding and contoencoding refer to in pg_conversion? How would I convert those numbers to a string encoding name, just using SQL? Chris Use pg_encoding_to_char(). -- Tatsuo Ishii ---(end of broadcast)--- TIP 2

Re: [HACKERS] Update on replication

2002-12-17 Thread Tatsuo Ishii
. It copies the input query and distribute to multiple PostgreSQL servers. As long as one of a server is working, users even do not notice some of them are failing. -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] Update on replication

2002-12-17 Thread Tatsuo Ishii
) transaction log based replications. -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Postgresql, unicode and umlauts

2003-01-01 Thread Tatsuo Ishii
The error message says all. You are trying to insert a character which is not a UTF-8. Probably you are inputting UCS-2? -- Tatsuo Ishii From: Atahualpa Jones [EMAIL PROTECTED] Subject: Postgresql, unicode and umlauts Date: Wed, 1 Jan 2003 20:17:15 +0100 Message-ID: 000d01c2b1ca$67838d60

[HACKERS] sync()

2003-01-07 Thread Tatsuo Ishii
I noticed sync() is used in PostgreSQL. CHECKPOINT - FlushBufferPool() - smgrsync() - mdsync() - sync() Can someone tell me why we need sync() here? -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] sync()

2003-01-07 Thread Tatsuo Ishii
Tatsuo Ishii wrote: I noticed sync() is used in PostgreSQL. CHECKPOINT - FlushBufferPool() - smgrsync() - mdsync() - sync() Can someone tell me why we need sync() here? As part of checkpoint, we discard some WAL files. To do that, we must first be sure that all the dirty buffers

Re: [HACKERS] sync()

2003-01-07 Thread Tatsuo Ishii
to disk *and* wait till they're written. But sync() and sleep for awhile is the closest portable approximation. Are you saying that fsync() might not wait untill the IO completes? -- Tatsuo Ishii ---(end of broadcast)--- TIP 5: Have you checked our

Re: [HACKERS] sync()

2003-01-07 Thread Tatsuo Ishii
scheduled, is not necessarily complete upon return from sync. I'm just wondering why we do not use fsync() to flush data/index pages. -- Tatsuo Ishii ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] sync()

2003-01-07 Thread Tatsuo Ishii
Tatsuo Ishii [EMAIL PROTECTED] writes: I'm just wondering why we do not use fsync() to flush data/index pages. There isn't any efficient way to do that AFAICS. The process that wants to do the checkpoint hasn't got any way to know just which files need to be sync'd. Even if it did know

Re: [HACKERS] UTF-8 encoding question regarding PhpPgAdmin

2003-01-08 Thread Tatsuo Ishii
that is ideal. (Yes, I should try this myself...) Ignored as in 'passed through unchanged'; or ignored as in 'removed from the string'? removed from the string. BTW, if I remember correctly, the euro sign is supported in ISO-8859-16, not in ISO-8859-1. -- Tatsuo Ishii

[HACKERS] UNION result

2003-01-14 Thread Tatsuo Ishii
a little bit inconsistent... -- Tatsuo Ishii ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Sorting Chinese data in Postgresql 7.3.1

2003-01-26 Thread Tatsuo Ishii
. Try re-initdb with --no-locale option to disable the locale support. Unfortunately there's no way to build PostgreSQL 7.3 or later without locale support except specify the option at initdb time. -- Tatsuo Ishii ---(end of broadcast)--- TIP 3

Re: [HACKERS] Sorting Chinese data in Postgresql 7.3.1

2003-01-26 Thread Tatsuo Ishii
) characters? -- Tatsuo Ishii ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] client_encoding directive is ignored in postgresql.conf

2003-01-29 Thread Tatsuo Ishii
, getdatabaseencoding() is called. This is simply wrong since it does not return the client encoding specified by postgressql.conf's client_encoding directive. Instead pg_client_encoding() should be called. (fix to this is included in the patches) -- Tatsuo Ishii

Re: [HACKERS] client_encoding directive is ignored in

2003-01-29 Thread Tatsuo Ishii
Tatsuo Ishii [EMAIL PROTECTED] writes: + /* Flag to we need to initialize client encoding info */ + static bool need_to_init_client_encoding = -1; Surely that should be int, not bool. Oops. Will fix. ! if (!PQsendQuery(conn, begin; select

Re: [HACKERS] POSIX regex performance bug in 7.3 Vs. 7.2

2003-02-04 Thread Tatsuo Ishii
have passed on my Linux box. -- Tatsuo Ishii --- cut here - *** postgresql-7.3.1/src/backend/regex/regcomp.c.orig 2002-09-05 05:31:24.0 +0900 --- postgresql-7.3.1/src/backend/regex/regcomp.c2003-02-05 10:05

Re: [HACKERS] POSIX regex performance bug in 7.3 Vs. 7.2

2003-02-05 Thread Tatsuo Ishii
just committed into the 7.3 stable branch. -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Status report: regex replacement

2003-02-06 Thread Tatsuo Ishii
all possible regex patterns. -- Tatsuo Ishii ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Status report: regex replacement

2003-02-06 Thread Tatsuo Ishii
ISO-8859-1 can be encoded in either 7 bit or 8 bit(we use this). I don't know what it is called though. -- Tatsuo Ishii ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Status report: regex replacement

2003-02-06 Thread Tatsuo Ishii
to natively support UTF-16. -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Changing the default configuration

2003-02-11 Thread Tatsuo Ishii
software and lower the max connections. -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Changing the default configuration

2003-02-11 Thread Tatsuo Ishii
be possible that the file system type might affect the wal_sync choice. -- Tatsuo Ishii ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

Re: [HACKERS] Wrong charset mappings

2003-02-12 Thread Tatsuo Ishii
/utils/mb/Unicode/ and rebuild postgres to use them, then I can test this out locally. Just edit src/backend/utils/mb/Unicode/*.map and rebiuld PostgreSQL. Probably you might want to modify utf8_to_euc_jp.map and euc_jp_to_utf8.map. -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] Changing the default configuration

2003-02-11 Thread Tatsuo Ishii
made clean explanation why non-repeatable results happen... -- Tatsuo Ishii ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Changing the default configuration

2003-02-11 Thread Tatsuo Ishii
performance degration! I guess this is due to the poor design of bufmgr. Until it is fixed, just increasing the number of shared_buffers a bit, say 1024, is enough IMHO. -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] client_encoding directive is ignored in

2003-02-15 Thread Tatsuo Ishii
the connection. This is just a mistake. I think we could fix 1) without any backward compatibilty problem and should be applied to both 7.3-STATBLE and current. -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] client_encoding directive is ignored in

2003-02-16 Thread Tatsuo Ishii
database_encoding? Why? No matter how the backend's behavior regarding client_encoding changes, libpq won't be affected by it since 7.2 and 7.3 libpq does not use client_encoding anyway. -- Tatsuo Ishii ---(end of broadcast)--- TIP 5: Have you

Re: [HACKERS] client_encoding directive is ignored in

2003-02-17 Thread Tatsuo Ishii
. pg_client_encoding() returns the client encoding as expected. Client/database encoding conversion will be peformed. After changes: same as above. -- Tatsuo Ishii ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

[HACKERS] Win32 Powerfail testing

2003-03-05 Thread Tatsuo Ishii
that Cygwin port of PostgreSQL does not pass his test neither. -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Win32 Powerfail testing

2003-03-06 Thread Tatsuo Ishii
. -- Tatsuo Ishii ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Win32 Powerfail testing

2003-03-06 Thread Tatsuo Ishii
to open files in the buffer manager? If so, basically PostgreSQL uses open() with flags (O_RDWR | PG_BINARY, 0600). -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Win32 Powerfail testing

2003-03-06 Thread Tatsuo Ishii
did not mention it explicitly. I meant we use the same implementation as Jan's work. He uses open()+_commit(), I believe. -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Win32 Powerfail testing

2003-03-07 Thread Tatsuo Ishii
. I regard the difference between sync() and fsync() does not affect too much to the whole performance. Checkpoint process is performed as a separate process and the fsync() part of checkpoint does nothing with WAL, that means other backend processes, busy with WAL IO will not be bothered. -- Tatsuo

Re: [HACKERS] Win32 Powerfail testing

2003-03-06 Thread Tatsuo Ishii
with the transaction log files. So probably I think I should stick with open()+_commit() approach for ordinary table/index files too. -- Tatsuo Ishii ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [HACKERS] [BUGS] Bug #908: Can not INSERT Cyrilic characters when use

2003-03-10 Thread Tatsuo Ishii
Sample Code insert into t2 (names) values ('xxx'); What did you insert as xxx? I would like to see them as hex or octal value. -- Tatsuo Ishii As 'xxx' I insert Cyrillic characters. Here are some hex values: E0, FE, DE, EE. Are you sure that these are correct UTF-8 character

[HACKERS] JDBC build fails

2002-04-13 Thread Tatsuo Ishii
Can someone please fix this? Building JDBC staffs in current has been broken for a while(7.2.x is ok). Maybe current JDBC build process requires more recent version of ant than I have, I don't know. But if so, that should be stated somewhere in the docs explicitly, I think. /usr/bin/ant

Re: [HACKERS] regexp character class locale awareness patch

2002-04-14 Thread Tatsuo Ishii
Can someone who is multbyte-aware comment on this patch? Thanks. I thought the patch is not relevant to multibyte support? -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

Re: [HACKERS] regexp character class locale awareness patch

2002-04-14 Thread Tatsuo Ishii
Whatever you do with this patch, remember that the USE_LOCALE symbol is gone. I thought we have some way to tern off locale support at the configure time. -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

  1   2   3   4   5   6   7   8   9   10   >