sql: it is not possible to rename a table that doesn't have a primary key

**Describe the problem**

Given a table as follows

```
CREATE TABLE "People" (
"Id" integer GENERATED BY DEFAULT AS IDENTITY,
CONSTRAINT "PK_People" PRIMARY KEY ("Id")
);
```

The scenario is to rename to table to `Persons` and at the same time rename the primary key constraint to `PK_Persons`. The following SQL is used for the migration

```
BEGIN;
ALTER TABLE "People" DROP CONSTRAINT "PK_People";

ALTER TABLE "People" RENAME TO "Persons";

ALTER TABLE "Persons" ADD CONSTRAINT "PK_Persons" PRIMARY KEY ("Id");
COMMIT;
```

which returns

```
SQLSTATE: 55C02
ERROR: requested table does not have a primary key
```

This error message is from the statement `ALTER TABLE "People" RENAME TO "Persons";`

**Additional context**
This affects efcore.pg tests

@fqazi @rafiss

Jira issue: CRDB-32232

Epic CRDB-60817

Start by running the reported SQL transaction with the People table and confirm that renaming it after dropping its primary key returns SQLSTATE 55C02. Review the affected efcore.pg tests and the ALTER TABLE rename path; done means the table can be renamed and the PK_Persons constraint added successfully in the same migration.

Written by the indexing model from the issue text.