Re: 'render_template' server_type/version resolution
Hi, On Sat, Feb 29, 2020 at 1:56 AM Radoslaw Garbacz < radoslaw.garb...@xtremedatainc.com> wrote: > Hi, > > I have a question regarding templates resolution from subdirectories based > on server version (and type) for 'SQL' templates (e.g. for > "get_encodinds.sql" in > "web/pgadmin/browser/server_groups/servers/databases/"). > > I created a subdirectory matching my pg like db version: > "web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/8.1_plus". > I have also a specific subdir for "server_type_version" (.../dbx_8.1_plus), > however the server does not seem to be able to find it, and always defaults > to ".../templates/databases/sql/default". > > pgAdmin does not support PostgreSQL absolute versions. However if you want to make local changes in the template loader mechanism, check the /web/pgadmin/utils/versioned_template_loader.py file to understand the template loader mapping logic. Thanks, Khushboo > When debugging, I get "self.template_path" as "databases/sql/#80102#" > (server_type: "dbx", however it's not used for "get_encodings"). > > So, I'd be grateful to hear how to make it find my modified > "get_encodings.sql"? > BTW: Is it OK if the directory is a link? > > -- > Best Regards, > > Radoslaw Garbacz > XtremeData Incorporated >
pgAdmin 4 commit: Update Japanese translation.
Update Japanese translation. Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=e330407d44f26be28169f6861dfb3ae6a15f06a1 Author: Identifier Anonymous Modified Files -- .../translations/ja/LC_MESSAGES/messages.mo| Bin 178133 -> 178991 bytes .../translations/ja/LC_MESSAGES/messages.po| 22 +++-- 2 files changed, 12 insertions(+), 10 deletions(-)
pgAdmin 4 commit: Update French translation.
Update French translation. Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=b9a036e5cb8eef69dd49b04ecabaddbb4db659fd Author: Fred Escallier Modified Files -- .../translations/fr/LC_MESSAGES/messages.mo| Bin 168652 -> 182776 bytes .../translations/fr/LC_MESSAGES/messages.po| 1252 ++-- 2 files changed, 594 insertions(+), 658 deletions(-)
pgAdmin 4 commit: Update Italian translation.
Update Italian translation. Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=8e40c8630dddf906eae1370d5452c07954802785 Author: Domenico Sgarbossa Modified Files -- .../translations/it/LC_MESSAGES/messages.mo| Bin 163708 -> 178638 bytes .../translations/it/LC_MESSAGES/messages.po| 1242 +- web/pgadmin/translations/it/messages.mo| Bin 178456 -> 0 bytes web/pgadmin/translations/it/messages.po| 12350 --- 4 files changed, 550 insertions(+), 13042 deletions(-)
Re: Translators: Release next week
Thanks, patch applied. On Fri, Feb 28, 2020 at 11:03 PM wrote: > > Hello. > Updated french translation for version 4.19 in attachment. > bye > > > -- > *De: *"Akshay Joshi" > *À: *"pgadmin-hackers" > *Envoyé: *Vendredi 28 Février 2020 13:27:47 > *Objet: *Translators: Release next week > > Hi Translators, > > We will have a release next week, so updates to translations before > release would be helpful. The template and catalogs have been updated in > git. > > -- > *Thanks & Regards* > *Akshay Joshi* > > *Sr. Software Architect* > *EnterpriseDB Software India Private Limited* > *Mobile: +91 976-788-8246* > > -- *Thanks & Regards* *Akshay Joshi* *Sr. Software Architect* *EnterpriseDB Software India Private Limited* *Mobile: +91 976-788-8246*
Re: Translators: Release next week
Thanks, patch applied. On Sat, Feb 29, 2020 at 8:49 PM Domenico Sgarbossa wrote: > Hi, > italian files ready! > Bye > > Il venerdì 28 febbraio 2020, 13:28:05 CET, Akshay Joshi < > akshay.jo...@enterprisedb.com> ha scritto: > > > Hi Translators, > > We will have a release next week, so updates to translations before > release would be helpful. The template and catalogs have been updated in > git. > > -- > *Thanks & Regards* > *Akshay Joshi* > > *Sr. Software Architect* > *EnterpriseDB Software India Private Limited* > *Mobile: +91 976-788-8246* > -- *Thanks & Regards* *Akshay Joshi* *Sr. Software Architect* *EnterpriseDB Software India Private Limited* *Mobile: +91 976-788-8246*
Re: Japanese translation (March 2020)
Thanks, patch applied. On Fri, Feb 28, 2020 at 10:19 PM fn ln wrote: > Hello. > Updated translation for upcoming version 4.19 is in attachment. > messages.pot was taken from git aa127fe0. > -- *Thanks & Regards* *Akshay Joshi* *Sr. Software Architect* *EnterpriseDB Software India Private Limited* *Mobile: +91 976-788-8246*
pgAdmin 4 commit: Update libraries.txt
Update libraries.txt Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=6340c70d7abe18a32fdfae8b26c70429a92fe18c Modified Files -- libraries.txt | 18 +- 1 file changed, 9 insertions(+), 9 deletions(-)
Re: OpenStreetMap not showing in geometry viewer
Hi Charles, It looks like the SRID for your geometry column is different from 4326 (You need to explore on your own what is SRID) Use https://postgis.net/docs/Find_SRID.html to get your SRID and try converting it to 4326(if not 4326) using https://postgis.net/docs/UpdateGeometrySRID.html On Sat, Feb 29, 2020 at 9:20 AM Charles Wang wrote: > Hi Guys, > [image: Screen Shot 2020-02-28 at 3.41.47 PM.png] > I've spent two days on this and still have no clue > The openstreetmap basemap only worked once at the first try of pgadmin. > And it only worked for one database. > I tried it on the second database it didn't work: no openstreetmap shown > up. > > I reinstalled it (macos), and it still didn't work for any database that I > connected to. > > I tried different browsers, cleared all browsers histories and cache. > I even tried to fire up pgadmin in a container, but the openstreetmap base > map is still missing in the geometry viewer. > > where is osm, any idea? Thanks. > > > BRGDS, > Charles > -- Thanks and Regards, Aditya Toshniwal pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune "Don't Complain about Heat, Plant a TREE"
Re: OpenStreetMap not showing in geometry viewer
Thank you Aditya, exactly! you made my day. I appreciate your help. BRGDS, Charles On Sun, Mar 1, 2020 at 9:49 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Charles, > > It looks like the SRID for your geometry column is different from 4326 > (You need to explore on your own what is SRID) > Use https://postgis.net/docs/Find_SRID.html to get your SRID and try > converting it to 4326(if not 4326) using > https://postgis.net/docs/UpdateGeometrySRID.html > > > On Sat, Feb 29, 2020 at 9:20 AM Charles Wang wrote: > >> Hi Guys, >> [image: Screen Shot 2020-02-28 at 3.41.47 PM.png] >> I've spent two days on this and still have no clue >> The openstreetmap basemap only worked once at the first try of pgadmin. >> And it only worked for one database. >> I tried it on the second database it didn't work: no openstreetmap shown >> up. >> >> I reinstalled it (macos), and it still didn't work for any database that >> I connected to. >> >> I tried different browsers, cleared all browsers histories and cache. >> I even tried to fire up pgadmin in a container, but the openstreetmap >> base map is still missing in the geometry viewer. >> >> where is osm, any idea? Thanks. >> >> >> BRGDS, >> Charles >> > > > -- > Thanks and Regards, > Aditya Toshniwal > pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune > "Don't Complain about Heat, Plant a TREE" >
Re: OpenStreetMap not showing in geometry viewer
On Mon, Mar 2, 2020 at 12:21 PM Charles Wang wrote: > Thank you Aditya, exactly! you made my day. > I appreciate your help. > Glad it worked !! :) > > > BRGDS, > Charles > > > On Sun, Mar 1, 2020 at 9:49 PM Aditya Toshniwal < > aditya.toshni...@enterprisedb.com> wrote: > >> Hi Charles, >> >> It looks like the SRID for your geometry column is different from 4326 >> (You need to explore on your own what is SRID) >> Use https://postgis.net/docs/Find_SRID.html to get your SRID and try >> converting it to 4326(if not 4326) using >> https://postgis.net/docs/UpdateGeometrySRID.html >> >> >> On Sat, Feb 29, 2020 at 9:20 AM Charles Wang wrote: >> >>> Hi Guys, >>> [image: Screen Shot 2020-02-28 at 3.41.47 PM.png] >>> I've spent two days on this and still have no clue >>> The openstreetmap basemap only worked once at the first try of pgadmin. >>> And it only worked for one database. >>> I tried it on the second database it didn't work: no openstreetmap shown >>> up. >>> >>> I reinstalled it (macos), and it still didn't work for any database that >>> I connected to. >>> >>> I tried different browsers, cleared all browsers histories and cache. >>> I even tried to fire up pgadmin in a container, but the openstreetmap >>> base map is still missing in the geometry viewer. >>> >>> where is osm, any idea? Thanks. >>> >>> >>> BRGDS, >>> Charles >>> >> >> >> -- >> Thanks and Regards, >> Aditya Toshniwal >> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune >> "Don't Complain about Heat, Plant a TREE" >> > -- Thanks and Regards, Aditya Toshniwal pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune "Don't Complain about Heat, Plant a TREE"
