Re: [GENERAL] Type cast removal - proposed exceptions for xml,enum

2010-12-07 Thread Peter Eisentraut
On tis, 2010-12-07 at 11:49 +0800, Craig Ringer wrote: This is driving me nuts when working with PgJDBC via various ORM layers (I know, I know, but they're life at this point) that would work happily with these types if they were implicitly castable to/from strings, but don't understand how to

[GENERAL] Type cast removal - proposed exceptions for xml,enum

2010-12-06 Thread Craig Ringer
Hi all I'm finding a few areas where PostgreSQL's refusal to implicitly cast from 'text' to another type is causing real problems, particularly when using the PgJDBC driver. I'd like to propose a couple of relaxations of the implicit cast rules for certain text-like types: - user-defined enums;

Re: [GENERAL] Type cast removal - proposed exceptions for xml,enum

2010-12-06 Thread Mike Christensen
On Mon, Dec 6, 2010 at 7:49 PM, Craig Ringer cr...@postnewspapers.com.au wrote: Hi all I'm finding a few areas where PostgreSQL's refusal to implicitly cast from 'text' to another type is causing real problems, particularly when using the PgJDBC driver. I'd like to propose a couple of

Re: [GENERAL] Type cast removal - proposed exceptions for xml,enum

2010-12-06 Thread Tom Lane
Craig Ringer cr...@postnewspapers.com.au writes: I'm finding a few areas where PostgreSQL's refusal to implicitly cast from 'text' to another type is causing real problems, particularly when using the PgJDBC driver. I'd like to propose a couple of relaxations of the implicit cast rules for