[PHP-users 5653] Re: DBクラスのnextID() でエラー

[Rui Hirokawa]

This is a multi-part message in MIME format.

--Multipart_Sun__24_Feb_2002_12:01:27_+0900_085fbad8
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit


廣川です。

エラーメッセージのフォーマットがPostgreSQL7.2で一部変わったようですね。
簡単なパッチを作ってみました(添付)のでお試し下さい。

On Sat, 23 Feb 2002 23:12:38 +0900
Naoki Shinjo <nshinjo@occ.co.jp> wrote:

> 
> 新城と申します。
> 
> PHP4.1.1+PostgreSQL7.2の環境でPEARを使っていて気が付いたのですが、
> DBクラスのnextID()がうまく機能しませんでした。
> 調べてみると下記のように、
> エラーメッセージの一部が変わっているため（ ' → " ）
> DB_ERROR_NOSUCHTABLEのエラーと判断するところを
> DB_ERRORと判断しているようです。
> そのため、シーケンスが作成出来ず、nextID()を実行すると
> エラーになります。
> 
> 以上、御報告致します。
> 
> 
> ○PostgreSQL7.1.3
>   template1=# select NEXTVAL('id');
>   ERROR:  Relation 'id' does not exist
> 
> ○PostgreSQL7.2
>   template1=# select NEXTVAL('id');
>   ERROR:  Relation "id" does not exist
> 
> --------------
> Naoki Shinjo <nshinjo@occ.co.jp>
> _______________________________________________
> PHP-users mailing list
> PHP-users@php.gr.jp
> http://ns1.php.gr.jp/mailman/listinfo/php-users


-- 
-----------------------------------------------------
Rui Hirokawa <rui_hirokawa@ybb.ne.jp>
             <hirokawa@php.net>

--Multipart_Sun__24_Feb_2002_12:01:27_+0900_085fbad8
Content-Type: application/octet-stream;
 name="php-4.1.1-pear.patch"
Content-Disposition: attachment;
 filename="php-4.1.1-pear.patch"
Content-Transfer-Encoding: base64

