Обсуждение: default value
Hi, i have a problem with the default value: 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 ??? I would greatly appreciate any feedback Regards Nathalie _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
"Nathalie Boulos" <nathalieboulos@hotmail.com> 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