Re: [BUGS] Sequence of characters not supported by psql/pg_dump

> I use PostgreSQL 7.0.2 on linux. > The base was set with initdb -E UNICODE. > > I have many Strings with accents (french language). > Some of them aren't supported by queries or pg_dump: > > WORKING EXAMPLE: > DB=# select * from element_attribute where java_lang_string

[BUGS] Sequence of characters not supported by psql/pg_dump

Hello, I use PostgreSQL 7.0.2 on linux. The base was set with initdb -E UNICODE. I have many Strings with accents (french language). Some of them aren't supported by queries or pg_dump: WORKING EXAMPLE: DB=# select * from element_attribute where java_lang_string

[BUGS] pgsql 7.1: int4out() brokeness?

POSTGRESQL BUG REPORT TEMPLATE Your name : James Troup Your email address : [EMAIL PROTECTED] Sys

[BUGS] Query!

Hello! I've installed Red Hat Linux in my PC. Along with the packages I installed Postgresql. I went through the documentation available and tried to create a database when I typed the following in the command prompt, createdb mydatabase the following error message was flashed: Connection to datab

[BUGS] jdbc driver: Support for 'BOOL'

Problem: If try to use field of type "java.sql.Types.BIT" obtains error "Unknown Types Value" Resolution: Add this: PreparedStatement.java 460,461d459 < case Types.BIT: < set(parameterIndex, ((Boolean)x).booleanValue()

Re: [BUGS] subselects doesn't work in v7.0.3

Andrew McMillan wrote: > [EMAIL PROTECTED] wrote: > > > > jose ([EMAIL PROTECTED]) reports a bug with a severity of 2 > > The lower the number the more severe it is. > > > > Short Description > > subselects doesn't work in v7.0.3 > > > > Long Description > > Version: PostgreSQL 7.0.3 on i686-pc

[BUGS] Interval bug

Hi guys, Firstly, Postgres rocks! Our live database is rapidly growing and ever-reliable. We're stupidly storing URLs visited by nearly a thousand of our own machines, and are yet to miss a beat (apart from the obvious speed problems)! Secondly, we have a problem with interval math, detailed b

[BUGS] Re: Error in Constraint Checks with PGSQL 7.03

Sorry, I somehow missed including the exact error message I get when inserting : Bad (null) varchar() external representation Regards and best wishes, Justin Clift Database Administrator [EMAIL PROTECTED] wrote: > > Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lo

[BUGS] Error in Constraint Checks with PGSQL 7.03

Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Error in Constraint Checks with PGSQL 7.03 Long Description Hi, I'm experiencing this bug with Postgres 7.03 : CREATE TABLE "staff_details" ( "userid" chara

Re: [BUGS] CONSTRAINT problems

This a known problem which is caused by subselects in check constraints. Current sources seem to give an error message at create time: ERROR: Cannot use subselect in CHECK clause In general subselects in check constraints also may constrain tables that the subselect mentions. In your case

[BUGS] CONSTRAINT problems

I've got a test table in 7.0.3 where I'm implementing a directory type structure in a RCS type system. I have a check to ensure that there are no duplicate filenames within for a specific directory given the revisionid of 0 (means it's the current revision rather than a historical one). CREAT

[BUGS] JDBC Connection must be restarted after executing SQL statement that calls a PL/PGSQL function that won't compile

Jason Southern ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC Connection must be restarted after executing SQL statement that calls a PL/PGSQL function that won't compile Long Description