<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clip

I think <a class="issue-link js-issue-link" data-error-text="Failed to load title" dat

I think there's a bug here, albeit at the edge. <div class="snippet-clipboard-cont

Misleading Error Message when extension name is > NAMEDATALEN about pg_tle HOT 3 OPEN

aws commented on August 25, 2024

Misleading Error Message when extension name is > NAMEDATALEN

from pg_tle.

Comments (3)

jkatz commented on August 25, 2024

I think #103 may address this. Going to try that out...

from pg_tle.

jkatz commented on August 25, 2024

I think there's a bug here, albeit at the edge.

NOTICE:  identifier "test9greaterthanNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALEN.control" will be truncated to "test9greaterthanNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAM"
NOTICE:  identifier "test9greaterthanNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALEN--0.1.sql" will be truncated to "test9greaterthanNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAM"
ERROR:  Extension 'test9greaterthanNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALENNAMEDATALEN' already installed.

What's happening is that the two functions we create (control function, version function) are truncated to have the same name. So it's coming across as the extension is already installed when really it's just the name is too long.

So yes, it's a misleading error message, but we're not capping the name of the extension to an appropriate length.

from pg_tle.

jkatz commented on August 25, 2024

Lowering the priority on this. I don't think this has v1.0.0 impact as it's an edge case. We should fix it in the fullness of time.

Leaving this in the milestone in case someone wants to pick it up, but deprioritizing it.

from pg_tle.

Recommend Projects