I agree it's not worth the effort, just found it "interesting" (duh)
and hastily sent a bugreport before checking upstream.
[off]
Another interesting story was 7.3 silently discarding unneeded
typecasts: create a view with a field ('a' || 'b')::varchar. The same
definition worked in 7.3 and 7.4 (b
Neil Conway <[EMAIL PROTECTED]> writes:
> Szűcs Gábor wrote:
>> Check constraints:
>> "foobar" CHECK ()
> Yeah, I can repro this with current REL7_4_STABLE sources, but it looks
> fixed in HEAD and REL8_0_STABLE.
I think the reason is that 7.4 applies make_ands_implicit before storing
the constr
SzÅcs GÃbor wrote:
# create table foo (bar int, constraint foobar check (true));
CREATE TABLE
# \d foo
Table "public.foo"
Column | Type | Modifiers
+-+---
bar| integer |
Check constraints:
"foobar" CHECK ()
Yeah, I can repro this with current REL7_4_STABLE
Dear Gurus,
Version: 7.3.3, 7.4.8
I don't know for sure, but something like this happened when dumping our
server from 7.3 to 7.4. Actually, it seems to be a problem in 7.4 (maybe
also in 7.3, but unlikely -- see below, "our original way").
# create table foo (bar int, constraint foobar check (t
