Okay, cool, so I just need to downgrade postrgres, as I don't want to take on a 6->7 upgrade right now.
Thanks. On Thu, Dec 1, 2022 at 11:51 AM [email protected] < [email protected]> wrote: > We noticed this when attempting to add testing for Postgres 15 and put up > a maintenance commit that fixed it > https://github.com/puppetlabs/puppetdb/commit/689e4cbae0773363bb9722fad5a8d7f415b00737. > The commit message describes the two breaking changes in Postgres 15 that > affected PuppetDB (one was a test-only issue), but what you are seeing is a > change that made the Postgres query parser more strict and it started > rejecting the query given its lack of space between the parameter and the > AND clause. > > Given the late stage of Puppet Platform 6's lifecycle, we currently only > added support for Postgres 15 to PuppetDB 7. There is a Puppet Platform 7 > release scheduled soon, so the packages that fix this issue will be > available shortly. > > - Austin > > On Thursday, December 1, 2022 at 7:13:43 AM UTC-8 [email protected] wrote: > >> Yes, that is the issue... the question is, where is this generated, and >> how do I fix it....... >> >> On Thursday, December 1, 2022 at 1:51:07 AM UTC-5 [email protected] >> wrote: >> >>> Am Mittwoch, dem 30.11.2022 um 07:58 -0800 schrieb Chris Hoffman: >>> >>> certname = $3AND >>> >>> >>> Is this a typo or is there really no blank between "$3" and "AND"? If >>> there really isn't one, that would explain it. >>> >>> Bye... >>> >>> Dirk >>> >>> -- >>> >>> *Dirk Heinrichs* >>> Senior Systems Engineer, Delivery Pipeline >>> OpenText ™ Discovery | Recommind >>> *Phone*: +49 2226 15966 18 <+49%202226%201596618> >>> *Email*: [email protected] >>> *Website*: www.recommind.de >>> Recommind GmbH, Von-Liebig-Straße 1, 53359 Rheinbach >>> Vertretungsberechtigte Geschäftsführer Gordon Davies, Madhu Ranganathan, >>> Christian Waida, Registergericht Amtsgericht Bonn, Registernummer HRB 10646 >>> This e-mail may contain confidential and/or privileged information. If >>> you are not the intended recipient (or have received this e-mail in error) >>> please notify the sender immediately and destroy this e-mail. Any >>> unauthorized copying, disclosure or distribution of the material in this >>> e-mail is strictly forbidden >>> Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte >>> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail >>> irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und >>> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte >>> Weitergabe dieser Mail sind nicht gestattet. >>> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "Puppet Users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/puppet-users/R7uzBTGJFXg/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/b81bbbf5-5ad5-45f3-b4dc-00bd14d68ea2n%40googlegroups.com > <https://groups.google.com/d/msgid/puppet-users/b81bbbf5-5ad5-45f3-b4dc-00bd14d68ea2n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CAL_djRy%3DNMTckKxyttWuv%3DUQ_HvLmZ0GGuzDibsJeJ26R1u6-A%40mail.gmail.com.
