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/ja/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 96% 27 95% 554 96% 4,245
Needs editing 3% 1 4% 25 3% 151
Read-only 0% 0 0% 0 0% 0
Failing checks 28% 8 20% 119 22% 983
Strings with suggestions 3% 1 4% 25 3% 151
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

0 changes 31 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
96%
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 — Japanese

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.
history_informationテーブルに追跡のための登録を行い、履歴テーブルを追加し、テーブルに挿入、更新、削除の規則を設定します。
a year ago
User avatar None

New string to translate

postgis_branch_32 / extras_historytable — Japanese

1 new string to translate appeared in the translation. a year ago
User avatar None

Resource update

postgis_branch_32 / extras_historytable — Japanese

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

String updated in the repository

postgis_branch_32 / extras_historytable — Japanese

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));

-- トランザクションの詳細を確認--
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

String updated in the repository

postgis_branch_32 / extras_historytable — Japanese

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.
この関数は現在は<varname>geometry_columns</varname>に登録されているジオメトリカラムに依っていて、<varname>geometry_columns</varname>にないジオメトリカラムでは失敗します。
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / extras_historytable — Japanese

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.
history_informationテーブルに追跡のための登録を行い、元テーブル名の前に<varname>history</varname>をつけた名前となる履歴テーブルを、元テーブルと同じスキーマに追加し、テーブルに挿入、更新、削除の規則を設定します。ジオメトリの挿入、更新、削除は履歴テーブルに全て記録されます。
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / extras_historytable — Japanese

<funcdef>boolean <function>Postgis_Enable_History</function></funcdef> <paramdef><type>text </type> <parameter>p_schema</parameter></paramdef> <paramdef><type>text </type> <parameter>p_table</parameter></paramdef>
<funcdef>boolean <function>Postgis_Enable_History</function></funcdef> <paramdef><type>text </type> <parameter>p_schema</parameter></paramdef> <paramdef><type>text </type> <parameter>p_table</parameter></paramdef>
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / extras_historytable — Japanese

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.
history_informationテーブルに追跡のための登録を行い、履歴テーブルを追加し、テーブルに挿入、更新、削除の規則を設定します。
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / extras_historytable — Japanese

Postgis_Enable_History
Postgis_Enable_History
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / extras_historytable — Japanese

See Also
関連情報
a year ago
Browse all translation changes