2003-03-25 18:42:01 [3525]   DEBUG:  /usr/bin/postmaster: PostmasterMain: initial environ dump:
2003-03-25 18:42:01 [3525]   DEBUG:  -----------------------------------------
2003-03-25 18:42:01 [3525]   DEBUG:  	SSH_AGENT_PID=978
2003-03-25 18:42:01 [3525]   DEBUG:  	HOSTNAME=dostoievsky
2003-03-25 18:42:01 [3525]   DEBUG:  	PVM_RSH=/usr/bin/rsh
2003-03-25 18:42:01 [3525]   DEBUG:  	SHELL=/bin/bash
2003-03-25 18:42:01 [3525]   DEBUG:  	TERM=xterm
2003-03-25 18:42:01 [3525]   DEBUG:  	HISTSIZE=1000
2003-03-25 18:42:01 [3525]   DEBUG:  	GTK_RC_FILES=/etc/gtk/gtkrc:/home/adrpo/.gtkrc-1.2-gnome2
2003-03-25 18:42:01 [3525]   DEBUG:  	WINDOWID=20971661
2003-03-25 18:42:01 [3525]   DEBUG:  	QTDIR=/usr/lib/qt3-gcc3.2
2003-03-25 18:42:01 [3525]   DEBUG:  	USER=adrpo
2003-03-25 18:42:01 [3525]   DEBUG:  	LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
2003-03-25 18:42:01 [3525]   DEBUG:  	PVM_ROOT=/usr/share/pvm3
2003-03-25 18:42:01 [3525]   DEBUG:  	SSH_AUTH_SOCK=/tmp/ssh-XXthYiDO/agent.929
2003-03-25 18:42:01 [3525]   DEBUG:  	SESSION_MANAGER=local/dostoievsky:/tmp/.ICE-unix/929
2003-03-25 18:42:01 [3525]   DEBUG:  	SMLNJ_PATH=/home/adrpo/sml
2003-03-25 18:42:01 [3525]   DEBUG:  	MAIL=/var/spool/mail/adrpo
2003-03-25 18:42:01 [3525]   DEBUG:  	PATH=/usr/kerberos/bin:/usr/local/Acrobat5/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/adrpo/rml-2.1.8/x86-linux-gcc/bin:/home/adrpo/sml/bin:/home/adrpo/bin:/home/adrpo/rml-2.1.8/x86-linux-gcc/bin:/home/adrpo/sml/bin
2003-03-25 18:42:01 [3525]   DEBUG:  	INPUTRC=/etc/inputrc
2003-03-25 18:42:01 [3525]   DEBUG:  	PWD=/home/adrpo/postgresql/bin
2003-03-25 18:42:01 [3525]   DEBUG:  	XMODIFIERS=@im=none
2003-03-25 18:42:01 [3525]   DEBUG:  	LANG=en_US.UTF-8
2003-03-25 18:42:01 [3525]   DEBUG:  	LAMHELPFILE=/etc/lam/lam-helpfile
2003-03-25 18:42:01 [3525]   DEBUG:  	GDMSESSION=Default
2003-03-25 18:42:01 [3525]   DEBUG:  	SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
2003-03-25 18:42:01 [3525]   DEBUG:  	HOME=/home/adrpo
2003-03-25 18:42:01 [3525]   DEBUG:  	SHLVL=4
2003-03-25 18:42:01 [3525]   DEBUG:  	XPVM_ROOT=/usr/share/pvm3/xpvm
2003-03-25 18:42:01 [3525]   DEBUG:  	GNOME_DESKTOP_SESSION_ID=Default
2003-03-25 18:42:01 [3525]   DEBUG:  	LOGNAME=adrpo
2003-03-25 18:42:01 [3525]   DEBUG:  	PGDATA=/home/adrpo/postgresql/data/
2003-03-25 18:42:01 [3525]   DEBUG:  	LESSOPEN=|/usr/bin/lesspipe.sh %s
2003-03-25 18:42:01 [3525]   DEBUG:  	DISPLAY=:0
2003-03-25 18:42:01 [3525]   DEBUG:  	G_BROKEN_FILENAMES=1
2003-03-25 18:42:01 [3525]   DEBUG:  	COLORTERM=gnome-terminal
2003-03-25 18:42:01 [3525]   DEBUG:  	XAUTHORITY=/home/adrpo/.Xauthority
2003-03-25 18:42:01 [3525]   DEBUG:  	_=/usr/bin/postmaster
2003-03-25 18:42:01 [3525]   DEBUG:  -----------------------------------------
2003-03-25 18:42:01 [3525]   DEBUG:  FindExec: found "/usr/bin/postgres" using argv[0]
2003-03-25 18:42:01 [3525]   DEBUG:  invoking IpcMemoryCreate(size=1466368)
2003-03-25 18:42:01 [3525]   DEBUG:  FindExec: found "/usr/bin/postmaster" using argv[0]
2003-03-25 18:42:01 [3527]   LOG:  database system was shut down at 2003-03-25 18:41:35 CET
2003-03-25 18:42:01 [3527]   LOG:  checkpoint record is at 0/904D30
2003-03-25 18:42:01 [3527]   LOG:  redo record is at 0/904D30; undo record is at 0/0; shutdown TRUE
2003-03-25 18:42:01 [3527]   LOG:  next transaction id: 568; next oid: 25171
2003-03-25 18:42:01 [3527]   LOG:  database system is ready
2003-03-25 18:42:01 [3527]   DEBUG:  proc_exit(0)
2003-03-25 18:42:01 [3527]   DEBUG:  shmem_exit(0)
2003-03-25 18:42:01 [3527]   DEBUG:  exit(0)
2003-03-25 18:42:01 [3525]   DEBUG:  reaping dead processes
2003-03-25 18:42:25 [3525]   DEBUG:  BackendStartup: forked pid=3531 socket=8
2003-03-25 18:42:25 [3531]   LOG:  connection received: host=127.0.0.1 port=33434
2003-03-25 18:42:25 [3531]   LOG:  connection authorized: user=pgadmin database=ida
2003-03-25 18:42:25 [3531]   DEBUG:  /usr/bin/postmaster child[3531]: starting with (
2003-03-25 18:42:25 [3531]   DEBUG:  	postgres
2003-03-25 18:42:25 [3531]   DEBUG:  	-v131072
2003-03-25 18:42:25 [3531]   DEBUG:  	-p
2003-03-25 18:42:25 [3531]   DEBUG:  	ida
2003-03-25 18:42:25 [3531]   DEBUG:  )
2003-03-25 18:42:25 [3531]   DEBUG:  InitPostgres
2003-03-25 18:42:25 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: begin; select getdatabaseencoding(); commit
2003-03-25 18:42:25 [3531]   LOG:  query: begin; select getdatabaseencoding(); commit
2003-03-25 18:42:25 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:25 [3531]   LOG:  statement: begin; select getdatabaseencoding(); commit
2003-03-25 18:42:25 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: begin; select getdatabaseencoding(); commit
2003-03-25 18:42:25 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: begin; select getdatabaseencoding(); commit
2003-03-25 18:42:25 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:25 [3531]   LOG:  statement: begin; select getdatabaseencoding(); commit
2003-03-25 18:42:25 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:25 [3531]   LOG:  statement: begin; select getdatabaseencoding(); commit
2003-03-25 18:42:25 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: begin; select getdatabaseencoding(); commit
2003-03-25 18:42:25 [3531]   LOG:  duration: 0.008674 sec
2003-03-25 18:42:25 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: drop sequence g_sqtranslate;
2003-03-25 18:42:25 [3531]   LOG:  query: drop sequence g_sqtranslate;
2003-03-25 18:42:25 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:25 [3531]   LOG:  statement: drop sequence g_sqtranslate;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to type g_sqtranslate
2003-03-25 18:42:25 [3531]   LOG:  statement: drop sequence g_sqtranslate;
2003-03-25 18:42:25 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: drop sequence g_sqtranslate;
2003-03-25 18:42:25 [3531]   LOG:  duration: 0.079556 sec
2003-03-25 18:42:25 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: create sequence g_sqtranslate;
2003-03-25 18:42:25 [3531]   LOG:  query: create sequence g_sqtranslate;
2003-03-25 18:42:25 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:25 [3531]   LOG:  statement: create sequence g_sqtranslate;
2003-03-25 18:42:25 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: create sequence g_sqtranslate;
2003-03-25 18:42:25 [3531]   LOG:  duration: 0.023250 sec
2003-03-25 18:42:25 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   LOG:  query: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to toast table pg_toast.pg_toast_17043
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to type pg_toast.pg_toast_17043
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to index pg_toast.pg_toast_17043_index
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to type g_translate
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   NOTICE:  Drop cascades to constraint p_c_title_fk_name_id on table p_title
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17086 on table g_translate
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17085 on table g_translate
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17084 on table p_title
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   NOTICE:  Drop cascades to constraint p_c_titletype_fk_name_id on table p_titletype
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17067 on table g_translate
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17066 on table g_translate
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17065 on table p_titletype
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to constraint g_translate_pkey on table g_translate
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  Drop auto-cascades to index g_translate_pkey
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: drop table g_translate cascade;
2003-03-25 18:42:25 [3531]   LOG:  duration: 0.087321 sec
2003-03-25 18:42:25 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: create table g_translate
(
	id	bigint	not null primary key,
	name_en	text	null,
        name_sv text	null,
        name_ro text	null
);
2003-03-25 18:42:25 [3531]   LOG:  query: create table g_translate
(
	id	bigint	not null primary key,
	name_en	text	null,
        name_sv text	null,
        name_ro text	null
);
2003-03-25 18:42:25 [3531]   NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'g_translate_pkey' for table 'g_translate'
2003-03-25 18:42:25 [3531]   LOG:  statement: create table g_translate
(
	id	bigint	not null primary key,
	name_en	text	null,
        name_sv text	null,
        name_ro text	null
);
2003-03-25 18:42:25 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:25 [3531]   LOG:  statement: create table g_translate
(
	id	bigint	not null primary key,
	name_en	text	null,
        name_sv text	null,
        name_ro text	null
);
2003-03-25 18:42:25 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:25 [3531]   LOG:  statement: create table g_translate
(
	id	bigint	not null primary key,
	name_en	text	null,
        name_sv text	null,
        name_ro text	null
);
2003-03-25 18:42:25 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:25 [3531]   LOG:  statement: create table g_translate
(
	id	bigint	not null primary key,
	name_en	text	null,
        name_sv text	null,
        name_ro text	null
);
2003-03-25 18:42:25 [3531]   LOG:  duration: 0.070468 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: insert into g_translate(id, name_en, name_sv, name_ro) values(0, 'No translation available', 'No translation available', 'No translation available');
2003-03-25 18:42:26 [3531]   LOG:  query: insert into g_translate(id, name_en, name_sv, name_ro) values(0, 'No translation available', 'No translation available', 'No translation available');
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:26 [3531]   LOG:  statement: insert into g_translate(id, name_en, name_sv, name_ro) values(0, 'No translation available', 'No translation available', 'No translation available');
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: insert into g_translate(id, name_en, name_sv, name_ro) values(0, 'No translation available', 'No translation available', 'No translation available');
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.009106 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: drop FUNCTION g_in_t(text,text);
2003-03-25 18:42:26 [3531]   LOG:  query: drop FUNCTION g_in_t(text,text);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: drop FUNCTION g_in_t(text,text);
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: drop FUNCTION g_in_t(text,text);
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.005880 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: CREATE FUNCTION g_in_t(text,text) RETURNS bigint AS
   'DECLARE
	id bigint;
    BEGIN
	select nextval(''g_sqtranslate'') into id;
	insert into g_translate values(id, $1, $2, $2);
	RETURN id;
    END;'
   language 'plpgsql';