KioqIHBocC00LjEuMS9wZWFyL0RCL3Bnc3FsLnBocC5vcmlnCVN1biBGZWIgMjQgMDg6MDc6MzMg
MjAwMgotLS0gcGhwLTQuMS4xL3BlYXIvREIvcGdzcWwucGhwCVN1biBGZWIgMjQgMDg6MDg6NDkg
MjAwMgoqKioqKioqKioqKioqKioKKioqIDIzOSwyNDkgKioqKgogICAgICAgICAgc3RhdGljICRl
cnJvcl9yZWdleHBzOwogICAgICAgICAgaWYgKGVtcHR5KCRlcnJvcl9yZWdleHBzKSkgewogICAg
ICAgICAgICAgICRlcnJvcl9yZWdleHBzID0gYXJyYXkoCiEgICAgICAgICAgICAgICAgICcvKFRh
YmxlIGRvZXMgbm90IGV4aXN0XC58UmVsYXRpb24gXCcuKlwnIGRvZXMgbm90IGV4aXN0fHNlcXVl
bmNlIGRvZXMgbm90IGV4aXN0fGNsYXNzICIuKyIgbm90IGZvdW5kKSQvJyA9PiBEQl9FUlJPUl9O
T1NVQ0hUQUJMRSwKISAgICAgICAgICAgICAgICAgJy9SZWxhdGlvbiBcJy4qXCcgYWxyZWFkeSBl
eGlzdHN8Q2Fubm90IGluc2VydCBhIGR1cGxpY2F0ZSBrZXkgaW50byBhIHVuaXF1ZSBpbmRleC8n
ICAgICAgPT4gREJfRVJST1JfQUxSRUFEWV9FWElTVFMsCiAgICAgICAgICAgICAgICAgICcvZGl2
aWRlIGJ5IHplcm8kLycgICAgICAgICAgICAgICAgICAgICA9PiBEQl9FUlJPUl9ESVZaRVJPLAog
ICAgICAgICAgICAgICAgICAnL3BnX2F0b2k6IGVycm9yIGluIC4qOiBjYW5cJ3QgcGFyc2UgLycg
PT4gREJfRVJST1JfSU5WQUxJRF9OVU1CRVIsCiEgICAgICAgICAgICAgICAgICcvdHRyaWJ1dGUg
XCcuKlwnIG5vdCBmb3VuZCR8UmVsYXRpb24gXCcuKlwnIGRvZXMgbm90IGhhdmUgYXR0cmlidXRl
IFwnLipcJy8nID0+IERCX0VSUk9SX05PU1VDSEZJRUxELAogICAgICAgICAgICAgICAgICAnL3Bh
cnNlcjogcGFyc2UgZXJyb3IgYXQgb3IgbmVhciBcIi8nICAgPT4gREJfRVJST1JfU1lOVEFYLAog
ICAgICAgICAgICAgICAgICAnL3JlZmVyZW50aWFsIGludGVncml0eSB2aW9sYXRpb24vJyAgICAg
PT4gREJfRVJST1JfQ09OU1RSQUlOVAogICAgICAgICAgICAgICk7Ci0tLSAyMzksMjQ5IC0tLS0K
ICAgICAgICAgIHN0YXRpYyAkZXJyb3JfcmVnZXhwczsKICAgICAgICAgIGlmIChlbXB0eSgkZXJy
b3JfcmVnZXhwcykpIHsKICAgICAgICAgICAgICAkZXJyb3JfcmVnZXhwcyA9IGFycmF5KAohICAg
ICAgICAgICAgICAgICAnLyhUYWJsZSBkb2VzIG5vdCBleGlzdFwufFJlbGF0aW9uIFtcIlwnXS4q
W1wiXCddIGRvZXMgbm90IGV4aXN0fHNlcXVlbmNlIGRvZXMgbm90IGV4aXN0fGNsYXNzICIuKyIg
bm90IGZvdW5kKSQvJyA9PiBEQl9FUlJPUl9OT1NVQ0hUQUJMRSwKISAgICAgICAgICAgICAgICAg
Jy9SZWxhdGlvbiBbXCJcJ10uKltcIlwnXSBhbHJlYWR5IGV4aXN0c3xDYW5ub3QgaW5zZXJ0IGEg
ZHVwbGljYXRlIGtleSBpbnRvIGEgdW5pcXVlIGluZGV4LycgICAgICA9PiBEQl9FUlJPUl9BTFJF
QURZX0VYSVNUUywKICAgICAgICAgICAgICAgICAgJy9kaXZpZGUgYnkgemVybyQvJyAgICAgICAg
ICAgICAgICAgICAgID0+IERCX0VSUk9SX0RJVlpFUk8sCiAgICAgICAgICAgICAgICAgICcvcGdf
YXRvaTogZXJyb3IgaW4gLio6IGNhblwndCBwYXJzZSAvJyA9PiBEQl9FUlJPUl9JTlZBTElEX05V
TUJFUiwKISAgICAgICAgICAgICAgICAgJy90dHJpYnV0ZSBbXCJcJ10uKltcIlwnXSBub3QgZm91
bmQkfFJlbGF0aW9uIFtcIlwnXS4qW1wiXCddIGRvZXMgbm90IGhhdmUgYXR0cmlidXRlIFtcIlwn
XS4qW1wiXCddLycgPT4gREJfRVJST1JfTk9TVUNIRklFTEQsCiAgICAgICAgICAgICAgICAgICcv
cGFyc2VyOiBwYXJzZSBlcnJvciBhdCBvciBuZWFyIFwiLycgICA9PiBEQl9FUlJPUl9TWU5UQVgs
CiAgICAgICAgICAgICAgICAgICcvcmVmZXJlbnRpYWwgaW50ZWdyaXR5IHZpb2xhdGlvbi8nICAg
ICA9PiBEQl9FUlJPUl9DT05TVFJBSU5UCiAgICAgICAgICAgICAgKTsK

--Multipart_Sun__24_Feb_2002_12:01:27_+0900_085fbad8--