WITH SYSID dropped

Поиск
Список
Период
Сортировка
От Dr. Ernst Molitor
Тема WITH SYSID dropped
Дата
Msg-id 200611051339.05471.molitor@uni-bonn.de
обсуждение исходный текст
Ответы Re: WITH SYSID dropped  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список pgsql-hackers
<p>Dear PostgreSQL gurus, <p><p>having read through the thread on the topic cited above, I still think the change -
howeverwell-founded it may be - carries a problem: That of an upgrade on installations that relied on the statement.
<p><p>Currently,I'm preparing to switch a PostgreSQL-8.0.3-installation to the current PostgreSQL version. The
installationmakes use of timetravel and of a one-liner to access the pg_users.usesysid field to keep a record about who
haschanged what and when (which, here in Germany, is a legal requirement if you deal with medical data). With a
one-liner,which is but a wrapper around PostgreSQL's internal GetUserId function, it has been nothing but creating a
function"current_userid" and adding a trigger to each table that should be able to record the user who commited or
changedthe row. Obviously, the whole job could be performed at database level. <p><p>The procedure still works, but due
tothe dropping of "WITH SYSID", moving the data to a new PostgreSQL installation causes headaches. After all, the
accessto the information about who has changed what is expected to stay. <p><p>Any hint (short of doing "update
<table_x>set usersno=<new value> where usersno=<old value>" for somewhat above 500 users and a chore
oftables) on how to proceed??<p><p>Best regards, <p><p>Ernst 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: Proposal: vacuum and autovacuum parameters to control freezing
Следующее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: WITH SYSID dropped