2003-03-25 18:42:26 [3531]   LOG:  query: CREATE FUNCTION g_in_t(text,text) RETURNS bigint AS
   'DECLARE
	id bigint;
    BEGIN
	select nextval(''g_sqtranslate'') into id;
	insert into g_translate values(id, $1, $2, $2);
	RETURN id;
    END;'
   language 'plpgsql';
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: CREATE FUNCTION g_in_t(text,text) RETURNS bigint AS
   'DECLARE
	id bigint;
    BEGIN
	select nextval(''g_sqtranslate'') into id;
	insert into g_translate values(id, $1, $2, $2);
	RETURN id;
    END;'
   language 'plpgsql';
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: CREATE FUNCTION g_in_t(text,text) RETURNS bigint AS
   'DECLARE
	id bigint;
    BEGIN
	select nextval(''g_sqtranslate'') into id;
	insert into g_translate values(id, $1, $2, $2);
	RETURN id;
    END;'
   language 'plpgsql';
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.006485 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: drop FUNCTION g_out_t(text, bigint);
2003-03-25 18:42:26 [3531]   LOG:  query: drop FUNCTION g_out_t(text, bigint);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: drop FUNCTION g_out_t(text, bigint);
2003-03-25 18:42:26 [3531]   ERROR:  RemoveFunction: function g_out_t(text, bigint) does not exist
2003-03-25 18:42:26 [3531]   LOG:  statement: drop FUNCTION g_out_t(text, bigint);
2003-03-25 18:42:26 [3531]   DEBUG:  AbortCurrentTransaction
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: CREATE FUNCTION g_out_t(text, bigint) RETURNS text AS
   'DECLARE
	t text;
	key text;
        b_en boolean;
        b_sv boolean;
        b_ro boolean;
    BEGIN
        select ($1 = ''en'') into b_en;
        select ($1 = ''sv'') into b_sv;
        select ($1 = ''ro'') into b_ro;
        if (b_en) then
	SELECT name_en from g_translate where id=$2 INTO t;
        end if;
        if (b_sv) then
	SELECT name_sv from g_translate where id=$2 INTO t;
        end if;
        if (b_ro) then
	SELECT name_ro from g_translate where id=$2 INTO t;
        end if;
	RETURN t;
    END;'
