nyuuzyou/wikis huggingface dataset:
Working With VisualStudio

== Pre-requisites ==
=== Visual Studio 2017 ===
PostgreSQL can be built using the Visual C++ compiler suite from Microsoft. These compilers are present in Visual Studio.
After installing Visual Studio, open Visual Studio application and click on ‘Tools’ option and select ‘Get Tools and Features’.
The following workloads need to be installed. Workloads required are .NET desktop development and Desktop development with C++.
Apart from these workloads individual components like VC++ development toolkit and Windows Universal CRT SDK also need to be installed. (Switch to Individual Components tab to install)
It is advised to install both Windows 10 SDK and Windows 8.1 SDK as the build fails with Windows 10 SDK in some machines.
=== Bison and Flex ===
Bison and Flex are aging unix utilities that help you write very fast parsers for almost arbitrary file formats
Bison and Flex are required to build from Git. Bison must be version 2.2 or later. Flex must be version 2.5.31 or later.
Both Bison and Flex are included in the msys tool suite, as part of the MinGW compiler suite.
The MinGW installer can be downloaded from https://osdn.net/projects/mingw/downloads/68260/mingw-get-setup.exe
After the installer is up and running, the following packages need to be selected.
Once it is done, include the path of bison and flex in Windows PATH variable. By default, they are under C:\MinGW\msys\1.0\bin
=== Perl ===
ActiveState Perl is required to run the build generation scripts.
MinGW or Cygwin Perl will not work.
Binaries can be downloaded from https://www.activestate.com 
This also must be present in the Windows PATH variable.
== Build and Installation ==
Create a local repository to store source code for PostgreSQL.
Clone/download the source code from GitHub to the local repository using following command:
		git clone “https://github.com/postgres/postgres.git”
Under the local repository move to tools section:
		Postgres/src/tools/msvc .
Open the ‘Developer Command Prompt for VS 2017’(Using Windows Search) and change the directory path to msvc.
We use the following command to intiate the build. 
		perl mkvcbuild.pl
If there are no errors in the console, solution file corresponding to the PostgreSQL code is generated.
Open solution file in Visual Studio, right click on the Solution ‘pgsql’ and select Build Solution to build.
Post successful build, run the install command to complete the installation for PostgreSQL, create local directory where the installed files should be placed and pass it to INSTALL command
After installation, all the binaries would be available under bin folder.
These binaries can be run through the command prompt.
== Running regression tests ==
Redirect to path postgres/src/tools/msvc using command prompt
Run the vcregress check command to run all the SQL regression tests.
To run a new perl test use the command 
vcregress taptest src\bin\<Test_Folder_name>
Working with Visual Studio Code/es

__NOTOC__
creado por Daymel Bonne
== Desarrollando con Visual Studio Code ==
Esta página explica como comenzar rápidamente si usted desea utilizar Visual Studio Code para desarrollar 
en PostgreSQL.
== Preparando el ambiente de desarrollo ==
# Descargar el Visual Studio Code desde https://code.visualstudio.com/download.
# Instalar e iniciar vscode.
# Instalar los plugins recomendados para el trabajo con C/C++. Ver enlace https://code.visualstudio.com/docs/languages/cpp
# Clonar el repositorio de PostgreSQL. En este ejemplo el directorio donde estará la copia local del repositorio es /pgroot, en la práctica puede ubicarlo en cualquer localización.
#: $ cd /pgroot
#: $ git clone https://github.com/postgres/postgres.git postgres
#: $ cd postgres
#: $ code .
#: 
== Agregar objetivos para generar ==
# Ir al menú Ver -> Paleta de Comandos introducir task y seleccionar Configure Task Runner 
# En el cuadro de selección, seleccione Others 
# Visual Studio Code creará el archivo .vscode/tasks.json en la raiz de su proyecto. Procedemos a editarlo e insertar las siguientes configuraciones. 
# Para ejecutar una tarea de las configuradas anteriormente ir al menú Ver -> Paleta de comandos, insertar task y seleccionar Run Task. En el cuadro de selección seleccione la tarea a ejecutar. 
# Ejecute las tareas 'configure', 'make all' y 'make install' en ese orden. La imagen siguiente muestra la finalización de la ejecución de 'make all' 
== Depurando PostgreSQL desde Visual Studio Code ==
# Asegúrese de que gdb esta instalado en su computadora.
# Ir al menú Ver -> Paleta de comandos, insertar launch y seleccionar 'Open launch.json'. Luego en el cuadro de selección de entorno seleccione la opción para depurar dependiendo del sistema operativo, en este ejemplo será 'C++(GDB/LLDB)' 
# Visual Studio Code creará el archivo .vscode/launch.json en la raiz de su proyecto. Procedemos a editarlo e insertar las siguientes configuraciones. 
# Para iniciar la depuración, ir a la pestaña de Depurar o presionar F5. 
Category:Español
WriteableCTEs

== Overview ==
Writeable CTEs add "(INSERT | UPDATE | DELETE) .. [RETURNING ..]" to CTEs(Common Table Expressions), both in the WITH clause and the top-level statement.
== Syntax ==
 [WITH with_query [, ...]
 plannable_statement
where with_query is:
 with_query_name [ ( column_name [, ...] ) ] AS ( plannable_statement )
and plannable_statement (see gram.y for the origin of this term) query is:
 ( select | insert | update | delete )
== Terminology ==
;DML
:An INSERT, DELETE, or UPDATE statement.
;Derived table
:A temporary table (set of tuples) returned by table expressions.
== General Rules ==
* Top level DML WITH clauses are executed using a single snapshot. This query would remove all rows from "x" and return the number of rows in "x" before DELETE (i.e. the number of deleted rows).
 WITH t1 AS (DELETE FROM x)
 SELECT count(*) FROM x;
* DMLs are executed as separated plans.
* DMLs in WITH list without RECURSIVE clause can refer to only other table expressions that precedes to it as literally specified. This behavior is the same as normal SELECT CTEs. For example:
 -- this should work
 WITH t1 AS(DELETE FROM src RETURNING *),
 t2 AS(INSERT INTO dest SELECT * FROM t1 RETURNING *)
 SELECT * FROM t2;
 
 -- this should raise error
 WITH t2 AS(INSERT INTO dest SELECT * FROM t1 RETURNING *),
 t1 AS(DELETE FROM src RETURNING *)
 SELECT * FROM t2;
* AFTER triggers will not run until the whole query has been executed.
* You cannot CREATE VIEW on wCTEs query. This restriction may be removed in the future.
* It is allowed to put DMLs without RETURING clause in WITH, but it is forbidden to refer to that derived table.
 -- this is ok
 WITH t1 AS(DELETE FROM src), t2 AS(SELECT * FROM dest)
 SELECT * FROM t2;
 
 -- this raises an error
 WITH t1 AS(DELETE FROM src), t2 AS(SELECT * FROM dest)
 SELECT * FROM t1;
* DMLs in WITH clause are allowed only in the top-level WITH.
 -- raise an error
 SELECT * FROM(WITH t1 AS(DELETE FROM src) SELECT * FROM t1)s;
== Implementation ==
== Usage ==
* Move rows from src to dest, and return them immediately.
 WITH t1 AS (DELETE FROM src RETURNING *),
 INSERT INTO dest SELECT * FROM t1 RETURNING *;
== Compatibility ==
Because RETURNING clause on DMLs is PostgreSQL's extension, writeable CTEs is not in the current standard. However, SQL 2011 possibly mentions about Delta Table, which might be similar to Writeable CTEs.
Category:SQL
XML Indexing

This is currently under development. See the ToDo list.
----
==Goals==
PostgreSQL currently supports indexing of XML using
* full text search engine
* functional indexes on XPath expressions
None of these offers the functionality needed to retrieve the data based on values of different parts of XML document. Queries on XML document are supposed to be specified using a query language like XPath or XQuery. Using a functional index on the XPath expression is the closest way, however, it is not robust and you can query the document effectively only using a constant XPath expression specified during the index creation. Users might require to query the document with various different XML queries on the same column.
The goal of this project is to provide an efficient way on how to store and retrieve tuples based on XML column values queried using XPath and/or XQuery language expressions.
==ToDo==
* Prepare the proposal
==Feedback==
If you have any comments, questions or suggestions, please feel free to write to
* Pragnesh Patel - pragnesh777 at gmail dot com
* Julius Stroffek - julo at stroffek dot net; julius dot stroffek at sun dot com
==Links==
Category:Feature request
Category:Indexes
YUM Installation on z Systems

PostgreSQL can be installed using RPMs (binary) or SRPMs (source) managed by YUM for Linux on IBM z Systems. Instructions for installing PostgreSQL on these systems have slightly different instructions while work is being done to integrate the z Systems packages with the other systems. This is currently available for RedHat Enterprise Linux 6 and 7.
== Instructions ==
The first step is to import the package signing public key:
RedHat Enterprise Linux 6
 rpm --import http://packages.2ndquadrant.com/postgresql-z-redhat/RPM-GPG-KEY-2NDQ-RHEL6
RedHat Enterprise Linux 7
 rpm --import http://packages.2ndquadrant.com/postgresql-z/RPM-GPG-KEY-2NDQ-RHEL7
=== Configure your YUM repository ===
The YUM repository can be added using the following command:
RedHat Enterprise Linux 6
PostgreSQL 10:
 yum-config-manager --add-repo http://packages.2ndquadrant.com/postgresql-z/yum/10/rhel6-s390x
PostgreSQL 11:
 yum-config-manager --add-repo http://packages.2ndquadrant.com/postgresql-z/yum/11/rhel6-s390x
PostgreSQL 12:
 yum-config-manager --add-repo http://packages.2ndquadrant.com/postgresql-z/yum/12/rhel6-s390x
RedHat Enterprise Linux 7
PostgreSQL 10:
 yum-config-manager --add-repo http://packages.2ndquadrant.com/postgresql-z/yum/10/rhel7-s390x
PostgreSQL 11:
 yum-config-manager --add-repo http://packages.2ndquadrant.com/postgresql-z/yum/11/rhel7-s390x
PostgreSQL 12:
 yum-config-manager --add-repo http://packages.2ndquadrant.com/postgresql-z/yum/12/rhel7-s390x
=== Install RPM files ===
At this point, installation, setup and service instructions can be followed on the YUM Installation page.
常见问题与解答

== 官方问答集 ==
官方的问答集正处于向Wiki迁移的过程中。对于那些尚未在此页中列出的问答，请参考官方网站上的FAQ页面。
==== 通用性问答集 ====
* 开发者问答（英文）
==== 平台相关问答 ====
* 在Windows平台上安装与运行PostgreSQL
== 其他问答集 ==
* 为什么我不能从远程系统连接到数据库？
* 怎么样改正不正确的序列？
* 为什么"select count(*) from table"这么慢？
* 我该怎么做让语句执行更快？
* 如何能查找为何个别语句执行缓慢？
* 新的PostgreSQL版本有何改动？
* 管理任务如何能不需口令登陆服务器？
* 为什么在我执行只读查询时，我看到了大量写数据库操作？
Category:FAQ
Category:Chinese
881st Dread Commandos

The Dread Commmando's are one of the Empire's Heavy Shock Trooper Battalions that is commanded currently by Colonel Dev'err Malren. This fiersome unit is known to follow the Colonel around the galaxy and when he strikes so do they. This unit has committed many atrocities alongside the belligerent and hated Colonel. As they've been known to assault townships and burn everything to the ground killing everyone.
==Overview==
==Training==
==History==
===Formation===
==Controversy==
===War Crimes===
Accelerate

== Description ==
Create a pocket of accelerated time around you.
== Effect ==
Speeds up time, making certain processes run faster. Not everything you would expect is affected.
== Mana Cost ==
Diminished: 5.5
Normal: 5.5
Augmented: 5.5
== Reagent ==
N/A
== Castable by NPCs ==
No
== Castable by Caster Block ==
No
Utility
Agility

== Description ==
"Anything you can do, I can do better."
== Effect ==
Increases jump height to 2 blocks and also has a small effect on walking and running speed. The effect is not changed by casting mode, only the duration.
Diminished: Lasts 10 seconds
Normal: Lasts 40 seconds
Augmented: Lasts 90 seconds
== Mana Cost ==
Diminished: 25 mana
Normal: 100 mana
Augmented: 500 mana
== Reagent ==
N/A
== Castable by NPCs ==
No
== Castable by Caster Block ==
No
Utility
Air Blade

== Description ==
Creates a razor sharp blast of air that will cut through multiple enemies.
== Effect ==
Spawns a projectile in front of the caster three blocks wide that will travel forward at rapid speed, damaging enemies it collides with.
Unlike other spell projectiles, it will not stop upon hitting an entity. It will continue through until existing for 3 seconds, or colliding with a block.
== Damage ==
Diminished:	
Normal: 	
Augmented: 	
Offense
Apprentice Armor

Novice armor is the most basic of the Ars Magica armors. It offers protection equivalent to Leather Armor.
== Infusion ==
Apprentice armor is designed to be mana stable around magic level 6 with a full set. 
If damaged, it will drain mana from the wearer at a rate of 0.02839975 per tick per piece worn in order to repair itself.
With a full suit with damage, your mana will be draining at a rate of 2.27198 mana per second.
== Bonus Effects ==
None
== Crafting Recipes ==
=== Hood ===
Durability: 199
=== Chest ===
Durability: 289
=== Leggings ===
Durability: 271
=== Boots ===
Durability: 235
Aqua

== Description ==
Creates water at your targeted location.
== Effect ==
Spawns one block of water on Diminished or Normal, and a 3x3 section when Augmented.
== Mana Cost ==
Diminished: 22
Normal: 22
Augmented: 118
== Reagent ==
1 x Water Essence when Augmented.
== Castable by NPCs ==
No
== Castable by Caster Block ==
No
Utility
Arcane Affinity

== Obtaining Arcane Affinity ==
To obtain Arcane Affinity, you will need to find an Arcane Affinity Tome. It can potentially spawn in Mage Towers or Mage Archives.
== Benefits ==
Having an affinity grants a reduction in mana cost to spells that of the Arcane Affinity and you will not need regents to cast augmented Arcane spells. 
==Hinderances== 
Spells from the Ender affinity have increased mana cost and requires double regents.
Arcane Ash

== Crafting Recipe ==
== Uses ==
Arcane Ash is obtained by burning an Arcane Compound in a furnace. It is a core component of all Essences and is used in several advanced crafting recipes, such as the Greater Focus.
Certain mobs, such as the Wisp also have a chance to drop arcane ash. It can also be really rarely found in Mage Towers and especially Mage Archives.
==Max Stack Size==
64
Arcane Compound

(Dust)|C3=Stone
|Output=Arcane Compound
}}
== Uses ==
The Arcane Compound is the starting point to the more advanced features of Ars Magica.
By burning it, the player gains access to Arcane Ash, which is a core ingredient for advanced blocks and recipes.
==Max Stack Size==
64
==Durability==
Infinite
==Trivia==
* This Item cannot be fabricated by a Magic Fabricator
* It can be found in Mage Tower chests
Arcane Empowerment Table

