File: set_user--2.0--3.0.sql

package info (click to toggle)
postgresql-set-user 4.1.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 296 kB
  • sloc: ansic: 714; sql: 249; makefile: 36; sh: 1
file content (13 lines) | stat: -rw-r--r-- 421 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
/* set-user-2.0--3.0.sql */

SET LOCAL search_path to @extschema@;

-- complain if script is sourced in psql, rather than via ALTER EXTENSION
\echo Use "ALTER EXTENSION set_user UPDATE to '3.0'" to load this file. \quit

CREATE FUNCTION @extschema@.set_session_auth(text)
RETURNS text
AS 'MODULE_PATHNAME', 'set_session_auth'
LANGUAGE C STRICT;

REVOKE EXECUTE ON FUNCTION @extschema@.set_session_auth(text) FROM PUBLIC;