{"id":21230,"date":"2025-10-28T08:54:23","date_gmt":"2025-10-28T08:54:23","guid":{"rendered":"https:\/\/pokecon.jp\/job\/?p=21230"},"modified":"2025-10-28T08:54:23","modified_gmt":"2025-10-28T08:54:23","slug":"%e3%81%a7%e3%81%8d%e3%82%8c%e3%81%b0%e7%9f%a5%e3%82%89%e3%81%9a%e3%81%ab%e6%b8%88%e3%81%be%e3%81%9b%e3%81%9f%e3%81%8b%e3%81%a3%e3%81%9faurora-dsql%e9%9d%9e%e4%ba%92%e6%8f%9b%e9%9b%86-arkedge-space-b","status":"publish","type":"post","link":"https:\/\/pokecon.jp\/job\/21230\/","title":{"rendered":"\u3067\u304d\u308c\u3070\u77e5\u3089\u305a\u306b\u6e08\u307e\u305b\u305f\u304b\u3063\u305fAurora DSQL\u975e\u4e92\u63db\u96c6 – ArkEdge Space Blog"},"content":{"rendered":"\n<\/p>\n
\n

\u682a\u5f0f\u4f1a\u793e\u30a2\u30fc\u30af\u30a8\u30c3\u30b8\u30fb\u30b9\u30da\u30fc\u30b9\u306e id:koba789<\/a> \u3067\u3059\u3002<\/p>\n

\u30a2\u30fc\u30af\u30a8\u30c3\u30b8\u30fb\u30b9\u30da\u30fc\u30b9\u3067\u306f\u3001\u885b\u661f\u30c7\u30fc\u30bf\u3092\u6d3b\u7528\u3059\u308b\u305f\u3081\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u958b\u767a\u3057\u3066\u3044\u307e\u3059\u3002\u4eba\u5de5\u885b\u661f<\/a>\u306e\u30ab\u30d0\u30ec\u30c3\u30b8<\/a>\u306f\u30b0\u30ed\u30fc\u30d0\u30eb\u306a\u305f\u3081\u3001\u305d\u308c\u3092\u6d3b\u7528\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3082\u30b0\u30ed\u30fc\u30d0\u30eb\u3067\u3042\u308b\u3079\u304d\u3067\u3057\u3087\u3046\u3002
\n\u30b0\u30ed\u30fc\u30d0\u30eb\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u30b3\u30b9\u30c8\u52b9\u7387\u9ad8\u304f\u63d0\u4f9b\u3059\u308b\u305f\u3081\u3001\u79c1\u305f\u3061\u306f\u30b5\u30fc\u30d0\u30ec\u30b9\u306a\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3092\u7a4d\u6975\u7684\u306b\u6d3b\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u305d\u308c\u306f DBMS<\/a> \u306b\u3064\u3044\u3066\u3082\u4f8b\u5916\u3067\u306f\u306a\u304f\u3001\u6628\u5e74\u306e re:Invent \u3067\u767a\u8868\u3055\u308c\u305f Amazon Aurora DSQL<\/a> \u3092\u6d3b\u7528\u3057\u3066\u3044\u307e\u3059\u3002\u8ab2\u91d1\u30e2\u30c7\u30eb\u304c\u5f93\u91cf\u8ab2\u91d1\u3067\u3042\u308b\u305f\u3081\u3001\u56fa\u5b9a\u8cbb\u3092\u62bc\u3055\u3048\u305f\u307e\u307e\u30b9\u30e2\u30fc\u30eb\u30b9\u30bf\u30fc\u30c8\u3067\u304d\u308b\u3068\u3044\u3046\u306e\u3082\u5927\u304d\u306a\u30e1\u30ea\u30c3\u30c8\u3067\u3059\u3002<\/p>\n

\u3055\u3066\u3001\u4eca\u56de\u306f\u305d\u3093\u306a Aurora DSQL \u3092\u4f7f\u3046\u3068\u304d\u306b\u30cf\u30de\u3063\u305f PostgreSQL<\/a> \u3068\u306e\u975e\u4e92\u63db\u30dd\u30a4\u30f3\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002Aurora DSQL \u306f\u30d7\u30ed\u30c8\u30b3\u30eb<\/a>\u3053\u305d PostgreSQL<\/a> \u4e92\u63db\u3067\u3059\u304c\u3001\u307f\u306a\u3055\u3093\u304c\u76f4\u611f\u7684\u306b\u60f3\u50cf\u3059\u308b PostgreSQL<\/a> \u3068\u306f\u3061\u3087\u3044\u3061\u3087\u3044\u632f\u308b\u821e\u3044\u304c\u7570\u306a\u308a\u307e\u3059\u3002
\n\u307e\u3042\u3001\u30b9\u30c8\u30ec\u30fc\u30b8\u307e\u308f\u308a\u306e\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3<\/a>\u304b\u3089\u3057<\/a>\u3066\u5225\u7269\u306e\u3088\u3046\u306a\u306e\u3067\u3001\u6319\u52d5\u304c\u9055\u3046\u306e\u306f\u5f53\u7136\u3068\u3044\u3048\u3070\u5f53\u7136\u3067\u3059\u3002MySQL<\/a> \u4e92\u63db DBMS<\/a> \u3092\u8da3\u5473\u3067\u4f5c\u3063\u3066\u3044\u305f\u8eab\u3068\u3057\u3066\u306f\u540c\u60c5\u3059\u308b\u90e8\u5206\u3082\u591a\u3044\u3067\u3059\u3002\u591a\u3044\u3067\u3059\u304c\u3001\u56f0\u308b\u3082\u306e\u306f\u56f0\u308b\uff01<\/p>\n

\u3053\u308c\u304b\u3089 Aurora DSQL \u3092\u89e6\u3063\u3066\u307f\u3088\u3046\u3068\u3044\u3046\u65b9\u3084\u3001\u79c1\u306e\u3088\u3046\u306a DBMS<\/a> \u30d5\u30ea\u30fc\u30af\u306e\u307f\u306a\u3055\u3093\u306e\u53c2\u8003\u306b\u306a\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<\/p>\n

\u57fa\u672c\u7684\u306a\u975e\u4e92\u63db\u306f Unsupported PostgreSQL features in Aurora DSQL<\/a> \u306b\u307e\u3068\u307e\u3063\u3066\u3044\u307e\u3059\u304c\u3001\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u8aad\u3093\u3060\u3060\u3051\u3067\u306f\u5206\u304b\u308a\u3065\u3089\u3044 “\u975e\u81ea\u660e” \u306a\u70b9\u3082\u3044\u304f\u3064\u304b\u3042\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u3067\u306f\u3001\u305d\u308c\u3089\u3092\u542b\u3081\u3066\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n

postgres<\/code> \u4ee5\u5916\u306e database \u306f\u4f5c\u308c\u306a\u3044<\/h2>\n

\u3064\u307e\u308a CREATE DATABASE<\/code> \u7981\u6b62\u3067\u3059\u3002
\n\u3053\u308c\u306f\u5408\u7406\u7684\u306a\u4ed5\u69d8\u3060\u3068\u601d\u3044\u307e\u3059\u3002\u81ea\u5206\u304c\u8a2d\u8a08\u8005\u3067\u3082\u304d\u3063\u3068\u305d\u3046\u3059\u308b\u3067\u3057\u3087\u3046\u3002
\n\u304a\u3068\u306a\u3057\u304f\u30c7\u30d5\u30a9\u30eb\u30c8\u306e postgres<\/code> database \u306b\u5168\u90e8\u7a81\u3063\u8fbc\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n

\n

You can’t create additional databases or rename or drop<\/a> the postgres database.<\/p>\n<\/blockquote>\n

Unsupported PostgreSQL features in Aurora DSQL<\/a><\/p>\n

\u975e admin \u30e6\u30fc\u30b6\u30fc\u306f public schema \u306b CREATE TABLE<\/code> \u3067\u304d\u306a\u3044<\/h2>\n

\u524d\u8ff0\u306e\u3068\u304a\u308a\u3001database \u3067\u306f\u5206\u96e2\u3067\u304d\u306a\u3044\u306e\u3067 schema\uff08namespace\uff09\u3067\u5206\u96e2\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002
\n\u3057\u304b\u3057\u975e admin \u30e6\u30fc\u30b6\u30fc\u306f public<\/code> schema \u306b CREATE TABLE<\/code> \u3067\u304d\u307e\u305b\u3093\u3002\u307e\u305f\u3001\u975e admin \u30e6\u30fc\u30b6\u30fc\u306b\u5bfe\u3057\u3066 GRANT CREATE<\/code> \u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u305b\u3093\u3002
\n\u304a\u305d\u3089\u304f CVE-2018-1058<\/a> \u3078\u306e\u5bfe\u5fdc\u3060\u3068\u601d\u308f\u308c\u307e\u3059\uff08\u63a8\u6e2c\uff09\u3002\u672c\u5bb6 PostgreSQL<\/a> \u3082 v15 \u304b\u3089\u540c\u69d8\u306e\u6319\u52d5\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n

\n

Non-admin users can’t create objects in the public schema. Only admin users can create objects in the public schema. The admin user role has permissions to grant read, write, and modify access<\/a> to these objects to non-admin users, but it cannot grant CREATE permissions to the public schema itself. Non-admin users must use different, user-created schemas for object creation.<\/p>\n<\/blockquote>\n

Unsupported PostgreSQL features in Aurora DSQL<\/a><\/p>\n

\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002\u307e\u305f\u3001DML<\/a> \u3092\u6df7\u305c\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n

begin<\/span>;\ncreate<\/span> table<\/span> ... ;\ncreate<\/span> table<\/span> ... ;\ncommit<\/span>;\n<\/pre>\n
\u5b9f\u52d9\u4e0a\u3001\u8907\u6570\u306e DDL<\/a> \u304c atomic \u304b\u3064 isolated \u3058\u3083\u306a\u3044\u3068\u56f0\u308b\u3053\u3068\u306f\u307e\u305a\u306a\u3044\uff08\u73fe\u5b9f\u7684\u306b\u306f\u305d\u3046\u3044\u3046\u3075\u3046\u306b\u30a2\u30d7\u30ea\u3092\u4f5c\u3063\u305f\u3089\u8ca0\u3051\u3067\u3042\u308b\uff09\u306e\u3067\u5408\u7406\u7684\u306a\u4ed5\u69d8\u3060\u3068\u601d\u3044\u307e\u3059\u3002\u601d\u3044\u307e\u3059\u304c\u3001\u4e00\u90e8\u306e\u30b9\u30ad\u30fc\u30de<\/a>\u7ba1\u7406\u30c4\u30fc\u30eb\u306f\u305d\u3046\u3067\u306f\u306a\u3044\u3053\u3068\u304c\u3042\u3063\u3066\u56f0\u308b\u306e\u3067\u3001\u304a\u4f7f\u3044\u306e\u30c4\u30fc\u30eb\u306e\u4ed5\u69d8\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n
\n
A transaction can include only 1 DDL<\/a> statement<\/p>\n<\/blockquote>\n
Unsupported PostgreSQL features in Aurora DSQL<\/a><\/p>\n\n
\u666e\u901a\u306e CREATE INDEX<\/code> \u306f\u4f7f\u3048\u306a\u3044<\/h2>\n
CREATE INDEX ASYNC<\/code> \u3092\u4f7f\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002ASYNC<\/code> \u30ad\u30fc\u30ef\u30fc\u30c9\u306f\u5fc5\u9808\u3067\u3059\u3002
\n\u3053\u308c\u306f DSQL \u306e\u72ec\u81ea\u62e1\u5f35\u3067\u3042\u308a\u3001\u73fe\u6642\u70b9\u3067\u306f\u307b\u307c\u3059\u3079\u3066\u306e\u30b9\u30ad\u30fc\u30de<\/a>\u7ba1\u7406\u30c4\u30fc\u30eb\u304c\u3053\u306e DDL<\/a> \u306b\u672a\u5bfe\u5fdc\u3067\u3059\u3002\u3059\u3052\u30fc\u56f0\u308b\u3002\u30de\u30b8\u3067\u3002<\/p>\n
\u3053\u306e DDL<\/a> \u306f\u540d\u524d\u306e\u3068\u304a\u308a\u975e\u540c\u671f\u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u69cb\u7bc9\u3057\u307e\u3059\u3002\u5b9f\u884c\u5b8c\u4e86=\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u69cb\u7bc9\u5b8c\u4e86\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002
\n\u5bfe\u8c61\u3068\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u304c\u5927\u304d\u3044\u5834\u5408\u306a\u3069\u3067\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u69cb\u7bc9\u306b\u306f\u9577\u3044\u6642\u9593\u304c\u304b\u304b\u308b\u3053\u3068\u304c\u3057\u3070\u3057\u3070\u3042\u308a\u307e\u3059\u304c\u3001\u305d\u306e\u305f\u3081\u306b\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3092\u52d5\u304b\u3057\u7d9a\u3051\u308b\u306e\u306f\u7d50\u69cb\u9762\u5012\u3067\u3059\u3002\u3046\u3063\u304b\u308a TCP<\/a> \u30bb\u30c3\u30b7\u30e7\u30f3\u304c\u5207\u308c\u3066\u3057\u307e\u3044\u3001\u9577\u3044\u6642\u9593\u3092\u304b\u3051\u305f create index \u304c\u30ed\u30fc\u30eb\u30d0\u30c3\u30af<\/a>\u3057\u305f\u3089\u6795\u3092\u6fe1\u3089\u3059\u304f\u3089\u3044\u306b\u306f\u60b2\u3057\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n
\u500b\u4eba\u7684\u306b\u306f\u3068\u3066\u3082\u826f\u3044\u4ed5\u69d8\u3060\u3068\u601d\u3044\u307e\u3059\u3002\u5c06\u6765\u7684\u306b\u306f\u3059\u3079\u3066\u306e DBMS<\/a> \u304c\u3053\u306e\u65b9\u5f0f\u306b\u306a\u3063\u3066\u307b\u3057\u3044\u3068\u3059\u3089\u601d\u3063\u3066\u3044\u307e\u3059\u3002\u305f\u3060\u3057\u73fe\u72b6\u3067\u306f\u30c4\u30fc\u30eb\u5074\u306e\u5bfe\u5fdc\u304c\u8ffd\u3044\u3064\u3044\u3066\u304a\u3089\u305a\u3001\u666e\u901a\u306b\u56f0\u308a\u307e\u3059\u3002<\/p>\n
\n
The CREATE INDEX ASYNC command creates an index on one or more columns of a specified table. This command is an asynchronous DDL<\/a> operation that doesn’t block other transactions. When you run CREATE INDEX ASYNC, Aurora DSQL immediately returns a job_id.<\/p>\n<\/blockquote>\n
Asynchronous indexes in Aurora DSQL<\/a><\/p>\n
\u30a2\u30af\u30bb\u30b9\u30e1\u30bd\u30c3\u30c9\u304c\u975e\u4e92\u63db<\/h2>\n
\u305d\u3082\u305d\u3082 DSQL \u306f B-Tree \u4ee5\u5916\u306e\u30a2\u30af\u30bb\u30b9\u30e1\u30bd\u30c3\u30c9\uff08\u3072\u3089\u305f\u304f\u8a00\u3048\u3070\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30a2\u30eb\u30b4\u30ea\u30ba\u30e0<\/a>\u306e\u3053\u3068\uff09\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\u3002\u3067\u3001\u3053\u306e B-Tree \u306e\u5b9f\u88c5\u306f\u5185\u90e8\u7684\u306b PostgreSQL<\/a> \u30aa\u30ea\u30b8\u30ca\u30eb\u306e btree \u3068\u306f\u5225\u7269\u3068\u3044\u3046\u3053\u3068\u306b\u306a\u3063\u3066\u3044\u308b\u3089\u3057\u304f\u3001btree_index \u3068\u3044\u3046\u540d\u524d\u306e\u30a2\u30af\u30bb\u30b9\u30e1\u30bd\u30c3\u30c9\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u304c\u307e\u305f\u3057\u3066\u3082\u30b9\u30ad\u30fc\u30de<\/a>\u7ba1\u7406\u30c4\u30fc\u30eb\u3092\u60d1\u308f\u305b\u308b\uff01<\/p>\n
\u305d\u306e\u305f\u3081\u3001CREATE INDEX<\/code> \u306e USING<\/code> \u53e5\u3067\u3082 USING btree_index<\/code> \u3068\u66f8\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002USING btree<\/code> \u3067\u306f\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002pg_am<\/code> \u30c6\u30fc\u30d6\u30eb\u306b\u306f btree<\/code> \u306f\u3042\u308a\u307e\u3059\u304c\u3001\u4f7f\u3048\u306a\u3044\u3089\u3057\u3044\u3067\u3059\u3002<\/p>\n
PostgreSQL<\/a> \u3092\u77e5\u3063\u3066\u3044\u308b\u4eba\u304c\u6b63\u3057\u304f\u62e1\u5f35\u3057\u305f\u7d50\u679c\u3001\u4e00\u822c\u4eba\u306b\u306f\u610f\u5473\u4e0d\u660e\u306a\u4ed5\u69d8\u306b\u306a\u3063\u3066\u3044\u308b\u3068\u3044\u3046\u6c17\u914d\u3092\u611f\u3058\u307e\u3059\u3002PostgreSQL<\/a> \u306f\u3053\u3046\u3044\u3046\u62e1\u5f35\u306b\u8010\u3048\u3089\u308c\u308b\u30e1\u30bf\u306a\u4ed5\u7d44\u307f\u304c\u305f\u304f\u3055\u3093\u3042\u308b\u3093\u3067\u3059\u3088\u306d\u3047\u3002<\/p>\n
primary key \u304c clustered index<\/h2>\n
\u30d2\u30fc\u30d7\u30c6\u30fc\u30d6\u30eb\u306a\u3093\u3066\u3060\u3063\u305b\u30fc\u3088\u306a\u3068\u3044\u3046\u610f\u898b\u306b\u306f\u540c\u610f\u3057\u307e\u3059\u3057\u3001\u73fe\u4ee3\u306e OLTP \u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306e\u5927\u534a\u306f primary key \u306b\u3088\u308b lookup \u306a\u306e\u3060\u304b\u3089 clustred index \u306b\u3059\u308b\u306e\u304c\u5408\u7406\u7684\u306a\u3093\u3067\u3042\u3063\u3066 vacuum \u3067\u982d\u3092\u60a9\u307e\u3059\u306e\u306f\u30ca\u30f3\u30bb\u30f3\u30b9\u3067\u3057\u3087\u3046\u3002InnoDB<\/a> \u3082\u305d\u3046\u8a00\u3046\u3068\u308b\u3002<\/p>\n
\u3057\u304b\u3057\u3001\u3053\u308c\u3092\u6b63\u76f4\u306b\u30ab\u30bf\u30ed\u30b0\u30c6\u30fc\u30d6\u30eb\u4e0a\u3067\u8868\u73fe\u3059\u308b\u306e\u3067\u307e\u305f\u3057\u3066\u3082\u30b9\u30ad\u30fc\u30de<\/a>\u7ba1\u7406\u30c4\u30fc\u30eb\u304c\u66b4\u308c\u308b\uff01<\/p>\n
\u305f\u3068\u3048\u3070 users<\/code> \u30c6\u30fc\u30d6\u30eb\u306e pkey \u3092 pg_indexes<\/code> \u3067\u898b\u308b\u3068\u3001id<\/code> \u4ee5\u5916\u306e\u3059\u3079\u3066\u306e\u30ab\u30e9\u30e0\u3092 INCLUDE<\/code> \u3057\u3066\u3044\u308b\u3088\u3046\u306b\u898b\u3048\u307e\u3059\u3002\u3061\u3083\u3093\u3068 clustered index \u3067\u3059\u3002<\/p>\n
create<\/span> unique<\/span> index<\/span> users_pkey on<\/span> users using<\/span> btree_index (id) include (name, email, email_verified, image, created_at, updated_at)\n<\/pre>\n
\u304a\u307e\u3051\uff1adrizzle-orm \u7528 monkey patch<\/h2>\n
drizzle-orm<\/a> \u3082\u4f8b\u306b\u6f0f\u308c\u305a\u3001Aurora DSQL \u3068\u306e\u76f8\u6027\u304c\u60aa\u3044\u90e8\u5206\u304c\u3042\u308a\u307e\u3059\u3002
\nPull Request<\/a> \u3082\u51fa\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u5341\u5206\u306a\u5bfe\u5fdc\u304c\u5165\u308b\u306b\u306f\u307e\u3060\u6642\u9593\u304c\u304b\u304b\u308a\u305d\u3046\u3067\u3059\u3002<\/p>\n
\u305d\u3053\u3067\u3001\u30a2\u30fc\u30af\u30a8\u30c3\u30b8\u30fb\u30b9\u30da\u30fc\u30b9\u3067\u306f\u66ab\u5b9a\u5bfe\u5fdc\u3068\u3057\u3066 drizzle-orm \u306b monkey patch \u3092\u5f53\u3066\u3066\u904b\u7528\u3057\u3066\u3044\u307e\u3059\u3002\u4ee5\u4e0b\u3001\u305d\u306e\u5185\u5bb9\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n
import<\/span> {<\/span> Connection<\/span> }<\/span> from<\/span> \"pg\"<\/span>;\nimport<\/span> {<\/span> defineConfig }<\/span> from<\/span> \"drizzle-kit\"<\/span>;\n\n\n\n\nfunction<\/span> patchPgForDsql<\/span>() {<\/span>\n  \n  function<\/span> rewriteSQL<\/span>(sql<\/span>: <\/span>string<\/span>): string<\/span> {<\/span>\n    \n    if<\/span> (sql.includes<\/span>(\"pg_stat_user_indexes\"<\/span>)) {<\/span>\n      const<\/span> [<\/span>tableName<\/span>, tableSchema<\/span>]<\/span> = sql.match<\/span>(\/'[^']+'\/g<\/span>)!;\n\n      return<\/span> `SELECT<\/span>\n          i.relname AS index_name,<\/span>\n          t.relname AS table_name,<\/span>\n          ns.nspname AS schemaname,<\/span>\n          CASE WHEN con.oid IS NOT NULL THEN 1 ELSE 0 END AS generated_by_constraint<\/span>\n        FROM<\/span>\n          pg_class t<\/span>\n        LEFT JOIN<\/span>\n          pg_namespace ns ON ns.oid = t.relnamespace<\/span>\n        LEFT JOIN<\/span>\n          pg_index x ON x.indrelid  = t.oid<\/span>\n        LEFT JOIN<\/span>\n          pg_class i ON i.oid = x.indexrelid<\/span>\n        LEFT JOIN<\/span>\n          pg_constraint con ON con.conindid = i.oid<\/span>\n        WHERE t.relname = <\/span>${<\/span>tableName}<\/span> AND ns.nspname = <\/span>${<\/span>tableSchema}<\/span>\n        GROUP BY i.relname, t.relname, ns.nspname, generated_by_constraint;`<\/span>;\n    }<\/span>\n\n    \n    return<\/span> sql.replace<\/span>(\n      \/(\\bCREATE\\s+(?:UNIQUE\\s+)?INDEX\\b[\\s\\S]*?)(?=;|$)\/gi<\/span>,\n      (stmt<\/span>) <\/span>=><\/span> {<\/span>\n        \n        if<\/span> (!\/\\bASYNC\\b\/i<\/span>.test<\/span>(stmt)) {<\/span>\n          \n          stmt = stmt.replace<\/span>(\n            \/\\bCREATE\\s+(?:UNIQUE\\s+)?INDEX\\b\/i<\/span>,\n            (m<\/span>) <\/span>=><\/span> `<\/span>${<\/span>m}<\/span> ASYNC`<\/span>,\n          );\n        }<\/span>\n        return<\/span> stmt;\n      }<\/span>,\n    );\n  }<\/span>\n\n  const<\/span> origQuery = Connection<\/span>.prototype.query;\n  Connection<\/span>.prototype.query = function<\/span> query<\/span>(sql<\/span>: <\/span>string<\/span>) {<\/span>\n    const<\/span> rewritten = rewriteSQL(sql);\n    origQuery.call<\/span>(this<\/span>, rewritten);\n  }<\/span>;\n}<\/span>\n\nconst<\/span> awsRegionInHostname = \/\\.dsql\\.(.+)\\.on\\.aws$\/<\/span>.exec<\/span>(hostname)?.[<\/span>1<\/span>]<\/span>;\nconst<\/span> isDsql = typeof<\/span> awsRegionInHostname === \"string\"<\/span>;\nif<\/span> (isDsql) {<\/span>\n  patchPgForDsql();\n}<\/span>\n\nexport<\/span> default<\/span> defineConfig({<\/span>\n  dialect<\/span>: \"postgresql\"<\/span>,\n  schema<\/span>: \".\/schema.ts\"<\/span>,\n  out<\/span>: \".\/drizzle\"<\/span>,\n  schemaFilter<\/span>: \"\"<\/your_schema_here><\/span>,\n  dbCredentials<\/span>: {<\/span>\n    host<\/span>: hostname,\n    port<\/span>,\n    database<\/span>,\n    user<\/span>,\n    ssl<\/span>: {<\/span> rejectUnauthorized<\/span>: true<\/span> }<\/span>,\n    password<\/span>,\n  }<\/span>,\n}<\/span>);\n<\/pre>\n<\/div>\n
\u5b9f\u614b\u3092\u53cd\u6620\u3057\u3066\u3044\u3066\u8aa0\u306b\u7d50\u69cb\u3067\u306f\u3042\u308b\u306e\u3067\u3059\u304c\u3001\u666e\u901a\u306e PostgreSQL<\/a> \u3092\u524d\u63d0\u306b\u3057\u305f\u30c4\u30fc\u30eb\u306f\u300c\u3053\u3093\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u77e5\u3089\u3093\uff01\u300d\u3068\u3044\u3063\u3066\u52dd\u624b\u306b pkey \u3092 DROP INDEX<\/code> \u3057\u3088\u3046\u3068\u3057\u305f\u308a\u3057\u307e\u3059\u3002\u6c17\u3092\u3064\u3051\u307e\u3057\u3087\u3046\u3002<\/p>\n