Re: Re: proposal: schema variables
От | jian he |
---|---|
Тема | Re: Re: proposal: schema variables |
Дата | |
Msg-id | CACJufxHB=xLzuq6Y2OsF_+KzGYg_U=1o4RBCciScn44Y3FMn6g@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: proposal: schema variables (Dmitry Dolgov <9erthalion6@gmail.com>) |
Ответы |
Re: Re: proposal: schema variables
|
Список | pgsql-hackers |
hi. src9=# select 'XLogRecPtr'::regtype; ERROR: type "xlogrecptr" does not exist LINE 1: select 'XLogRecPtr'::regtype; ^ so + <structfield>varcreate_lsn</structfield> <type>XLogRecPtr</type> should be <structfield>varcreate_lsn</structfield> <type>pg_lsn</type> ? also + <row> + <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>varcreate_lsn</structfield> <type>XLogRecPtr</type> + </para> + <para> + LSN of the transaction where the variable was created. + <structfield>varcreate_lsn</structfield> and + <structfield>oid</structfield> together form the all-time unique + identifier (<structfield>oid</structfield> alone is not enough, since + object identifiers can get reused). + </para></entry> + </row> + we have "pg_variable_oid_index" PRIMARY KEY, btree (oid) for table pg_variable. so I am confused by saying the column "oid" itself is not enough to prove unique. in let.sgml <term><literal>session_variable</literal></term> should be <term><replaceable class="parameter">session_variable</replaceable></term> <term><literal>sql_expression</literal></term> should be <term><replaceable class="parameter">sql_expression</replaceable></term>
В списке pgsql-hackers по дате отправления: