FAQ

PostgreSQL > pgsql-docs

Search Discussions

2,206 discussions - 8,403 posts

  • The documentation says: The view schemata contains all schemas in the current database that are owned by a currently enabled role. ( http://www.postgresql.org/docs/9.2/static/infoschema-schemata.html ...
    Ian Lawrence BarwickIan Lawrence Barwick
    Jan 10, 2013 at 12:35 am
    Jan 10, 2013 at 1:56 am
  • I've noticed that the documentation for PostgreSQL comes in two formats: HTML and PDF. This is great if you have a full sized screen and an internet connection. But what if you have a device that ...
    Edward HooperEdward Hooper
    Jan 9, 2013 at 7:13 pm
    Jan 11, 2013 at 4:17 am
  • This documentation page: http://www.postgresql.org/docs/current/static/lo-examplesect.html contains a hardcoded copy of ./src/test/examples/testlo.c, and it seems like this version hasn't been ...
    Josh KupershmidtJosh Kupershmidt
    Jan 5, 2013 at 2:27 am
    Jan 6, 2013 at 10:33 am
  • You might want to read this page: http://www.postgresql.org/docs/9.2/static/storage-toast.html Note that there is seldom a good reason to use char(n) in PostgreSQL for any value of n. As the page you ...
    Kevin GrittnerKevin Grittner
    Jan 4, 2013 at 8:12 pm
    Jan 4, 2013 at 8:12 pm
  • On the doc page for ALTER VIEW . . . In the discussion about SET/DROP DEFAULT, I am thinking that [instead-of insert trigger] should be mentioned in addition to [ON INSERT rule]. "A default value ...
    Sahagian, DavidSahagian, David
    Jan 2, 2013 at 4:58 pm
    Jan 2, 2013 at 4:58 pm
  • Hi, Here: http://www.postgresql.org/docs/9.2/interactive/datatype-character.html There isn't really clear guidance on ranges and limits. All we have to go on is this paragraph: =start The storage ...
    LyleLyle
    Dec 30, 2012 at 3:02 pm
    Dec 30, 2012 at 3:02 pm
  • To index pattern matching, you can use the _pattern_ops operator classes, or you can set the column collation in the index to "C". The latter option doesn't appear to be documented (unless you read ...
    Peter EisentrautPeter Eisentraut
    Dec 24, 2012 at 2:45 pm
    Dec 27, 2012 at 4:39 pm
  • In GiST indexes, storing nodes larger than an index page is apparently not allowed. This prohibits, for example, storing 600 entry float8 arrays in the index. For SP-GiST in PostgreSQL 9.2, it was ...
    Morten HustveitMorten Hustveit
    Dec 22, 2012 at 1:59 pm
    Dec 22, 2012 at 1:59 pm
  • I think that "GetForeignTableColumnOptions" should be "GetForeignColumnOptions" in the documentation page below. In the source code of 9.2.2, GetForeignColumnOptions is used ...
    Metin DöşlüMetin Döşlü
    Dec 18, 2012 at 10:12 am
    Dec 22, 2012 at 7:54 pm
  • Hi! It's very sorry to disrupted you, but could you help me? I am a programmer, and i want to use Postgresql 9.2.2 to store my applications' data. I had to build a trigger wich based on Database ...
    劉維毅劉維毅
    Dec 14, 2012 at 4:05 am
    Dec 17, 2012 at 2:06 pm
  • Applied, thanks for catching it. regards, tom lane
    Tom LaneTom Lane
    Dec 3, 2012 at 4:10 pm
    Dec 3, 2012 at 4:10 pm
  • Hi, I found that the manual page for pg_buffercache module explains "usagecount" as "Page LRU count". http://www.postgresql.org/docs/devel/static/pgbuffercache.html However, AFAIK, "usagecount" is ...
    Satoshi NagayasuSatoshi Nagayasu
    Nov 24, 2012 at 2:58 am
    Nov 24, 2012 at 2:58 am
  • Based on Jürgen Fuchsberger's experience described on the general list, I think the following should have been back-patched to 8.4 and 8.3 (assuming it gets a minor update before it EOL) as well, not ...
    Jeff JanesJeff Janes
    Nov 21, 2012 at 6:09 pm
    Nov 26, 2012 at 10:37 pm
  • The ability to refer to the collection of old and new rows (transition table) as OLD TABLE and NEW TABLE for statement-level trigger is missing from the SQL:2011 standard. --- ...
    Louis-Claude CanonLouis-Claude Canon
    Nov 14, 2012 at 9:02 pm
    Nov 14, 2012 at 9:02 pm
  • I'm not sure if this is worth documenting, but pg_dumping mixed-case tables with the '-t table' option appears to not be accurately documented for cmd.exe. Here are my four attempts, with only the ...
    Mike ToewsMike Toews
    Nov 13, 2012 at 1:45 am
    Nov 14, 2012 at 3:49 am
  • Hello, the compatibility section of the "create trigger" page (http://www.postgresql.org/docs/devel/static/sql-createtrigger.html) claims that a missing functionality is the ability to define aliases ...
    Louis-Claude CanonLouis-Claude Canon
    Nov 11, 2012 at 8:53 pm
    Nov 14, 2012 at 9:19 pm
  • I think there is at least[4] one confusing documentation leftover from the 9.0 days at: http://www.postgresql.org/docs/devel/static/warm-standby.html First, we claim: This unqualified statement, ...
    Josh KupershmidtJosh Kupershmidt
    Nov 9, 2012 at 2:56 am
    Jan 5, 2013 at 6:27 pm
  • CREATE TABLE employ_presence ( p_id character(6) not null, p_month character(3) NOT NULL, statuscode integer array[7], CONSTRAINT unq_employ_presence UNIQUE (p_id, p_month), CONSTRAINT ...
    Nikolaos IkonomopoulosNikolaos Ikonomopoulos
    Nov 3, 2012 at 9:43 am
    Nov 4, 2012 at 5:33 pm
  • On the SELECT manual-page synopsis, http://www.postgresql.org/docs/devel/static/sql-select.html the LATERAL feature is documented in three sparate lines (the are separate, right?). Because of their ...
    Erik RijkersErik Rijkers
    Oct 27, 2012 at 3:54 pm
    Oct 27, 2012 at 5:56 pm
  • Hi all, This libpq page: http://www.postgresql.org/docs/current/static/libpq-exec.html#LIBPQ-PQRESULTSTATUS has claimed since at least the 7.x days: UPDATE, etc.) However, as of 8.2 we support the ...
    Josh KupershmidtJosh Kupershmidt
    Oct 26, 2012 at 11:58 pm
    Oct 26, 2012 at 11:58 pm
  • Hi, I found the old information about -l option of pg_resetxlog in its document. In HEAD, what -l option of pg_resetxlog allows to be set is a WAL file name. So 'timelineid,fileid,seg' part should be ...
    Fujii MasaoFujii Masao
    Oct 24, 2012 at 2:54 pm
    Jan 1, 2013 at 3:17 pm
  • A few ways in which the formatting could be improved : a) Not so much space between the bottom of the text and the page number. The page number could in fact go at the top with the chapter name. As ...
    Andre MajorelAndre Majorel
    Oct 11, 2012 at 2:28 pm
    Nov 2, 2012 at 4:28 pm
  • Hi, In alter_tablespace.sgml, tablespace option is called in two ways, tablespace_option and tablespace_parameter. We should unify them. The attached patch replaces tablespace_parameter with ...
    Fujii MasaoFujii Masao
    Oct 8, 2012 at 11:45 pm
    Oct 9, 2012 at 7:31 am
  • The CREATE SCHEMA reference page says "Only superusers can create schemas owned by users other than themselves". ISTM this is incorrect, or at least not the whole truth, because the test that is ...
    Tom LaneTom Lane
    Oct 4, 2012 at 3:14 am
    Oct 4, 2012 at 3:14 am
  • Hi, pgsql-docs, I was confused by the system behavior of PG's write ahead log, specifically the relation between commit_delay, commit_siblings, and fsync. Basically according to the manual ( ...
    Tianyin XuTianyin Xu
    Oct 3, 2012 at 12:36 am
    Oct 28, 2012 at 1:16 am
  • On page http://www.postgresql.org/docs/9.1/interactive/server-start.html was published a wrong startup script for automatic starting PostgeSQL during boot under OpenBSD. Here is a working one which ...
    Denis LapshinDenis Lapshin
    Sep 25, 2012 at 6:37 am
    Sep 25, 2012 at 5:41 pm
  • Hi list, Hope this is the right place to suggest that change in the docs, otherwise is there a ticket management system for this stuff somewhere? Paying attention to the documentation at ...
    Alan BAlan B
    Sep 20, 2012 at 4:17 pm
    Sep 20, 2012 at 4:17 pm
  • I found the term "foreign data server" in file_fdw document. It doesn't sound so strange, but "foreign server" or "server" (when context is clear) are used for same meaning in other places, so users ...
    Shigeru HANADAShigeru HANADA
    Sep 19, 2012 at 11:06 am
    Sep 19, 2012 at 11:06 am
  • Hi, I'm using postgresql 9.1 as my database server on a linux server that has 8 GB of RAM. After I changed the shared_buffers parameter to 2GB, I get the following error when I try to start ...
    Data tangerData tanger
    Sep 18, 2012 at 2:00 pm
    Sep 18, 2012 at 6:09 pm
  • Neither; it specifies to search the table and its inheritance children, ie, the opposite of ONLY. This has been the default behavior (unless you change the setting of sql_inheritance) for many years, ...
    Tom LaneTom Lane
    Sep 17, 2012 at 3:58 am
    Sep 26, 2012 at 3:42 pm
  • Is this documented anywhere? I couldn't find it. If not, which section would be the best one to add it to? Cheers, Jeff
    Jeff JanesJeff Janes
    Sep 16, 2012 at 9:39 pm
    Sep 26, 2012 at 3:52 pm
  • Hello, I believe there is some info missing in the page describing libpq programs build: http://www.postgresql.org/docs/9.2/interactive/libpq-build.html I am working with PostgreSQL for several years ...
    Sebastien FLAESCHSebastien FLAESCH
    Sep 12, 2012 at 3:20 pm
    Sep 14, 2012 at 9:42 am
  • I noticed a typo in the description of the column domains.collation_name. This view contains domain entries, so "Name of the collation of the domain" would be correct. -- Shigeru HANADA
    Shigeru HANADAShigeru HANADA
    Sep 5, 2012 at 10:52 am
    Sep 6, 2012 at 3:38 am
  • A few observations here. Want to get feedback before considering proposing a documentation update here. The first is that the only example given for table inheritance is a set/subset model, and the ...
    Chris TraversChris Travers
    Aug 23, 2012 at 6:40 am
    Aug 23, 2012 at 4:06 pm
  • I just had a discussion with someone off-list, where he was looking at the documentation page of a contrib module at www.postgresql.org/docs. Looking at the page, he came to the conclusion that the ...
    Heikki LinnakangasHeikki Linnakangas
    Aug 14, 2012 at 10:32 am
    Aug 15, 2012 at 1:06 am
  • Hi all; I would like to contribute a "What is an Object Relational database?" section to the documentation for 9.3. Where is the best place to start tools and community-process-wise? My thinking is ...
    Chris TraversChris Travers
    Aug 13, 2012 at 10:41 am
    Aug 21, 2012 at 4:19 pm
  • Hello, I've just stumbled on the issue mentioned in this thread, which is not fixed in 9.1. To my knowledge the box @ point index limitation is not described anywhere in the docs (which has costed me ...
    Daniele VarrazzoDaniele Varrazzo
    Aug 11, 2012 at 3:12 pm
    Aug 14, 2012 at 5:41 pm
  • Where the SQL COPY command warns us not to confuse it with \copy, a link to \copy would be useful. The attached patch implements that, but I'm not sure it does so in the preferred way. Thanks, Jeff
    Jeff JanesJeff Janes
    Aug 10, 2012 at 8:54 pm
    Aug 11, 2012 at 5:49 pm
  • Hello, Pgsql-docs. Seems like there is no search in devel branch of the docs, right? Example: http://www.postgresql.org/search/?u=%2Fdocs%2Fdevel%2F&q=smallserial -- With best wishes, Pavel ...
    Pavel GolubPavel Golub
    Jul 11, 2012 at 8:13 am
    Jul 11, 2012 at 5:02 pm
  • I noticed this little snippet claiming to be output on FreeBSD in pgtesttiming.sgml: <screen dmesg | grep "Timecounter" sysctl kern.timecounter.hardware=TSC </screen First, grep is case-sensitive by ...
    Josh KupershmidtJosh Kupershmidt
    Jul 6, 2012 at 8:21 pm
    Aug 30, 2012 at 10:38 pm
  • patch attached. gabrielle
    GabrielleGabrielle
    Jul 3, 2012 at 11:51 pm
    Jul 4, 2012 at 7:12 am
  • A documentation comment came in recently about ssl-tcp.html not specifying what format is expected for the CRL file. Seems like something that could be described better now that I look at it, so I'm ...
    Greg SmithGreg Smith
    Jul 3, 2012 at 12:30 am
    Jul 3, 2012 at 7:21 pm
  • Hi all, In the "Notes" section[0] of the postgres command's page, this advice is given: I think now that we've added pg_terminate_backend() and made it callable by non-superusers, we should relax the ...
    Josh KupershmidtJosh Kupershmidt
    Jun 30, 2012 at 3:11 am
    Aug 30, 2012 at 9:58 pm
  • Folks, Way it is now: =============== max_locks_per_transaction (integer) The shared lock table tracks locks on max_locks_per_transaction * (max_connections + max_prepared_transactions) objects ...
    Josh BerkusJosh Berkus
    Jun 15, 2012 at 6:05 pm
    Aug 30, 2012 at 8:56 pm
  • Hello, 1, I've been playing with PostgreSQL on OpenBSD (5.1), and I found the startup script described on http://www.postgresql.org/docs/9.1/interactive/server-start.html not working, "su" is ...
    Hidvégi GáborHidvégi Gábor
    Jun 2, 2012 at 2:47 pm
    Jun 3, 2012 at 3:31 pm
  • Hi, I attach a proposed change to the docs which points out that if the size of track_activity_query_size is changed and the is server restarted, it won't have any effect if query statistics are ...
    Thom BrownThom Brown
    May 24, 2012 at 12:17 pm
    May 24, 2012 at 2:44 pm
  • Hello, I find that 2 informations on vacuum are quite hard to find in the doc: - "log_autovacuum_min_duration" is not listed in "What to log" ( ...
    Marc MaminMarc Mamin
    May 22, 2012 at 8:57 am
    Aug 30, 2012 at 6:45 pm
  • Hi all, The reference page for ALTER TABLE[1] correctly has the synopsis: CLUSTER ON <replaceable class="PARAMETER" index_name</replaceable but later leaves off the "ON" keyword: <term <literal ...
    Josh KupershmidtJosh Kupershmidt
    May 21, 2012 at 2:13 am
    Aug 30, 2012 at 1:41 pm
  • I'm updating the SQL key word list in the appendix. Since there is now SQL:2011, this should be included in the table. But we're running out of horizontal space. We currently have Key word | ...
    Peter EisentrautPeter Eisentraut
    May 19, 2012 at 6:01 pm
    May 21, 2012 at 1:19 pm
  • I installed PostgreSQL without using "-enable-debug". Now I would like to modify some files. Do I need to re-install PostgreSQL with "-enable-debug". I would be grateful if you let me know whether I ...
    Febin jacobFebin jacob
    May 18, 2012 at 6:13 am
    May 18, 2012 at 1:32 pm
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
grouppgsql-docs @
categoriespostgresql
discussions2,206
posts8,403
users1,102
websitepostgresql.org...
irc#postgresql

Top users

Tom Lane: 892 posts Bruce Momjian: 760 posts Peter Eisentraut: 729 posts Bruce Momjian: 655 posts Robert Haas: 219 posts Alvaro Herrera: 197 posts Thomas G. Lockhart: 185 posts Vince Vielhaber: 171 posts Thom Brown: 166 posts Joshua D. Drake: 154 posts Josh Berkus: 142 posts Bruce Momjian: 137 posts Magnus Hagander: 119 posts David Fetter: 101 posts Josh Kupershmidt: 95 posts Marc G. Fournier: 87 posts Simon Riggs: 84 posts Kevin Grittner: 63 posts Neil Conway: 56 posts Fujii Masao: 55 posts
show more
Archives