plpython2u
E427684
plpython2u is an untrusted PostgreSQL procedural language extension that allows writing database functions in Python 2.
All labels observed (2)
| Label | Occurrences |
|---|---|
| PL/PythonU (Python 2 variant) | 1 |
| plpython2u canonical | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T4279259 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: plpython2u Context triple: [PL/Python, hasVariant, plpython2u]
-
A.
Pythonidae
Pythonidae is a family of nonvenomous constrictor snakes that includes pythons found across Africa, Asia, and Australia.
-
B.
PyPy
PyPy is a high-performance alternative Python interpreter featuring a Just-In-Time (JIT) compiler designed to significantly speed up the execution of Python programs.
-
C.
PiTaPa
PiTaPa is a rechargeable contactless smart card system used for fare payment on public transportation networks in the Kansai region of Japan.
-
D.
Apollo slaying Python
"Apollo slaying Python" is a mythological episode in which the Greek god Apollo kills the serpent Python at Delphi, establishing his divine authority over the sanctuary and inspiring later religious rites and festivals.
-
E.
Python
Python is a monstrous serpent or dragon from Greek mythology, best known for being slain by the god Apollo at Delphi.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: plpython2u Target entity description: plpython2u is an untrusted PostgreSQL procedural language extension that allows writing database functions in Python 2.
-
A.
Pythonidae
Pythonidae is a family of nonvenomous constrictor snakes that includes pythons found across Africa, Asia, and Australia.
-
B.
PyPy
PyPy is a high-performance alternative Python interpreter featuring a Just-In-Time (JIT) compiler designed to significantly speed up the execution of Python programs.
-
C.
PiTaPa
PiTaPa is a rechargeable contactless smart card system used for fare payment on public transportation networks in the Kansai region of Japan.
-
D.
Apollo slaying Python
"Apollo slaying Python" is a mythological episode in which the Greek god Apollo kills the serpent Python at Delphi, establishing his divine authority over the sanctuary and inspiring later religious rites and festivals.
-
E.
Python
Python is a monstrous serpent or dragon from Greek mythology, best known for being slain by the god Apollo at Delphi.
- F. None of above. chosen
Statements (48)
| Predicate | Object |
|---|---|
| instanceOf |
PostgreSQL extension
ⓘ
PostgreSQL procedural language ⓘ untrusted procedural language ⓘ |
| allowsWriting | PostgreSQL functions in Python 2 ⓘ |
| belongsToCategory | server-side scripting language for PostgreSQL ⓘ |
| canAccess |
file system of database server
ⓘ
network from database server ⓘ |
| canBeOwnedBy | database superuser ⓘ |
| canImport | standard Python 2 libraries ⓘ |
| executionContext | per-session Python interpreter ⓘ |
| executionModel | functions executed inside backend process, not separate OS process ⓘ |
| hasLanguageName |
PL/PythonU (Python 2 variant)
ⓘ
linked to:
plpython2u
|
| hasLimitation |
not suitable for shared hosting environments
ⓘ
tied to Python 2 syntax and libraries ⓘ |
| hasRisk | arbitrary code execution in database backend ⓘ |
| hasSecurityModel | no sandboxing inside database backend ⓘ |
| implementationLanguage | C ⓘ |
| introducedBefore | PostgreSQL 9.x era ⓘ |
| isAffectedBy | Python 2 end-of-life (January 1, 2020) ⓘ |
| isCreatedWithCommand |
CREATE EXTENSION plpython2u
ⓘ
CREATE LANGUAGE plpython2u ⓘ |
| isDeprecatedFor | new development due to Python 2 end-of-life ⓘ |
| isDocumentedIn |
PostgreSQL official documentation
ⓘ
linked to:
PostgreSQL documentation
|
| isPackagedWith | many standard PostgreSQL distributions ⓘ |
| isPartOf | PostgreSQL procedural languages family ⓘ |
| isRelatedTo |
plpython3u
ⓘ
plpythonu ⓘ
linked to:
PL/Python
|
| languageHandlerFunction | plpython_call_handler ⓘ |
| namingConvention | suffix "u" indicates untrusted language ⓘ |
| recommendedAlternative | plpython3u ⓘ |
| requires | Python 2 interpreter on server ⓘ |
| requiresPrivilege | superuser to create language ⓘ |
| runsIn | PostgreSQL server process ⓘ |
| securityRecommendation | avoid granting to untrusted users ⓘ |
| supportsDataExchange |
conversion of JSON to Python objects
ⓘ
conversion of arrays to Python lists ⓘ conversion of records to Python dictionaries ⓘ mapping between PostgreSQL types and Python types ⓘ |
| supportsFeature |
returning composite types
ⓘ
returning sets ⓘ using Python modules inside database functions ⓘ using SPI to execute SQL ⓘ writing SQL-callable functions ⓘ writing trigger functions ⓘ |
| supportsLanguage |
Python 2
ⓘ
linked to:
Python
|
| trustedStatus | untrusted ⓘ |
| usedFor |
embedding business logic in database using Python 2
ⓘ
rapid prototyping of database functions in Python 2 ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: plpython2u Description of subject: plpython2u is an untrusted PostgreSQL procedural language extension that allows writing database functions in Python 2.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.
linked to: plpython2u