| From: | "Richard Huxton" <dev(at)archonet(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | RFC: automatic "lastchange" timestamp updater module |
| Date: | 2001-02-15 13:16:10 |
| Message-ID: | 004101c09751$79c9fe40$1001a8c0@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
A little while ago there was a question about how to automatically update a
timestamp so I drafted the attached code.
NOTE - you need 7.1beta to use the attached code and plpgsql enabled on your
db.
I'm interested in any comments on the attached before I submit it for
possible inclusion in contrib/ (or wherever).
I'm especially interested in any comments on the readme/tutorial from
newbies who haven't experimented with plpgsql before (like me a few weeks
ago). Is it clear enough? Would you prefer HTML?
Also - any special requests for another module? I was thinking of some
functions to provide friendlier access to the system tables (index details,
triggers on a table etc)
PS - developers - where should I submit this stuff to if people like it?
pgsql-doc?
TIA
- Richard Huxton
| Attachment | Content-Type | Size |
|---|---|---|
| lastchange-install.sql | application/octet-stream | 1.5 KB |
| lastchange-README.txt | text/plain | 3.2 KB |
| lastchange-remove.sql | application/octet-stream | 121 bytes |
| lastchange-tutorial.txt | text/plain | 3.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-02-15 13:35:56 | Re: replica question |
| Previous Message | pejac | 2001-02-15 13:12:25 | re : Re: what means |