Re: How can I see IDENTITY columns?

2018-08-08 Thread Murtuza Zabuawala
Hello, Please create a ticket for the same https://redmine.postgresql.org/projects/pgadmin4 -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Thu, Aug 9, 2018 at 1:48 AM, Stephen Frost wrote: > Greetings, > > * Dave Cramer (davecra..

Re: How can I see IDENTITY columns?

2018-08-08 Thread Stephen Frost
Greetings, * Dave Cramer (davecra...@gmail.com) wrote: > 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 > > ( > > identity_sample_key bigint NO

Re: How can I see IDENTITY columns?

2018-08-08 Thread Dave Cramer
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 > ( > identity_s

Re: How can I see IDENTITY columns?

2018-08-08 Thread Rob Richardson
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, attna

Re: How can I see IDENTITY columns?

2018-08-08 Thread Dave Cramer
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 > u

How can I see IDENTITY columns?

2018-08-08 Thread Rob Richardson
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 w

pgadmin 4 won't load on my machine

2018-08-08 Thread Nikrahei, Bardia
Hi, I am a Purdue Employee that uses pgadmin 4. I had to install the software on my newly re-imaged machine and it won't work. So, the internet explorer says : Loading pgadmin 4.. for the last hour. I uninstalled and reinstalled, restarted and all and won't help the issue. Please let me know wha