Skip to content

ENUM Types not supported #28

Description

@DigitalZilla

Our pgSQL DB is using ENUM types but those are showing up as unsupported which prevents us from querying against them.

I'm not sure if this is a Linqpad issue, or an issue with this driver, but if it is an issue with the driver, is there any chance of this feature being added/supported?

CREATE TYPE IntakeType AS ENUM ('Floor', 'Exchange', 'Own Switch', 'Opponent Switch', 'Power Cube Zone', 'Portal', 'Preload')
CREATE TYPE OuttakeType AS ENUM ('Floor', 'Exchange', 'Own Switch', 'Opponent Switch', 'Scale')
CREATE TYPE CubeManipulationQuality AS ENUM ('Poor', 'Average', 'Excellent')

...

CREATE TABLE Cubes (
	ID serial PRIMARY KEY,
	teamMatchID serial NOT NULL REFERENCES TeamMatches,

	durringAuto boolean NOT null,
	index integer NOT NULL,
	
	intakeTimestamp timestamp NOT NULL,
	intakeType IntakeType NOT NULL,
	intakeQuality CubeManipulationQuality NOT NULL,
	
	outtakeTimestamp timestamp NOT NULL,
	outtakeType OuttakeType NOT NULL,
	outtakeQuality CubeManipulationQuality NOT NULL,
	outtakeSuccess boolean NULL -- Floor-False == dropped cube
);

image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions