Skip to content
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

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

Closed

Conversation

zimny9932
Copy link
Contributor

@zimny9932 zimny9932 commented Jul 26, 2022

…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

@carsonbot carsonbot commented Jul 26, 2022

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

fabpot
fabpot approved these changes Jul 27, 2022
Copy link

@thamine-cleverside thamine-cleverside left a comment

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

@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 fabpot commented Jul 28, 2022

Thank you @zimny9932.

fabpot added a commit that referenced this issue 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 Jul 28, 2022
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.

None yet

5 participants