The Arcane Empowerment Table is a block used to level up your Magic Level by using Experience. The way it works is by having your current Exp Level the same as your Magic Level,(the first magic level is free) then your Exp Levels will be drained and your Magic Level will increase by 1; magic levels disappear on death,so don't die! Though the amount is configurable between 1 and 50 levels. Example: the player has 5 Exp levels and their magic level is at 6 they need one more
Exp level to level up there magic level
Note: The minimum amount of levels lost on death is 1. This can be disabled completely, if you want to change the .config for the table, and risk corrupting your whole client and/or server. 
== Description ==
This block is possibly the most important block in the mod as it is what you need to get started and progress in magic throughout the game. In order to level up, you must first gain in normal levels your magic level, so to become level 1 in magic, you don't even have to level up at all in normal levels, whereas to go from level 49 to 50, you must gain 49 levels. Whenever you level up in magic, it removes the normal levels you had to gain to level up.
== Crafting ==
--Removed as of AM2
Arcane Generator

== Crafting Recipe ==
;Crafting an arcane generator requires the following:
*1 x Stone
*1 x Arcane Ash
*1 x Redstone
Place the components in the following configuration:
== Description ==
A redstone device using raw essence
Capacity: 50 essence
== Usage ==
The Arcane Generator is used as a redstone activator when essence from a nexus is applied. Right-clicking it will activate the device just as you would activate a lever. If no essence is present, no redstone signal will be applied.
Arcane Reconstructor

== Description ==
This block will repair damaged equipment using Raw Essence
== Usage ==
Place this block close enough to a source of Essence to allow it to be powered. As standard, the block will store a maximum of 100,000 essence. There are three slots in the top of the interface, where Charge Foci or Mana Foci can be placed. Items that need to be repaired can be placed in one of the 6 spaces to the left. One by one, they will move to the center, where they will be repaired, before being placed in one of the 6 spaces to the right.
== Trivia ==
This block can repair tools made with the mod Tinker's Construct.
== Tutorial ==
Spell Research Table, Reconstructor and Keystone Block by Huntanor
Archive Bookshelves

== Desciption ==
Archive Bookshelves are a component that can assist with Spell Creation.
== Crafting Recipe ==
;Crafting an Archive Bookshelf requires the following:
*6 x Logs
*3 x Wood Planks
Place the components in the following configuration:
== Uses ==
When within 10 blocks of an active Pure Vinteum Crystal, the bookshelf will assist in reducing the likelihood of ill effects and will lower the natural instability gain rate of the vortex. 
Bookshelves need to be filled with Journal Fragments in order to function. The entire lost journal story must be completed in a single bookshelf for it to work. Only one completed journal story per vortex will be accepted. So multiple bookshelves are possible, multiple copies of the same story in different bookshelves, will not.
To add a book, right click the bookshelf. If it is of the same series, and is not already in the shelf, it will be added. Breaking a bookshelf will return the bookshelf and all books that were inside.
Right clicking the bookshelf will allow you to read all parts of the story that have been added to it, ordered correctly (even if you put them into the shelf in a different order, they will be reordered).
== Max Stack Size ==
64
== History ==
Version 	Changes
5.36.016	Introduced to spell creation process
5.36.026	Added more placeholder content for the story that can be placed in bookshelves
5.36.040	Now affect spell creation as intended (one per story)
5.36.045	Attempting to place the "Lost Journal Fragment" into an archive bookshelf no longer causes the game to crash
Archmage Armor

