edoceo / pg-ulid Goto Github PK

CREATE FUNCTION ulid_create()
 RETURNS text
 LANGUAGE C
 VOLATILE STRICT
 AS '$libdir/pg_ulid';

ERROR:  function ulid_create(timestamp with time zone) does not exist
LINE 1: SELECT ulid_create(now() - '37 days'::interval);
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883
Character: 8

--
-- AMD Ryzen 3400G, PG13, WSL Ubuntu 20.04
--

-- Generation

-- uuid-ossp 
-- "Execution Time: 2712.880 ms"
explain analyze SELECT uuid_generate_v4()
FROM generate_series(1, 499000) t(i);

-- "Execution Time: 5083.430 ms"
explain analyze SELECT ulid_create()
FROM generate_series(1, 499000) t(i);


-- "Execution Time: 5927.542 ms"
explain analyze SELECT generate_ulid()
FROM generate_series(1, 499000) t(i);

-- Inserts

-- INSERT 0 499000 uuid_generate_v4()
-- Query returned successfully in 6 secs 748 msec.

-- INSERT 0 499000  ulid_create()
-- Query returned successfully in 8 secs 529 msec.

-- INSERT 0 499000 generate_ulid()
-- Query returned successfully in 12 secs 99 msec.

root@0046bd9d2463:/usr/src/ulid-c# git clone https://github.com/skeeto/ulid-c.git
Cloning into 'ulid-c'...
remote: Enumerating objects: 116, done.
remote: Total 116 (delta 0), reused 0 (delta 0), pack-reused 116
Receiving objects: 100% (116/116), 22.24 KiB | 437.00 KiB/s, done.
Resolving deltas: 100% (68/68), done.


root@0046bd9d2463:/usr/src# apt install build-essential postgresql-server-dev-14
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
.....


root@0046bd9d2463:/usr/src/ulid-c# make install-strip
make: *** No rule to make target 'install-strip'.  Stop.

ERROR:  type "ulid" does not exist
LINE 2:  id ulid not null default ulid_create(),