On Wed, Jun 29, 2011 at 12:09:13PM +0200, Philipp Kern wrote:
> On Wed, Jun 29, 2011 at 10:32:27AM +0200, Josip Rodin wrote:
> > Anyway, this kind of a query fails under PostgreSQL 9.0.4 and 8.4.8:
>
> Would you mind completing this testcase for me? I.e. at least acl_inherits is
> missing.
Ah, sure:
CREATE TABLE acl_inherits (
acl_id character(4) NOT NULL,
object_id integer NOT NULL,
parent_acl_id character(4) NOT NULL,
parent_object_id integer NOT NULL
);
So anyway "Returned type bpchar does not match expected type character(4) in
column 3" doesn't really make sense to me because on 8.4.7:
template=# \dT bpchar
List of data types
Schema | Name | Description
------------+-----------+---------------------------------------------------------
pg_catalog | character | char(length), blank-padded string, fixed storage
length
(1 row)
And on 8.4.8:
template=# \dT bpchar
List of data types
Schema | Name | Description
------------+-----------+---------------------------------------------------------
pg_catalog | character | char(length), blank-padded string, fixed storage
length
(1 row)
I don't see a difference, yet it's there :) I mean if the database told me
an actual reason for why these length modifiers would be a problem there,
I'd rewrite the code, but as it is, it looks like a bug.
Do you have any packages built with the patch that I could test?
amd64 preferably :)
--
2. That which causes joy or happiness.
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