drop FUNCTION p_in_title(text,text,text);
2003-03-25 18:42:26 [3531]   LOG:  query: CREATE FUNCTION g_out_t(text, bigint) RETURNS text AS
   'DECLARE
	t text;
	key text;
        b_en boolean;
        b_sv boolean;
        b_ro boolean;
    BEGIN
        select ($1 = ''en'') into b_en;
        select ($1 = ''sv'') into b_sv;
        select ($1 = ''ro'') into b_ro;
        if (b_en) then
	SELECT name_en from g_translate where id=$2 INTO t;
        end if;
        if (b_sv) then
	SELECT name_sv from g_translate where id=$2 INTO t;
        end if;
        if (b_ro) then
	SELECT name_ro from g_translate where id=$2 INTO t;
        end if;
	RETURN t;
    END;'
drop FUNCTION p_in_title(text,text,text);
2003-03-25 18:42:26 [3531]   ERROR:  parser: parse error at or near "drop" at character 580
2003-03-25 18:42:26 [3531]   LOG:  statement: CREATE FUNCTION g_out_t(text, bigint) RETURNS text AS
   'DECLARE
	t text;
	key text;
        b_en boolean;
        b_sv boolean;
        b_ro boolean;
    BEGIN
        select ($1 = ''en'') into b_en;
        select ($1 = ''sv'') into b_sv;
        select ($1 = ''ro'') into b_ro;
        if (b_en) then
	SELECT name_en from g_translate where id=$2 INTO t;
        end if;
        if (b_sv) then
	SELECT name_sv from g_translate where id=$2 INTO t;
        end if;
        if (b_ro) then
	SELECT name_ro from g_translate where id=$2 INTO t;
        end if;
	RETURN t;
    END;'
