From: | Steve Midgley <science(at)misuse(dot)org> |
---|---|
To: | Karen Goh <karenworld(at)yahoo(dot)com> |
Cc: | pgsql-sql(at)lists(dot)postgresql(dot)org |
Subject: | Re: How do I enabled Windows 10 to be able to run PSQL etc |
Date: | 2019-09-12 12:07:39 |
Message-ID: | CAJexoSLb0s26Nb+EjQH8fB8OUwF49ACTbmJQJ2pMZZ4WiO_dGA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Thu, Sep 12, 2019 at 11:50 AM Karen Goh <karenworld(at)yahoo(dot)com> wrote:
> Anyway, now my problem is that i get a
>
> org.postgresql.util.PSQLException: ERROR: null value in column "parent_id"
> violates not-null constraint
>
> I'd like to know since I have already made parent_id a primary key, do I
> need to put a idenity as ALWAYS and increment by 1 ?
>
> cos another table I had used pgAdmin4 to define it as identity, ALWAYS,
> increment 1 and it works well....
>
> so what is the difference between identity and PRIMARY KEY ?
>
> and if I follow the other table definition for id and put in the ALWAYS,
> it will give me another problem...that the generated_id doesn't get
> inserted even though it should not
>
Hi Karen,
Please bottom post on this forum - it's uncommon these days, but the custom
on this email list to post replies at the bottom of the email.
Regarding your question about nulls and primary keys -- yes you want to
define, where it makes sense, to use autoincrementing primary keys, if you
want the system to manage your keys. Note that autoincrementing IDs, if
exposed to the public via the web or similar, could create some security
issues.
But in many cases it makes a lot of sense to use them. To create a primary
key that autoincrements, use the "serial" or "bigserial" datatype. Combined
with a primary key (that enforces "not null" among other things), your
create table would look like this:
CREATE TABLE sample (
id SERIAL PRIMARY KEY,);
I have not tested it, but I'd guess you should be able to alter a
table that has an integer primary key and convert it to a serial. I
hope that's helpful! Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Shaozhong SHI | 2019-09-12 12:09:50 | Looking for technical references on how to set up PostGIS/PostgreSQL for serving MapInfo Desktop application users |
Previous Message | Karen Goh | 2019-09-12 10:50:19 | Re: How do I enabled Windows 10 to be able to run PSQL etc |