Oh, ok,
that seems like a bug, at least a feature that should be there..
Dave Cramer
On 8 August 2018 at 15:52, Rob Richardson wrote:
> I have now downloaded pgAdmin 4 v3.1. It has the same problem.
> I run this command:
>
> CREATE TABLE public.identity_sample
> (
>
I have now downloaded pgAdmin 4 v3.1. It has the same problem.I run this
command:
CREATE TABLE public.identity_sample ( identity_sample_key bigint
NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY ) WITH (
OIDS = FALSE )
Then, I run
select attrelid,
The attribute table now has an attidentity column.
https://www.postgresql.org/docs/10/static/catalog-pg-attribute.html
Curious why are you using with oid's
Dave Cramer
On 8 August 2018 at 14:16, Rob Richardson wrote:
> I just learned about IDENTITY columns in PostgreSQL 10. I am working on
>
I just learned about IDENTITY columns in PostgreSQL 10. I am working on
upgrading a database for an upcoming major revision of my company's software
package, and I want to make all of the columns defined as "serial" or
"bigserial" IDENTITY columns. I found a nice web page with a function that