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 austin...@puppet.com < austin.bl...@puppet.com> 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 ch...@picomes.com 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 dhei...@opentext.com >> 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*: dhei...@opentext.com >>> *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 > puppet-users+unsubscr...@googlegroups.com. > 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 puppet-users+unsubscr...@googlegroups.com. 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.
