Re: [DOCS] Use of term Master/Slave

2017-08-01 Thread Mike Toews
On 1 August 2017 at 09:13, wrote: > Wondering why PostgreSQL still uses the terms master and slave when there > are other terms like primary/secondary that can be used in the same manner. Another alternative I've seen in different fields is "manager" and "agent". -- Sent via pgsql-docs mailin

Re: [DOCS] Reg Date/Time function

2017-08-01 Thread Mike Toews
On 1 August 2017 at 12:30, wrote: > Hi, > I am going through PostgreSQL, for the first day. And it was great till > now. > One quick question/doubt regarding the function > "justify_days(interval)" > > select justify_days(interval '365 days'); > > this statement returns 1 year 5 days, whereas I

[DOCS] Online docs links for 10.0 vs 10

2017-05-18 Thread Mike Toews
I think the documentation links for version 10 need attention. The series of documentation text and links for the current releases are 9.5, 9.6: ... https://www.postgresql.org/docs/9.5/static/ https://www.postgresql.org/docs/9.6/static/ so I would have expected the new batch of releases[1] to sim

Re: [DOCS] ST_AsLatLonText bug

2017-01-17 Thread Mike Toews
On 18 January 2017 at 09:57, wrote: > select > (ST_AsLatLonText('POINT ('||(-76.6)||' '||(35.1)||')', 'DD°MM''SS.SSS&C')) > dms > > returns unexpected 60 seconds > 35° 6'0.000&N 76°35'60.000&W This is not a PostgreSQL bug. PostGIS bugs go to https://trac.osgeo.org/postgis See https://trac.osgeo

[DOCS] pg_dump -t '"Table"' for cmd.exe

2012-11-12 Thread Mike Toews
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 last as success: Intuitive (supplying "My Table" like "My Database"), but not correct: C:\>"C:\Progra

[DOCS] Latest release date formatting on http://www.postgresql.org/

2010-10-05 Thread Mike Toews
See "latest releases" in the upper-left corner on http://www.postgresql.org/ 9.0.1 · 2010-10-04 · Notes 8.4.5 · 2010-10-04 · Notes 8.3.12 · 2010-10-04 · Notes 8.2.18 · 2010-04-10 · Notes 8.1.22 · 2010-04-10 · Notes The dates should follow a consistent Y-M-D formatting: 9.0.1 · 2010-10-04 · Notes

[DOCS] Rename install-win32?

2010-09-22 Thread Mike Toews
Hi, While files are being renamed in the main repo, is it possible to rename install-win32.sgml ? "win32" implies a 32-bit windows architecture, which is dated and misleading. Could I suggest: git mv doc/src/sgml/install-win32.sgml doc/src/sgml/install-windows.sgml and fix chapter_id references

Re: [DOCS] INTEGER range ("-2147483648" is not accepted.)

2010-06-23 Thread Mike Toews
On 22 June 2010 18:49, Tom Lane wrote: > Thom Brown writes: >> Is that the right behaviour though?  Shouldn't the signed value reach >> the cast step rather than the absolute value?  Or maybe Postgres could >> implicitly accept -12345::integer to be (-12345)::integer.  Is there a >> blocking reas

Re: [DOCS] Improve pg_restore docs

2009-06-29 Thread Mike Toews
Greg Smith wrote: The standard way to submit patches here is to attach a file with a full context diff (diff -c) to the message, rather than putting it inline or including just the changes. The idea is to make it easy for the committers to grab your patch and apply it. Part of my hesitation

[DOCS] Improve pg_restore docs

2009-06-29 Thread Mike Toews
Hi, From a quick discussion on hackers (http://archives.postgresql.org/pgsql-hackers/2009-06/msg01434.php), it appears the documentation can improve for pg_restore. I've prepared some quick diff output from pgsql/doc/src/sgml/ref/pg_restore.sgml for some changes that I think would help. Not