CYBERTEC PostgreSQL Logo

Tag: constraint

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: constraint. You can go back to all blog posts or take a look into our other categories & tags.

Breaking your PostgreSQL database with bad CHECK constraints

by Laurenz Albe | 03.2023
I am on a spree! After writing about breaking your database and transaction ID wraparound, here I am writing about […]

A unique constraint where NULL conflicts with everything

by Laurenz Albe | 01.2023
  I have been faced with a request for an unusual unique constraint that puzzled me for a while. Since […]

Primary Keys vs. UNIQUE Constraints in PostgreSQL

by Hans-Jürgen Schönig | 11.2021
What primary keys and UNIQUE constraints do: Both features create an index, but what makes a primary key different from a unique constraint?

PostgreSQL: Useful new data types - CREATE DOMAIN

by Hans-Jürgen Schönig | 07.2020
UPDATED 08.05.2023 How to create useful new data types with CREATE DOMAIN in PostgreSQL | Advanced server side check constraints

Triggers to enforce constraints in PostgreSQL

by Laurenz Albe | 04.2019
  Sometimes you want to enforce a condition on a table that cannot be implemented by a constraint. In such […]
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram