On Thu, 2009-01-29 at 13:16 +0000, Gregory Stark wrote: > So, what do people say? Is Postgres perfect in your world or does it > do some > things which rub you the wrong way? For me: Lack of column-level privileges. It just doesn't help scalability at all. You end up having different tables each with different permissions, or having to create a view with a ruleset attached, having to update the view for each definition change in the view. Lack of allowing subqueries in CHECK constraints and lack of allowing references to other columns in DEFAULT clauses (like columns that default to a calculated formula, but may be overridden if it violates a constraint) Now, last time I checked, Postgresql lacked an SQL extension to create crosstab queries. Even though contrib have some helper functions, they are not official and work only if the number of columns is actually predefined. For instance if you want to create a query to produce different paths to go through a graph, being represented by 1 arc per record, you will never be able to predict the final number of columns (path steps) needed for the crosstab without doing the whole query one extra time to get the max(step). Of course, there are things that PostgreSQL does great, like the user-defined types. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
