ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
I created this first table named 'bookstore' where Primary Key is book_name: create table bookstore (book_name varchar primary key, author varchar, price decimal); I am trying to create a second table named 'name' where name is primary key. I want to make this primary key- author.name as a foreign key of bookstore.author. create table author (name varchar pr
I have a table with a "currency" column. I'd like to prevent further insertion of certain currencies, without removing the existing ones. Initially I was thinking of a validation trigger. Then I discovered the NOT VALID option of ALTER TABLE ADD CONSTRAINT , which prevents the validation of existing data. The documentation seems to imply that the NOT VALID o
CREATE TABLE my_app.person ( person_id smallserial NOT NULL, first_name character varying(50), last_name character varying(50), full_name character varying(100) generated always as (concat(first_name, ' ', last_name)) STORED, birth_date date, created_timestamp timestamp default current_timestamp, PRIMARY KEY (person_id) ); Error: generation expression is not