Re: [HACKERS] Can't cast bigint to smallint?

2001-10-25 Thread Tom Lane
Philip Warner <[EMAIL PROTECTED]> writes: > The problem in in the code to re-enable triggers: > ...reltriggers = (select Count(*) > So perhaps this version now has Count returning a bigint rather than an int? Okay, I've added conversion functions for int8-to-int2 and vice versa.

Re: [HACKERS] Can't cast bigint to smallint?

2001-10-24 Thread Philip Warner
At 19:41 24/10/01 -0400, Tom Lane wrote: >We just had one earlier this week, so I suppose another wouldn't make >all that much difference. Comments? My pref would be for the initdb; the current situation may break (other) existing apps. -

Re: [HACKERS] Can't cast bigint to smallint?

2001-10-24 Thread Philip Warner
At 16:09 24/10/01 -0400, Tom Lane wrote: > >Huh? There's never been a cast from int8 to int2. I checked 7.0 and >7.1, they both complain as well: > Is this a policy decision, or just a case where noone has had a chance to do it? >Where exactly is pg_dump failing? > The problem in in the code

Re: [HACKERS] Can't cast bigint to smallint?

2001-10-24 Thread Tom Lane
Philip Warner <[EMAIL PROTECTED]> writes: > At 16:09 24/10/01 -0400, Tom Lane wrote: >> Huh? There's never been a cast from int8 to int2. I checked 7.0 and >> 7.1, they both complain as well: > Is this a policy decision, or just a case where noone has had a chance to > do it? Just a missing fe

Re: [HACKERS] Can't cast bigint to smallint?

2001-10-24 Thread Tom Lane
Philip Warner <[EMAIL PROTECTED]> writes: > The minor featurette seems to have crept into current sources; it is > probably the cause of pg_dump being unable to reinstate disabled triggers. Huh? There's never been a cast from int8 to int2. I checked 7.0 and 7.1, they both complain as well: tes

[HACKERS] Can't cast bigint to smallint?

2001-10-24 Thread Philip Warner
The minor featurette seems to have crept into current sources; it is probably the cause of pg_dump being unable to reinstate disabled triggers. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |--