(amoro) branch master updated: [hotfix][postgres] Fix org.postgresql.util.PSQLException: ERROR: column name must be qualified (#4396)

[jinsongzhou]

This is an automated email from the ASF dual-hosted git repository.

zhoujinsong pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/amoro.git


The following commit(s) were added to refs/heads/master by this push:
     new ac9a343df [hotfix][postgres] Fix org.postgresql.util.PSQLException: 
ERROR: column name must be qualified (#4396)
ac9a343df is described below

commit ac9a343df0fb873a184815e31ddd9bb40afe10f1
Author: Nikita Ryanov <ryanov.nik...@gmail.com>
AuthorDate: Fri Oct 9 14:45:13 2026 +0300

    [hotfix][postgres] Fix org.postgresql.util.PSQLException: ERROR: column 
name must be qualified (#4396)
---
 .../src/main/resources/postgres/ams-postgres-init.sql      | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)

diff --git a/amoro-ams/src/main/resources/postgres/ams-postgres-init.sql 
b/amoro-ams/src/main/resources/postgres/ams-postgres-init.sql
index 5f1494bc0..4dd8098f8 100644
--- a/amoro-ams/src/main/resources/postgres/ams-postgres-init.sql
+++ b/amoro-ams/src/main/resources/postgres/ams-postgres-init.sql
@@ -470,10 +470,10 @@ CREATE TABLE IF NOT EXISTS bucket_assignments (
 
 CREATE INDEX IF NOT EXISTS idx_bucket_assignments_cluster ON 
bucket_assignments (cluster_name);
 
-COMMENT ON COLUMN service_name IS 'Service name 
(AMS/TABLE_SERVICE/OPTIMIZING_SERVICE)';
-COMMENT ON COLUMN node_id IS 'Unique node identifier (host:port:uuid)';
-COMMENT ON COLUMN node_ip IS 'Node IP address';
-COMMENT ON COLUMN server_info_json IS 'JSON encoded server info 
(AmsServerInfo)';
-COMMENT ON COLUMN lease_expire_ts IS 'Lease expiration timestamp (ms since 
epoch)';
-COMMENT ON COLUMN version IS 'Optimistic lock version of the lease row';
-COMMENT ON COLUMN updated_at IS 'Last update timestamp (ms since epoch)';
+COMMENT ON COLUMN ha_lease.service_name IS 'Service name 
(AMS/TABLE_SERVICE/OPTIMIZING_SERVICE)';
+COMMENT ON COLUMN ha_lease.node_id IS 'Unique node identifier 
(host:port:uuid)';
+COMMENT ON COLUMN ha_lease.node_ip IS 'Node IP address';
+COMMENT ON COLUMN ha_lease.server_info_json IS 'JSON encoded server info 
(AmsServerInfo)';
+COMMENT ON COLUMN ha_lease.lease_expire_ts IS 'Lease expiration timestamp (ms 
since epoch)';
+COMMENT ON COLUMN ha_lease.version IS 'Optimistic lock version of the lease 
row';
+COMMENT ON COLUMN ha_lease.updated_at IS 'Last update timestamp (ms since 
epoch)';