Quick Links

string escaping in tutorial/syscat.source

From:	Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To:	pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	string escaping in tutorial/syscat.source
Date:	2012-10-15 03:53:51
Message-ID:	CAK3UJREtO1QEi3uRWaaJBg8giOaX8fFCv7vaQoQ5RLhYTOKx5w@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

Hi all,
It seems the queries in ./src/tutorial/syscat.source use string
escaping with the assumption that standard_conforming_strings is off,
and thus give wrong results with modern versions. A simple fix is
attached.
Josh

Attachment	Content-Type	Size
syscat.source_escaping.diff	application/octet-stream	3.6 KB

Responses

string escaping in tutorial/syscat.source at 2013-01-16 01:35:15 from Jeff Janes
Re: string escaping in tutorial/syscat.source at 2013-01-19 22:23:19 from Tom Lane

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Pavel Stehule	2012-10-15 03:57:42	Re: proposal - assign result of query to psql variable
Previous Message	Tom Lane	2012-10-15 03:02:44	Re: Making the planner more tolerant of implicit/explicit casts