QueryFailedError: function uuid_generate_v4() does not exist

[chriskolenko]

Apparently most new installations of Postgres don't include the extension uuid-ossp

However typeorm have added in an extra option:
uuidExtension: pgcrypto to allow for this:
typeorm/typeorm#3537

Might have to create another querystring override?

prime/packages/prime-core/src/utils/connect.ts

Line 13 in 7b0f33c

type: 'postgres',

[chriskolenko]

Oh.. and typeorm needs to be upgraded.

[agustif]

I've been implementing this in a separated typeorm project, with an external dependency uuid and using @BeforeInsert from typeorm when creating the Entity.

just as an fyi, in case it helps you patch this temporarily, not suggesting not to use postgres add-on.

import { Entity, PrimaryColumn, Column, BeforeInsert, BaseEntity } from 'typeorm';
import { v4 } from 'uuid';
import * as bcrypt from 'bcryptjs';

@Entity('users')
export class User extends BaseEntity {
	@PrimaryColumn('uuid') id: string;

	@Column('varchar', { length: 255 })
	firstName: string;

	@Column('varchar', { length: 255 })
	lastName: string;

	@Column('text') email: string;

	@Column('text') password: string;

	@Column('boolean', { default: false })
	confirmed: boolean;

	@BeforeInsert()
	addId() {
		this.id = v4();
	}
	async hashPassword() {
		this.password = await bcrypt.hash(this.password, 10);
	}
}

[chriskolenko]

Looks like pgcrypto extension isn't 100%

    {
        "message": "null value in column \"id\" violates not-null constraint",
        "locations": [{
            "line": 2,
            "column": 3
        }],
        "path": ["onboard"],
        "extensions": {
            "code": "INTERNAL_SERVER_ERROR",
            "exception": {
                "message": "null value in column \"id\" violates not-null constraint",
                "name": "QueryFailedError",
                "length": 204,
                "severity": "ERROR",
                "code": "23502",
                "detail": "Failing row contains (null, viper@..., f, null).",
                "schema": "public",
                "table": "user_email",
                "column": "id",
                "file": "execMain.c",
                "line": "2017",
                "routine": "ExecConstraints",
                "query": "INSERT INTO \"user_email\"(\"id\", \"address\", \"verified\", \"userId\") VALUES (DEFAULT, $1, $2, DEFAULT) RETURNING \"id\", \"verified\"",
                "parameters": ["viper@....", 0]
            }
        }
    }

EDIT:
Ignore above.. I created the DB schema with an older version of the application. I was doing some bad things which got me into that state.

Everything is working good with pgcrypto.

[birkir]

Both circleci and heroku install this by default. I would say it's almost mandatory to have uuid support in postgres today. TypeORM will attempt to enable the extension on start.

Are you guys running on windows maybe? I am all for fixing platform issues.

[chriskolenko]

I'm using the stable helm chart and install postgres on kubernetes.

The maintainers have refused to install this deprecated plugin. Which has forced TypeORM to implement a fix. Which was merged a few weeks back.

[chriskolenko]

Would you except a PR to fix?

[birkir]

Absolutely! Is it a matter of just upgrading typeorm?

[chriskolenko]

Upgrading typeorm and also passing on the extra settings from the ENV db connection string. Can give this a crack in a couple days time.

[chroline]

Sorry, newbie to primeCMS here. I'm getting this error and not exactly sure on the steps to fix it. Any thoughts? Thanks

[tolumide-ng]

Sorry, newbie to primeCMS here. I'm getting this error and not exactly sure on the steps to fix it. Any thoughts? Thanks

You need to create the extension uuid_ossp on the database you're using:
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

[tupizz]

@tolumide-ng why i have to run this command? Pg dont have natively this?