René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"pgx transaction example improvements","articleBody":"### Version\n\n1.28.0\n\n### What happened?\n\nThe example for how to do transactions with pgx added in #3557 will always run `Rollback`. The rollback will return an error which appears silent, but isn't if pgx is wrapped in opentelemetry tracing.\n\nInstead of always doing a Rollback I believe you can make a `context.WithCancel` context and then `defer cancel()` will rollback the transaction if it's not already committed.\n\n### Relevant log output\n\n```shell\n\n```\n\n### Database schema\n\n```sql\n\n```\n\n### SQL queries\n\n```sql\n\n```\n\n### Configuration\n\n```yaml\n\n```\n\n### Playground URL\n\n_No response_\n\n### What operating system are you using?\n\n_No response_\n\n### What database engines are you using?\n\n_No response_\n\n### What type of code are you generating?\n\n_No response_","author":{"url":"https://github.com/abh","@type":"Person","name":"abh"},"datePublished":"2025-01-25T07:48:38.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/3808/sqlc/issues/3808"}