drop FUNCTION p_in_title(text,text,text);
2003-03-25 18:42:26 [3531]   DEBUG:  AbortCurrentTransaction
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: CREATE FUNCTION p_in_title(text,text,text) RETURNS bigint AS
   'DECLARE
	zid bigint;
    BEGIN
	select nextval(''p_sqtitle'') into zid;
	insert into p_title values(zid, $1, g_in_t($2, $3));
	RETURN zid;
    END;'
   language 'plpgsql';
2003-03-25 18:42:26 [3531]   LOG:  query: CREATE FUNCTION p_in_title(text,text,text) RETURNS bigint AS
   'DECLARE
	zid bigint;
    BEGIN
	select nextval(''p_sqtitle'') into zid;
	insert into p_title values(zid, $1, g_in_t($2, $3));
	RETURN zid;
    END;'
   language 'plpgsql';
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: CREATE FUNCTION p_in_title(text,text,text) RETURNS bigint AS
   'DECLARE
	zid bigint;
    BEGIN
	select nextval(''p_sqtitle'') into zid;
	insert into p_title values(zid, $1, g_in_t($2, $3));
	RETURN zid;
    END;'
   language 'plpgsql';
2003-03-25 18:42:26 [3531]   ERROR:  function p_in_title already exists with same argument types
2003-03-25 18:42:26 [3531]   LOG:  statement: CREATE FUNCTION p_in_title(text,text,text) RETURNS bigint AS
   'DECLARE
	zid bigint;
    BEGIN
	select nextval(''p_sqtitle'') into zid;
	insert into p_title values(zid, $1, g_in_t($2, $3));
	RETURN zid;
    END;'
   language 'plpgsql';
