ChatGPT hallucinates a PostgreSQL setting that doesn't exist & someone tries to help in #postgresql

gistfile1.txt

12:39:17 <heanol> i'm testing an application built for postgresql 9 on postgresql 14 now
12:39:25 <heanol> one of the queries seem to work fine in pg9, but not pg14
12:39:46 <heanol> ERROR: column "xxx" must appear in the GROUP BY clause or be used in an aggregate function
12:39:54 <ilmari> "pg9" is 7 different versions. 9 point what?
12:39:56 <heanol> did the handling of that become stricter in a version?
12:40:11 <heanol> 9.5.24
12:43:22 <ilmari> not that I can see in https://why-upgrade.depesz.com/show?from=9.5.24&to=14&keywords=group+by
12:43:26 <Naktibalda> heanol: there is configuration option called sql_group_by_fixup
12:43:31 <ilmari> can you show the actual query and table definitions?
12:44:58 <ilmari> Naktibalda: postgres doesn't have and has never had such an option
12:45:14 <ilmari> Naktibalda: neither google and duckduckgo know about it
12:46:41 <Naktibalda> interesting, did chatgpt make it up?
12:46:45 <ilmari> yes
12:47:07 <ilmari> it makes up all sorts of shit. don't use it for anything that involves actual knowledge of things that exist
12:47:20 <ilmari> it doesn't know what anything is, only what language look like
12:47:24 <ilmari> *looks
12:48:15 <Naktibalda> it apologized for making mistake, wtf
12:48:16 <ilmari> _espeicially_ don't use it for giving advice to others without first verifying that what it said is correct
12:48:54 <depesz> i'm tempted to auto-ignore all people mentioning chatgpt
12:49:23 <depesz> it's 2nd time in a week that someone gets "advice" from some ai system
12:51:56 <tykling> depesz: the problem is they don't mention it (until called out on it), they (try to) pass off the advice as their own
12:56:31 <Naktibalda> I apologize and I won't do it again here.
12:56:51 <depesz> Naktibalda: just don't use "ai" for getting tech related information.
12:56:56 <depesz> as in: reliable information.