@pgsql/types を 17.x から 18.x へアップグレード

@pgsql/types 17.6.2 と 18.0.0 の公開 API を、TypeScript の型から自動的に比較したものです。シグネチャの変更は破壊的変更の候補であり、確定ではありません。

概要

削除されたインポートパス	0
削除されたエクスポート	3
変更されたシグネチャ	8
削除されたクラス／インターフェースのメンバー	6
変更されたクラス／インターフェースのメンバー	1
新たに非推奨	0
要件の変更（engines、peer 依存関係）	0
新しいエクスポート	16

削除されたエクスポート

import	export	kind	変更前
`@pgsql/types`	`RowCompareType`	type	`"ROWCOMPARE_LT" \| "ROWCOMPARE_LE" \| "ROWCOMPARE_EQ" \| "ROWCOMPARE_GE" \| "ROWCOMPARE_GT" \| "ROWCOMPARE_NE"`
`@pgsql/types`	`SinglePartitionSpec`	interface	`interface`
`@pgsql/types/enums`	`RowCompareType`	type	`"ROWCOMPARE_LT" \| "ROWCOMPARE_LE" \| "ROWCOMPARE_EQ" \| "ROWCOMPARE_GE" \| "ROWCOMPARE_GT" \| "ROWCOMPARE_NE"`

変更されたシグネチャ

export	変更前	変更後
`@pgsql/types · RTEKind`	`"RTE_RELATION" \| "RTE_SUBQUERY" \| "RTE_JOIN" \| "RTE_FUNCTION" \| "RTE_TABLEFUNC" \| "RTE_VALUES" \| "RTE_CTE" \| "RTE_NAMEDTUPLESTORE" \| "RTE_RESULT"`	`"RTE_RELATION" \| "RTE_SUBQUERY" \| "RTE_JOIN" \| "RTE_FUNCTION" \| "RTE_TABLEFUNC" \| "RTE_VALUES" \| "RTE_CTE" \| "RTE_NAMEDTUPLESTORE" \| "RTE_RESULT" \| "RTE_GROUP"`
`@pgsql/types · JoinType`	`"JOIN_INNER" \| "JOIN_LEFT" \| "JOIN_FULL" \| "JOIN_RIGHT" \| "JOIN_SEMI" \| "JOIN_ANTI" \| "JOIN_RIGHT_ANTI" \| "JOIN_UNIQUE_OUTER" \| "JOIN_UNIQUE_INNER"`	`"JOIN_INNER" \| "JOIN_LEFT" \| "JOIN_FULL" \| "JOIN_RIGHT" \| "JOIN_SEMI" \| "JOIN_ANTI" \| "JOIN_RIGHT_SEMI" \| "JOIN_RIGHT_ANTI" \| "JOIN_UNIQUE_OUTER" \| "JOIN_UNIQUE_INNER"`
`@pgsql/types · ConstrType`	`"CONSTR_NULL" \| "CONSTR_NOTNULL" \| "CONSTR_DEFAULT" \| "CONSTR_IDENTITY" \| "CONSTR_GENERATED" \| "CONSTR_CHECK" \| "CONSTR_PRIMARY" \| "CONSTR_UNIQUE" \| "CONSTR_EXCLUSION" \| "CONSTR_FOREIGN" \| "CONSTR_ATTR_DEFERRABLE" \| "CONSTR_ATTR_NOT_DEFERRABLE" \| "CONSTR_ATTR_DEFERRED" \| "CONSTR_ATTR_IMMEDIATE"`	`"CONSTR_NULL" \| "CONSTR_NOTNULL" \| "CONSTR_DEFAULT" \| "CONSTR_IDENTITY" \| "CONSTR_GENERATED" \| "CONSTR_CHECK" \| "CONSTR_PRIMARY" \| "CONSTR_UNIQUE" \| "CONSTR_EXCLUSION" \| "CONSTR_FOREIGN" \| "CONSTR_ATTR_DEFERRABLE" \| "CONSTR_ATTR_NOT_DEFERRABLE" \| "CONSTR_ATTR_DEFERRED" \| "CONSTR_ATTR_IMMEDIATE" \| "CONSTR_ATTR_ENFORCED" \| "CONSTR_ATTR_NOT_ENFORCED"`
`@pgsql/types · AlterTableType`	"AT_AddColumn" \| "AT_AddColumnToView" \| "AT_ColumnDefault" \| "AT_CookedColumnDefault" \| "AT_DropNotNull" \| "AT_SetNotNull" \| "AT_SetExpression" \| "AT_DropExpression" \| "AT_CheckNotNull" \| "AT_SetStatistics" \| "AT_SetOptions" \| "AT_ResetOptions" \| "AT_SetStorage" \| "AT_SetCompression" \| "AT_DropColumn" \| "AT_AddIndex" \| "AT_ReAddIndex" \| "AT_AddConstraint" \| "AT_ReAddConstraint" \| "AT_ReAddDomainConstraint" \| "AT_AlterConstraint" \| "AT_ValidateConstraint" \| "AT_AddIndexConstraint" \| "AT_DropConstraint" \| "AT_ReAddComment" \| "AT_AlterColumnType" \| "AT_AlterColumnGenericOptions" \| "AT_ChangeOwner…	"AT_AddColumn" \| "AT_AddColumnToView" \| "AT_ColumnDefault" \| "AT_CookedColumnDefault" \| "AT_DropNotNull" \| "AT_SetNotNull" \| "AT_SetExpression" \| "AT_DropExpression" \| "AT_SetStatistics" \| "AT_SetOptions" \| "AT_ResetOptions" \| "AT_SetStorage" \| "AT_SetCompression" \| "AT_DropColumn" \| "AT_AddIndex" \| "AT_ReAddIndex" \| "AT_AddConstraint" \| "AT_ReAddConstraint" \| "AT_ReAddDomainConstraint" \| "AT_AlterConstraint" \| "AT_ValidateConstraint" \| "AT_AddIndexConstraint" \| "AT_DropConstraint" \| "AT_ReAddComment" \| "AT_AlterColumnType" \| "AT_AlterColumnGenericOptions" \| "AT_ChangeOwner" \| "AT_ClusterOn" \|…
`@pgsql/types/enums · RTEKind`	`"RTE_RELATION" \| "RTE_SUBQUERY" \| "RTE_JOIN" \| "RTE_FUNCTION" \| "RTE_TABLEFUNC" \| "RTE_VALUES" \| "RTE_CTE" \| "RTE_NAMEDTUPLESTORE" \| "RTE_RESULT"`	`"RTE_RELATION" \| "RTE_SUBQUERY" \| "RTE_JOIN" \| "RTE_FUNCTION" \| "RTE_TABLEFUNC" \| "RTE_VALUES" \| "RTE_CTE" \| "RTE_NAMEDTUPLESTORE" \| "RTE_RESULT" \| "RTE_GROUP"`
`@pgsql/types/enums · JoinType`	`"JOIN_INNER" \| "JOIN_LEFT" \| "JOIN_FULL" \| "JOIN_RIGHT" \| "JOIN_SEMI" \| "JOIN_ANTI" \| "JOIN_RIGHT_ANTI" \| "JOIN_UNIQUE_OUTER" \| "JOIN_UNIQUE_INNER"`	`"JOIN_INNER" \| "JOIN_LEFT" \| "JOIN_FULL" \| "JOIN_RIGHT" \| "JOIN_SEMI" \| "JOIN_ANTI" \| "JOIN_RIGHT_SEMI" \| "JOIN_RIGHT_ANTI" \| "JOIN_UNIQUE_OUTER" \| "JOIN_UNIQUE_INNER"`
`@pgsql/types/enums · ConstrType`	`"CONSTR_NULL" \| "CONSTR_NOTNULL" \| "CONSTR_DEFAULT" \| "CONSTR_IDENTITY" \| "CONSTR_GENERATED" \| "CONSTR_CHECK" \| "CONSTR_PRIMARY" \| "CONSTR_UNIQUE" \| "CONSTR_EXCLUSION" \| "CONSTR_FOREIGN" \| "CONSTR_ATTR_DEFERRABLE" \| "CONSTR_ATTR_NOT_DEFERRABLE" \| "CONSTR_ATTR_DEFERRED" \| "CONSTR_ATTR_IMMEDIATE"`	`"CONSTR_NULL" \| "CONSTR_NOTNULL" \| "CONSTR_DEFAULT" \| "CONSTR_IDENTITY" \| "CONSTR_GENERATED" \| "CONSTR_CHECK" \| "CONSTR_PRIMARY" \| "CONSTR_UNIQUE" \| "CONSTR_EXCLUSION" \| "CONSTR_FOREIGN" \| "CONSTR_ATTR_DEFERRABLE" \| "CONSTR_ATTR_NOT_DEFERRABLE" \| "CONSTR_ATTR_DEFERRED" \| "CONSTR_ATTR_IMMEDIATE" \| "CONSTR_ATTR_ENFORCED" \| "CONSTR_ATTR_NOT_ENFORCED"`
`@pgsql/types/enums · AlterTableType`	"AT_AddColumn" \| "AT_AddColumnToView" \| "AT_ColumnDefault" \| "AT_CookedColumnDefault" \| "AT_DropNotNull" \| "AT_SetNotNull" \| "AT_SetExpression" \| "AT_DropExpression" \| "AT_CheckNotNull" \| "AT_SetStatistics" \| "AT_SetOptions" \| "AT_ResetOptions" \| "AT_SetStorage" \| "AT_SetCompression" \| "AT_DropColumn" \| "AT_AddIndex" \| "AT_ReAddIndex" \| "AT_AddConstraint" \| "AT_ReAddConstraint" \| "AT_ReAddDomainConstraint" \| "AT_AlterConstraint" \| "AT_ValidateConstraint" \| "AT_AddIndexConstraint" \| "AT_DropConstraint" \| "AT_ReAddComment" \| "AT_AlterColumnType" \| "AT_AlterColumnGenericOptions" \| "AT_ChangeOwner…	"AT_AddColumn" \| "AT_AddColumnToView" \| "AT_ColumnDefault" \| "AT_CookedColumnDefault" \| "AT_DropNotNull" \| "AT_SetNotNull" \| "AT_SetExpression" \| "AT_DropExpression" \| "AT_SetStatistics" \| "AT_SetOptions" \| "AT_ResetOptions" \| "AT_SetStorage" \| "AT_SetCompression" \| "AT_DropColumn" \| "AT_AddIndex" \| "AT_ReAddIndex" \| "AT_AddConstraint" \| "AT_ReAddConstraint" \| "AT_ReAddDomainConstraint" \| "AT_AlterConstraint" \| "AT_ValidateConstraint" \| "AT_AddIndexConstraint" \| "AT_DropConstraint" \| "AT_ReAddComment" \| "AT_AlterColumnType" \| "AT_AlterColumnGenericOptions" \| "AT_ChangeOwner" \| "AT_ClusterOn" \|…

削除されたクラス／インターフェースのメンバー

member	import	変更前
`MergeStmt.returningList`	`@pgsql/types`	`Node[] \| undefined`
`Constraint.inhcount`	`@pgsql/types`	`number \| undefined`
`DeleteStmt.returningList`	`@pgsql/types`	`Node[] \| undefined`
`InsertStmt.returningList`	`@pgsql/types`	`Node[] \| undefined`
`UpdateStmt.returningList`	`@pgsql/types`	`Node[] \| undefined`
`RowCompareExpr.rctype`	`@pgsql/types`	`RowCompareType \| undefined`

変更されたクラス／インターフェースのメンバー

member	変更前	変更後
`IntoClause.viewQuery`	`Node \| undefined`	`Query \| undefined`

新たに非推奨

検出されませんでした。

要件の変更（engines、peer 依存関係）

検出されませんでした。

新しいエクスポート (16)

import	export	kind
`@pgsql/types`	`Table`	interface
`@pgsql/types`	`Context`	type
`@pgsql/types`	`Function`	interface
`@pgsql/types`	`CompareType`	type
`@pgsql/types`	`FilterColumn`	interface
`@pgsql/types`	`ReturningExpr`	interface
`@pgsql/types`	`SummaryResult`	interface
`@pgsql/types`	`ReturningClause`	interface
`@pgsql/types`	`ReturningOption`	interface
`@pgsql/types`	`VarReturningType`	type
`@pgsql/types`	`ATAlterConstraint`	interface
`@pgsql/types`	`ReturningOptionKind`	type
`@pgsql/types/enums`	`Context`	type
`@pgsql/types/enums`	`CompareType`	type
`@pgsql/types/enums`	`VarReturningType`	type
`@pgsql/types/enums`	`ReturningOptionKind`	type

このデータを AI エージェントに渡す

Vigia は無料の MCP サーバーです。コーディングエージェントがコードを書く前に、バージョン・破壊的変更・脆弱性を確認できます。登録も API キーも不要です。

claude mcp add --transport http vigia https://vigia.coredls.cloud/mcp

Cursor に追加 VS Code に追加 ★ GitHub でスターを付ける

その他の MCP クライアント

{ "mcpServers": { "vigia": { "url": "https://vigia.coredls.cloud/mcp" } } }

エージェント用スキル (SKILL.md)：Vigia を使うタイミングをエージェントに伝えます · プルリクエスト用 GitHub Action

よくある質問

@pgsql/types を 17 から 18 にアップグレードする際の破壊的変更は？

@pgsql/types 17.6.2 と 18.0.0 の間で、Vigia は削除されたエクスポートを 3 件、変更されたシグネチャを 8 件、削除または変更されたクラス／インターフェースのメンバーを 7 件検出しました。

@pgsql/types 18 で非推奨になったものは？

@pgsql/types 18.0.0 では 0 件のエクスポートまたはメンバーが新たに非推奨になりました。

エージェント向け

GET https://vigia.coredls.cloud/v1/packages/npm/@pgsql/types/upgrade?from=17.6.2&to=18.0.0