2003-03-25 18:42:26 [3531]   DEBUG:  AbortCurrentTransaction
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   LOG:  query: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to type p_person
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   NOTICE:  Drop cascades to constraint p_c_p2title_fk_person_code on table p_p2title
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17101 on table p_person
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17100 on table p_person
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17099 on table p_p2title
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to constraint p_person_pkey on table p_person
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to index p_person_pkey
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to index p_ndxperson0
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to index p_ndxperson1
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to index p_ndxperson2
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_person cascade;
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.061279 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_person
(
	code            varchar(200)    not null primary key,
	firstname	varchar(80)     not null,
	lastname	varchar(80)     not null,
	personalno	varchar(15)     null,
        schedule_code   varchar(200)    null,
        doorkey         varchar(500)    null
);
2003-03-25 18:42:26 [3531]   LOG:  query: create table p_person
(
	code            varchar(200)    not null primary key,
	firstname	varchar(80)     not null,
	lastname	varchar(80)     not null,
	personalno	varchar(15)     null,
        schedule_code   varchar(200)    null,
        doorkey         varchar(500)    null
);
2003-03-25 18:42:26 [3531]   NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'p_person_pkey' for table 'p_person'
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_person
(
	code            varchar(200)    not null primary key,
	firstname	varchar(80)     not null,
	lastname	varchar(80)     not null,
	personalno	varchar(15)     null,
        schedule_code   varchar(200)    null,
        doorkey         varchar(500)    null
);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_person
(
	code            varchar(200)    not null primary key,
	firstname	varchar(80)     not null,
	lastname	varchar(80)     not null,
	personalno	varchar(15)     null,
        schedule_code   varchar(200)    null,
        doorkey         varchar(500)    null
);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_person
(
	code            varchar(200)    not null primary key,
	firstname	varchar(80)     not null,
	lastname	varchar(80)     not null,
	personalno	varchar(15)     null,
        schedule_code   varchar(200)    null,
        doorkey         varchar(500)    null
);
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_person
(
	code            varchar(200)    not null primary key,
	firstname	varchar(80)     not null,
	lastname	varchar(80)     not null,
	personalno	varchar(15)     null,
        schedule_code   varchar(200)    null,
        doorkey         varchar(500)    null
);
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.049213 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create index p_ndxperson0 on p_person
(
	firstname
);
2003-03-25 18:42:26 [3531]   LOG:  query: create index p_ndxperson0 on p_person
(
	firstname
);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: create index p_ndxperson0 on p_person
(
	firstname
);
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create index p_ndxperson0 on p_person
(
	firstname
);
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.006631 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create index p_ndxperson1 on p_person
(
	lastname
);
2003-03-25 18:42:26 [3531]   LOG:  query: create index p_ndxperson1 on p_person
(
	lastname
);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: create index p_ndxperson1 on p_person
(
	lastname
);
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create index p_ndxperson1 on p_person
(
	lastname
);
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.006891 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create index p_ndxperson2 on p_person
(
	personalno
);
2003-03-25 18:42:26 [3531]   LOG:  query: create index p_ndxperson2 on p_person
(
	personalno
);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: create index p_ndxperson2 on p_person
(
	personalno
);
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create index p_ndxperson2 on p_person
(
	personalno
);
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.007138 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   LOG:  query: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to type p_titletype
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   NOTICE:  Drop cascades to constraint p_c_title_fk_type_code on table p_title
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17090 on table p_titletype
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17089 on table p_titletype
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17088 on table p_title
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to constraint p_titletype_pkey on table p_titletype
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to index p_titletype_pkey
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  Drop auto-cascades to default for table p_titletype column name_id
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: drop table p_titletype cascade;
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.086820 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_titletype
(
	code		varchar(500)	not null primary key,
	name_id      bigint not null default 0,
	constraint p_c_titletype_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:26 [3531]   LOG:  query: create table p_titletype
(
	code		varchar(500)	not null primary key,
	name_id      bigint not null default 0,
	constraint p_c_titletype_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:26 [3531]   NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'p_titletype_pkey' for table 'p_titletype'
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_titletype
(
	code		varchar(500)	not null primary key,
	name_id      bigint not null default 0,
	constraint p_c_titletype_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:26 [3531]   NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_titletype
(
	code		varchar(500)	not null primary key,
	name_id      bigint not null default 0,
	constraint p_c_titletype_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_titletype
(
	code		varchar(500)	not null primary key,
	name_id      bigint not null default 0,
	constraint p_c_titletype_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_titletype
(
	code		varchar(500)	not null primary key,
	name_id      bigint not null default 0,
	constraint p_c_titletype_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_titletype
(
	code		varchar(500)	not null primary key,
	name_id      bigint not null default 0,
	constraint p_c_titletype_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: create table p_titletype
(
	code		varchar(500)	not null primary key,
	name_id      bigint not null default 0,
	constraint p_c_titletype_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:26 [3531]   LOG:  duration: 0.391289 sec
2003-03-25 18:42:26 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: insert into p_titletype(code, name_id) values('--', g_in_t('None', 'sv None'));
2003-03-25 18:42:26 [3531]   LOG:  query: insert into p_titletype(code, name_id) values('--', g_in_t('None', 'sv None'));
2003-03-25 18:42:26 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:26 [3531]   LOG:  statement: insert into p_titletype(code, name_id) values('--', g_in_t('None', 'sv None'));
2003-03-25 18:42:26 [3531]   LOG:  query: SELECT  nextval('g_sqtranslate')
2003-03-25 18:42:26 [3531]   LOG:  query: insert into g_translate values( $1 ,  $2 ,  $3 ,  $4 )
2003-03-25 18:42:26 [3531]   LOG:  query: SELECT   $1 
2003-03-25 18:42:26 [3531]   LOG:  query: SELECT 1 FROM ONLY "public"."g_translate" x WHERE "id" = $1 FOR UPDATE OF x
2003-03-25 18:42:26 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:26 [3531]   LOG:  statement: insert into p_titletype(code, name_id) values('--', g_in_t('None', 'sv None'));
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.043847 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_titletype(code, name_id) values('AT', g_in_t('Academic title', 'sv AT'));
2003-03-25 18:42:27 [3531]   LOG:  query: insert into p_titletype(code, name_id) values('AT', g_in_t('Academic title', 'sv AT'));
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_titletype(code, name_id) values('AT', g_in_t('Academic title', 'sv AT'));
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_titletype(code, name_id) values('AT', g_in_t('Academic title', 'sv AT'));
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.030544 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_titletype(code, name_id) values('ET', g_in_t('Education title', 'sv AT'));
2003-03-25 18:42:27 [3531]   LOG:  query: insert into p_titletype(code, name_id) values('ET', g_in_t('Education title', 'sv AT'));
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_titletype(code, name_id) values('ET', g_in_t('Education title', 'sv AT'));
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_titletype(code, name_id) values('ET', g_in_t('Education title', 'sv AT'));
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.030676 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: drop sequence p_sqtitle;
2003-03-25 18:42:27 [3531]   LOG:  query: drop sequence p_sqtitle;
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: drop sequence p_sqtitle;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to type p_sqtitle
2003-03-25 18:42:27 [3531]   LOG:  statement: drop sequence p_sqtitle;
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: drop sequence p_sqtitle;
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.018490 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: create sequence p_sqtitle;
2003-03-25 18:42:27 [3531]   LOG:  query: create sequence p_sqtitle;
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: create sequence p_sqtitle;
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: create sequence p_sqtitle;
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.062330 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   LOG:  query: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to type p_title
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   NOTICE:  Drop cascades to constraint p_c_p2title_fk_title_id on table p_p2title
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17105 on table p_title
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17104 on table p_title
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to trigger RI_ConstraintTrigger_17103 on table p_p2title
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to constraint p_title_pkey on table p_title
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to index p_title_pkey
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to default for table p_title column id
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to default for table p_title column type_code
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to default for table p_title column name_id
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_title cascade;
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.074152 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_title
(
	id			bigint	not null primary key default nextval('p_sqtitle'),
	type_code		varchar(200)	not null default '--',
	name_id			bigint	not null default 0,
	constraint p_c_title_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default,
	constraint p_c_title_fk_type_code foreign key(type_code) references p_titletype(code)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   LOG:  query: create table p_title
(
	id			bigint	not null primary key default nextval('p_sqtitle'),
	type_code		varchar(200)	not null default '--',
	name_id			bigint	not null default 0,
	constraint p_c_title_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default,
	constraint p_c_title_fk_type_code foreign key(type_code) references p_titletype(code)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'p_title_pkey' for table 'p_title'
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_title
(
	id			bigint	not null primary key default nextval('p_sqtitle'),
	type_code		varchar(200)	not null default '--',
	name_id			bigint	not null default 0,
	constraint p_c_title_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default,
	constraint p_c_title_fk_type_code foreign key(type_code) references p_titletype(code)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_title
(
	id			bigint	not null primary key default nextval('p_sqtitle'),
	type_code		varchar(200)	not null default '--',
	name_id			bigint	not null default 0,
	constraint p_c_title_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default,
	constraint p_c_title_fk_type_code foreign key(type_code) references p_titletype(code)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_title
(
	id			bigint	not null primary key default nextval('p_sqtitle'),
	type_code		varchar(200)	not null default '--',
	name_id			bigint	not null default 0,
	constraint p_c_title_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default,
	constraint p_c_title_fk_type_code foreign key(type_code) references p_titletype(code)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_title
(
	id			bigint	not null primary key default nextval('p_sqtitle'),
	type_code		varchar(200)	not null default '--',
	name_id			bigint	not null default 0,
	constraint p_c_title_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default,
	constraint p_c_title_fk_type_code foreign key(type_code) references p_titletype(code)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_title
(
	id			bigint	not null primary key default nextval('p_sqtitle'),
	type_code		varchar(200)	not null default '--',
	name_id			bigint	not null default 0,
	constraint p_c_title_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default,
	constraint p_c_title_fk_type_code foreign key(type_code) references p_titletype(code)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_title
(
	id			bigint	not null primary key default nextval('p_sqtitle'),
	type_code		varchar(200)	not null default '--',
	name_id			bigint	not null default 0,
	constraint p_c_title_fk_name_id foreign key(name_id) references g_translate(id)
		match full
		on update cascade
		on delete set default,
	constraint p_c_title_fk_type_code foreign key(type_code) references p_titletype(code)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.084040 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_title(id, type_code, name_id) values(0, '--', g_in_t('None', 'sv None'));
2003-03-25 18:42:27 [3531]   LOG:  query: insert into p_title(id, type_code, name_id) values(0, '--', g_in_t('None', 'sv None'));
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_title(id, type_code, name_id) values(0, '--', g_in_t('None', 'sv None'));
2003-03-25 18:42:27 [3531]   LOG:  query: SELECT 1 FROM ONLY "public"."g_translate" x WHERE "id" = $1 FOR UPDATE OF x
2003-03-25 18:42:27 [3531]   LOG:  query: SELECT 1 FROM ONLY "public"."p_titletype" x WHERE "code" = $1 FOR UPDATE OF x
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_title(id, type_code, name_id) values(0, '--', g_in_t('None', 'sv None'));
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.050751 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_p2title cascade;
2003-03-25 18:42:27 [3531]   LOG:  query: drop table p_p2title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_p2title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to type p_p2title
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_p2title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to constraint p_c_p2title_pk on table p_p2title
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_p2title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to index p_c_p2title_pk
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_p2title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  Drop auto-cascades to default for table p_p2title column title_id
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_p2title cascade;
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: drop table p_p2title cascade;
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.046444 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_p2title
(
	person_code		varchar(200)	not null,
	title_id		bigint	not null default 0,
	constraint p_c_p2title_pk primary key(person_code, title_id),
	constraint p_c_p2title_fk_person_code foreign key(person_code) references p_person(code)
		match full
		on update cascade
		on delete cascade,
	constraint p_c_p2title_fk_title_id foreign key(title_id) references p_title(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   LOG:  query: create table p_p2title
(
	person_code		varchar(200)	not null,
	title_id		bigint	not null default 0,
	constraint p_c_p2title_pk primary key(person_code, title_id),
	constraint p_c_p2title_fk_person_code foreign key(person_code) references p_person(code)
		match full
		on update cascade
		on delete cascade,
	constraint p_c_p2title_fk_title_id foreign key(title_id) references p_title(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'p_c_p2title_pk' for table 'p_p2title'
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_p2title
(
	person_code		varchar(200)	not null,
	title_id		bigint	not null default 0,
	constraint p_c_p2title_pk primary key(person_code, title_id),
	constraint p_c_p2title_fk_person_code foreign key(person_code) references p_person(code)
		match full
		on update cascade
		on delete cascade,
	constraint p_c_p2title_fk_title_id foreign key(title_id) references p_title(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_p2title
(
	person_code		varchar(200)	not null,
	title_id		bigint	not null default 0,
	constraint p_c_p2title_pk primary key(person_code, title_id),
	constraint p_c_p2title_fk_person_code foreign key(person_code) references p_person(code)
		match full
		on update cascade
		on delete cascade,
	constraint p_c_p2title_fk_title_id foreign key(title_id) references p_title(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_p2title
(
	person_code		varchar(200)	not null,
	title_id		bigint	not null default 0,
	constraint p_c_p2title_pk primary key(person_code, title_id),
	constraint p_c_p2title_fk_person_code foreign key(person_code) references p_person(code)
		match full
		on update cascade
		on delete cascade,
	constraint p_c_p2title_fk_title_id foreign key(title_id) references p_title(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_p2title
(
	person_code		varchar(200)	not null,
	title_id		bigint	not null default 0,
	constraint p_c_p2title_pk primary key(person_code, title_id),
	constraint p_c_p2title_fk_person_code foreign key(person_code) references p_person(code)
		match full
		on update cascade
		on delete cascade,
	constraint p_c_p2title_fk_title_id foreign key(title_id) references p_title(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_p2title
(
	person_code		varchar(200)	not null,
	title_id		bigint	not null default 0,
	constraint p_c_p2title_pk primary key(person_code, title_id),
	constraint p_c_p2title_fk_person_code foreign key(person_code) references p_person(code)
		match full
		on update cascade
		on delete cascade,
	constraint p_c_p2title_fk_title_id foreign key(title_id) references p_title(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: create table p_p2title
(
	person_code		varchar(200)	not null,
	title_id		bigint	not null default 0,
	constraint p_c_p2title_pk primary key(person_code, title_id),
	constraint p_c_p2title_fk_person_code foreign key(person_code) references p_person(code)
		match full
		on update cascade
		on delete cascade,
	constraint p_c_p2title_fk_title_id foreign key(title_id) references p_title(id)
		match full
		on update cascade
		on delete set default
);
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.308321 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_person values('99999999-9999', 'Adrian', 'Pop', '999999-9999', 'ADPOP', 'XXX');
2003-03-25 18:42:27 [3531]   LOG:  query: insert into p_person values('99999999-9999', 'Adrian', 'Pop', '999999-9999', 'ADPOP', 'XXX');
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_person values('99999999-9999', 'Adrian', 'Pop', '999999-9999', 'ADPOP', 'XXX');
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_person values('99999999-9999', 'Adrian', 'Pop', '999999-9999', 'ADPOP', 'XXX');
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.014517 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_p2title values ('99999999-9999', p_in_title('AT','PhD Student','Doktorand'));
2003-03-25 18:42:27 [3531]   LOG:  query: insert into p_p2title values ('99999999-9999', p_in_title('AT','PhD Student','Doktorand'));
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_p2title values ('99999999-9999', p_in_title('AT','PhD Student','Doktorand'));
2003-03-25 18:42:27 [3531]   LOG:  query: SELECT  nextval('p_sqtitle')
2003-03-25 18:42:27 [3531]   LOG:  query: insert into p_title values( $1 ,  $2 , g_in_t( $3 ,  $4 ))
2003-03-25 18:42:27 [3531]   LOG:  query: SELECT   $1 
2003-03-25 18:42:27 [3531]   LOG:  query: SELECT 1 FROM ONLY "public"."p_person" x WHERE "code" = $1 FOR UPDATE OF x
2003-03-25 18:42:27 [3531]   LOG:  query: SELECT 1 FROM ONLY "public"."p_title" x WHERE "id" = $1 FOR UPDATE OF x
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: insert into p_p2title values ('99999999-9999', p_in_title('AT','PhD Student','Doktorand'));
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.025779 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: start transaction;
2003-03-25 18:42:27 [3531]   LOG:  query: start transaction;
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessUtility
2003-03-25 18:42:27 [3531]   LOG:  statement: start transaction;
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: start transaction;
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.000268 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: delete from p_p2title where person_code='99999999-9999' and title_id=1;
2003-03-25 18:42:27 [3531]   LOG:  query: delete from p_p2title where person_code='99999999-9999' and title_id=1;
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:27 [3531]   LOG:  statement: delete from p_p2title where person_code='99999999-9999' and title_id=1;
2003-03-25 18:42:27 [3531]   DEBUG:  CommitTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: delete from p_p2title where person_code='99999999-9999' and title_id=1;
2003-03-25 18:42:27 [3531]   LOG:  duration: 0.002086 sec
2003-03-25 18:42:27 [3531]   DEBUG:  StartTransactionCommand
2003-03-25 18:42:27 [3531]   LOG:  statement: delete from g_translate where id=5;
2003-03-25 18:42:27 [3531]   LOG:  query: delete from g_translate where id=5;
2003-03-25 18:42:27 [3531]   DEBUG:  ProcessQuery
2003-03-25 18:42:27 [3531]   LOG:  statement: delete from g_translate where id=5;
2003-03-25 18:42:27 [3531]   LOG:  query: UPDATE ONLY "public"."p_titletype" SET "name_id" = NULL WHERE "name_id" = $1
2003-03-25 18:42:27 [3531]   LOG:  query: UPDATE ONLY "public"."p_title" SET "name_id" = NULL WHERE "name_id" = $1
2003-03-25 18:42:27 [3525]   DEBUG:  reaping dead processes
2003-03-25 18:42:27 [3525]   DEBUG:  child process (pid 3531) was terminated by signal 11
2003-03-25 18:42:27 [3525]   LOG:  server process (pid 3531) was terminated by signal 11
2003-03-25 18:42:27 [3525]   LOG:  terminating any other active server processes
2003-03-25 18:42:27 [3525]   LOG:  all server processes terminated; reinitializing shared memory and semaphores
2003-03-25 18:42:27 [3525]   DEBUG:  shmem_exit(0)
2003-03-25 18:42:27 [3525]   DEBUG:  invoking IpcMemoryCreate(size=1466368)
2003-03-25 18:42:28 [3532]   LOG:  database system was interrupted at 2003-03-25 18:42:01 CET
2003-03-25 18:42:28 [3532]   LOG:  checkpoint record is at 0/904D30
2003-03-25 18:42:28 [3532]   LOG:  redo record is at 0/904D30; undo record is at 0/0; shutdown TRUE
2003-03-25 18:42:28 [3532]   LOG:  next transaction id: 568; next oid: 25171
2003-03-25 18:42:28 [3532]   LOG:  database system was not properly shut down; automatic recovery in progress
2003-03-25 18:42:28 [3532]   LOG:  redo starts at 0/904D70
2003-03-25 18:42:28 [3532]   LOG:  ReadRecord: record with zero length at 0/97CEC4
2003-03-25 18:42:28 [3532]   LOG:  redo done at 0/97CEA0
2003-03-25 18:42:30 [3532]   LOG:  database system is ready
2003-03-25 18:42:30 [3532]   DEBUG:  proc_exit(0)
2003-03-25 18:42:30 [3532]   DEBUG:  shmem_exit(0)
2003-03-25 18:42:30 [3532]   DEBUG:  exit(0)
2003-03-25 18:42:30 [3525]   DEBUG:  reaping dead processes
2003-03-25 18:42:48 [3525]   DEBUG:  pmdie 15
2003-03-25 18:42:48 [3525]   LOG:  smart shutdown request
2003-03-25 18:42:48 [3544]   LOG:  shutting down
2003-03-25 18:42:50 [3544]   LOG:  database system is shut down
2003-03-25 18:42:50 [3544]   DEBUG:  proc_exit(0)
2003-03-25 18:42:50 [3544]   DEBUG:  shmem_exit(0)
2003-03-25 18:42:50 [3544]   DEBUG:  exit(0)
2003-03-25 18:42:50 [3525]   DEBUG:  reaping dead processes
2003-03-25 18:42:50 [3525]   DEBUG:  proc_exit(0)
2003-03-25 18:42:50 [3525]   DEBUG:  shmem_exit(0)
2003-03-25 18:42:50 [3525]   DEBUG:  exit(0)