Re: PGAdmin

2023-07-24 Thread Rob Richardson
Uninstall pgAdmin and then go to pgAdmin.org and get the installer from there. The installer at postgresql.org does not work. Sent from Yahoo Mail on Android On Mon, Jul 24, 2023 at 11:06 AM, ROBERT GAULT wrote: I'm using PGAdmin on Win 10 without any problem. I've never had an issue ins

Re: desktop application

2021-02-14 Thread Rob Richardson
What release of PostgreSQL will include this version of pgAdmin?  I really dislike the web-only versions that started shipping with PostgreSQL 10.On Sunday, February 14, 2021, 01:07:19 PM EST, Post Gresql wrote: Hi. That sounds good. Looking forward for its release.  10 feb. 2021 kl

Re: Varying Character comparison

2021-01-06 Thread Rob Richardson
You could try reddit.com/r/sql RobR On Wednesday, January 6, 2021, 01:55:23 PM EST, Joseph Ruffino wrote: #yiv6276017970 #yiv6276017970 -- _filtered {} _filtered {}#yiv6276017970 #yiv6276017970 p.yiv6276017970MsoNormal, #yiv6276017970 li.yiv6276017970MsoNormal, #yiv6276017970 div.yiv6

Re: Critical bug: pgAdmin v4.25 has started ignoring my "Browser Command" which completely cripples me and makes me unable to manage my PostgreSQL database.

2020-08-21 Thread Rob Richardson
rs, should expect. Rob Richardson On Friday, August 21, 2020, 06:51:29 AM EDT, Stephen Knox wrote: Gosh, you're right, this does sound very rude. I'm not sure where to start with this and I'm a user, not a developer of the software, so shouldn't be taking this too person

Foreign key indexes sometimes automatically named, sometimes not

2018-10-05 Thread Rob Richardson
Most of the time, when I create a foreign key, the covering index is automatically named and generated, and the table that gets the foreign key also gets an index with a name beginning with "fki".  But sometimes, when I try to save the FK, I get an error message asking me to supply a name for th

Re: Not null constraint violation flagged on a field that has a value

2018-08-09 Thread Rob Richardson
Please ignore my previous message on this topic.  The error was being raised by a trigger. My apologies for cluttering the list. RobR On Thursday, August 9, 2018, 3:07:03 PM EDT, Rob Richardson wrote: Please see the attached image.  As you can see, a not-null constraint error is

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Rob Richardson
I edited config.py, and that worked. RobR On Thursday, August 9, 2018, 10:49:29 AM EDT, Rob Richardson wrote: Thank you, but that did not work.  I am running pgAdmin 4 on a Windows 7 box, executing the file pgAdmin4.exe in my c:/Program Files (x86)/pgAmin4/v3/runtime folder.  Should

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Rob Richardson
line? On Thursday, August 9, 2018, 10:27:21 AM EDT, Dave Page wrote: On Thu, Aug 9, 2018 at 3:10 PM, Rob Richardson wrote: In pgAdmin 3, if I select a table with a few thousand rows and then click the Edit button, I get a grid of data and a vertical scrollbar.  If I drag the

Navigation through edit screen is very difficult

2018-08-09 Thread Rob Richardson
In pgAdmin 3, if I select a table with a few thousand rows and then click the Edit button, I get a grid of data and a vertical scrollbar.  If I drag the scrollbar's thumb to the bottom of the bar, I am taken to the bottom of my result set and the blank row where I can add a new row if I want to.

Re: How can I see IDENTITY columns?

2018-08-08 Thread Rob Richardson
wrote: 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 wo

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