Re: [BUGS] abnormal behaviour of a CHECK CONSTRAINT with a regular

2004-02-11 Thread Daniel Struck
> Correct. It is annoying in some cases, but if the input to the trigger > isn't of the column datatype, then what type is it? It's hard to see > how that could work in general. > > If you want, say, a varchar length constraint to be checked only after > the trigger runs, I'd counsel declaring t

[BUGS] BUG #1078: Ref #1045 hostname lookup does not work

2004-02-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1078 Logged by: Josh Rovero Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: HP-UX 11.11 Description:Ref #1045 hostname lookup does not work Details: Box configured with /etc/hos

[BUGS] BUG #1079: ALTER TABLE does not add foreign key

2004-02-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1079 Logged by: Vladimir Sitarchuk Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3 Operating system: Red Hat 9 Description:ALTER TABLE does not add foreign key Details: ALTER TABLE tablename ADD

Re: [BUGS] BUG #1079: ALTER TABLE does not add foreign key

2004-02-11 Thread Richard Huxton
On Wednesday 11 February 2004 17:29, PostgreSQL Bugs List wrote: > The following bug has been logged online: > > Bug reference: 1079 > Logged by: Vladimir Sitarchuk > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.3 > Operating system: Red Hat 9 > Description:

[BUGS] BUG #1080: Ref #1045 resolved

2004-02-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1080 Logged by: Josh Rovero Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: HP-UX 11.11 (aka 11i) Description:Ref #1045 resolved Details: Error "psql: could not translate host n

Re: [BUGS] I find a bug (IMHO)

2004-02-11 Thread Bruce Momjian
Tom Lane wrote: > Danger Dancer <[EMAIL PROTECTED]> writes: > > #little example > > create table a (d int check (d<5)); > > create table b () inherits (a); > > alter table b drop constraint "a_d"; > > I think the bug is that it allowed you to do this. You should not be > able to drop an inherited