<html xmlns="http://www.w3.org/1999/xhtml"><head></head><body><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="1" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[1]</anchor-end> <cite>UbuntuでPostgreSQLをインストールからリモートアクセスまでの手順 - Qiita</cite>
( (<time>2016-07-13 12:10:26 +09:00</time>))
<anchor-external xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resScheme="URI" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resParameter="http://qiita.com/ibara1454/items/40ce2d82926f48cf02bc">http://qiita.com/ibara1454/items/40ce2d82926f48cf02bc</anchor-external></p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="2" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[2]</anchor-end> <cite>psql接続時に対話でパスワードを入力しない - shibainu55日記</cite>
( (<time>2016-07-13 12:29:40 +09:00</time>))
<anchor-external xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resScheme="URI" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resParameter="http://d.hatena.ne.jp/shibainu55/20090917/1253453342">http://d.hatena.ne.jp/shibainu55/20090917/1253453342</anchor-external></p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="3" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[3]</anchor-end> <cite xml:lang="ja">Docker Hub 公式 PostgreSQL イメージを用いて、データベースクラスタ作成済みコンテナイメージを作成する - Thanks Driven Life</cite>
( (<time>2016-11-01 19:14:58 +09:00</time>))
<anchor-external xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resScheme="URI" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resParameter="http://gongo.hatenablog.com/entry/2015/08/04/232650">http://gongo.hatenablog.com/entry/2015/08/04/232650</anchor-external></p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="4" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[4]</anchor-end> ( (<time>2016-11-01 19:15:52 +09:00</time>))
<anchor-external xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resScheme="URI" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resParameter="https://hub.docker.com/_/postgres/">https://hub.docker.com/_/postgres/</anchor-external></p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="5" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[5]</anchor-end> <cite xml:lang="en">TJC/Test-postgresql: Fork of Test::postgresql that is actively maintained</cite>
(<time>2017-12-30 00:19:27 +09:00</time>)
<anchor-external xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resScheme="URI" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resParameter="https://github.com/TJC/Test-postgresql">https://github.com/TJC/Test-postgresql</anchor-external></p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="6" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[6]</anchor-end> <cite xml:lang="ja">Ubuntu で PostgreSQL を使ってみよう(続編) | Let's Postgres</cite>
(<time>2017-12-30 01:16:37 +09:00</time>)
<anchor-external xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resScheme="URI" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resParameter="https://lets.postgresql.jp/documents/tutorial/ubuntu/4">https://lets.postgresql.jp/documents/tutorial/ubuntu/4</anchor-external></p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="7" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[7]</anchor-end> <anchor xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:">Debian</anchor> と <anchor xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:">Ubuntu</anchor> はこういうわけのわからんことするの好きだなあ。
その方がいいという言い分があるのはわからんでもないが、
普通の postgres を前提にしたプログラムが動かないのは地獄でしかない。</p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="8" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[8]</anchor-end> <cite>postgresql - Is there a maximum length constraint for a postgres query? - Database Administrators Stack Exchange</cite>
(<time>2018-01-13 16:46:41 +09:00</time>)
<anchor-external xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resScheme="URI" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resParameter="https://dba.stackexchange.com/questions/131399/is-there-a-maximum-length-constraint-for-a-postgres-query">https://dba.stackexchange.com/questions/131399/is-there-a-maximum-length-constraint-for-a-postgres-query</anchor-external></p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="9" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[9]</anchor-end> <cite>postgresql - Is there a maximum length constraint for a postgres query? - Database Administrators Stack Exchange</cite>
(<time>2018-01-13 16:56:52 +09:00</time>)
<anchor-external xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resScheme="URI" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:resParameter="https://dba.stackexchange.com/questions/131399/is-there-a-maximum-length-constraint-for-a-postgres-query">https://dba.stackexchange.com/questions/131399/is-there-a-maximum-length-constraint-for-a-postgres-query</anchor-external></p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="10" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[10]</anchor-end> <pre class="code">dbdimp.c: In function 'pg_db_error_field':
dbdimp.c:4325:21: error: 'PG_DIAG_SEVERITY_NONLOCALIZED' undeclared (first use in this function)
         fieldcode = PG_DIAG_SEVERITY_NONLOCALIZED; // i.e. 'V'
                     ^</pre></p><p><anchor-end xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:" a0:anchor="11" xmlns:a0="urn:x-suika-fam-cx:markup:suikawiki:0:9:">[11]</anchor-end> <code>DBD::Pg</code> 3.9.0 でこのコードが入りましたが、
やや古めの <anchor xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:">PostgreSQL</anchor> ではこの定数が定義されていないので、エラーになります。
解決策は新しい <anchor xmlns="urn:x-suika-fam-cx:markup:suikawiki:0:9:">PostgreSQL</anchor> に更新するか、
<code>DBD::Pg</code> を 3.8.1 以前に戻すことです。
<time>2019-08-14T02:19:53.800Z</time></p></body></html>