Dolphin ​

Dolphin Overview ​

openGauss provides Dolphin extensions (version: Dolphin-1.0.0). Dolphin extensions of openGauss are compatible with MySQL databases (dbcompatibility='B') in terms of keywords, data types, constants and macros, functions and operators, expressions, type conversion, DDL/DML/DCL syntax, stored procedures/user-defined functions, and system views.

Dolphin Restrictions ​

• The lite edition is not supported.
• The Dolphin plug-in cannot be deleted.
• The Dolphin plug-in can be created only in the B-compatible database.
• The Dolphin plug-in needs to create data types and functions in schemas such as pg_catalog. Therefore, loading the Dolphin plug-in requires initial user permissions. openGauss automatically loads the Dolphin plug-in when the initial user or a user with the initial user permissions connects to B-compatible database for the first time. If a B-compatible database has never been connected by an initial user or a user with initial user permissions, it will not load the Dolphin plug-in.
• All added or modified syntaxes in Dolphin cannot be viewed by running \h on the gsql client, and cannot be automatically supplemented on the gsql client.
• The creation of the Dolphin plug-in deletes the functions and types with the same name required by the plug-in that exists in the database and the objects that previously depend on the plug-in.

Dolphin Installation ​

The plug-in is automatically installed and loaded. You do not need to manually install and load the plug-in. To manually compile and load the plug-in, perform the following steps:

Compilation and Installation ​

1. Compile and install openGauss.

2. Copy the Dolphin source code to the contrib directory of the openGauss source code.

3. Go to the Dolphin directory and run make install.

4. Create a B-compatible database and connect to B-compatible database as the initial user.

OM Installation ​

1. Install openGauss on the OM.

2. Copy the files required by the plug-in.
   Path of dolphin.so: app/lib/postgresql/
   Path of dolphin.control and dolphin--1.0.sql: app/share/postgresql/extension

3. Create a B-compatible database and connect to B-compatible database as the initial user.