The Samba-Bugzilla – Attachment 1201 Details for
Bug 2334
[patch] pgsql passdb case sensitive for machine accounts
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Trigger to lowercase usernames on insert/update.
samba_trigger.sql (text/plain), 325 bytes, created by
Fernando Schapachnik
on 2005-05-02 06:15:59 UTC
(
hide
)
Description:
Trigger to lowercase usernames on insert/update.
Filename:
MIME Type:
Creator:
Fernando Schapachnik
Created:
2005-05-02 06:15:59 UTC
Size:
325 bytes
patch
obsolete
>CREATE OR REPLACE FUNCTION lowercase_usename() RETURNS TRIGGER AS ' > DECLARE > cant INTEGER:= 0; > BEGIN > NEW.username= lower(NEW.username); > RETURN NEW; > END; >' LANGUAGE 'plpgsql'; > >CREATE TRIGGER tr_lowercase_usename BEFORE INSERT OR UPDATE ON TABLE >FOR EACH ROW EXECUTE PROCEDURE lowercase_usename();
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=1201">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 2334
:
963
| 1201