Joe Van Dyk wrote: > I have an index on a column that can be nullable. I decide the column > shouldn't be nullable anymore. So I alter the column to be not > nullable. > > That "alter column" query does a full table scan, which can be painful > for large tables. Couldn't that index be used instead? Interesting idea, but I'm pretty sure we don't yet have such logic. -Kevin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
