Skip to content

[Messenger] Fix function name in TriggerSql on postgresql bridge to support table name with schema #47070

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed

Conversation

zimny9932
Copy link
Contributor

…support table name with schema

Q A
Branch? 5.4
Bug fix? yes
New feature? no
Deprecations? no
Tickets Fix #46984
License MIT

Allow use schema in table_name option when configure postgresql transport. There was a problem with procedure name in getTriggerSql function in Symfony\Component\Messenger\Bridge\Doctrine\Transport\PostgreSqlConnection.

@carsonbot
Copy link

Hey!

I see that this is your first PR. That is great! Welcome!

Symfony has a contribution guide which I suggest you to read.

In short:

  • Always add tests
  • Keep backward compatibility (see https://symfony.com/bc).
  • Bug fixes must be submitted against the lowest maintained branch where they apply (see https://symfony.com/releases)
  • Features and deprecations must be submitted against the 6.2 branch.

Review the GitHub status checks of your pull request and try to solve the reported issues. If some tests are failing, try to see if they are failing because of this change.

When two Symfony core team members approve this change, it will be merged and you will become an official Symfony contributor!
If this PR is merged in a lower version branch, it will be merged up to all maintained branches within a few days.

I am going to sit back now and wait for the reviews.

Cheers!

Carsonbot

Copy link

@thamine-cleverside thamine-cleverside left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

The PR fixes the bug, but still create the function inside the default schema (public)
I suggest to add this code in order to put the function in the specified schema

@zimny9932 zimny9932 force-pushed the messenger-postgres-trigger-sql-fix branch from bf2c22e to c26d122 Compare July 27, 2022 19:39
@carsonbot carsonbot changed the title Messenger postgres trigger sql fix [Messenger] Messenger postgres trigger sql fix Jul 28, 2022
@nicolas-grekas nicolas-grekas changed the title [Messenger] Messenger postgres trigger sql fix [Messenger] Fix function name in TriggerSql on postgresql bridge to support table name with schema Jul 28, 2022
@fabpot
Copy link
Member

fabpot commented Jul 28, 2022

Thank you @zimny9932.

fabpot added a commit that referenced this pull request Jul 28, 2022
…bridge to support table name with schema (zimny9932)

This PR was squashed before being merged into the 5.4 branch.

Discussion
----------

[Messenger] Fix function name in TriggerSql on postgresql bridge to support table name with schema

…support table name with schema

| Q             | A
| ------------- | ---
| Branch?       | 5.4
| Bug fix?      | yes
| New feature?  | no
| Deprecations? | no
| Tickets       | Fix #46984
| License       | MIT

Allow use schema in table_name option when configure postgresql transport. There was a problem with procedure name in getTriggerSql function in Symfony\Component\Messenger\Bridge\Doctrine\Transport\PostgreSqlConnection.

Commits
-------

64e7c9b [Messenger] Fix function name in TriggerSql on postgresql bridge to support table name with schema
@fabpot fabpot closed this Jul 28, 2022
@fabpot fabpot force-pushed the messenger-postgres-trigger-sql-fix branch from 545cc3a to 64e7c9b Compare July 28, 2022 08:28
This was referenced Jul 29, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

5 participants