| From: | Vams <vmudrageda(at)charter(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: plpgsql - Inserting DEFAULT Value. |
| Date: | 2004-06-21 16:32:57 |
| Message-ID: | 200406211232.57297.vmudrageda@charter.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sunday 20 June 2004 03:37 pm, Tom Lane wrote:
> Consider passing the appropriate sequence name to the function as a
> trigger parameter.
That was going to be a last resort. So there is no way to access the DEFAULT
value that a column would get if no value or a DEFAULT was sent in an insert?
How about removing a column value so that the default action would be
performed. Like someone would "INSERT ... VALUES (1234, ...);" and I would
remove the 1234 or something similar so that the INSERT would activate the
default constraint for the column?
Thx,
Vams
PS. I tried to post much sooner (like a week ago), but for some reason I was
unable to. I emailed the admins and whoever dropped the restriction, thank
you very much.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2004-06-21 16:55:40 | Re: JDBC driver inserting into a table with Bytea type gets out of |
| Previous Message | Richard Huxton | 2004-06-21 16:26:59 | Re: New to the list; would this be an okay question? |