postgis_branch_32

extras_historytable

	Language	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
	English		0	0	0	0	13	0	0

	French	50%	14	461	3,365	14	8	0	0

	German	96%	1	25	151	0	5	0	0

	Italian	75%	7	239	1,961	6	6	7	0

	Japanese	96%	1	25	151	0	8	1	0

	Korean	96%	1	25	151	0	8	0	0

	Polish	14%	24	573	4,350	24	0	0	0

	Portuguese (Brazil)	96%	1	25	151	0	7	0	0

	Spanish	85%	4	159	1,399	3	14	0	0

Please sign in to see the alerts.

Overview

Project website	postgis.net
Translation process	Translations can be made directly. Translation suggestions can be made. Any authenticated user can contribute. The translation uses bilingual files.
Source code repository	`https://git.osgeo.org/gitea/postgis/postgis.git`
Repository branch	stable-3.2
Last remote commit	Push to 3.2.6dev milestone `6e2c5206d` Regina Obe authored 22 hours ago
Weblate repository	`https://weblate.osgeo.org/git/postgis_branch_32/postgis/`
File mask	`doc/po/*/extras_historytable.xml.po`

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		252		5,211		39,564
Source		28		579		4,396
Translated	78%	199	70%	3,679	70%	27,885
Needs editing	2%	6	2%	150	2%	906
Read-only	11%	28	11%	579	11%	4,396
Failing checks	27%	69	16%	843	19%	7,647
Strings with suggestions	3%	8	5%	264	5%	2,112
Untranslated strings	18%	47	26%	1,382	27%	10,773

Last 12 months Previous

Activity in last 12 months


May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr

Quick numbers

5,211

Hosted words

252

Hosted strings

78%

Translated

1

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

—

—

Hosted strings

—

—

Translated

—

+100%

Contributors

—

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2023-04-29 AND NOT changed_by:anonymous`	Add
Translated strings	`state:>=translated`	Add
Strings with comments	`has:comment`	Add
Strings with any failing checks	`has:check`	Add
Strings with suggestions from others	`has:suggestion AND NOT suggestion_author:anonymous`	Add
Approved strings with suggestions	`state:approved AND has:suggestion`	Add
All untranslated strings added the past month	`added:>=2023-04-29 AND state:<=needs-editing`	Add
Translated strings in a certain language	`is:translated AND language:en`	Add

None Component unlocked postgis_branch_32 / extras_historytable	Fixing an alert automatically unlocked the component. 10 days ago
None Component locked postgis_branch_32 / extras_historytable	The component was automatically locked because of an alert. 11 days ago
None New alert postgis_branch_32 / extras_historytable	Could not update the repository. 11 days ago
None Suggestion added postgis_branch_32 / extras_historytable — Japanese	English Registers a table in the history_information table for tracking and also adds in side line history table and insert, update, delete rules on the table. Japanese 70 characters edited Current translation history_informationテーブルに追跡のための登録を行い、履歴テーブルを追加し、テーブルに挿入、更新、削除の規則を設定します。 a year ago
None Suggestion added postgis_branch_32 / extras_historytable — Italian	English CREATE TABLE roads(gid SERIAL PRIMARY KEY, road_name varchar(150)); SELECT AddGeometryColumn('roads', 'geom', 26986, 'LINESTRING', 2); SELECT postgis_enable_history('public', 'roads', 'geom') As register_table; register_table -------------- t INSERT INTO roads(road_name, geom) VALUES('Test Street', ST_GeomFromText('LINESTRING(231660.5 832170,231647 832202,231627.5 832250.5)',26986)); -- check transaction detail -- SELECT date_added, last_operation, current_version FROM roads_history WHERE road_name = 'Test Street' ORDER BY date_added DESC; date_added \| last_operation \| current_version ------------------------+----------------+----------------- 2011-02-07 12:44:36.92 \| INSERT \| 2 Italian 730 characters edited CREATE TABLE roads(gid SERIAL PRIMARY KEY, road_name varchar(150)); SELECT AddGeometryColumn('roads', 'geom', 26986, 'LINESTRING', 2); SELECT postgis_enable_history('public', 'roads', 'geom') As register_table; register_table -------------- t INSERT INTO roads(road_name, geom) VALUES('Test Street', ST_GeomFromText('LINESTRING(231660.5 832170,231647 832202,231627.5 832250.5)',26986)); -- controlla i dettagli della transaction -- SELECT date_added, last_operation, current_version FROM roads_history WHERE road_name = 'Test Street' ORDER BY date_added DESC; date_added \| last_operation \| current_version ------------------------+----------------+----------------- 2011-02-07 12:44:36.92 \| INSERT \| 2 a year ago
None Suggestion added postgis_branch_32 / extras_historytable — Italian	English This function currently relies on a geometry column being registered in <varname>geometry_columns</varname> and fails if the geometry column is not present in <varname>geometry_columns</varname> table. Italian 178 characters edited Questa funzione al momento dipende dalla registrazione di una colonna geometrica in <varname>geometry_columns</varname> e fallisce se la colonna non è registrata in tale tabella. a year ago
None Suggestion added postgis_branch_32 / extras_historytable — Italian	English Registers a table in the history_information table for tracking and also adds in side line history table with same name as table but prefixed with <varname>history</varname> in the same schema as the original table. Puts in insert, update, delete rules on the table. Any inserts,updates,deletes of the geometry are recorded in the history table. Italian 390 characters edited Registra una tabella nella tabella history_information per il tracciamento e aggiunge anche una tabella con lo stesso nome della tabella data ma col prefisso <varname>history</varname> nello stesso schema della tabella originale. Aggiunge regole di insert, update e delete alla tabella. Ogni inserimento, aggiornamento o cancellazione della geometria viene registrato nella tabella storica. a year ago
None Suggestion added postgis_branch_32 / extras_historytable — Italian	English Registers a table in the history_information table for tracking and also adds in side line history table and insert, update, delete rules on the table. Italian 164 characters edited Current translation Registra una tabella nella tabella history_information e aggiunge le regole per l'inserimento, l'aggiornamento e la cancellazione di record per la tabella inserita. a year ago
None Suggestion added postgis_branch_32 / extras_historytable — Italian	English SELECT * FROM roads_history WHERE date_added < 'January 1, 2001' AND ( date_deleted >= 'January 1, 2001' OR date_deleted IS NULL ); Italian 149 characters edited SELECT * FROM roads_history WHERE date_added < 'January 1, 2001' AND ( date_deleted >= 'January 1, 2001' OR date_deleted IS NULL ); a year ago
None Suggestion added postgis_branch_32 / extras_historytable — Italian	English history_id \| integer \| not null default date_added \| timestamp without time zone \| not null default now() date_deleted \| timestamp without time zone \| last_operation \| character varying(30) \| not null active_user \| character varying(90) \| not null default "current_user"() current_version \| text \| not null Italian 384 characters edited history_id \| integer \| not null default date_added \| timestamp without time zone \| not null default now() date_deleted \| timestamp without time zone \| last_operation \| character varying(30) \| not null active_user \| character varying(90) \| not null default "current_user"() current_version \| text \| not null a year ago

Browse all component changes