Re: [BUGS] pg_dump -t option doesn't take schema-qualified table names

2003-07-01 Thread Tom Lane
Curt Sampson <[EMAIL PROTECTED]> writes: > On Tue, 1 Jul 2003, Tom Lane wrote: >> IMO that's not a bug; you should spell it pg_dump -n foo -t bar. >> The other way is ambiguous with a table named "foo.bar". > Oh, I didn't realize that dots are allowed in table names. But is there > an unambiguous

[BUGS] Bug in japanese charset mappings?

2003-07-01 Thread Jean-Christian Imbeault
I've run into what seems like an old bug in the character set mapping for japanese encoding while trying to extract data from my database using the Java JDBC driver. The problem has to do with the japanese full-width wave dash. This problem was brought up by Tom O'Dowd way back in February but

Re: [BUGS] Invalid EUC_JP char seq bug?

2003-07-01 Thread Jean-Christian Imbeault
Tatsuo Ishii wrote: Since you did not show us exact query you send to PostgreSQL I can't show the exact query because it is generated by PHP. I can however show you the code that generates the query: $words = $_GET["words"]; $sql = "select id from products where name like '$words'"; $conn = pg_co

Re: [BUGS] Invalid EUC_JP char seq bug?

2003-07-01 Thread Tatsuo Ishii
> I am using PHP with postgreSQL and I have been getting a few rare errors > while trying to do selects on a table containing EUC_JP text. > > I thought it was a bug with PHP not recognizing a string as invalid > EUC_JP characters and wrote up a bug report but the PHP developers > assure me that t

[BUGS] Invalid EUC_JP char seq bug?

2003-07-01 Thread Jean-Christian Imbeault
I am using PHP with postgreSQL and I have been getting a few rare errors (Bwhile trying to do selects on a table containing EUC_JP text. (B (BI thought it was a bug with PHP not recognizing a string as invalid (BEUC_JP characters and wrote up a bug report but the PHP developers (Bassure me tha

Re: [BUGS] Problem with "z_" in Unicode-DB

2003-07-01 Thread Markus Bertheau
В Срд, 02.07.2003, в 00:27, Ian Barwick пишет: > On Tuesday 01 July 2003 11:01, Wehrle, Daniel wrote: > > > > Statement: > > SELECT ID FROM tblAssets WHERE uri like > > '/files/AssetStore/postgreSqlTest/ratz_ruebe.jpg' ; > > > > ERROR: Invalid UNICODE character sequence found (0xc000) > > > > Has

Re: [BUGS] Problem with "z_" in Unicode-DB

2003-07-01 Thread Ian Barwick
On Tuesday 01 July 2003 11:01, Wehrle, Daniel wrote: > Hi, > > i have following problem: > (...) > When i try to execute this select, i get an error: > > Statement: > SELECT ID FROM tblAssets WHERE uri like > '/files/AssetStore/postgreSqlTest/ratz_ruebe.jpg' ; > > Error: > ERROR: Invalid UNICODE c

Re: [BUGS] pg_dump -t option doesn't take schema-qualified table names

2003-07-01 Thread Tom Lane
Curt Sampson <[EMAIL PROTECTED]> writes: > It appears that the command "pgsql -t foo.bar" will not dump the table > bar in the schema foo. I saw a patch a while back to add schema support > to pg_dump (with the --namespace option), but I did not see a fix for > this. IMO that's not a bug; you shou

[BUGS] Problem with "z_" in Unicode-DB

2003-07-01 Thread Wehrle, Daniel
Hi, i have following problem: I created a database with encoding UNICODE CREATE DATABASE elements WITH ENCODING = 'UNICODE'; In this db there is a table "tblassets" CREATE TABLE public.tblassets ( id serial NOT NULL, uri text NOT NULL, CONSTRAINT tblassets_pkey PRIMARY KEY (id) ) WITH