I have fixed it. I have pg8.03 but database is 8.0. I dump database and
reload it, it work well.
Thank for your help.
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "hatuan" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, May 26, 2005 4:19 AM
Su
"hatuan" <[EMAIL PROTECTED]> writes:
> My version is "PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC gcc.exe
> (GCC) 3.4.2 (mingw-special)"
Well, if it's 8.0.3 then you've found a new variant of the problem, but
we cannot fix it without a complete test case. Please read the bug
reporting gu
My version is "PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC gcc.exe
(GCC) 3.4.2 (mingw-special)"
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "hatuan" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, May 26, 2005 4:19 AM
S
"hatuan" <[EMAIL PROTECTED]> writes:
> I have a select query Select * from A where id like 'US%'
> In pgAdmin i have error : "ERROR: unsupported type: 136452".
What PG version is this?
There were some bugs of that ilk in 8.0..8.0.2, but I think they
are all fixed in 8.0.3. Leastwise your exampl
I use domain in my database
Ex
CREATE DOMAIN ud_id
AS bpchar(3)
DEFAULT ''::bpchar
NOT NULL;
And have table A
CREATE TABLE A
(
id ud_ma_nt NOT NULL,
name ud_name,
CONSTRAINT A_pkey PRIMARY KEY (id)
)
I have a select query Select * from A where id like 'US%'
In pgAdmin i have er
