Re: [BUGS] BUG #1976: steps to reproduce BUG #1438: Non UTF-8 client encoding problem

2005-10-22 Thread Bill Shui
Hi, I have the following scenario. I have two boxes (1 windows server 2003 and 1 linux debian sarge). The debian box runs the PostgreSQL server and the windows box is using Chinese character set. If I want to building an application on windows (through ODBC), should I connect to the server with

[BUGS] BUG #1986: Please include ONE BIG .txt and .HTML file in *docs*.tar.gz

2005-10-22 Thread Jari Aalto
The following bug has been logged online: Bug reference: 1986 Logged by: Jari Aalto Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Windows 2000 sp 5 Description:Please include ONE BIG .txt and .HTML file in *docs*.tar.gz Details: The po

[BUGS] BUG #1985: cannot insert Chinese character into a table encoded with UTF8

2005-10-22 Thread Jeff Tong
The following bug has been logged online: Bug reference: 1985 Logged by: Jeff Tong Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1beta3 Operating system: Windows XP Description:cannot insert Chinese character into a table encoded with UTF8 Details: I am a t

[BUGS] BUG #1984: automatic casting for using indexes on bigint

2005-10-22 Thread Atanas Hristov
The following bug has been logged online: Bug reference: 1984 Logged by: Atanas Hristov Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: FreeBSD5 Description:automatic casting for using indexes on bigint Details: Maybe it is more convient t

Re: [BUGS] BUG #1984: automatic casting for using indexes on bigint

2005-10-22 Thread Tom Lane
"Atanas Hristov" <[EMAIL PROTECTED]> writes: > Maybe it is more convient to cast automaticly in sich a case? : These are the same query. I think you've forgotten to consider the effects of caching on repeated execution of a query. regards, tom lane --

Re: [BUGS] BUG #1986: Please include ONE BIG .txt and .HTML file in *docs*.tar.gz

2005-10-22 Thread Peter Eisentraut
Am Freitag, 21. Oktober 2005 17:31 schrieb Jari Aalto: > This ONE BIG file will help loading it off-line to > a web browser (or editor *.txt), and to make quick searches on backward and > forward. This wouldn't be hard to implement. Are others interested in this? ---(end

Re: [BUGS] BUG #1986: Please include ONE BIG .txt and .HTML file in *docs*.tar.gz

2005-10-22 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Am Freitag, 21. Oktober 2005 17:31 schrieb Jari Aalto: >> This ONE BIG file will help loading it off-line to >> a web browser (or editor *.txt), and to make quick searches on backward and >> forward. > This wouldn't be hard to implement. Are others i

Re: [BUGS] timezone offsets and documentation

2005-10-22 Thread Tom Lane
Quite some time ago, Kris Jurka <[EMAIL PROTECTED]> wrote: > This allows: > jurka=# set timezone to 'Etc/GMT-14'; > SET > jurka=# select '00:00:00'::timetz; >timetz > - > 00:00:00+14 > (1 row) > but this is not an allowed value: > jurka=# select '00:00:00+14'::timetz; > ERRO