Karel Zak - Zakkr <zakkr@zf.jcu.cz> writes:
> What is changed on INSERT/max() in v7.0? (CVS - today).
> template1=> INSERT INTO pg_group VALUES ('abg_root', max(grosysid)+1, '{}');
> ERROR: attribute 'grosysid' not found
That's the way it should work, AFAICS. VALUES() isn't supposed to
contain anything except constant expressions. Perhaps what you are
after would be more properly expressed as
INSERT INTO pg_group SELECT 'abg_root', max(grosysid)+1, '{}' FROM pg_group;
6.5 may have accepted the other, but it was an artifact of extremely
broken code...
regards, tom lane