{"hits":[{"excerpt":"To run all the <strong>tests</strong>, the user also needs superuser privilege. Create a PostgreSQL password file, e.g., on Linux: ~/.pgpass, on Windows: %APPDATA%\\postgresql\\pgpass.conf.","date":"2013-01-31T20:17:16Z","version":"0.6.1","dist":"Pyrseas","score":"0.415","user_name":"Joe Abbate","user":"jma","title":"Testing","abstract":"","docpath":"docs/testing"},{"excerpt":"The simplest way to do so is to define a function that RETURNS SETOF TEXT and then simply call RETURN NEXT for each TAP <strong>test</strong>. Here's a simple example: CREATE OR REPLACE FUNCTION my_tests( ) RETURNS&#8230;","date":"2013-01-28T20:15:00Z","version":"0.93.0","dist":"pgTAP","score":"0.307","user_name":"David E. Wheeler","user":"theory","title":"pgTAP 0.93.0","abstract":"Unit testing for PostgreSQL","docpath":"doc/pgtap"},{"excerpt":"&#8230; parser <strong>tests</strong><strong>.Standard postgres PGXS regression </strong><strong>tests</strong><strong> Location: </strong><strong>test</strong><strong>/sql/ - input files </strong><strong>test</strong><strong>/expected/ - output filesEach </strong><strong>test</strong><strong> has same filename base, but differs in extension: .sql - for input&#8230;</strong>","date":"2012-05-27T07:52:16Z","version":"0.1.6","dist":"www_fdw","score":"0.282","user_name":"Alex","user":"cyga","title":"Test types","abstract":"","docpath":"test/README"},{"excerpt":"There is a separate <strong>test</strong><strong> script for each of the partitioning types. The </strong><strong>tests</strong><strong> are not required to run pg_partman, so if you don't feel safe doing this you don't need to run the </strong><strong>tests</strong>.","date":"2013-03-21T21:57:30Z","version":"1.2.0","dist":"pg_partman","score":"0.225","user_name":"Keith Fiske","user":"keithf4","title":"pg_partman Test Suite","abstract":"","docpath":"test/README_test"},{"excerpt":"PG Jobmon <strong>Test</strong><strong> Suite The pgTAP </strong><strong>testing</strong><strong> suite is used to provide functional </strong><strong>testing</strong> during development and evaluation. Please see the pgTAP home page for more details on its installation and use.","date":"2013-05-06T18:22:59Z","version":"1.1.1","dist":"pg_jobmon","score":"0.223","user_name":"Keith Fiske","user":"keithf4","title":"PG Jobmon Test Suite","abstract":"","docpath":"test/README_test"},{"excerpt":"After running the <strong>test</strong><strong> suite you may check the regression.diff file to verify that the only </strong><strong>tests</strong> failed are the ones related to the missing functionalities and the different default random numbers&#8230;","date":"2012-09-29T01:54:53Z","version":"1.0.1","dist":"pgmp","score":"0.007","user_name":"Daniele Varrazzo","user":"piro","title":"!pgmp extension installation","abstract":"","docpath":"docs/install"},{"excerpt":"After running the <strong>test</strong><strong> suite you may check the regression.diff file to verify that the only </strong><strong>tests</strong> failed are the ones related to the missing functionalities and the different default random numbers&#8230;","date":"2011-05-23T00:29:23Z","version":"1.0.0","dist":"pgmp","score":"0.007","user_name":"Daniele Varrazzo","user":"piro","title":"pgmp extension installation — PostgreSQL Multiple Precision Arithmetic 1.0.0 documentation","abstract":"","docpath":"docs/html/install"},{"excerpt":"&#8230; make: make <strong>test</strong><strong> To compile and run the </strong><strong>tests</strong><strong> with SCons: scons </strong><strong>test</strong><strong> You may optionally specify a remote server: scons </strong><strong>test</strong><strong> --</strong><strong>test</strong><strong>-server=123.4.5.67 You may also specify an alternate starting port&#8230;</strong>","date":"2012-10-19T07:04:19Z","version":"1.0.0","dist":"mongo_fdw","score":"0.007","user_name":"Citus Data","user":"citusdata","title":"Building the MongoDB C Driver","abstract":"","docpath":"mongo-c-driver-v0.6/docs/source/sphinx/source/building"},{"excerpt":"Mainly <strong>tested</strong> with Release 9.2. Building make make install Using andrew# create extension unnest_ordinality; andrew=# select * from unnest_ordinality('{a,b,c,d,e,f,g}'::text[]); element_number |&#8230;","date":"2013-04-19T16:39:07Z","version":"1.0.1","dist":"unnest_ordinality","score":"0.006","user_name":"Andrew Dunstan","user":"andrew","title":"unnest_ordinality PostgreSQL Extension","abstract":"turn an array into a set of (element_number, element) pairs","docpath":"doc/unnest_ordinality"},{"excerpt":"The procedure described in this document has been <strong>tested</strong><strong> on versions 0.1.4 of both packages, installed on a PostgreSQL 9.2 server. The SQL files in the </strong><strong>test</strong>/sql/play directory make use of the&#8230;","date":"2012-10-26T18:11:09Z","version":"0.1.4","dist":"pgchess","score":"0.006","user_name":"Gianni Ciolli","user":"gciolli","title":"pgchess Quickstart","abstract":"","docpath":"doc/QUICKSTART"},{"excerpt":"&#8230; pg_column_size -----------------+----------------- 5 | 5 (1 row) <strong>test</strong><strong>=# INSERT INTO t VALUES (0::VARINT64, 0::VARUINT64); </strong><strong>test</strong>=# SELECT pg_column_size(i) AS signed, pg_column_size(u) AS unsigned&#8230;","date":"2012-10-24T08:31:50Z","version":"0.1.0","dist":"varint","score":"0.006","user_name":"Sean Chittenden","user":"sean","title":"PostgreSQL varint extension","abstract":"","docpath":"www/index"},{"excerpt":"To compile and run the <strong>tests</strong><strong>: scons </strong><strong>test</strong> Error Handling Most functions return MONGO_OK or BSON_OK on success and MONGO_ERROR or BSON_ERROR on failure.","date":"2012-10-19T07:04:19Z","version":"1.0.0","dist":"mongo_fdw","score":"0.006","user_name":"Citus Data","user":"citusdata","title":"MongoDB C Driver","abstract":"","docpath":"mongo-c-driver-v0.6/README"},{"excerpt":"&#8230; (see alow_on_condition). Examples: Assume we have a table <strong>test</strong><strong>: CREATE TABLE </strong><strong>test</strong>(a INTEGER, b INTEGER, c INTEGER); To block updates to columns a and b unless value of column b + c is greater than&#8230;","date":"2012-09-25T18:19:32Z","version":"1.0.1","dist":"check_updates","score":"0.006","user_name":"Alexey Klyukin","user":"alexk","title":"check_updates","abstract":"Trigger functions to allow/deny certain type of table updates","docpath":"doc/check_updates"},{"excerpt":"&#8230; to connect!\\n&quot; ); exit(1); } mongo_cmd_drop_collection( conn, &quot;<strong>test</strong>&quot;, &quot;foo&quot;, NULL ); /* Initialize the write concern object.*/ mongo_write_concern_init( write_concern ); write_concern-&gt;w = 1&#8230;","date":"2012-10-19T07:04:19Z","version":"1.0.0","dist":"mongo_fdw","score":"0.005","user_name":"Citus Data","user":"citusdata","title":"Write Concern (a.k.a. \"Safe Mode\")","abstract":"","docpath":"mongo-c-driver-v0.6/docs/source/sphinx/source/write_concern"},{"excerpt":"The procedure described in this document has been <strong>tested</strong><strong> on a PostgreSQL 9.2 server, where pgchess version 0.1.7 and pg2podg version 0.1.3 have been installed.</strong>","date":"2012-11-20T21:04:39Z","version":"0.1.7","dist":"pgchess","score":"0.005","user_name":"Gianni Ciolli","user":"gciolli","title":"pgchess Quickstart","abstract":"","docpath":"doc/pgchess-QUICKSTART"},{"excerpt":"&#8230; period); CREATE TABLE temporal=&gt; CREATE INDEX test_period_idx ON <strong>test</strong><strong> USING GiST (test_period); CREATE INDEX temporal=&gt; INSERT INTO </strong><strong>test</strong> ( temporal(&gt; SELECT period( temporal(&gt; clock_timestamp() +&#8230;","date":"2011-06-03T08:09:04Z","version":"0.7.1","dist":"temporal","score":"0.005","user_name":"Jeff Davis","user":"jdavis","title":"Temporal Postgres - Reference","abstract":"","docpath":"doc/html/reference"},{"excerpt":"&#8230; select (aclexplode(relacl)).* from pg_class where relname='<strong>test</strong>'; grantor | grantee | privilege_type | is_grantable ---------+---------+----------------+-------------- 10 | 10 | INSERT | f 10 | 10&#8230;","date":"2012-09-21T16:51:39Z","version":"1.0.3","dist":"aclexplode","score":"0.004","user_name":"Alexey Klyukin","user":"alexk","title":"aclexplode","abstract":"A backport of aclexplode function for PostgreSQL 8.4 and below","docpath":"doc/aclexplode"},{"excerpt":"&#8230; is an example stored procedure written in PL/Perl 6, from our <strong>test</strong> suite:CREATE OR REPLACE FUNCTION test_fibonacci_plperl6(integer) RETURNS int LANGUAGE plperl6 AS $$ { [+] (1, 1, *+* ...","date":"2011-07-24T08:09:25Z","version":"0.4.0","dist":"plparrot","score":"0.004","user_name":"Jonathan \"Duke\" Leto","user":"dukeleto","title":"PL/Parrot - Parrot Virtual Machine in PostgreSQL","abstract":"","docpath":"html/plperl6"},{"excerpt":"To easily run the Pyrseas <strong>tests</strong><strong> against various Python/PostgreSQL version combinations, install Tox. Please refer to </strong><strong>testing</strong> for more information.","date":"2013-01-31T20:17:16Z","version":"0.6.1","dist":"Pyrseas","score":"0.003","user_name":"Joe Abbate","user":"jma","title":"Development","abstract":"","docpath":"docs/devel"},{"excerpt":"&#8230; USE WITH CAUTION: It is not production ready but you could <strong>test</strong><strong> it in your </strong><strong>test</strong> server and help us to improve it; it not implements limits yet, so if you do a select * from ldap_table it will fetch&#8230;","date":"2013-04-01T23:48:13Z","version":"0.1.1","dist":"ldap_fdw","score":"0.003","user_name":"Dickson S. Guedes","user":"guedes","title":"LDAP Foreign Data Wrapper for PostgreSQL 9.2","abstract":"LDAP Foreign Data Wrapper","docpath":"doc/ldap_fdw"},{"excerpt":"Pyrseas has been <strong>tested</strong> with PG 8.4, 9.0, 9.1 and 9.2, and we'll certainly keep up with future releases. Please refer to section III, Server Administration of the PostgreSQL documentation for details&#8230;","date":"2013-01-31T20:17:16Z","version":"0.6.1","dist":"Pyrseas","score":"0.003","user_name":"Joe Abbate","user":"jma","title":"Installation","abstract":"","docpath":"docs/install"},{"excerpt":"This use has not been <strong>tested</strong><strong>. IF YOU ARE PLANNING TO USE pg_upgrade THEN DO NOT USE THIS EXTENSION WITHOUT UPGRADE </strong><strong>TESTING</strong>. If you ignore this warning and it breaks you get to keep all the pieces.","date":"2013-04-10T00:52:38Z","version":"1.0.0","dist":"json_enhancements","score":"0.003","user_name":"Andrew Dunstan","user":"andrew","title":"Json Enhancements for PostgreSQL 9.2","abstract":"Backport of pg 9.3 JSON enhancements to PostgreSQL 9.2","docpath":"doc/json_enhancements"},{"excerpt":"&#8230; INTO extensions VALUES ('pgtap', '0.35.0', 'PostgreSQL unit <strong>testing</strong><strong>'), ('pgtap', '0.35.0-b1', 'PostgreSQL unit </strong><strong>testing</strong>.'), ('pair', '0.1.0', 'Key/value pair data type'), ('PostGIS', '1.5.0'&#8230;","date":"2012-11-20T19:04:19Z","version":"0.3.0","dist":"semver","score":"0.003","user_name":"David E. Wheeler","user":"theory","title":"semver 0.3.0","abstract":"A semantic version data type","docpath":"doc/semver"},{"excerpt":"When ready to create or upgrade a <strong>test</strong> or production database, the yamltodb utility can be used with the YAML spec as input, to generate a script of SQL CREATE or ALTER statements to modify the&#8230;","date":"2013-01-31T20:17:16Z","version":"0.6.1","dist":"Pyrseas","score":"0.002","user_name":"Joe Abbate","user":"jma","title":"Overview","abstract":"","docpath":"docs/overview"},{"excerpt":"&#8230; can be created for the table with the following commands: -- <strong>test</strong> table, column `val` needs to be indexed create table test_table(id bigserial, val text[]); -- create the index create index&#8230;","date":"2012-12-11T18:13:51Z","version":"1.2.0","dist":"parray_gin","score":"0.002","user_name":"Eugene Seliverstov","user":"theirix","title":"parray_gin extension","abstract":"","docpath":"doc/parray_gin"},{"excerpt":"&#8230; an online CLUSTER of all tables in database <strong>test</strong><strong>: $ pg_repack </strong><strong>test</strong><strong> Execute the following command to perform an online VACUUM FULL of table foo in database </strong><strong>test</strong><strong>: $ pg_repack --no-order --table foo&#8230;</strong>","date":"2012-12-01T13:06:08Z","version":"1.1.8","dist":"pg_repack","score":"0.002","user_name":"Daniele Varrazzo","user":"piro","title":"pg_repack -- Reorganize tables in PostgreSQL databases with minimal locks","abstract":"Reorganize tables in PostgreSQL databases with minimal locks","docpath":"doc/pg_repack"},{"excerpt":"reps controls how many such <strong>tests</strong> are done, 5 to 10 is a reasonable number, more will reduce the chances of a composite being returned as &#8220;probably prime&#8221;.","date":"2012-09-29T01:54:53Z","version":"1.0.1","dist":"pgmp","score":"0.002","user_name":"Daniele Varrazzo","user":"piro","title":"!mpz data type","abstract":"","docpath":"docs/mpz"},{"excerpt":"reps controls how many such <strong>tests</strong> are done, 5 to 10 is a reasonable number, more will reduce the chances of a composite being returned as &#8220;probably prime&#8221;.","date":"2011-05-23T00:29:23Z","version":"1.0.0","dist":"pgmp","score":"0.002","user_name":"Daniele Varrazzo","user":"piro","title":"mpz data type — PostgreSQL Multiple Precision Arithmetic 1.0.0 documentation","abstract":"","docpath":"docs/html/mpz"},{"excerpt":"&#8230; mongo_cursor cursor[1]; mongo_cursor_init( cursor, conn, &quot;<strong>test</strong>.foo&quot; ); bson query[1]; bson_init( query ); bson_append_int( query, &quot;bar&quot;, 1 ); bson_finish( query ); bson fields[1]; bson_init( fields&#8230;","date":"2012-10-19T07:04:19Z","version":"1.0.0","dist":"mongo_fdw","score":"0.002","user_name":"Citus Data","user":"citusdata","title":"MongoDB C Driver History","abstract":"","docpath":"mongo-c-driver-v0.6/HISTORY"},{"excerpt":"OmniPITR might work, but was not <strong>tested</strong> on your version of Perl) Errors: - you don't have any of programs used to transmit WAL files (ssh, rsync) - you don't have POSIX Perl library (should be&#8230;","date":"2013-04-01T20:16:09Z","version":"1.1.0","dist":"omnipitr","score":"0.002","user_name":"Hubert depesz Lubaczewski","user":"depesz","title":"OmniPITR - Installation","abstract":"","docpath":"doc/install"},{"excerpt":"&#8230; Fix slave backup on 9.0 systems (new option, -cm) Add <strong>test</strong> system, not really configurable now, but works, and lets me easily verify that OmniPITR still works. Add (finally) versions.","date":"2013-04-01T20:16:09Z","version":"1.1.0","dist":"omnipitr","score":"0.002","user_name":"Hubert depesz Lubaczewski","user":"depesz","title":"OmniPITR","abstract":"","docpath":"doc/changes"},{"excerpt":"&#8230; ); } Further Reading This overview just touches on the basics of using Mongo from C. For more examples, check out the other documentation pages, and have a look at the driver's <strong>test</strong> cases.","date":"2012-10-19T07:04:19Z","version":"1.0.0","dist":"mongo_fdw","score":"0.001","user_name":"Citus Data","user":"citusdata","title":"MongoDB C Driver Tutorial","abstract":"","docpath":"mongo-c-driver-v0.6/docs/source/sphinx/source/tutorial"},{"excerpt":"&#8230; CRITICAL(PG_JOBMON <strong>TEST</strong> BAD JOB: 1 consecutive job failure(s)) Here's a more advanced query that will still give you the highest alert_code text at the beginning of the result, but also give all&#8230;","date":"2013-05-06T18:22:59Z","version":"1.1.1","dist":"pg_jobmon","score":"0.001","user_name":"Keith Fiske","user":"keithf4","title":"pg_jobmon","abstract":"Job logging and monitoring extension","docpath":"doc/pg_jobmon"},{"excerpt":"PostgreSQL (since version 8.0, but OmniPITR has been <strong>tested</strong> only with 8.2 and newer) supports WAL Segments Archiving. What it really is, is that you can define a command, that will be run as soon as&#8230;","date":"2013-04-01T20:16:09Z","version":"1.1.0","dist":"omnipitr","score":"0.001","user_name":"Hubert depesz Lubaczewski","user":"depesz","title":"OmniPITR","abstract":"","docpath":"doc/internals"},{"excerpt":"&#8230; WITH arguments in your COPY file, but such behaviour has not been <strong>tested</strong> or allowed for. Configuration file All configuration of the script is done using a configuration file.","date":"2011-05-31T21:38:08Z","version":"2.0.999","dist":"Slony-I","score":"0.001","user_name":"Christopher Browne","user":"cbbrowne","title":"bulk_load_for_slony.pl","abstract":"","docpath":"tools/slony_bulkload/bulk_load_for_slony"},{"excerpt":"&#8230; learn more on how to use these API in sql/window.sql regression <strong>test</strong>, which implements most of the native window functions. For the general information of the user-defined window function, see the&#8230;","date":"2013-05-15T06:06:19Z","version":"1.4.1","dist":"plv8","score":"0.001","user_name":"Hitoshi Harada","user":"umitanuki","title":"PL/v8","abstract":"A procedural language in JavaScript","docpath":"doc/plv8"}],"count":36,"query":"test","limit":50,"offset":0}