On 2/14/16 7:09 PM, Tom Lane wrote:
> Yeah, that's what I was thinking about. But yes, if we append the OID
> anyway then we might as well just strip all non-alphanumeric chars
> from the name. Safe and you still get some debuggability.
Attached. I opted not to modify the name in-place. If it's safe to
modify in place, might want to just replace invalid characters with '_'
instead of making a copy.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com