[pgcluster: 593] Re: シーケンス番号の整合性が崩れる

[mitani]

三谷＠広島です．

> 三谷様が検証した環境は、solaris(sparc)環境でしょうか？
手元のsolaris(intel版ですが)環境で試してみました．
結果はLinuxと同様で，シリアル番号は崩れませんでした．

[postgres ＠ post1 serial_test]$ psql -p 5001 test
Welcome to psql 7.3.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

test=# select id from test where name like '%x%';
  id
------
 3359
(1 row)

[postgres ＠ post1 serial_test]$ psql -p 5002 test
Welcome to psql 7.3.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

test=# select id from test where name like '%x%';
  id
------
 3359
(1 row)

=============================
三谷　篤<mitani ＠ sraw.co.jp>
=============================