Le 14/02/2011 22:28, Guillaume Lelarge a écrit : > Le 14/02/2011 21:51, A.M. a écrit : >> [...] >> I am using ALTER VIEW x ALTER COLUMN y SET DEFAULT defaultclause, but the >> defaults do not seem to appear in the pgadmin generated SQL for the view. Is >> this a deliberate omission? psql does display view column defaults: >> > > Mainly because it was forgotten. I checked, it's available since 8.4. > Should be an easy patch (once someone found the time to work on it :) ). >
Seems I was totally wrong. pgAdmin supports default values for columns in views since quite some time (at least 1.12). It doesn't use the ALTER VIEW statement, but the ALTER TABLE one. I don't think we really need to change this right now. It works and that's good enough for me. Can you check your release and see if you have the ALTER TABLE statement? it should be after the ALTER TABLE that sets the owner. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
