On Mar 6, 2011, at 9:29 AM, Guillaume Lelarge wrote: > 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.
I can confirm that is indeed the case- thanks for pointing that out. The column defaults appear between the ACLs and rules. Cheers, M -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
