fix(cli): improve init error output

Nik Samokhvalov · Nik Samokhvalov · commit b33b9af9e906 · 2025-12-13T11:07:27.000-08:00
- Avoid blank init failure messages; show code/detail/hint when available

- Add regression test ensuring missing-connection error includes examples
diff --git a/cli/bin/postgres-ai.ts b/cli/bin/postgres-ai.ts
@@ -255,8 +255,29 @@ program
       }
     } catch (error) {
       const errAny = error as any;
-      const message = error instanceof Error ? error.message : String(error);
+      let message = "";
+      if (error instanceof Error && error.message) {
+        message = error.message;
+      } else if (errAny && typeof errAny === "object" && typeof errAny.message === "string" && errAny.message) {
+        message = errAny.message;
+      } else {
+        message = String(error);
+      }
+      if (!message || message === "[object Object]") {
+        message = "Unknown error";
+      }
       console.error(`✗ init failed: ${message}`);
+      if (errAny && typeof errAny === "object") {
+        if (typeof errAny.code === "string" && errAny.code) {
+          console.error(`Error code: ${errAny.code}`);
+        }
+        if (typeof errAny.detail === "string" && errAny.detail) {
+          console.error(`Detail: ${errAny.detail}`);
+        }
+        if (typeof errAny.hint === "string" && errAny.hint) {
+          console.error(`Hint: ${errAny.hint}`);
+        }
+      }
       if (errAny && typeof errAny === "object" && typeof errAny.code === "string") {
         if (errAny.code === "42501") {
           console.error("Hint: connect as a superuser (or a role with CREATEROLE and sufficient GRANT privileges).");
diff --git a/cli/test/init.test.cjs b/cli/test/init.test.cjs
@@ -95,6 +95,10 @@ test("resolveAdminConnection rejects when only PGPASSWORD is provided (no connec
   assert.throws(() => init.resolveAdminConnection({ envPassword: "pw" }), /Connection is required/);
 });
 
+test("resolveAdminConnection error message includes examples", () => {
+  assert.throws(() => init.resolveAdminConnection({}), /Examples:/);
+});
+
 test("print-sql redaction regex matches password literal with embedded quotes", async () => {
   const plan = await init.buildInitPlan({
     database: "mydb",
