将 @pgsql/types 从 17.x 升级到 18.x

根据 TypeScript 类型自动比较 @pgsql/types 17.6.2 与 18.0.0 的公开 API。签名变化表示可能存在不兼容变更，并非确定结论。

概要

已删除的导入路径	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" \|…