Re: [BUGS] PostgreSQL does not have native spinlock support on this

2004-06-14 Thread Bruce Momjian
Martino Serri wrote: > Bruce Momjian wrote: > > That is very strange. I assume you are on an i386 cpu. Many are running > > the same configuration just fine. > > > > Thank you for the answer. > > Yes, this is a PentiumIII 800Mhz. > > > I've searched on /src/include/storage/s_lock.h and i've

[BUGS] BUG #1165: ECPG can't parse dynamic SQL with indicator

2004-06-14 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1165 Logged by: ISHIDA Akio Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux miracle 2.4.9-31.22ml Description:ECPG can't parse dynamic SQL with indicator Details: $ cat in

[BUGS] BUG #1164: Informix compatibility ecpg

2004-06-14 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1164 Logged by: John Smith Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux 2.4 [Fedora core 1] Description:Informix compatibility ecpg Details: O/S: Linux 2.4 [Fedora core

Re: [BUGS] inserting lots of values into a column that has "unique" property

2004-06-14 Thread Bruno Wolff III
On Mon, Jun 14, 2004 at 01:07:09 +0800, Fehmi Noyan ISI <[EMAIL PROTECTED]> wrote: > > I got the error message as expected. Everything is ok.Now, let's create > another table called "table_2" with an inheritence from "table_1". > > But, when I insert a new value into "table_2" with an "id" v

Re: [BUGS] \w doesn't match non-ASCII letters

2004-06-14 Thread Tom Lane
Markus Bertheau <[EMAIL PROTECTED]> writes: > Is there something planned to support UTF-8 in regexps? It'd be relatively easy to use the functions here if we were convinced that pg_mb2wchar() generated exactly the same wide-character encoding as the C library is expecting for the current LC_CTYPE

Re: [BUGS] \w doesn't match non-ASCII letters

2004-06-14 Thread Markus Bertheau
Ð ÐÐÐ, 14.06.2004, Ð 17:25, Tom Lane ÐÐÑÐÑ: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Markus Bertheau wrote: > >> oocms=# select 'Ñ' ~ '^\\w$'; > >> ?column? > >> -- > >> f > >> (1 ÑÑ) > > > What locale are you using for LC_COLLATE? If it's C or POSIX, you need > > to change

[BUGS] BUG #1163: cursor "jdbc_curs_1" does not exist

2004-06-14 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1163 Logged by: Timo Nentwig Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux Description:cursor "jdbc_curs_1" does not exist Details: Hi! I read about 4000 html pages (i.

Re: [BUGS] \w doesn't match non-ASCII letters

2004-06-14 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Markus Bertheau wrote: >> oocms=# select 'ф' ~ '^\\w$'; >> ?column? >> -- >> f >> (1 запись) > What locale are you using for LC_COLLATE? If it's C or POSIX, you need > to change it and re-initdb. Another likely cause of trouble is that the

Re: [BUGS] \w doesn't match non-ASCII letters

2004-06-14 Thread Peter Eisentraut
Markus Bertheau wrote: > oocms=# select 'Ñ' ~ '^\\w$'; > ?column? > -- > f > (1 ÑÑ) What locale are you using for LC_COLLATE? If it's C or POSIX, you need to change it and re-initdb. ---(end of broadcast)--- TIP 5: Have you checked

[BUGS] Postgres eat my data suddenly...

2004-06-14 Thread M.Z.
Hi all. I use postgres to collect all information of my work. Debian: 3.0r1 Version: 7.2.1 Libc: 2.2.5 I have change a table schema and since this Postgres has lost the definition of some table. That is. The database's name is 'dbore'. Inside I defined a table ore. The schema, since january

[BUGS] \w doesn't match non-ASCII letters

2004-06-14 Thread Markus Bertheau
oocms=# select 'Ñ' ~ '^\\w$'; ?column? -- f (1 ÑÑ) or oocms=# select 'Ã' ~ '^\\w$'; ?column? -- f (1 ÑÑ) both should return true, as does oocms=# select 'n' ~ '^\\w$'; ?column? -- t (1 ÑÑ) Thanks. -- Markus Bertheau <[EMAIL PROTECTED]> ---

Re: [BUGS] PostgreSQL does not have native spinlock support on this

2004-06-14 Thread Martino Serri
Bruce Momjian wrote: > That is very strange. I assume you are on an i386 cpu. Many are running > the same configuration just fine. > Thank you for the answer. Yes, this is a PentiumIII 800Mhz. I've searched on /src/include/storage/s_lock.h and i've found this line. #ifdef HAVE_SPINLOCKS #error Pos