Re: Navigation through edit screen is very difficult
Hi Clicking top-left corner (aka "Select All") does work on my Win10-64 laptop, at least for tables with a few 10-thousands rows. Haven't tried with e.g. 5 or 10 million (I suspect that might take considerable time, so I'm not sure if Dave's suggestion to increase the ON_DEMAND_RECORD_COUNT is ideal). That said - why not add a "go to row X" field and add a "go to end row" button? Pretty standard stuff Regards Calle On Thu, 9 Aug 2018 at 17:31, Dave Page wrote: > > > On Thu, Aug 9, 2018 at 3:49 PM, 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 config_local.py be a copy of >> config.py except for the record count value, or should config_local.py just >> contain the one line? >> > > It only needs to contain one line. Copying config.py isn't a good idea as > it's contents will change when you next upgrade. > > >> >> On Thursday, August 9, 2018, 10:27:21 AM EDT, Dave Page < >> dp...@pgadmin.org> 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 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. >> But in pgAdmin 4, the scrollbar's parameters are only calculated on the >> basis of some subset of the rows in the table. So, I drag the thumb to the >> bottom of the scrollbar, the selected row goes to some random row part way >> down the grid, the scroll bar's parameters are recalculated, and the thumb >> jumps up to somewhere around a third of the way up from the bottom. If I >> drag the thumb down again, the process repeats. I don't know how many >> times I have to do that to get to the bottom of the grid and the blank row, >> since I've never had that much patience. The only way I can get to the >> bottom is to select some random cell and then hold down the Page Down key >> until I get there. >> >> Is there some way I can get the scrollbar to behave the same way it does >> in pgAdmin 3? >> >> >> Create (or edit if it exists) a file called config_local.py in the same >> directory as config.py (normally $INSTALLDIR/web). Add the following line >> to it: >> >> ON_DEMAND_RECORD_COUNT = 1000 >> >> Restart pgAdmin. >> >> That will adjust the number of records retrieved at any one time to 10 >> million, effectively disabling on demand loading for tables with < 10M >> rows. Of course, you can adjust that number to something lower (or higher) >> if you prefer. The default is 1000. >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> >> > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > -- *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg ***
pgadmin 4 v3.0 installation
Hi, I'm running pgadmin 4 v2.1 on win10 64 bits, and it's installed under the Postgresql 10 folder in Program Files (which for me up to now indicated it was a 64-bit version, but I see now that it seems pgadmin only exist as a 32 bit app). With regard to upgrading to 4.30, I can only find a 32 bits installation file and that wants to install under Program Files (x86). The documentation does not say anything about these issues. Is this a deliberate change - should I uninstall the previous version under Program Files and then install 4 v3.0 under Program Files (x86)? Regards Calle
Problems connecting to remote database with recent pgAdmin versions
Hi, I've been experiencing problems viewing tables and running scripts on a remote database (accessed using pgremote) with version 3.4 and 3.5 - I never had similar problems with earlier versions on the same remote server database. When e.g. selecting "view/edit last 100 records" for a table, or when opening a query tool window, I get a small red "disconnect" symbol but no error message of any kind. It is erratic, though - in periods everything works fine, then it starts failing again. During failure periods, I've also noticed that retrieving meta-data (properties, SQL) is very sluggish (but usually working, so the db IS connected) I suspect this is related to some change in a timeout configuration, but I don't know which and/or whether this behaviour need to be addressed through a pgadmin configuration setting or a configuration setting on the server side (the latter has not changed, but I obviously cannot rule out that there are changes in overall internet connectivity speed/bandwidth) Any thoughts on how to resolve this? Regards Calle
Re: How to: copy records from one table to another?
Hi I often use CSV as a step too: - Dump the data you want to work on, copy/edit or whatever from db 1 in csv - Copy the SQL for the same source table design and use it to create a similar table in db 2 (using a different name where necessary) - import the CSV data into that new table in db2 Then using the usual scripting tools to add/edit/delete the related data in db2. I was unable to get foreign data wrappers to perform for larger data set updates recently (few hundred million records), at least when those dbs were on remote servers. Transferring a copy via CSV to use for the updates were quick and easy. Regards Calle On Mon, 25 Mar 2019 at 14:04, Dave Caughey wrote: > Hi Khushboo, > > And then what's the process to upload the downloaded records into the > other database? > > Cheers, > Dave > > > On Mon, Mar 25, 2019 at 12:14 AM Khushboo Vashi < > khushboo.va...@enterprisedb.com> wrote: > >> >> >> On Fri, Mar 22, 2019 at 6:06 PM Dave Caughey wrote: >> >>> Sorry, for the basic question, but I'm not sure if there are bug(s) in >>> pgAdmin, or just that I'm clueless. (My money lies on the latter!) >>> >>> Imagine the scenario where you are adding a feature to a product that >>> requires adding some new rows to a configuration table, and as part of the >>> patch you need to replicate a bunch of record from your development >>> database to your production databases. >>> >>> You'd think there'd be a number of options, e.g., >>> >>> 1. After doing a "View/Edit..." | "Filter by", select the displayed >>> records, click "copy" to get them on to the clipboard, then go to the >>> production database, do a "View/Edit..." on the corresponding table, and >>> paste. But, in my case, I need my auto-sequenced "id" column to be omitted >>> (so it gets re-generated in the new table), so perhaps this isn't the right >>> choice. Even worse, over the years, my database tables (auto-created via >>> Hibernate used in a Java Servlet) no longer have the same column order. >>> (Question: is there no way that copy-and-paste between tables can consider >>> the column names so copying between (int id,int feature_id,text name) and >>> (int id,text name,int feature_id) is possible?) >>> >>> 2. Or, I could right-click on the table and use Import/Export..." >>> (Question: is there a way to filter the records that will get exported? >>> Or is there a way to trigger import/export on the results of a >>> "View/Edit..." | "Filter by"?). However, here the issue is the columns no >>> longer have the same order (e.g., (int,int,text) vs (int,text,int)) so >>> "Import/Export..." fails. (Question: Is that not what the "Header" toggle >>> is supposed to do? I see that enabling it during export *adds* a header >>> to the export files, but shouldn't enabling it during import cause it to be >>> used to identify the order?). This method has the attraction that I can >>> use the "Columns" tab to exclude one of the columns from my export (i.e., >>> my auto-sequenced "id" column). >>> >>> 3. Or, I could do a "Backup..." and then a corresponding "Restore..." , >>> but I noticed that there the generated file contains CREATE DATABASE bits >>> of code even though the "Include CREATE DATABASE" toggle in the Backup..." >>> dialog is set to "No" (Question: bug, or my misunderstanding?). But I'm >>> guessing that a backup/restore will generally do a complete and utter >>> restore, rather than just moving some data. >>> >>> 4. Other options? >>> >>> How about *Download as CSV* option? >> >>> So, what is the best/simplest way to copy data between tables, given the >>> possibility that some/all might apply? >>> >>>- The columns may be in a different order in different databases >>>- One column might need be left blank >>>- I only want to copy some of the records >>> >>> Cheers, >>> Dave >>> >> -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Connection error after upgrading to v4.4
Hi I upgraded to 4.4 earlier this evening, and now a considerable number of small scripts I'm running regularly fails with the following error that I have not seen before: SSL SYSCALL error: Software caused connection abort (0x2745/10053) Would any of the 4.4 fixes or changes cause this issue? If yes, anything I can do or should I revert back to 4.3? Regards Calle *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: Connection error after upgrading to v4.4
Dave, The scripts are just normal select, update and delete queries, running in the script window against a remote server (logged in using pgremote). In any case - I rebooted everything and haven't seen the error again, so it might have been caused by some intermittent problem. Best regards Calle On Fri, 5 Apr 2019 at 10:12, Dave Page wrote: > > > On Fri, Apr 5, 2019 at 12:29 AM Calle Hedberg > wrote: > >> Hi >> >> I upgraded to 4.4 earlier this evening, and now a considerable number of >> small scripts I'm running regularly fails with the following error that I >> have not seen before: >> >> SSL SYSCALL error: Software caused connection abort (0x2745/10053) >> >> Would any of the 4.4 fixes or changes cause this issue? If yes, anything >> I can do or should I revert back to 4.3? >> > > What scripts (and what platform etc)? Are you using the pgAdmin virtual > environment for your own code? If so, that's really not something we > support or test in any way. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: pgAdmin Download as CSV
Elizabeth, You must be doing something wrong, or else your computer has an incorrect configuration of some sort. I'm importing and exporting from/to CSV several times a day, and it has generally always worked (exceptions are cases where the CSV file to be imported contains e.g. non-UTF8 characters). I run any select query and then press the download icon - and the query result downloads with a file name like "data_.csv" where x is some random number. Using windows 10-64, latest Chrome Regards Calle On Sat, 2 Mar 2019 at 11:07, Akshay Joshi wrote: > Hi Elizabeth > > I have tried with pgAdmin4 v4.2 and able to download the query result. > Please refer the attached screenshots. Can you please provide following > information: > >- Browser and their version >- Any error in browser when click on download button? Please attached >the screenshot. > > > On Sat, Mar 2, 2019 at 6:06 AM Elizabeth Mytko < > e.my...@woodgate-clark.co.uk> wrote: > >> Hi, >> >> It seems the Download as CSV button doesn’t work anymore for the last few >> versions. I upgraded from version 3.3 (didn’t work here) to version 4.2 and >> it still doesn’t work. It used to work before version 3.3 and downloaded >> the current query results to the c:\Downloads folder which was very handy. >> Just to clarify it works for the table list but not for a query results. >> Not sure if I am doing something wrong? >> >> Regards >> >> Ela Mytko >> >> *Woodgate and Clark Limited* >> >> >> >> Tel: 01732 520281 >> >> Email: e.my...@woodgate-clark.co.uk >> >> Web: www.woodgate-clark.co.uk >> >> >> Woodgate and Clark Limited, Registered Office, The Red House, King >> Street, West Malling, Kent, ME19 6QT No. 02090698 England. >> This message is sent in confidence for the addressee only. It may contain >> confidential or sensitive information. The contents are not to be disclosed >> to anyone other than the addressee. Unauthorised recipients are requested >> to preserve this confidentiality and to advise us of any errors in >> transmission. Thank you. >> >> Our privacy policy is available at www.woodgate-clark.co.uk >> <https://www.woodgate-clark.co.uk/privacy-policy/> >> > > > -- > *Akshay Joshi* > > *Sr. Software Architect * > > > > *Phone: +91 20-3058-9517Mobile: +91 976-788-8246* > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: pgAdmin Download as CSV
Elizabeth,
I just tested a query with six aliases (using win10-64 and latest Chrome) -
and it downloads without problems.
So the prime suspect would be your browser - why don't you try Chrome or
Firefox instead, to see if there's a difference?
Regards
Calle
On Mon, 4 Mar 2019 at 15:40, Elizabeth Mytko
wrote:
> Hi,
>
>
>
> Thank you all for your replies. I am using 64-bit Windows 10 and Microsoft
> Edge browser. I have done some more tests and came into conclusion the
> download button only works when I use less than 4 aliases in the query. If
> there are more then 4 aliases in the query the button won’t work. I enclose
> the example of a simple query, it doesn’t matter which aliases of the 5
> below I use but it will only accept 3 aliases. Hope that makes sense.
>
>
>
> SELECT ins.insurer,
>
> ib.branch,
>
> ib.ins_br_index,
>
> fe.invoice_total,
>
> fe.fee_date,
>
> fe.unpaid_amount,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) <= '30 days'::interval THEN fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c30,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) >= '31 days'::interval AND ('now'::text::date::timestamp
> without time zone - fe.fee_date) <= '60 days'::interval THEN
> fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c60,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) >= '61 days'::interval AND ('now'::text::date::timestamp
> without time zone - fe.fee_date) <= '90 days'::interval THEN
> fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c90,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) >= '91 days'::interval AND ('now'::text::date::timestamp
> without time zone - fe.fee_date) <= '120 days'::interval THEN
> fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c120,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) > '120 days'::interval THEN fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c120plus
>
>FROM fee fe,
>
> claim cl,
>
> insurer ins,
>
> insurerbranch ib
>
> WHERE cl.claim_ref::text = fe.claim_ref::text AND ib.ins_br_index =
> cl.ins_br_index AND ins.ins_index = ib.ins_index AND fe.fee_type =
> 'I'::bpchar AND fe.fee_status = 1
>
> And ins.ins_index=82
>
> ORDER BY ib.ins_br_index;
>
>
>
> Regards
>
> Ela Mytko
>
> *Woodgate and Clark Limited*
>
>
>
> Tel: 01732 520281
>
> Email: e.my...@woodgate-clark.co.uk
>
> Web: www.woodgate-clark.co.uk
>
>
>
> *From:* Calle Hedberg
> *Sent:* 02 March 2019 13:03
> *To:* Akshay Joshi
> *Cc:* Elizabeth Mytko ;
> pgadmin-support@lists.postgresql.org
> *Subject:* Re: pgAdmin Download as CSV
>
>
>
> Elizabeth,
>
>
>
> You must be doing something wrong, or else your computer has an incorrect
> configuration of some sort.
>
>
>
> I'm importing and exporting from/to CSV several times a day, and it has
> generally always worked (exceptions are cases where the CSV file to be
> imported contains e.g. non-UTF8 characters).
>
>
>
> I run any select query and then press the download icon - and the query
> result downloads with a file name like "data_.csv" where x is
> some random number. Using windows 10-64, latest Chrome
>
>
>
> Regards
>
> Calle
>
>
>
> On Sat, 2 Mar 2019 at 11:07, Akshay Joshi
> wrote:
>
> Hi Elizabeth
>
>
>
> I have tried with pgAdmin4 v4.2 and able to download the query result.
> Please refer the attached screenshots. Can you please provide following
> information:
>
>- Browser and their version
>- Any error in browser when click on download button? Please attached
>the screenshot.
>
>
>
> On Sat, Mar 2, 2019 at 6:06 AM Elizabeth Mytko <
> e.my...@woodgate-clark.co.uk> wrote:
>
> Hi,
>
> It seems the Download as CSV button doesn’t work anymore for the last few
> versions. I upgraded from version 3.3 (didn’t work here) to version 4.2 and
> it still doesn’t work. It used to work before version 3.3 and downloaded
> the current query results to the c:\Downloads folder which was very handy.
> Just to clarify it works for the table list but not for a query results.
> Not sure if I am doing something wrong?
>
> Regards
>
> Ela Mytko
>
> *Wood
Re: How to: copy records from one table to another?
Dave, You are talking about "copying" data from one table to another table in the same database, yes? For that use an INSERT INTO (SELECT .FROM sourcetable) query - it will provide most of the flexibility you need with regard to including/excluding columns, renaming, changing column order, etc. If you need to do several sequential manipulation steps on the data to be copied, it might be necessary to first insert the data into a temporary table, then do whatever manipulations necessary, before inserting the final result into the destination table (or if not absolutely necessary, at least easier - while advanced manipulation can be done in a single step, it might require advanced skills and a crystal clear understanding of the underlying processes, and doing it step by step can be safer/easier for us normal mortals...) Regards Calle On Fri, 22 Mar 2019 at 13:36, Dave Caughey wrote: > Sorry, for the basic question, but I'm not sure if there are bug(s) in > pgAdmin, or just that I'm clueless. (My money lies on the latter!) > > Imagine the scenario where you are adding a feature to a product that > requires adding some new rows to a configuration table, and as part of the > patch you need to replicate a bunch of record from your development > database to your production databases. > > You'd think there'd be a number of options, e.g., > > 1. After doing a "View/Edit..." | "Filter by", select the displayed > records, click "copy" to get them on to the clipboard, then go to the > production database, do a "View/Edit..." on the corresponding table, and > paste. But, in my case, I need my auto-sequenced "id" column to be omitted > (so it gets re-generated in the new table), so perhaps this isn't the right > choice. Even worse, over the years, my database tables (auto-created via > Hibernate used in a Java Servlet) no longer have the same column order. > (Question: is there no way that copy-and-paste between tables can consider > the column names so copying between (int id,int feature_id,text name) and > (int id,text name,int feature_id) is possible?) > > 2. Or, I could right-click on the table and use Import/Export..." > (Question: is there a way to filter the records that will get exported? > Or is there a way to trigger import/export on the results of a > "View/Edit..." | "Filter by"?). However, here the issue is the columns no > longer have the same order (e.g., (int,int,text) vs (int,text,int)) so > "Import/Export..." fails. (Question: Is that not what the "Header" toggle > is supposed to do? I see that enabling it during export *adds* a header > to the export files, but shouldn't enabling it during import cause it to be > used to identify the order?). This method has the attraction that I can > use the "Columns" tab to exclude one of the columns from my export (i.e., > my auto-sequenced "id" column). > > 3. Or, I could do a "Backup..." and then a corresponding "Restore..." , > but I noticed that there the generated file contains CREATE DATABASE bits > of code even though the "Include CREATE DATABASE" toggle in the Backup..." > dialog is set to "No" (Question: bug, or my misunderstanding?). But I'm > guessing that a backup/restore will generally do a complete and utter > restore, rather than just moving some data. > > 4. Other options? > > So, what is the best/simplest way to copy data between tables, given the > possibility that some/all might apply? > >- The columns may be in a different order in different databases >- One column might need be left blank >- I only want to copy some of the records > > Cheers, > Dave > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: How can I add a custom EPSG to the Map (Geometry) Viewer in PGAdmin4,
elect > st_transform(geometry, 4326) from table_name and it will enable the world > map. AFAIK no other EPSG is supported for viewing on the map without > transformation. I discovered it by sheer accident. > > > > On Wed, Jul 31, 2019 at 7:54 PM Basques, Bob (CI-StPaul) < > bob.basq...@ci.stpaul.mn.us> wrote: > >> All, >> >> Following the appreciation thread and saw the reference to the geometry >> viewer, I didn’t even know that was in there. Anyway, nice, but we have a >> custom EPSG, where do I add this into PGAdmin4? >> >> Also, it would be nice to add in our own background mapping layers as >> well, is there a method for adding in WMS/WFS to the layer list? >> >> Thanks >> >> bobb >> >> >> >> -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: messages tab
Hi I can confirm that - was just going to report the same. I often run multi-update scripts, by the way (updating a range of tables using different scripts in one go, each terminated by ; ), and I would like to ask if you can return the number of affected rows for each of them, instead of only the last one as it was earlier. Regards Calle On Sun, 4 Aug 2019 at 18:10, Polgár Benedek wrote: > Dear Support Team! > > > > About The pgadmin4 new version (4.11) i have a problem. > > When I run a update script, on messages tab, I dont get info abbout > affected rows, when I rollback and run again update script in the same > guery tool. > > > > For example pgadminIII: > > „Query returned successfully: one row affected, 121 msec execution time.” > > > > In pgadmin4: > > „Query returned successfully in 345 msec.” > > > > Can you help me? > > > > *__* > > *Best Regardsl:* > > > > *Benedek Polgár* > > System administrator > > > > polgar.bene...@otpmobil.com > > > > > > 1093 Budapest, Közraktár u. 30-32. > > RiverPark, K30. épület, II. emelet > > > > <https://itunes.apple.com/us/app/simple-labs/id819236628?ls=1=8> > <https://play.google.com/store/apps/details?id=com.otpmobil.simple> > > > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run
Great, thanks! Regards Calle On Thu, 13 Aug 2020 at 06:08, Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Calle, > > The feature is not implemented yet - > https://redmine.postgresql.org/issues/3256. > > On Thu, Aug 13, 2020 at 4:59 AM Calle Hedberg > wrote: > >> Hi >> >> I find that a nice feature... But if I may ask a related question that >> baffles me: If I paste multiple queries into a window and then run all of >> them, they all run BUT the output window only show the last sub-query >> result. >> >> Is there a configuration setting that will concatenate output when >> running such sequential queries in one go? >> >> Regards >> Calle >> >> On Wed, 12 Aug 2020 at 22:53, Trung Do wrote: >> >>> I see, thanks for the explanation. It's a strange feature then, since >>> I accidentally selected part of the query and was so puzzled at the >>> cryptic error message that followed. And having an error is actually >>> the best case scenario. I can see someone doing copy/paste operations >>> to/from this query editor, somehow have part of the query selected but >>> that part is valid SQL, then run it and have no idea that it's not >>> running the whole thing. Being sneaky around something that deals with >>> data is IMO not a good thing. I think it's better if that's an opt-in >>> behavior instead. Just my 2c. >>> >>> >>> On Wed, 12 Aug 2020 at 15:36, richard coleman >>> wrote: >>> > >>> > That's not a bug, it's a *feature* !! >>> > >>> > Seriously though, presently the query window in pgAdmin4 has two >>> options: >>> > If nothing is selected -> run the entire window >>> > If something is selected -> run just what's selected. >>> > >>> > That's how it's been since, well as long as I can recall. Unlike some >>> other tools, pgAdmin4 lacks the ability to "Run Selected" vs. "Run Entire >>> Query Window", so it implements the previously mentioned logic. >>> > >>> > So I guess what you should probably do is create a *feature* request >>> for this additional functionality. >>> > >>> > rik. >>> > >>> > On Wed, Aug 12, 2020 at 3:18 PM Trung Do wrote: >>> >> >>> >> If I enter a well formed SQL query into the Query Editor, but only >>> >> select a portion of the query with the mouse and try to run, pgAdmin >>> >> will try to run the selected portion as the query (and will fail most >>> >> of the time because of syntax error) >>> >> >>> >> >>> >>> >>> >> >> -- >> >> *Carl-Anders (Calle) Hedberg* >> >> HISP >> >> Researcher & Technical Specialist >> >> Health Information Systems Programme – South Africa >> >> Cell:+47 41461011 (Norway) >> >> Iridium SatPhone: +8816-315-19119 (usually OFF) >> >> E-mail1: ca...@hisp.org >> >> E-mail2: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> > > > -- > Thanks, > Aditya Toshniwal > pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* > <http://edbpostgres.com> > "Don't Complain about Heat, Plant a TREE" > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: Bug report: pgAdmin takes selected portion of query in Query Editor to run
Hi I find that a nice feature... But if I may ask a related question that baffles me: If I paste multiple queries into a window and then run all of them, they all run BUT the output window only show the last sub-query result. Is there a configuration setting that will concatenate output when running such sequential queries in one go? Regards Calle On Wed, 12 Aug 2020 at 22:53, Trung Do wrote: > I see, thanks for the explanation. It's a strange feature then, since > I accidentally selected part of the query and was so puzzled at the > cryptic error message that followed. And having an error is actually > the best case scenario. I can see someone doing copy/paste operations > to/from this query editor, somehow have part of the query selected but > that part is valid SQL, then run it and have no idea that it's not > running the whole thing. Being sneaky around something that deals with > data is IMO not a good thing. I think it's better if that's an opt-in > behavior instead. Just my 2c. > > > On Wed, 12 Aug 2020 at 15:36, richard coleman > wrote: > > > > That's not a bug, it's a *feature* !! > > > > Seriously though, presently the query window in pgAdmin4 has two options: > > If nothing is selected -> run the entire window > > If something is selected -> run just what's selected. > > > > That's how it's been since, well as long as I can recall. Unlike some > other tools, pgAdmin4 lacks the ability to "Run Selected" vs. "Run Entire > Query Window", so it implements the previously mentioned logic. > > > > So I guess what you should probably do is create a *feature* request for > this additional functionality. > > > > rik. > > > > On Wed, Aug 12, 2020 at 3:18 PM Trung Do wrote: > >> > >> If I enter a well formed SQL query into the Query Editor, but only > >> select a portion of the query with the mouse and try to run, pgAdmin > >> will try to run the selected portion as the query (and will fail most > >> of the time because of syntax error) > >> > >> > > > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
PgAdmin behaviour under win10 - bugs or settings?
Hi, with recent pgadmin versions (5.x mainly), I have noticed some strange behaviours - and I am not sure if they are bugs to be reported or simply configuration issues. The last issue has always been there. Any advice would be appreciated: 1. When starting pgAdmin, the password entry popup does not appear before I place my cursor in another window. That behaviour came with the de-coupling from the browser. It's merely annoying, but it would be nice to avoid that extra step. 2. When I work on a script in the script window, I frequently find it difficult to place the cursor / edit line 1 in the script. I have to fiddle a bit, maybe add an empty line and remove it again, before I can edit line 1. If I leave line 1 blank (starting the script at line 2), there are no such issues. 3. When running working scripts against remote servers, I now and then get no output and the "run" icon turns grey - that script window is then "dead" and I have to delete it and copy the script to another window, where it runs fine. This is also recent behaviour. I get no error messages or anything like that - it just "hangs". 4. And finally, one behaviour that's been there for as long as I can remember: when I run multiple scripts together in PSQL, I get the output for each sub-script. In pgadmin, I only see the output from the last sub-script. Is there a pgadmin setting I can use to display the outputs from all sub-scripts, similar to psql? Best regards Calle -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Query tool bombing out
Hi, For at least the last 6 months, I have observed an increased tendency for query tools tabs to bomb out without providing any data output and/or Message output. What I see has the following characteristics: 1. Whether I run a single script or multiple scripts (each terminated by semicolon) does not matter, and I have not been able to figure out any kind of pattern to these failures; 2. The majority of my update scripts relate to JSONB field updates, but not all; 3. The script run will bomb out after anywhere from 2 to 20 seconds; 4. There is no message output, the execute icon turns grey, and the connection status indicates "The session is idle and there is no current transaction"; 5. The query tool tab is permanently disabled, and I have to close it and open a new tab to run the script again; Usually the script will then run normally, but sometimes I have to do it 2 or 3 times before success (for each round I have to close the disabled tab and open a new one); 6. Sometimes I find that the original script actually DID work (when running it again I get 0 updates even when I know there must be some), sometimes it has not actually updated anything. This indicates that the script execution sometimes bombs before it has even run or at least finished, sometimes it bombs out after finishing but before the result message is displayed; 7. Finally, note that these are standardised scripts, around 50 of them, that I run every 2-3 days to correct errors or missing values for client data (covid-19 vaccinations) captured on a daily basis. So there is nothing wrong with the scripts themselves - the problem is that pgadmin is somehow unable to finish many of them in some cases. 8. I see no similar problems when running the same scripts from the command line. Does anybody have a clue what the issue might be here? Best regards Calle
Re: Query tool bombing out
Hi, The data output tab is empty. and yes, in the bottom right corner I do see the usual "waiting... " message for 2-20 seconds - but when the query bombs, the connecting shifts to idle, the execute icon is greyed out, then that "waiting..." message disappears too It is interesting that the problem varies so much in intensity: the day before yesterday it bombed out at least 10 times, sometimes repeatedly while running the same script. Yesterday it happened only twice during the usual run of around 50 scripts This erraticness do make me wonder if this is some kind of race bug, where server loads and internet connectivity delays and a host of other factors cause some kind of race condition Using explain / analyze does not help either, since when it bombs out there is no output or message at all Best regards Calle On Fri, 29 Apr 2022 at 06:27, Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi calle, > > Did you check the Data output tab ? There must be a visible loader to show > the progress. Or, on the bottom right corner - "Waiting" message ? > > On Fri, Apr 29, 2022 at 4:25 AM Calle Hedberg > wrote: > >> Aditya, >> >> Here's a typical screenshot, but I am afraid it won't tell you much: >> >> [image: image.png] >> Session is idle, the execute icon greyed out, and there is nothing under >> messages after execution. >> >> Logs and sample data is more tricky, because the database has health data >> for well over a million people - not something I can just share or provide >> access to. >> >> My initial query was basically just to ask if anybody has experienced the >> query tool behaving in this way, and if yes if they figured out why >> >> Regards >> Calle >> >> On Wed, 27 Apr 2022 at 06:13, Aditya Toshniwal < >> aditya.toshni...@enterprisedb.com> wrote: >> >>> Hi Calle, >>> >>> It would be helpful if you can provide some screenshots, log, sample >>> data and steps to reproduce at our end. >>> >>> On Wed, Apr 27, 2022 at 4:19 AM Calle Hedberg >>> wrote: >>> >>>> Hi, >>>> >>>> For at least the last 6 months, I have observed an increased tendency >>>> for query tools tabs to bomb out without providing any data output and/or >>>> Message output. What I see has the following characteristics: >>>> >>>> 1. >>>> Whether I run a single script or multiple scripts (each terminated by >>>> semicolon) does not matter, and I have not been able to figure out any kind >>>> of pattern to these failures; >>>> 2. >>>> The majority of my update scripts relate to JSONB field updates, but >>>> not all; >>>> 3. >>>> The script run will bomb out after anywhere from 2 to 20 seconds; >>>> 4. >>>> There is no message output, the execute icon turns grey, and the >>>> connection status indicates "The session is idle and there is no current >>>> transaction"; >>>> 5. >>>> The query tool tab is permanently disabled, and I have to close it and >>>> open a new tab to run the script again; Usually the script will then run >>>> normally, but sometimes I have to do it 2 or 3 times before success (for >>>> each round I have to close the disabled tab and open a new one); >>>> 6. >>>> Sometimes I find that the original script actually DID work (when >>>> running it again I get 0 updates even when I know there must be some), >>>> sometimes it has not actually updated anything. This indicates that the >>>> script execution sometimes bombs before it has even run or at least >>>> finished, sometimes it bombs out after finishing but before the result >>>> message is displayed; >>>> 7. >>>> Finally, note that these are standardised scripts, around 50 of them, >>>> that I run every 2-3 days to correct errors or missing values for client >>>> data (covid-19 vaccinations) captured on a daily basis. So there is nothing >>>> wrong with the scripts themselves - the problem is that pgadmin is somehow >>>> unable to finish many of them in some cases. >>>> 8. >>>> I see no similar problems when running the same scripts from the >>>> command line. >>>> >>>> Does anybody have a clue what the issue might be here? >>>> >>>> Best regards >>>> Calle >>>> >>>> >>>> >>> >>> --
Re: Query tool bombing out
Aditya, Here's a typical screenshot, but I am afraid it won't tell you much: [image: image.png] Session is idle, the execute icon greyed out, and there is nothing under messages after execution. Logs and sample data is more tricky, because the database has health data for well over a million people - not something I can just share or provide access to. My initial query was basically just to ask if anybody has experienced the query tool behaving in this way, and if yes if they figured out why Regards Calle On Wed, 27 Apr 2022 at 06:13, Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Calle, > > It would be helpful if you can provide some screenshots, log, sample data > and steps to reproduce at our end. > > On Wed, Apr 27, 2022 at 4:19 AM Calle Hedberg > wrote: > >> Hi, >> >> For at least the last 6 months, I have observed an increased tendency for >> query tools tabs to bomb out without providing any data output and/or >> Message output. What I see has the following characteristics: >> >> 1. >> Whether I run a single script or multiple scripts (each terminated by >> semicolon) does not matter, and I have not been able to figure out any kind >> of pattern to these failures; >> 2. >> The majority of my update scripts relate to JSONB field updates, but not >> all; >> 3. >> The script run will bomb out after anywhere from 2 to 20 seconds; >> 4. >> There is no message output, the execute icon turns grey, and the >> connection status indicates "The session is idle and there is no current >> transaction"; >> 5. >> The query tool tab is permanently disabled, and I have to close it and >> open a new tab to run the script again; Usually the script will then run >> normally, but sometimes I have to do it 2 or 3 times before success (for >> each round I have to close the disabled tab and open a new one); >> 6. >> Sometimes I find that the original script actually DID work (when running >> it again I get 0 updates even when I know there must be some), sometimes it >> has not actually updated anything. This indicates that the script execution >> sometimes bombs before it has even run or at least finished, sometimes it >> bombs out after finishing but before the result message is displayed; >> 7. >> Finally, note that these are standardised scripts, around 50 of them, >> that I run every 2-3 days to correct errors or missing values for client >> data (covid-19 vaccinations) captured on a daily basis. So there is nothing >> wrong with the scripts themselves - the problem is that pgadmin is somehow >> unable to finish many of them in some cases. >> 8. >> I see no similar problems when running the same scripts from the command >> line. >> >> Does anybody have a clue what the issue might be here? >> >> Best regards >> Calle >> >> >> > > -- > Thanks, > Aditya Toshniwal > pgAdmin Hacker | Software Architect | *edbpostgres.com* > <http://edbpostgres.com> > "Don't Complain about Heat, Plant a TREE" > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Browser pane blanks out
Hi, With the last few versions, I have encountered a really annoying problem: Having a range of databases on various servers displayed in the browser pane, the whole pane will now and then "blank out" with nothing showing, even if a range of open tabs will still reference the same tables etc as before. When it happened 10 min ago, I was working on a remote server, pg11.16, pgAdmin4 6.14, Chrome 99.0.4844.84 (machine is win11-64). It typically happens when I try to refresh a single table after having modified it by e.g. adding or dropping columns. I have not found a way of getting the db list to display again, except by using Reset layout or re-starting pgAdmin - in both cases losing all tables and their content unless I save them all. Then I have to set all the tabs up again before I can continue working. Anybody else experiencing this? OR any suggestion of how to force the browser display to refresh/reappear? Best regards Calle
Re: UI freezes on closing a tab
Hi, I was just going to report the same when I saw this. I am running win 10 and 11 on different machines. Problem goes beyond that closing tabs are taking long, though - I have recently had 2 incidents where having 8-12 tabs open and closing one resulted in pgadmin freezing up. I had to terminate and re-open it again to get back to normal. Regards Calle On Fri, 28 Oct 2022 at 14:01, Ray O'Donnell wrote: > On 28/10/2022 11:43, Aditya Toshniwal wrote: > > Hi Ray, > > > > The issue is logged https://github.com/pgadmin-org/pgadmin4/issues/5465 > > <https://github.com/pgadmin-org/pgadmin4/issues/5465> and we're looking > > into it. > > From initial findings it looks related to NW.js wrapper. > > Ah, OK, that's grand - thanks Aditya. > > Ray. > > -- > Raymond O'Donnell // Galway // Ireland > r...@rodonnell.ie > > > > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: Tree view stuck on fixed height
Hi, Same here (windows 10 and 11). Have you formally reported the bug? Better get it in now - PG15 first production release is scheduled for Oct 13, which is likely to trigger a range of updates including possibly pgAdmin. Regards calle On Tue, 4 Oct 2022 at 18:23, Ray O'Donnell wrote: > On 04/10/2022 17:15, Richard Greenwood wrote: > > Same here on Linux Mint 21. > > Glad to hear it's not just me! :-) > > I forgot to add that I've tried the "Reset layout" button, but no change. > > Ray. > > -- > Raymond O'Donnell // Galway // Ireland > r...@rodonnell.ie > > > > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: Content assist / autocomplete hangs the server (latest pgAdmin version)
Hi, I would like to echo Cherio's suggestion here. I copy/paste and run very complex scripts every day, and after the recent changes I see the same: "Then it sort of let me do things but everything was like in slow motion: the tree browser, the other SQL tabs - everything became slow as molasses. I logged onto the server and the "pgAdmin4.py" was keeping the CPU quite busy. It didn't recover for some time so I simply restarted the server and switched autocomplete to manual." When things get really slow I find that I have to close pgadmin completely and re-open it, and if I had let us say 20 tabs open I have to re-create them - painful. Note that I really LIKE autocomplete to be on when writing NEW scripts, it can be a timesaver. But I cannot turn it off and turn it on again 30 times a day - the scripts I'm running are a mix of existing-run-as-is, existing-modify-run, and new-run. Autocomplete pops up after the semicolon I always put at the end of any script when it's finished, so if you could enable a switch to turn autocomplete off if a semicolon is present it would be helpful... (I generally do NOT want auto-complete when just editing old scripts). One specific issue I've noticed is that whenever I paste a complex script, I have to wait for the "Loading" to disappear before executing, or else I get that "ERROR: execute cannot be used while an asynchronous query is underway" message. That's new, but I presume it is doing some kind of script checking and it usually is quick, so that's OK. NOTE, though, that the hourglass icon to the left of the URL does not change to "this session is idle.." etc, it still says "a command is currently in progress" until you have actually executed something [image: Screenshot latest pgAdmin.png] Best regards Calle Hedberg On Fri, 5 Aug 2022 at 10:35, Akshay Joshi wrote: > Hi Cherio > > You can disable the automatic autocomplete option from "File -> > Preferences -> Query Tool -> Auto completion -> Autocomplete on key press". > We have also fixed an issue to stop autocomplete on arrow keys #7573 > <https://redmine.postgresql.org/issues/7573> which will be available in > the next release, meanwhile, you can install the snapshot build > <https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/>. > > > > On Wed, Aug 3, 2022 at 11:39 PM Cherio wrote: > >> I had to examine certain aspects of a query that looks like this: >> >> SELECT COUNT(*) >> FROM schema.table >> WHERE id IN ( >> '1', >> '2', >> '3', >> >> '19998', >> '1', >> '2' >> ) >> >> I pasted the query and autocomplete kicked in. For a minute it froze >> entirely. Then it sort of let me do things but everything was like in slow >> motion: the tree browser, the other SQL tabs - everything became slow as >> molasses. I logged onto the server and the "pgAdmin4.py" was >> keeping the CPU quite busy. It didn't recover for some time so I simply >> restarted the server and switched autocomplete to manual. >> >> Not knowing the design I may not be able to make a viable suggestion but >> maybe some sort of complexity counter (configurable or at least hard-coded >> at first) should be considered, which would hint to the autocomplete to >> stop trying, after it realizes the task may be too complex or takes too >> long to complete. >> >> Sure, a query like the one above should probably make use of a temporary >> table but it is beyond the point - there has to be a safeguard against an >> overloaded autocomplete. Without such a safeguard an ugly/invalid query or >> a user error could kill the server for all connected pgadmin clients. >> >>> > > -- > > <http://www.enterprisedb.com> > > Akshay Joshi > > Principal Software Architect > > +91 9767888246 > > www.enterprisedb.com > > <https://www.linkedin.com/company/edbpostgres> > <https://twitter.com/edbpostgres?lang=en> > <https://www.facebook.com/EDBpostgres> > <https://www.instagram.com/EDBpostgres/> > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
Re: ERD for single tables
Hi, Changing the table relation depth to 0 or to 1 resolved my issue. THANKS!! Regards & Merry Christmas to all Calle On Thu, 7 Dec 2023 at 06:59, Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Calle, > > You can try the solution mentioned by Pravesh. > Alternatively, pgAdmin ERD also allows you to drag the table and drop it > in ERD. So you can start with a blank ERD and drag the tables you need. > > On Thu, Dec 7, 2023 at 9:13 AM Pravesh Sharma < > pravesh.sha...@enterprisedb.com> wrote: > >> Hi Calle, >> >> By default, pgAdmin creates ERD for all the related tables. To generate >> ERD for a single table, you can set the value at *Preferences -> ERD >> tool -> Options -> Table Relation Depth* to 0. >> >> Please let me know if this resolves the issue. >> >> Regards, >> Pravesh >> >> On Wed, Dec 6, 2023 at 11:43 PM Calle Hedberg >> wrote: >> >>> Hi, >>> >>> I have a large and very complicated database, where the complete ERD is >>> so large that it is very hard to find anything (even with a 45" monitor and >>> zooming out). Hundreds of tables, hundreds or relationships. >>> >>> I have tried to create an ERD for a single table only, but that does not >>> seem to work - every time I do it, the result is a complete ERD for the >>> whole database. >>> >>> Is this a bug, or have I missed something? I'm selecting one table, >>> right-click and select "ERD for Table". But I get the complete diagram... >>> >>> Best regards >>> Calle >>> >> >> >> -- >> >> <http://www.enterprisedb.com> >> >> Pravesh Sharma >> >> Software Engineer >> >> +91 9406461406 >> >> www.enterprisedb.com >> >> Power to Postgres >> >> <https://www.linkedin.com/company/edbpostgres> >> <https://twitter.com/edbpostgres?lang=en> >> <https://www.facebook.com/EDBpostgres> >> <https://www.instagram.com/EDBpostgres/> >> > > > -- > Thanks, > Aditya Toshniwal > pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* > <https://www.enterprisedb.com/> > "Don't Complain about Heat, Plant a TREE" > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
ERD for single tables
Hi, I have a large and very complicated database, where the complete ERD is so large that it is very hard to find anything (even with a 45" monitor and zooming out). Hundreds of tables, hundreds or relationships. I have tried to create an ERD for a single table only, but that does not seem to work - every time I do it, the result is a complete ERD for the whole database. Is this a bug, or have I missed something? I'm selecting one table, right-click and select "ERD for Table". But I get the complete diagram... Best regards Calle
Re: pgAdmin 4 v8.5 Released
Hi, I have noticed that 4.8.5 no longer keep query tabs active. Previously I could have 10-15 tabs open and re-run the scripts in each as many times as I wanted over hours and days - now I find that most tabs get deactivated (the "hour-glass" splits with the "Transaction status check failed" message) after a relatively a few hours, and I have to close the tab and re-open a new one (which typically also mean I'm loosing the content of the scratch-pad etc unless I manually copy it over to the new tab). It is really annoying Is this change related to some kind of configuration setting, or is it a regression bug? Regards Calle On Thu, 4 Apr 2024 at 13:08, Akshay Joshi wrote: > The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.5. > > This release of pgAdmin 4 includes 24 bug fixes and new features. For more > details please see the release notes at: > > https://www.pgadmin.org/docs/pgadmin4/8.5/release_notes_8_5.html > > pgAdmin is the leading Open Source graphical management tool for > PostgreSQL. For more information, please see: > > https://www.pgadmin.org/ > > Notable changes in this release include: > > Features: > >- > >Added support for EDB Job Scheduler. >- > >Added support for viewing Log Based Clusters. >- > >Added support for UNIX socket in entrypoint.sh for Docker >implementation. >- > >Added support for provider, deterministic, version, and RULES >parameters while creating collation. > > > > Bugs/Housekeeping: > >- > >Fixed a remote code execution issue in the validate binary path >(CVE-2024-3116). >- > >Fixed an issue in Schema Diff where Columns with sequences get altered >unnecessarily. >- > >Fixed schema diff wrong query generation for the table, foreign table, >and sequence. >- > >Fixed an issue where the maximize icon is missing from the query tool >panel. >- > >Fix an issue in the editor where the Format SQL shortcut and multiline >selection are not working. >- > >Fix an issue in the editor where the "Use Spaces?" preference of the >Editor is not working. >- > >Fixed an issue where Triggers, Rules, and Indexes were absent from the >Schema Diff when comparing views. >- > >Fixed an issue where taking a backup of a shared server was using the >server owner's user name. >- > >Fix an issue in the query tool where custom keyboard shortcuts are not >working for some. > > > Builds for Windows and macOS are available now, along with a Python Wheel, > > Docker Container, RPM, DEB Package, and source code tarball from: > > https://www.pgadmin.org/download/ > > -- > > Akshay Joshi > > pgAdmin Project > > -- *Carl-Anders (Calle) Hedberg* HISP Researcher & Technical Specialist Health Information Systems Programme – South Africa Cell:+47 41461011 (Norway) Iridium SatPhone: +8816-315-19119 (usually OFF) E-mail1: ca...@hisp.org E-mail2: calle.hedb...@gmail.com Skype: calle_hedberg
8.4: CTRL-SHIFT-f no longer works as shortcut to Find and Replace
Hi, I just found that the long-established standard keyboard shortcut on windows/linux for "Find" and "Find and replace" no longer works: CTRL-SHIFT-f has been there for as long as I can remember. I looked at the 8.4 docs here: https://www.pgadmin.org/docs/pgadmin4/development/keyboard_shortcuts.html I can see that there is now "Shift+Ctrl+f" under "Shortcut for all platforms" for the function Quick Search. That is the one now popping up when using that shortcut. But at the end of the "SQL Editors" section, you see "Ctrl+Shift+f" for the function replace. So something must be wrong here - "Shift+Ctrl+f" and "Ctrl+Shift+f" are the same, since the keys are pressed simultaneously. Or is there some devious plot at work here that my grey cells don't get? Enlightenment would be appreciated Regards Calle
