[DOCS] Skype Link broken
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/static/sql-comment.html Description: On https://www.postgresql.org/about/quotesarchive/ there is a link to a Whitepaper of Skype, that link is broken. It is in this quote and the other quote of Skype: Skype has been using PostgreSQL as the main DB for most of our business needs right from the start. Hannu Krosing, Skype [ Cheers Bernd -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
[DOCS] Admin catalog setup
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.2/static/adminpack.html Description: This is the script shown on the website: int8 pg_catalog.pg_file_write(fname text, data text, append bool) bool pg_catalog.pg_file_rename(oldname text, newname text, archivename text) bool pg_catalog.pg_file_rename(oldname text, newname text) bool pg_catalog.pg_file_unlink(fname text) setof record pg_catalog.pg_logdir_ls() /* Renaming of existing backend functions for pgAdmin compatibility */ int8 pg_catalog.pg_file_read(fname text, data text, append bool) bigint pg_catalog.pg_file_length(text) int4 pg_catalog.pg_logfile_rotate() It states that it should be run as a superuser. I am new to postgresql. I ran these step because I will be using pgadmin3. I ran the scripts in psql as myself who is a superuser. I got nothing back from these commands. How can I check if it ran correctly? Thank you, -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Skype Link broken
I am forwarding this to the www email list that deals with website changes: --- On Wed, Aug 10, 2016 at 05:10:15AM +, supp...@korthaus.de wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.5/static/sql-comment.html > Description: > > On > https://www.postgresql.org/about/quotesarchive/ > > there is a link to a Whitepaper of Skype, that link is broken. It is in this > quote and the other quote of Skype: > > Skype has been using PostgreSQL as the main DB for most of our business > needs right from the start. > Hannu Krosing, Skype > [ > Cheers > Bernd > > -- > Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-docs -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription + -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Admin catalog setup
ken.z...@tmctechnologies.com writes: > Page: https://www.postgresql.org/docs/9.2/static/adminpack.html > Description: > This is the script shown on the website: > int8 pg_catalog.pg_file_write(fname text, data text, append bool) > bool pg_catalog.pg_file_rename(oldname text, newname text, archivename text) > bool pg_catalog.pg_file_rename(oldname text, newname text) > bool pg_catalog.pg_file_unlink(fname text) > setof record pg_catalog.pg_logdir_ls() > /* Renaming of existing backend functions for pgAdmin compatibility */ > int8 pg_catalog.pg_file_read(fname text, data text, append bool) > bigint pg_catalog.pg_file_length(text) > int4 pg_catalog.pg_logfile_rotate() My goodness, that's an embarrassingly bad excuse for actual documentation, isn't it. I'm surprised this has been there so long and no one's tried to improve it. Maybe I will. > It states that it should be run as a superuser. I am new to postgresql. I > ran these step because I will be using pgadmin3. I ran the scripts in psql > as myself who is a superuser. I got nothing back from these commands. How > can I check if it ran correctly? It didn't, because those are just function prototypes not SQL commands. (If you'd added a semicolon at the end, you'd have gotten a syntax error, but if you didn't then psql is probably still waiting for you to complete the command.) What you are supposed to do to install adminpack, these days, is say "CREATE EXTENSION adminpack;". FWIW, though I'm not at all familiar with pgAdmin, I'd have guessed that it could/would do this for you. regards, tom lane -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
