PL/Tcl
E97111
PL/Tcl is a procedural language extension for PostgreSQL that allows writing database functions and triggers using the Tcl scripting language.
All labels observed (2)
| Label | Occurrences |
|---|---|
| PL/Tcl canonical | 1 |
| SPI (Server Programming Interface) access from Tcl | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T816969 — 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: PL/Tcl Context triple: [PostgreSQL, supportsLanguage, PL/Tcl]
-
A.
PDL
PDL is a former name for USL League Two, a North American pre-professional soccer league that serves as a key development platform for college-aged and aspiring professional players.
-
B.
SETL
SETL is a high-level programming language developed in the late 1960s that is notable for its powerful set-theoretic abstractions and influence on later language design.
-
C.
TXL
TXL was the IATA airport code for Berlin Tegel Airport, the former main international airport of Berlin, Germany.
-
D.
Pascal
Pascal is a high-level, strongly typed procedural programming language designed by Niklaus Wirth in the late 1960s, widely used for teaching structured programming and data structuring concepts.
-
E.
PTC
PTC is an advanced safety system used on railroads to automatically prevent train collisions, overspeed derailments, and other dangerous movements.
- 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: PL/Tcl Target entity description: PL/Tcl is a procedural language extension for PostgreSQL that allows writing database functions and triggers using the Tcl scripting language.
-
A.
PDL
PDL is a former name for USL League Two, a North American pre-professional soccer league that serves as a key development platform for college-aged and aspiring professional players.
-
B.
SETL
SETL is a high-level programming language developed in the late 1960s that is notable for its powerful set-theoretic abstractions and influence on later language design.
-
C.
TXL
TXL was the IATA airport code for Berlin Tegel Airport, the former main international airport of Berlin, Germany.
-
D.
Pascal
Pascal is a high-level, strongly typed procedural programming language designed by Niklaus Wirth in the late 1960s, widely used for teaching structured programming and data structuring concepts.
-
E.
PTC
PTC is an advanced safety system used on railroads to automatically prevent train collisions, overspeed derailments, and other dangerous movements.
- F. None of above. chosen
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
PostgreSQL procedural language
ⓘ
procedural language ⓘ server-side programming language ⓘ |
| allows |
accessing trigger data from Tcl code
ⓘ
calling SQL commands from Tcl code ⓘ raising PostgreSQL errors from Tcl code ⓘ |
| canBeInstalledWith |
CREATE EXTENSION pltcl
ⓘ
CREATE EXTENSION pltclu ⓘ |
| category |
database extension
ⓘ
scripting language binding ⓘ |
| designedFor |
writing PostgreSQL functions in Tcl
ⓘ
writing PostgreSQL triggers in Tcl ⓘ |
| distributedWith | PostgreSQL source distribution ⓘ |
| documentationSection | PostgreSQL PL/Tcl documentation chapter ⓘ |
| executionLocation | server-side ⓘ |
| executionModel | invoked per SQL call or trigger event ⓘ |
| hasSecurityModel | trusted and untrusted language variants ⓘ |
| implements | Tcl interpreter inside PostgreSQL backend ⓘ |
| integratesWith |
PostgreSQL function manager
ⓘ
PostgreSQL function manager ⓘ
surface form:
PostgreSQL trigger manager
PostgreSQL type system ⓘ |
| introducedIn | early PostgreSQL 7.x era (as a contributed language) ⓘ |
| isTrustedVariant | pltcl ⓘ |
| isUntrustedVariant | pltclu ⓘ |
| languageHandlerFunction | pltcl_call_handler ⓘ |
| license | same license as PostgreSQL ⓘ |
| maintainedBy |
PostgreSQL
ⓘ
surface form:
PostgreSQL Global Development Group
|
| primaryUseCase | embedding Tcl business logic in PostgreSQL ⓘ |
| relatedTo |
PL/Perl
ⓘ
PL/Python ⓘ PL/pgSQL ⓘ |
| requires |
Tcl library at build time
ⓘ
Tcl library at runtime ⓘ |
| runsOn | PostgreSQL ⓘ |
| supports |
PL/Tcl
self-linksurface differs
ⓘ
surface form:
SPI (Server Programming Interface) access from Tcl
TG_* trigger variables ⓘ conversion between SQL and Tcl data types ⓘ parameter passing between SQL and Tcl ⓘ raising NOTICE, WARNING, and ERROR messages ⓘ returning composite types ⓘ returning sets ⓘ trigger NEW and OLD row access ⓘ |
| supportsFeature |
stored procedures
ⓘ
triggers ⓘ user-defined functions ⓘ |
| supportsVersion | Tcl 8.x family (depending on PostgreSQL build) ⓘ |
| trustedVariantRestricts |
access to file system
ⓘ
access to operating system facilities ⓘ |
| untrustedVariantAllows | full Tcl functionality ⓘ |
| usesLanguage | Tcl ⓘ |
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: PL/Tcl Description of subject: PL/Tcl is a procedural language extension for PostgreSQL that allows writing database functions and triggers using the Tcl scripting language.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.