"Nathalie Boulos" <[EMAIL PROTECTED]> writes:
> When i insert a value into a field in the table directly, all the other
> fields take their default values normaly, but the problem is if i insert
> into the rule and not into the table, all the fields who has default values
> do not take them. those fields remains empty.
> So the default value does not work if i insert into a rule ???
A rule has its own defaults --- set them with ALTER TABLE rule SET DEFAULT.
(IIRC this works since about 7.2; it won't work on old Postgresen.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
