LexDbFunctions

The LexDB uses a PostgreSQL database to provide a source of lexical items for client applications such as the LKB. This page provides a description of the internal (but "public") database functions used by a client connected to the LexDB. See also LexDbInternals for some documentation on the structure of the database itself.

check_psql_server_version RETURNS SETOF text

Returns nothing if psql server version is compatible with the LexDB. Else returns message text.

clear_rev() RETURNS boolean

Empty rev and rev_key tables. Register updated modstamp.

Returns t.

commit_rev(user text) RETURNS boolean

Call as user lexdb.

Update public schema with contents of rev and rev_key. Register updated modstamp.

Does NOT empty contents of rev and rev_key. Call clear_rev() as standard user to do this.

Returns t.

complete('''field''' text,'''val''' text) RETURNS SETOF text

Returns possible completions of val amongst values taken by field in table lex.

current_timestamp() RETURNS text

Returns current timestamp.

db_owner() RETURNS text

Returns name of database owner (default lexdb).

TO DO...

• dump_public_rev_rev_key_to_tmp_tmp_key filter initialize_user_schema lex_id_set lexdb_version list_fld lookup_general lookup_general_null lookup_word merge_dfn_from_tmp_dfn merge_public_rev_rev_key_from_tmp_tmp_key mneum_f_map orthography_set register_modstamp retrieve_all_entries retrieve_entries_by_orthkey retrieve_entry retrieve_head_entry retrieve_private_revs retrieve_semi_extra retrieve_semi_frame retrieve_semi_pred retrieve_semi_var return_field_info2 rev_key_p rev_new semi_out_of_date semi_setup_post semi_setup_pre semi_up_to_date_p

---

⚠️