how to grant user privilege on specific schema?
Grant Select on all Tables Owned By Specific User
I have a mouse with lots of buttons, but it's not a mainstream make like Logitech. For Windows, I have a driver that lets me assign actions like close-window (Ctrl+W) or next-tab (Ctrl+Tab), but I don't have a Linux driver. Since Linux is so flexible, I thought perhaps there is a general way to do this, regardless of brand?  Update: Based on input from Cyrex, I installed and ran sudo apt-get install btnx which found several but not all mouse buttons. Found: left, right, wheel, wheelclick, thumb fwd, thumb back. Not found: wheel left, wheel right, thumb middle button. Vendor ID is 0x04d9, Model ID is 0xa015.  Update 2: In System>Prefs>Mouse there's a lightbulb icon for testing double-click speed. Every working button can turn the bulb on&amp;off, but the missing buttons can't. It would seem that Ubuntu isn't aware of these buttons and thus doesn't register their clicks. I guess I need to hunt for a driver, though a mainstream mouse is probably the easier way. I was surprised to only recently notice that      An object of any density can be large enough to fall within its own   Schwarzschild radius.   Of course! It turns out that supermassive black holes at galactic centers can have an average density of less than water's.  Somehow I always operated under the assumption that black holes of any size had to be superdense objects by everyday standards.  Compare the Earth to collapsing into a mere 9mm marble retaining the same mass, in order for the escape velocity at the surface to finally reach that of light.  Or Mt. Everest packed into one nanometer.  Reading on about this , it increases proportionally with total mass.  Assuming matter is accumulated at a steady density into a spherical volume, the volume's radius will only "grow" at a cube root of the total volume and be quickly outpaced by its own gravitational radius.  Question: For an object the , what would have to be its diameter for it to qualify as a black hole (from an external point of view)?  Would this not imply by definition that:   The Earth, Solar system and Milky Way are conceivably inside this black hole? Black holes can be nested/be contained within larger ones? Whether something is a black hole or not is actually a matter of perspective/where the observer is, inside or outside? Check ping statistics without stopping Is there a way to tell ping to show its usual termination statistics without stopping the execution?  For instance, I'd like to quickly view:  --- 8.8.8.8 ping statistics --- 2410 packets transmitted, 2274 received, +27 errors, 5% packet loss, time 2412839ms rtt min/avg/max/mdev = 26.103/48.917/639.493/52.093 ms, pipe 3   without having to stop the program, thus losing the accumulated data. find exec '{}' not available after > Exec allows us to either pass all arguments at once with {} + or to pass them one by one with {} \;  Now let's say I want to rename all jpeg, no problem doing this:  find . \( -name '*.jpg' -o -name '*.jpeg' \) -exec mv '{}' '{}'.new \;   But if I need to redirect output, '{}' isn't accessible after redirection.  find . \( -name '*.jpg' -o -name '*.jpeg' \) -exec cjpeg -quality 80 '{}' &gt; optimized_'{}' \;   This wouldn't work. I'd have to use a for loop, storing find's output into a variable before using it. Let's admit it, it's cumbersome.  for f in `find . \( -name '*.jpg' -o -name '*.jpeg' \)`; do cjpeg -quality 80 $f &gt; optimized_$f; done;   So is there a better way? Lower case "k" in Cocoa I know this is a common convention, but what does the "k" in variable names signify? (i.e. kMaxImageViewSize)  I looked in the Apple documentation on Variable names and found no mention of it.  Thanks for answering Graph vertex chromatic number in a union of 2 sub-graphs $G_1$ is graph on the set of vertices $\{1,2,3,4,5,6,7,8\}$, $G_1$ vertex chromatic number is 5. $G_2$ is graph on the set of vertices $\{7,8,9,10,11,12,13,14,15,17,18,19,20\}$, $G_2$ vertex chromatic number is 7. We know $G_1$ and $G_2$ have an edge between vertex 7 and vertex 8. (We already used 2 different colors on them both). $G$ is graph on the set of vertices $\{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20\}$, and its set of edges is the union of the edges set of $G_1$ with the edges set of $G_2$. The vertex chromatic number of $G$ is: 5 / 7 / 12 / we can't know without further information Prove the answer. I think I got it, can someone approve? After the union to $G$, we copy the colors of $G_2$ to 7,8,9,10,11,12,13,14,15,16,17,18,19,20, obviously, $G$ vertex chromatic number is 7 and can't be less. We go through the vertices 1,2,3,4,5,6,7,8. We look for a vertex that doesn't connect to a different vertex. (There must be one, because if only one edge was missing in $G_1$, our chromatic number of $G_1$ was 7, but it's 5). Once we find a missing edge, we color both its vertices in the same color. We go through vertices 1-6, and color each vertex that doesn't have a color, with the colors of $G_2$ that we didn't use in $G_1$ (there should be 4-5 of them). Why does speed of light have to be constant? My question is not about why speed of light has a particular constant value which has been sufficiently addressed in other questions on SE already. I want to know whether the fact that speed of light has to be constant is a consequence of other fundamental laws of Universe, or is it just a fundamental law itself.  My motivation for asking this question is thinking about Special Theory of Relativity. One way of understanding why time dilation and length contraction happen is to look at it from the perspective of constancy of speed of light. Alice who is on the moving source of light and Bob, a fixed observer see the speed of light as constant. In order for Alice to see the speed of light as a constant value, time slows down and length expands (in forward direction) thus keeping the speed constant.   In the  I'm doing, the Professor tells that this constancy of speed of light could be more generally referred to as, "Principle of wave constancy". That is, the speed of any wave is a property of the medium (and thus it remains constant). So, the speed of a wave in water, for example, remains constant even if the source of the waves (say a paddle keeps moving). Frequency and wavelength may change but the speed remains constant. In a similar fashion, light is an electromagnetic wave and thus its speed is constant. And the constant speed is defined by the medium (which happens to be vaccum i.e., no medium for light).   My questions are twofold now -    Is the above reasoning correct to explain why speed of light is constant? (i.e., thinking of it as constancy of any wave in general) Theoretically, could there be other waves that could travel through vaccum at a different speed? If yes, time dilation and length contraction will have to be different.   I'd appreciate it if the answer is kept non-technical (essential math is okay). More importantly, I request you to try and explain without using General Theory of Relativity. Because I'm thinking how the scientific understanding by 1905 had already knew that speed of light has to be constant. I heard that there was a twitter bot which automatically posted questions and asked for answers for specific questions on every site. How do they work? Is there an algorithm for doing this or is it purely random? I know that it doesn't tweet closed questions, but that's it. Is there a word for when an action has an effect opposite to the one intended? Is there a word or phrase to express the concept of an action having the opposite effect of the expected outcome?  For example, a drug taken to cure headaches that actually causes headaches, or an advertising campaign designed to deter smoking that leads to an increase in smoking. Across the Stack Exchange network you may leave comments on a question or answer.  How do comments work? What are comments for, and when shouldn't I comment? Who can post comments? Who can edit comments? How can I format and link in comments? My comment doesn't contain some of the text I typed in it; why? My comment appears to be long enough, but I can't post it because it's too short; why? Who can delete comments? When should comments be deleted? Why can't I comment on specific posts even if I have enough reputation to comment? When can comments be undeleted? What are automatic comments? How can I link to comments? Anything else I should know about comments?  Also see the FAQ articles on  and . About free quarks and confinement Why can't I find any manpages? I'm working on a Power8 server running Ubuntu 16.04.2 LTS:  $ uname -a     Linux power 4.4.0-75-generic #96-Ubuntu SMP Thu Apr 20 09:55:30 UTC 2017 ppc64le ppc64le ppc64le GNU/Linux  $ cat /etc/lsb-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=16.04 DISTRIB_CODENAME=xenial DISTRIB_DESCRIPTION="Ubuntu 16.04.2 LTS"   None of the usual manpages appear to be installed. Even a simple command like:  man man   returns   No manual entry for man See 'man 7 undocumented' for help when manual pages are not available.   This goes for a variety of other tools, like ls, grep, etc. and library functions like usleep, printf, and so on.  I've checked that at least some manpages are actually installed:  $ dpkg -l | grep -i manpages ii  manpages                           4.04-2                                     all          Manual pages about using a GNU/Linux system ii  manpages-dev                       4.04-2                                     all          Manual pages about using GNU/Linux for development ii  manpages-posix                     2013a-1                                    all          Manual pages about using POSIX system ii  manpages-posix-dev                 2013a-1                                    all          Manual pages about using a POSIX system for development   Am I missing something? Is this specific to the ppc64le architecture? Or is there something else I can/should install to access these manpages?  Update: As requested, I ran sudo mandb. The result was:  0 man subdirectories contained newer manual pages. 0 manual pages were added. 0 stray cats were added. 2 old database entries were purged.   There were no changes to man man and other such commands.  Additionally, the output of manpath was:  $ manpath -g /usr/man:/usr/share/man:/usr/local/man:/usr/local/share/man:/usr/X11R6/man:/opt/man $ manpath -c /var/cache/man/oldlocal:/var/cache/man/local:/var/cache/man can't send email to addresses at my own domain Optimal way to ignore duplicate inserts? Background  This problem relates to ignoring duplicate inserts using PostgreSQL 9.2 or greater. The reason I ask is because of this code:    -- Ignores duplicates.   INSERT INTO     db_table (tbl_column_1, tbl_column_2)   VALUES (     SELECT       unnseted_column,       param_association     FROM       unnest( param_array_ids ) AS unnested_column   );   The code is unencumbered by checks for existing values. (In this particular situation, the user does not care about errors from inserting duplicates -- the insertion should "just work".) Adding code in this situation to explicitly test for duplicates imparts complications.  Problem  In PostgreSQL, I have found a few ways to ignore duplicate inserts.  Ignore Duplicates #1  Create a transaction that catches unique constraint violations, taking no action:    BEGIN     INSERT INTO db_table (tbl_column) VALUES (v_tbl_column);   EXCEPTION WHEN unique_violation THEN     -- Ignore duplicate inserts.   END;   Ignore Duplicates #2  Create a rule to ignore duplicates on a given table:  CREATE OR REPLACE RULE db_table_ignore_duplicate_inserts AS     ON INSERT TO db_table    WHERE (EXISTS ( SELECT 1            FROM db_table           WHERE db_table.tbl_column = NEW.tbl_column)) DO INSTEAD NOTHING;   Questions  My questions are mostly academic:   What method is most efficient? What method is most maintainable, and why? What is the standard way to ignore insert duplication errors with PostgreSQL? Is there a technically more efficient way to ignore duplicate inserts; if so, what is it?   Thank you! In the first book, Harry sees his Gringotts vault for the first time.  (Quotes thanks to Slytherincess!)     Griphook unlocked the door. A lot of green smoke came billowing out, and as it cleared, Harry gasped. Inside were mounds of gold coins. Columns of silver. Heaps of little bronze Knuts.      "All yours," smiled Hagrid.      All Harry's -- it was incredible. The Dursleys couldn't have known about this or they'd have had it from him faster than blinking. How often had they complained how much Harry cost them to keep? And all the time there had been a small fortune belonging to him, buried deep under London.      Hagrid helped Harry pile some of it into a bag. "The gold ones are Galleons," he explained. "Seventeen silver Sickles to a Galleon and twenty-nine Knuts to a Sickle, it's easy enough. Right, that should be enough fer a couple o' terms, we'll keep the rest safe for yeh."      Harry Potter and the Sorcerer's Stone - pages 58-59 - US Hardcover Edition   Jk Rowling posts in the Harry Potter Lexicon      JKR has stated in an interview (Comic Relief 2001) that she estimates the value of one Galleon to be "about five pounds," which works out to around US$9.75 (the exchange rate at the time of the interview was US$7.33). In the introduction to both QA and FB, US$250-million is stated to be the equivelent of 34 million Galleons. That also works out to a value of £5 to the Galleon, at the exchange rate of the time. The price listed on the back of the books, however, is not correct, since US$3.99 would equal less than half a British pound, or 8 sickles and 15 knuts. The book instead incorrectly lists US$3.99 as being equal to 14 sickles and 3 knuts. (Unfortunately, CNN.com uses this incorrect value for their Knuts-to-dollars converter.)      This gives us approximate values as follows:      1 bronze Knut = £0.01 (US about 2 cents)      1 silver Sickle = £0.29 (about US$0.57)      1 Galleon = £5.00 (more or less US$9.75)      These rates vary as the exchange rate fluctuates - see the Wizarding World Currency Converter for the current rate.   Now looking at the quote      Hagrid helped Harry pile some of it into a bag.   and     Right, that should be enough fer a couple o' terms, we'll keep the rest safe for yeh.   Obviously "some" is unspecified, but presuming the costs of ...     Typical elementary-school textbooks cost more than $100 each   He would be carrying at least 10 galleons for each school book, and going by the list of books just for his first year,  (Thanks Ibid!)     COURSE BOOKS      All students should have a copy of each of the following:         The Standard Book of Spells (Grade 1) by Miranda Goshawk   A History of Magic by Bathilda Bagshot   Magical Theory by Adalbert Waffling   A Beginners’ Guide to Transfiguration by Emeric Switch   One Thousand Magical Herbs and Fungi by Phyllida Spore   Magical Drafts and Potions by Arsenius Jigger   Fantastic Beasts and Where to Find Them by Newt Scamander   The Dark Forces: A Guide to Self-Protection by Quentin Trimble         (Harry Potter and Philospher's Stone, Chapter 5)   That's 80 Galleons just for books. This does not include the list of other expenses Harry has for his school years (wand, potion reagents, etc.)  How many Galleons is "some" or is Diagon Alley selling supplies for third world prices?  Sidenote, is this just a case of bad JK maths? :  Not ten minutes ago, I received this error, twice:  And also an &quot;Oops, something bad happened&quot; error.  I'm also getting question posting errors.  Can we fix this, please? Short story about dead soldiers bodies being reused Tasks in custom Environment I need to wrap a tasks environment inside a custom \NewEnviron. Apparently, tasks chokes on code besides its \task or \item due to the , presumably causing it to do so on \BODY. Any way to get around this? Exact error given is "Something's wrong--perhaps a missing \item", as per:  \documentclass[a4paper]{book} \usepackage{environ} \usepackage[more]{tasks}  \NewTasks[style=enumerate,counter-format=tsk[1]),label-width=2ex]{mytaskenum}[\item](3) \NewEnviron{mytaskenv}[1][Exercises]{   % Misc. stuff to precede the tasks env here   \begin{mytaskenum}   \BODY   \end{mytaskenum}   % Misc. stuff to follow }{}  \begin{document}  \begin{mytaskenv}   \item item 1   \item item 2   \item item 3 \end{mytaskenv}  \end{document} Isomorphism of centers of isomorphic groups ii) Show that $u$ is not a real part of the function which analytic on $\mathbb{C} \backslash \lbrace 0 \rbrace$ Suppose $u(x,y)=\ln(x^2+y^2)$  i) Show that $u$ is harmonic on $\mathbb{C} \backslash \lbrace 0 \rbrace$  ii) Show that $u$ is not the real part of a function which analytic on  $\mathbb{C} \backslash \lbrace 0 \rbrace$  I manage to show the first part. For the second part, note that $u(x,y)=\ln(x^2+y^2)=\ln(|z|^2)=2 \Re \log(z)$  But this only show that $u$ is not a real part of $\log(z)$. I don know how to show $u$ cannot be the real part of a function which analytic on $\mathbb{C} \backslash \lbrace 0 \rbrace$  Can anyone guide me?