> "Donald Fraser" <[EMAIL PROTECTED]> writes: > > What would be nice is when you don't specify a default on the view, the default > > from the table is used. > > What table? You seem to have an extremely narrow-minded concept of what > a view is. > > regards, tom lane
In the above I was referring to columns that have a direct relationship with an underlying table. Obviously when a column does not have this relationship then a default from a table cannot be used. If have I overlooked something fundamental about views that makes this idea sound ridiculous then I apologise for my ignorance. Regards, Donald Fraser ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org