1-to-1 relationship in PostgreSQL for real
Years ago Years ago I wrote the post describing how to implement 1-to-1 relationship in PostgreSQL. The trick was simple and obvious: You put a unique constraint on a referenced column and you’re fine. But then one of the readers noticed, that this is the 1-to-(0..1) relationship, not a true 1-to-1. And he was absolutely […]
Choose plpgsql variable names wisely
Pavel Stehule recently wrote the post “Don’t use SQL keywords as PLpgSQL variable names” describing the situation when internal stored routine variable names match PostgreSQL keywords. But the problem is not only in keywords. Consider: Output: OK, at least we have no hidden error like in Pavel’s case. Let’s try to fix it specifying an […]
Keyword mess
Once I received a mail with question: Can you tell me why I can’t select the column `references`? =# \d v_table_relation View “public.v_table_relation” Column | Type | Collation | Nullable | Default ————+————————————-+———–+———-+——— schema | information_schema.sql_identifier | | | table | information_schema.sql_identifier | | | columns | information_schema.sql_identifier[] | | | references | jsonb[] | […]
Building PostgreSQL with MSYS2 and MinGW under Windows
Preface There are several ways of building PostgreSQL under Windows. Official manual stands using Visual Studio is the simplest one, wiki describes how to use mingw and mingw-w64. As for me, using new MSYS2 building platform for Windows is a bless. With its help not only PostgreSQL sources are built smoothly, but even extensions are […]