diff options
| author | Bruce Momjian | 1999-12-12 05:57:36 +0000 |
|---|---|---|
| committer | Bruce Momjian | 1999-12-12 05:57:36 +0000 |
| commit | cb00b7faa5849d8460198f7ced1cfdd0a92cfe53 (patch) | |
| tree | d389b1907364124e8c6703af287ed0e593d06446 /src/include | |
| parent | 11023eb1f5bd4fe6ddff652957848437b5d16f14 (diff) | |
I'm in TODO mood today ...
* Document/trigger/rule so changes to pg_shadow recreate pg_pwd
I did it with a trigger and it seems to work like a charm. The function
that already updates the file for create and alter user has been made a
built-in "SQL" function and a trigger is created at initdb time.
Comments around the pg_pwd updating function seem to be worried about
this
routine being called concurrently, but I really don't see a reason to
worry about this. Verify for yourself. I guess we never had a system
trigger before, so treat this with care, and feel free to adjust the
nomenclature as well.
--
Peter Eisentraut Sernanders väg 10:115
Diffstat (limited to 'src/include')
| -rw-r--r-- | src/include/catalog/pg_proc.h | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index 9e9f01b3fd7..05cdd7f6b3e 100644 --- a/src/include/catalog/pg_proc.h +++ b/src/include/catalog/pg_proc.h @@ -6,7 +6,7 @@ * * Copyright (c) 1994, Regents of the University of California * - * $Id: pg_proc.h,v 1.108 1999/12/01 18:03:26 momjian Exp $ + * $Id: pg_proc.h,v 1.109 1999/12/12 05:57:36 momjian Exp $ * * NOTES * The script catalog/genbki.sh reads this file and generates .bki @@ -93,6 +93,8 @@ typedef FormData_pg_proc *Form_pg_proc; /* keep the following ordered by OID so that later changes can be made easier */ /* OIDS 1 - 99 */ +DATA(insert OID = 12 ( update_pg_pwd PGUID 11 f t f 0 f 0 "" 100 0 0 100 update_pg_pwd - )); +DESCR("update pg_pwd file"); DATA(insert OID = 1242 ( boolin PGUID 11 f t t 1 f 16 "0" 100 0 0 100 boolin - )); DESCR("(internal)"); |