Method PinChatByID

coderd/database/querier.go:1096–1096

Under READ COMMITTED, concurrent pin operations for the same owner may momentarily produce duplicate pin_order values because each CTE snapshot does not see the other's writes. The next pin/unpin/reorder operation's ROW_NUMBER() self-heals the sequence, so this is acceptable.

(ctx context.Context, id uuid.UUID)

	// pin/unpin/reorder operation's ROW_NUMBER() self-heals the
	// sequence, so this is acceptable.
	PinChatByID(ctx context.Context, id uuid.UUID) error
	PopNextQueuedMessage(ctx context.Context, chatID uuid.UUID) (ChatQueuedMessage, error)
	ReduceWorkspaceAgentShareLevelToAuthenticatedByTemplate(ctx context.Context, templateID uuid.UUID) error
	RegisterWorkspaceProxy(ctx context.Context, arg RegisterWorkspaceProxyParams) (WorkspaceProxy, error)