[BUGS] JDBC and BigDecimal problem

2002-07-03 Thread Peter Figuli
Dear JDBC team, I'm using pgjdbc2.jar from february and facing this problem: I have a table (UNICODE database is set up) having numeric type in it. Than something like this: statement = connection.preparedStatement( "SELECT * from account WHERE rate > ?" ); statement.setBigDecimal( 1, BigDecimal

Re: [BUGS] Problem

2002-07-03 Thread Tom Lane
Ram <[EMAIL PROTECTED]> writes: > # createdb test; > psql: FATAL 1: Database "template1" does not exist in the system > catalog. What PG version is this? Can you get into any of your other databases? If so, what do you get from "SELECT * FROM pg_database"? regards, tom

[BUGS] Unicode collation error.

2002-07-03 Thread Peter Figuli
Dear postgres team. I'm not member of any of your list, but I decided to send this bugreport since focusing same problem for more than 2 releases of PGSQL. I'm running Linux-box 2.4.18 kernel, postgres build from your sources-7.2.1. Steps: 1. Set locales to any UTF-8 one. Do not forget LC_COLLATE

Re: [BUGS] Bug #702: NULLs order by bug in 7.2.1

2002-07-03 Thread Stephan Szabo
On Tue, 2 Jul 2002 [EMAIL PROTECTED] wrote: > John Liu ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > NULLs order by bug in 7.2.1 > > Long Description > select date_fld from my_table order by date_fld desc; > > The ab

[BUGS] Bug #703: granted permisions lost next day

2002-07-03 Thread pgsql-bugs
Petr Husak ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description granted permisions lost next day Long Description Hello, I've a table named map. I need to allow all users to select from this table. "GRANT select ON map TO public ;"

Re: [BUGS] Bug #702: NULLs order by bug in 7.2.1

2002-07-03 Thread Tom Lane
[EMAIL PROTECTED] writes: > select date_fld from my_table order by date_fld desc; > The above query put NULLs on top of normal values > in stead of bottom, this is not the case in 7.1.3. This is not a bug; it is an intentional change in behavior to conform to SQL92. We are not going to change

Re: [BUGS] Bug #703: granted permisions lost next day

2002-07-03 Thread Tom Lane
[EMAIL PROTECTED] writes: > Hello, I've a table named map. I need to allow all users to select from this table. >"GRANT select ON map TO public ;" works but permissions are lost next day and I must >grant them again and again. I also tried to do it in a transaction: "BEGIN ; GRANT >select ON ma

Re: [BUGS] Bug #703: granted permisions lost next day

2002-07-03 Thread Bruce Momjian
Very strange. I can't imagine what would cause this. --- [EMAIL PROTECTED] wrote: > Petr Husak ([EMAIL PROTECTED]) reports a bug with a severity > of 2 The lower the number the more severe it is. > > Short Description gra