type Application @table { id: String! @unique # other properties here } type Snapshot @table (key: [ "application", "version"]) { # The id property must be there, else, can't self reference id: UUID! @unique @default(expr: "uuidV4()") application: Application! version: String! # other properties here } type Style @table (key: [ "id", "snapshot"]) { id: String! prompt: String! snapshot: Snapshot! @ref(references: "id") # other properties here } 

SQL query error: pq: unexpected message 'E'; expected ReadyForQuery WITH "style_upsertMany_0" AS (INSERT INTO "public"."style" ( "created_at" , "id" , "prompt" , "snapshot_id" , "updated_at" ) VALUES (timestamptz '2025-05-30T07:56:18.850000Z','style','Anything Here !!!!!!!!!!!!!!','b587429f-1811-4aa9-93fc-10941508f69a'::uuid,timestamptz '2025-05-30T07:56:18.850000Z') ON CONFLICT ( "id" , "snapshot_id" ) DO UPDATE SET "created_at" = excluded. "created_at" , "id" = excluded. "id" , "prompt" = excluded. "prompt" , "snapshot_id" = excluded. "snapshot_id" , "updated_at" = excluded. "updated_at" RETURNING jsonb_build_object('id', "id" , 'snapshotId', REPLACE(CAST(( "snapshot_id" ) AS text), '-', '')) AS j), "style_upsertMany_1" AS (INSERT INTO "public"."style" ( "created_at" , "id" , "prompt" , "snapshot_id" , "updated_at" ) VALUES (timestamptz '2025-05-30T07:56:18.850000Z','stylex','Some Text Describing what the expected outcome should look like','b587429f-1811-4aa9-93fc-10941508f69a'::uuid,timestamptz '2025-05-30T07:56:18.850000Z') ON CONFLICT ( "id" , "snapshot_id" ) DO UPDATE SET "created_at" = excluded. "created_at" , "id" = excluded. "id" , "prompt" = excluded. "prompt" , "snapshot_id" = excluded. "snapshot_id" , "updated_at" = excluded. "updated_at" RETURNING jsonb_build_object('id', "id" , 'snapshotId', REPLACE(CAST(( "snapshot_id" ) AS text), '-', '')) AS j), "style_upsertMany_temp" AS (SELECT * FROM "style_upsertMany_0" UNION ALL SELECT * FROM "style_upsertMany_1" ) SELECT coalesce(json_agg(j), '[]') FROM "style_upsertMany_temp" Params: [] 

I0530 11:01:35.797815 20032 load.go:37] Reloading schema and connectors... I0530 11:01:35.856012 20032 control.go:73] [/emulator/backend 4a6f] UpdateResources(): done Schema: sources: schema\schema.gql [2459B] Connector "default": sources: connector\users.queries.gql [791B] connector\applications.mutations.gql [3603B] connector\applications.queries.gql [2376B] connector\users.mutations.gql [969B] I0530 11:01:35.910477 20032 codegen.go:82] [connector "default" javascriptSdk] Generating sources into "C:\\Petit p\\densograph_2\\citygraph\\lib\\js\\default-connector" I0530 11:01:35.937628 20032 collector.go:107] schema extensions wrote into "C:\\Petit p\\densograph_2\\backend\\dataconnect\\.dataconnect\\schema" Generated sources: prelude.gql [71531B] main\implicit.gql [3786B] main\input.gql [70283B] main\relation.gql [41228B] main\query.gql [10088B] main\mutation.gql [27480B] I0530 11:01:35.942533 20032 collector.go:107] connector "default" javascriptSdk wrote into "C:\\Petit p\\densograph_2\\citygraph\\lib\\js\\default-connector" Generated sources: react\index.d.ts [13204B] react\esm\package.json [17B] react\index.cjs.js [10377B] react\esm\index.esm.js [9766B] esm\index.esm.js [11259B] esm\package.json [17B] README.md [125595B] react\package.json [456B] react\README.md [130107B] index.d.ts [26740B] index.cjs.js [13004B] package.json [848B] I0530 11:01:35.951584 20032 installsdk.go:80] Running command: C:\Users\USER\AppData\Local\fnm_multishells\30576_1748595423183\npm.cmd install file:lib\js\default-connector I0530 11:01:38.719237 20032 load.go:115] Finished reloading I0530 11:01:38.720264 20032 dev.go:95] Listening on address (HTTP + gRPC): 127.0.0.1:9399 I0530 11:01:38.720264 20032 dev.go:95] Listening on address (HTTP + gRPC): [::1]:9399 I0530 11:01:40.802904 20032 migrate.go:24] Running migration SQL: Step 1: ALTER TABLE "public"."style" DROP CONSTRAINT "style_pkey", ADD PRIMARY KEY ("id", "snapshot_id") Step 2: DROP INDEX "public"."style_spec_styleId_idx" Step 3: ALTER TABLE "public"."style_spec" DROP CONSTRAINT "style_spec_style_id_fkey", DROP COLUMN "title", ADD COLUMN "style_snapshot_id" uuid NOT NULL, ADD COLUMN "created_at" timestamptz NOT NULL, ADD COLUMN "enforced" boolean NOT NULL, ADD COLUMN "label" text NOT NULL, ADD CONSTRAINT "style_spec_style_id_style_snapshot_id_fkey" FOREIGN KEY ("style_id", "style_snapshot_id") REFERENCES "public"."style" ("id", "snapshot_id") ON DELETE CASCADE Step 4: CREATE INDEX "style_spec_styleId_styleSnapshotId_idx" ON "public"."style_spec" ("style_id", "style_snapshot_id") Step 5: CREATE UNIQUE INDEX "style_spec_id_uidx" ON "public"."style_spec" ("id") E0530 11:01:40.810941 20032 service.go:89] [/emulator/backend 172d] failed to migrate schema: SQL migration error: failed to apply migration: failed to execute SQL migration step 1 modify "style" table: pq: cannot drop constraint style_pkey on table style because other objects depend on it SQL: ALTER TABLE "public"."style" DROP CONSTRAINT "style_pkey", ADD PRIMARY KEY ("id", "snapshot_id") Original plan: Step 1: ALTER TABLE "public"."style" DROP CONSTRAINT "style_pkey", ADD PRIMARY KEY ("id", "snapshot_id") Step 2: DROP INDEX "public"."style_spec_styleId_idx" Step 3: ALTER TABLE "public"."style_spec" DROP CONSTRAINT "style_spec_style_id_fkey", DROP COLUMN "title", ADD COLUMN "style_snapshot_id" uuid NOT NULL, ADD COLUMN "created_at" timestamptz NOT NULL, ADD COLUMN "enforced" boolean NOT NULL, ADD COLUMN "label" text NOT NULL, ADD CONSTRAINT "style_spec_style_id_style_snapshot_id_fkey" FOREIGN KEY ("style_id", "style_snapshot_id") REFERENCES "public"."style" ("id", "snapshot_id") ON DELETE CASCADE Step 4: CREATE INDEX "style_spec_styleId_styleSnapshotId_idx" ON "public"."style_spec" ("style_id", "style_snapshot_id") Step 5: CREATE UNIQUE INDEX "style_spec_id_uidx" ON "public"."style_spec" ("id") I0530 11:01:40.841493 20032 control.go:73] [/emulator/backend 172d] UpdateResources(): done Schema: sources: schema\schema.gql [2459B] Connector "default": sources: connector\users.queries.gql [791B] connector\applications.mutations.gql [3603B] connector\applications.queries.gql [2376B] connector\users.mutations.gql [969B] I0530 11:02:05.713112 20032 prepare.go:118] [operation "" attempt 1] preparePlan succeeded I0530 11:02:05.713112 20032 prepare.go:109] [operation "" attempt 1] DBStats beforePrepare: sql.DBStats{MaxOpenConnections:1, OpenConnections:1, InUse:0, Idle:1, WaitCount:0, WaitDuration:0, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:0}, afterPrepare: sql.DBStats{MaxOpenConnections:1, OpenConnections:1, InUse:0, Idle:1, WaitCount:0, WaitDuration:0, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:0} I0530 11:02:05.730166 20032 executor.go:97] [operation "" attempt 1] DBStats beforeRun: sql.DBStats{MaxOpenConnections:1, OpenConnections:1, InUse:0, Idle:1, WaitCount:0, WaitDuration:0, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:0}, afterRun: sql.DBStats{MaxOpenConnections:1, OpenConnections:1, InUse:0, Idle:1, WaitCount:0, WaitDuration:0, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:0} I0530 11:02:05.730860 20032 engine.go:170] [/emulator/backend 172d] ExecuteGraphql : succeeded. I0530 11:02:09.758296 20032 prepare.go:118] [operation "" attempt 1] preparePlan succeeded I0530 11:02:09.758296 20032 prepare.go:109] [operation "" attempt 1] DBStats beforePrepare: sql.DBStats{MaxOpenConnections:1, OpenConnections:1, InUse:0, Idle:1, WaitCount:0, WaitDuration:0, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:0}, afterPrepare: sql.DBStats{MaxOpenConnections:1, OpenConnections:1, InUse:0, Idle:1, WaitCount:0, WaitDuration:0, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:0} I0530 11:02:09.768232 20032 executor.go:97] [operation "" attempt 1] DBStats beforeRun: sql.DBStats{MaxOpenConnections:1, OpenConnections:1, InUse:0, Idle:1, WaitCount:0, WaitDuration:0, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:0}, afterRun: sql.DBStats{MaxOpenConnections:1, OpenConnections:0, InUse:0, Idle:0, WaitCount:0, WaitDuration:0, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:0} W0530 11:02:09.768232 20032 engine.go:174] [/emulator/backend 172d] ExecuteGraphql : failed. Auth: admin Errors: input: style_upsertMany SQL query error: pq: unexpected message 'E'; expected ReadyForQuery WITH "style_upsertMany_0" AS (INSERT INTO "public"."style" ( "created_at" , "id" , "prompt" , "snapshot_id" , "updated_at" ) VALUES (timestamptz '2025-05-30T07:56:18.850000Z','style','Anything Here !!!!!!!!!!!!!!','b587429f-1811-4aa9-93fc-10941508f69a'::uuid,timestamptz '2025-05-30T07:56:18.850000Z') ON CONFLICT ( "id" , "snapshot_id" ) DO UPDATE SET "created_at" = excluded. "created_at" , "id" = excluded. "id" , "prompt" = excluded. "prompt" , "snapshot_id" = excluded. "snapshot_id" , "updated_at" = excluded. "updated_at" RETURNING jsonb_build_object('id', "id" , 'snapshotId', REPLACE(CAST(( "snapshot_id" ) AS text), '-', '')) AS j), "style_upsertMany_1" AS (INSERT INTO "public"."style" ( "created_at" , "id" , "prompt" , "snapshot_id" , "updated_at" ) VALUES (timestamptz '2025-05-30T07:56:18.850000Z','stylex','Some Text Describing what the expected outcome should look like','b587429f-1811-4aa9-93fc-10941508f69a'::uuid,timestamptz '2025-05-30T07:56:18.850000Z') ON CONFLICT ( "id" , "snapshot_id" ) DO UPDATE SET "created_at" = excluded. "created_at" , "id" = excluded. "id" , "prompt" = excluded. "prompt" , "snapshot_id" = excluded. "snapshot_id" , "updated_at" = excluded. "updated_at" RETURNING jsonb_build_object('id', "id" , 'snapshotId', REPLACE(CAST(( "snapshot_id" ) AS text), '-', '')) AS j), "style_upsertMany_temp" AS (SELECT * FROM "style_upsertMany_0" UNION ALL SELECT * FROM "style_upsertMany_1" ) SELECT coalesce(json_agg(j), '[]') FROM "style_upsertMany_temp" Params: [] Data: { "style_upsertMany": null } sources: input [666B]