Archmage armor is the most advanced of the Ars Magica armors. It offers physical protection equivalent to Diamond Armor, and superior protection against magical damage.
== Bonus Effects ==
Archmage Armor offers the following additional effects:
=== Head ===
The headpiece is woven with powerful water and air magics that will protect the wearer from drowning. When your breath underwater reaches three bubbles remaining, the headpiece will cast Water Breathing (buff) on you, with the highest magnitude. The water breathing effect will last for 45 seconds. The helmet has a cooldown of 50 seconds before it can protect its wearer again. If you already have Water Breathing (buff) active, regardless of magnitude, the armor will do nothing until it runs out.
=== Chest ===
The chest has powerful life magics on it that will attempt to protect the wearer from death. At 2.5 hearts, it will cast Regeneration (buff) on you, with the highest magnitude. The regeneration effect will last for 12 seconds. The chest piece has a cooldown of 60 seconds before it can protect you again. If you already have Regeneration (buff) on you regardless of magnitude, the armor will do nothing until it runs out.
Additionally, the chest piece will cast an augmented heal spell on you in the event that you are about to die, however, the cost to the armor is significant, costing 75% of the armor's magic. If there is not enough magic left in the armor at that point, it will be unable to save you.
=== Legs ===
This is the thing that I get saved by a lot! The legs are fortified with powerful fire and water magics that will protect the wearer from fire or lava. If the wearer is on fire, the leggings will cast a short duration Water Shield (buff) (1 second duration) that will put them out.
If the wearer is in lava, the leggings will cast a longer lasting Water Shield (buff) (15 second duration) on the caster to give them a chance to protect themselves. This is a much higher cost to the armor, and will cost more of its available reserves.
Either effect has a cooldown of 30 seconds.
In either case, if you already have Water Shield (buff) on you regardless of magnitude, the armor will do nothing and save its mana.
=== Boots ===
The boots are woven with powerful air magics that protect the wearer from falling. They will let you fall at full speed until right before you hit the ground, then will quickly slow your fall. They can only sustain the slow for a brief second, and if you pass the ledge to continue falling, they will be unable to protect you.
If you are not falling far enough to take damage or are otherwise protected from falling, the boots will conserve their mana and do nothing.
The fall protection has a 10 second cooldown.
== Crafting Recipes ==
=== Hood ===
Durability: 859
=== Chest ===
Durability: 1249
=== Leggings ===
Durability: 1171
=== Boots ===
Durability: 1015
Archmage Podium

== Desciption ==
The Archmage Podium is located in the Archmage Tower and is how Augmented Casting is unlocked.
== Uses ==
Right click on the podium once both tower guardians are defeated and Augmented Casting will be unlocked and a short catchy jingle will play. The Podium can be picked up and placed back at your home, which is convenient in case a bug removed your augmented casting.
== Max Stack Size ==
64 (but you're only going to get 1 without cheats)
== Durability ==
Has No Durablility
Archmage Tower

== Description ==
The Archmage Tower is a structure generated by the mod. The tower is guarded by 2 Tower Guardians and has an Essence Nexus at the top of it. Only one Archmage Tower exists per world and can spawn up to 2,000 blocks away from spawn. The Archmage Podium found near the top of the tower is the only way to unlock Augmented casting(And pure evil) ! 
== Contents ==
10 Double chests with random spell recipes, essences, and affinity tomes
1 Brewing Stand
4 Cauldrons
1 Archmage Podium
4 Essence Conduits
l
Arctic Wind

== Description ==
Blast forth a cone of chilling winds to sap the strength from your foes.
== Effect ==
Channeled spell. Creates a cone of frost in front of the caster that applies the Frost Slowed debuff to all entities within the cone, pushing entities caught in the frost backwards, useful for knocking Mob's/Players off ledges. 
== Mana Cost ==
Diminished: 5/second
Normal: 5/second
Augmented: 5/second
== Reagent ==
N/A
== Damage ==
Diminished:	
Normal: 	
Augmented: 	
== Castable by NPCs ==
Yes
== Castable by Caster Block ==
Yes
Offense