pg should ignore u+200b zero width space

From: James Cloos <cloos(at)jhcloos(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: pg should ignore u+200b zero width space
Date: 2020-11-03 13:41:23
Message-ID: m3k0v21rss.fsf@carbon.jhcloos.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

i had a hell of a night last night trying to figure out what was wrong
with an attempt to use on constraint.

this morning i tried again and it worked.

but pasting the failed line from .psql_history into psql still failed.

i had to resort to od(1) to discover a no break space showed up just
before on constraint in the failing lines.

pg should treat a no break space after whitespace as just more
whitespace.

i'm not sure about alone between printing characters, but definitely
immediately after current whitespace characters.

[sent directly to the list because the 'community login' form is b0rked.]

-JimC
--
James Cloos <cloos(at)jhcloos(dot)com> OpenPGP: 0x997A9F17ED7DAEA6

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2020-11-03 13:52:45 Re: pg should ignore u+200b zero width space
Previous Message Miha Vrhovnik 2020-11-03 13:14:05 Re: BUG #16698: Create extension and search path