export	変更前	変更後
`@pgsql/types · RTEKind`	`"RTE_RELATION" \| "RTE_SUBQUERY" \| "RTE_JOIN" \| "RTE_FUNCTION" \| "RTE_TABLEFUNC" \| "RTE_VALUES" \| "RTE_CTE" \| "RTE_NAMEDTUPLESTORE" \| "RTE_RESULT"`	`"RTE_RELATION" \| "RTE_SUBQUERY" \| "RTE_JOIN" \| "RTE_FUNCTION" \| "RTE_TABLEFUNC" \| "RTE_VALUES" \| "RTE_CTE" \| "RTE_NAMEDTUPLESTORE" \| "RTE_RESULT" \| "RTE_GROUP"`
`@pgsql/types · JoinType`	`"JOIN_INNER" \| "JOIN_LEFT" \| "JOIN_FULL" \| "JOIN_RIGHT" \| "JOIN_SEMI" \| "JOIN_ANTI" \| "JOIN_RIGHT_ANTI" \| "JOIN_UNIQUE_OUTER" \| "JOIN_UNIQUE_INNER"`	`"JOIN_INNER" \| "JOIN_LEFT" \| "JOIN_FULL" \| "JOIN_RIGHT" \| "JOIN_SEMI" \| "JOIN_ANTI" \| "JOIN_RIGHT_SEMI" \| "JOIN_RIGHT_ANTI" \| "JOIN_UNIQUE_OUTER" \| "JOIN_UNIQUE_INNER"`
`@pgsql/types · ConstrType`	`"CONSTR_NULL" \| "CONSTR_NOTNULL" \| "CONSTR_DEFAULT" \| "CONSTR_IDENTITY" \| "CONSTR_GENERATED" \| "CONSTR_CHECK" \| "CONSTR_PRIMARY" \| "CONSTR_UNIQUE" \| "CONSTR_EXCLUSION" \| "CONSTR_FOREIGN" \| "CONSTR_ATTR_DEFERRABLE" \| "CONSTR_ATTR_NOT_DEFERRABLE" \| "CONSTR_ATTR_DEFERRED" \| "CONSTR_ATTR_IMMEDIATE"`	`"CONSTR_NULL" \| "CONSTR_NOTNULL" \| "CONSTR_DEFAULT" \| "CONSTR_IDENTITY" \| "CONSTR_GENERATED" \| "CONSTR_CHECK" \| "CONSTR_PRIMARY" \| "CONSTR_UNIQUE" \| "CONSTR_EXCLUSION" \| "CONSTR_FOREIGN" \| "CONSTR_ATTR_DEFERRABLE" \| "CONSTR_ATTR_NOT_DEFERRABLE" \| "CONSTR_ATTR_DEFERRED" \| "CONSTR_ATTR_IMMEDIATE" \| "CONSTR_ATTR_ENFORCED" \| "CONSTR_ATTR_NOT_ENFORCED"`
`@pgsql/types · AlterTableType`	"AT_AddColumn" \| "AT_AddColumnToView" \| "AT_ColumnDefault" \| "AT_CookedColumnDefault" \| "AT_DropNotNull" \| "AT_SetNotNull" \| "AT_SetExpression" \| "AT_DropExpression" \| "AT_CheckNotNull" \| "AT_SetStatistics" \| "AT_SetOptions" \| "AT_ResetOptions" \| "AT_SetStorage" \| "AT_SetCompression" \| "AT_DropColumn" \| "AT_AddIndex" \| "AT_ReAddIndex" \| "AT_AddConstraint" \| "AT_ReAddConstraint" \| "AT_ReAddDomainConstraint" \| "AT_AlterConstraint" \| "AT_ValidateConstraint" \| "AT_AddIndexConstraint" \| "AT_DropConstraint" \| "AT_ReAddComment" \| "AT_AlterColumnType" \| "AT_AlterColumnGenericOptions" \| "AT_ChangeOwner…	"AT_AddColumn" \| "AT_AddColumnToView" \| "AT_ColumnDefault" \| "AT_CookedColumnDefault" \| "AT_DropNotNull" \| "AT_SetNotNull" \| "AT_SetExpression" \| "AT_DropExpression" \| "AT_SetStatistics" \| "AT_SetOptions" \| "AT_ResetOptions" \| "AT_SetStorage" \| "AT_SetCompression" \| "AT_DropColumn" \| "AT_AddIndex" \| "AT_ReAddIndex" \| "AT_AddConstraint" \| "AT_ReAddConstraint" \| "AT_ReAddDomainConstraint" \| "AT_AlterConstraint" \| "AT_ValidateConstraint" \| "AT_AddIndexConstraint" \| "AT_DropConstraint" \| "AT_ReAddComment" \| "AT_AlterColumnType" \| "AT_AlterColumnGenericOptions" \| "AT_ChangeOwner" \| "AT_ClusterOn" \|…
`@pgsql/types/enums · RTEKind`	`"RTE_RELATION" \| "RTE_SUBQUERY" \| "RTE_JOIN" \| "RTE_FUNCTION" \| "RTE_TABLEFUNC" \| "RTE_VALUES" \| "RTE_CTE" \| "RTE_NAMEDTUPLESTORE" \| "RTE_RESULT"`	`"RTE_RELATION" \| "RTE_SUBQUERY" \| "RTE_JOIN" \| "RTE_FUNCTION" \| "RTE_TABLEFUNC" \| "RTE_VALUES" \| "RTE_CTE" \| "RTE_NAMEDTUPLESTORE" \| "RTE_RESULT" \| "RTE_GROUP"`
`@pgsql/types/enums · JoinType`	`"JOIN_INNER" \| "JOIN_LEFT" \| "JOIN_FULL" \| "JOIN_RIGHT" \| "JOIN_SEMI" \| "JOIN_ANTI" \| "JOIN_RIGHT_ANTI" \| "JOIN_UNIQUE_OUTER" \| "JOIN_UNIQUE_INNER"`	`"JOIN_INNER" \| "JOIN_LEFT" \| "JOIN_FULL" \| "JOIN_RIGHT" \| "JOIN_SEMI" \| "JOIN_ANTI" \| "JOIN_RIGHT_SEMI" \| "JOIN_RIGHT_ANTI" \| "JOIN_UNIQUE_OUTER" \| "JOIN_UNIQUE_INNER"`
`@pgsql/types/enums · ConstrType`	`"CONSTR_NULL" \| "CONSTR_NOTNULL" \| "CONSTR_DEFAULT" \| "CONSTR_IDENTITY" \| "CONSTR_GENERATED" \| "CONSTR_CHECK" \| "CONSTR_PRIMARY" \| "CONSTR_UNIQUE" \| "CONSTR_EXCLUSION" \| "CONSTR_FOREIGN" \| "CONSTR_ATTR_DEFERRABLE" \| "CONSTR_ATTR_NOT_DEFERRABLE" \| "CONSTR_ATTR_DEFERRED" \| "CONSTR_ATTR_IMMEDIATE"`	`"CONSTR_NULL" \| "CONSTR_NOTNULL" \| "CONSTR_DEFAULT" \| "CONSTR_IDENTITY" \| "CONSTR_GENERATED" \| "CONSTR_CHECK" \| "CONSTR_PRIMARY" \| "CONSTR_UNIQUE" \| "CONSTR_EXCLUSION" \| "CONSTR_FOREIGN" \| "CONSTR_ATTR_DEFERRABLE" \| "CONSTR_ATTR_NOT_DEFERRABLE" \| "CONSTR_ATTR_DEFERRED" \| "CONSTR_ATTR_IMMEDIATE" \| "CONSTR_ATTR_ENFORCED" \| "CONSTR_ATTR_NOT_ENFORCED"`
`@pgsql/types/enums · AlterTableType`	"AT_AddColumn" \| "AT_AddColumnToView" \| "AT_ColumnDefault" \| "AT_CookedColumnDefault" \| "AT_DropNotNull" \| "AT_SetNotNull" \| "AT_SetExpression" \| "AT_DropExpression" \| "AT_CheckNotNull" \| "AT_SetStatistics" \| "AT_SetOptions" \| "AT_ResetOptions" \| "AT_SetStorage" \| "AT_SetCompression" \| "AT_DropColumn" \| "AT_AddIndex" \| "AT_ReAddIndex" \| "AT_AddConstraint" \| "AT_ReAddConstraint" \| "AT_ReAddDomainConstraint" \| "AT_AlterConstraint" \| "AT_ValidateConstraint" \| "AT_AddIndexConstraint" \| "AT_DropConstraint" \| "AT_ReAddComment" \| "AT_AlterColumnType" \| "AT_AlterColumnGenericOptions" \| "AT_ChangeOwner…	"AT_AddColumn" \| "AT_AddColumnToView" \| "AT_ColumnDefault" \| "AT_CookedColumnDefault" \| "AT_DropNotNull" \| "AT_SetNotNull" \| "AT_SetExpression" \| "AT_DropExpression" \| "AT_SetStatistics" \| "AT_SetOptions" \| "AT_ResetOptions" \| "AT_SetStorage" \| "AT_SetCompression" \| "AT_DropColumn" \| "AT_AddIndex" \| "AT_ReAddIndex" \| "AT_AddConstraint" \| "AT_ReAddConstraint" \| "AT_ReAddDomainConstraint" \| "AT_AlterConstraint" \| "AT_ValidateConstraint" \| "AT_AddIndexConstraint" \| "AT_DropConstraint" \| "AT_ReAddComment" \| "AT_AlterColumnType" \| "AT_AlterColumnGenericOptions" \| "AT_ChangeOwner" \| "AT_ClusterOn" \|…