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 yesterday
Weblate repository https://weblate.osgeo.org/git/postgis_branch_32/postgis/
File mask doc/po/*/extras_historytable.xml.po
Translation file Download doc/po/it_IT/extras_historytable.xml.po
Last change None
Last author None

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 28 579 4,396
Translated 75% 21 58% 340 55% 2,435
Needs editing 3% 1 4% 25 3% 151
Read-only 0% 0 0% 0 0% 0
Failing checks 21% 6 8% 50 14% 618
Strings with suggestions 25% 7 41% 239 44% 1,961
Untranslated strings 21% 6 36% 214 41% 1,810
Last 12 months Previous

Activity in last 12 months

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

Quick numbers

579
Hosted words
28
Hosted strings
75%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
—
—
Hosted strings
—
—
Translated
—
—
Contributors
—
User avatar None

Suggestion added

postgis_branch_32 / extras_historytable — Italian

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
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
User avatar None

Suggestion added

postgis_branch_32 / extras_historytable — Italian

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.
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
User avatar None

Suggestion added

postgis_branch_32 / extras_historytable — Italian

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.
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
User avatar None

Suggestion added

postgis_branch_32 / extras_historytable — Italian

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.
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
User avatar None

Suggestion added

postgis_branch_32 / extras_historytable — Italian

SELECT * FROM roads_history
WHERE date_added &lt; 'January 1, 2001' AND
( date_deleted &gt;= 'January 1, 2001' OR date_deleted IS NULL );
SELECT * FROM roads_history
WHERE date_added &lt; 'January 1, 2001' AND
( date_deleted &gt;= 'January 1, 2001' OR date_deleted IS NULL );
a year ago
User avatar None

Suggestion added

postgis_branch_32 / extras_historytable — Italian

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
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
User avatar None

Suggestion added

postgis_branch_32 / extras_historytable — Italian

History Tracking
Tracciamento Storico
a year ago
User avatar None

New strings to translate

postgis_branch_32 / extras_historytable — Italian

7 new strings to translate appeared to the translation. a year ago
User avatar None

Resource update

postgis_branch_32 / extras_historytable — Italian

File doc/po/it_IT/extras_historytable.xml.po was added. a year ago
User avatar None

String updated in the repository

postgis_branch_32 / extras_historytable — Italian

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
 
a year ago
Browse all translation changes