diff options
| author | Bruce Momjian <bruce@momjian.us> | 1997-11-05 21:38:25 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1997-11-05 21:38:25 +0000 |
| commit | 951986c550dccfdafffcf2eda30980c7310b41b4 (patch) | |
| tree | 9bd4eb75a2c8cdc96e72cd5675c0a398d9c3659c /contrib/userlock/user_locks.sql.in | |
| parent | 5aaf00f3f39848eb8fef768e3ec8c0e816a87172 (diff) | |
| download | postgresql-951986c550dccfdafffcf2eda30980c7310b41b4.tar.gz | |
Update of contrib stuff from massimo.
Diffstat (limited to 'contrib/userlock/user_locks.sql.in')
| -rw-r--r-- | contrib/userlock/user_locks.sql.in | 69 |
1 files changed, 69 insertions, 0 deletions
diff --git a/contrib/userlock/user_locks.sql.in b/contrib/userlock/user_locks.sql.in new file mode 100644 index 0000000000..da8d105de9 --- /dev/null +++ b/contrib/userlock/user_locks.sql.in @@ -0,0 +1,69 @@ +-- SQL code to define the user locks functions + +-- select user_lock(group,id,type); +-- +create function user_lock(int4,int4,int4) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_unlock(group,id,type); +-- +create function user_unlock(int4,int4,int4) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_write_lock(group,id); +-- +create function user_write_lock(int4,int4) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_write_unlock(group,id); +-- +create function user_write_unlock(int4,int4) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_write_lock(group,oid); +-- +create function user_write_lock(int4,oid) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_write_unlock(group,oid); +-- +create function user_write_unlock(int4,oid) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_write_lock_oid(oid); +-- +create function user_write_lock_oid(oid) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_write_unlock_oid(oid); +-- +create function user_write_unlock_oid(oid) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_write_lock_oid(int4); +-- +create function user_write_lock_oid(int4) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_write_unlock_oid(int4); +-- +create function user_write_unlock_oid(int4) returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- select user_unlock_all(); +-- +create function user_unlock_all() returns int4 + as 'MODULE_PATHNAME' + language 'c'; + +-- end of file |
