Re: [BUGS] Money locale currency symbol position

2002-07-29 Thread Tom Lane
Marko Mikulicic <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Note though that most of us think the current money type is a kluge >> anyway; anything based on int4 storage doesn't have enough significant >> digits. It would be better rewritten as a thin locale-aware veneer >> over type "numeri

Re: [BUGS] Select For Update bug???

2002-07-29 Thread Bruce Momjian
What PostgreSQL version are you using? Please try this in two psql sessions and see if you see the same thing. --- [EMAIL PROTECTED] wrote: > Hi, I'm encountered a problem with a select for update sentence with > postgres

Re: [BUGS] Money locale currency symbol position

2002-07-29 Thread Tom Lane
Marko Mikulicic <[EMAIL PROTECTED]> writes: >The code in cash.c should be cleaned up completely Such criticism is best expressed in the form of a patch ;-) Note though that most of us think the current money type is a kluge anyway; anything based on int4 storage doesn't have enough significa

Re: [BUGS] Bug #722: SELECT FOR UPDATE bug

2002-07-29 Thread Stephan Szabo
On Fri, 26 Jul 2002 [EMAIL PROTECTED] wrote: > Pablo Aviles > 27/07/2002 10:58 > > > To: Tom Lane <[EMAIL PROTECTED]> > cc: > Subject:Re: [BUGS] Bug #722: SELECT FOR UPDATE bug > > > Hi, > we are use Postgresql 7.3. > The case in questions is: we have many cl

Re: [BUGS] Multi-byte character bug

2002-07-29 Thread Tatsuo Ishii
> Two bugs has been found in the SQL parser and Multibyte char support: > > 1. ¡§Problem connecting to database: java.sql.SQLException: ERROR: > Invalid EUC_TW character sequence found (0xb27a)¡¨ was reported in using > JDBC driver to insert record, similar error reported when using OD

Re: [BUGS] bug "\! cd"

2002-07-29 Thread Victor Wagner
On 2002.07.26 at 12:00:01 -0600, Kathy zhu wrote: > I did '\i cd' on solaris. > It doesn't change the directory. It stays where it is. It is not a bug, it is a feature. Of any Unix, including Solaris, Linux etc. Current directory is a propriety of running process. When process is finished, its

[BUGS] share lib libpq++

2002-07-29 Thread serge.zangheri
Hi, installation from postgres7.2.1.tar.gz. The automatic installation does not create lib/libpq++.so. In src/interfaces/libpq++, there is a Makefile which generates fpic command directly (instead of gcc ... -fpic ...) and of course the fpic command does not exist. Using gcc -fpic pgconnect

[BUGS] Multi-byte character bug

2002-07-29 Thread Richard So
  Two bugs has been found in the SQL parser and Multibyte char support:   1.   ¡§Problem connecting to database: java.sql.SQLException: ERROR: Invalid EUC_TW character sequence found (0xb27a)¡¨ was reported in using JDBC driver to insert record, similar error reported when using ODBC

[BUGS] Select For Update bug???

2002-07-29 Thread paviles
Hi, I'm encountered a problem with a select for update sentence with postgresql. If I use...: begin transaction; select * from employees where status = 'A' limit 1 for update; ... The problem, in the previous sentence, is block every record on employees, although we want one record, we want limi

[BUGS] Money locale currency symbol position

2002-07-29 Thread Marko Mikulicic
POSTGRESQL BUG REPORT TEMPLATE Your name : Marko Mikulicic Your email address : [EMAIL PROTECTED]

[BUGS] Bug #722: SELECT FOR UPDATE bug

2002-07-29 Thread paviles
Pablo Aviles 27/07/2002 10:58         To:        Tom Lane <[EMAIL PROTECTED]>         cc:                 Subject:        Re: [BUGS] Bug #722: SELECT FOR UPDATE bugLink    Hi, we are use Postgresql 7.3. The case in questions is: we have many clients (pc's) of postgresql. Every client try to

[BUGS] bug: 2 dimensional array

2002-07-29 Thread Kathy zhu
Here is the sequence suggested in the Tutorial from your site: CREATE TABLE SAL_EMP ( kathydb(# nametext, pkathydb(# ay_by_quarter integer[], schedule kathydb(# text[][] ); INSERT INTO SAL_EMP VAkathydb-# LUES ('Bill', kathydb(# '{1, 1, 1, 1000

[BUGS] bug "\! cd"

2002-07-29 Thread Kathy zhu
I did '\i cd' on solaris. It doesn't change the directory. It stays where it is. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html