Skip to content
Snippets Groups Projects
  1. Apr 09, 2004
  2. Apr 07, 2004
    • Bruce Momjian's avatar
      Push superuser check farther down in the if() statements to fix startup · 1f12abbc
      Bruce Momjian authored
      crash with debug in log_statement patch.
      1f12abbc
    • Tom Lane's avatar
      Still another place to make the world safe for zero-column tables. · 0bb21d39
      Tom Lane authored
      Per example from Jiang Wei.
      0bb21d39
    • Bruce Momjian's avatar
    • Bruce Momjian's avatar
      Update darwin OS version. · 9b3bc35f
      Bruce Momjian authored
      9b3bc35f
    • Tom Lane's avatar
      Extend set-operation planning to keep track of the sort ordering induced · 989067bd
      Tom Lane authored
      by the set operation, so that redundant sorts at higher levels can be
      avoided.  This was foreseen a good while back, but not done.  Per request
      from Karel Zak.
      989067bd
    • Tom Lane's avatar
      build_subquery_pathkeys() was examining wrong copy of subquery target list, · 5d1af6ae
      Tom Lane authored
      causing it to fail to recognize the output ordering of subqueries that
      contain set operations (UNION/INTERSECT/EXPECT).  Per example from Karel Zak.
      5d1af6ae
    • Bruce Momjian's avatar
      Update Darwin as thread-safe. · b4832531
      Bruce Momjian authored
      b4832531
    • Bruce Momjian's avatar
      > >>1. change the type of "log_statement" option from boolean to string, · 6a25c6e1
      Bruce Momjian authored
      > >>with allowed values of "all, mod, ddl, none" with default "none".
      
      OK, here is a patch that implements #1.  Here is sample output:
      
              test=> set client_min_messages = 'log';
              SET
              test=> set log_statement = 'mod';
              SET
              test=> select 1;
               ?column?
              ----------
                      1
              (1 row)
      
              test=> update test set x=1;
              LOG:  statement: update test set x=1;
              ERROR:  relation "test" does not exist
              test=> update test set x=1;
              LOG:  statement: update test set x=1;
              ERROR:  relation "test" does not exist
              test=> copy test from '/tmp/x';
              LOG:  statement: copy test from '/tmp/x';
              ERROR:  relation "test" does not exist
              test=> copy test to  '/tmp/x';
              ERROR:  relation "test" does not exist
              test=> prepare xx as select 1;
              PREPARE
              test=> prepare xx as update x set y=1;
              LOG:  statement: prepare xx as update x set y=1;
              ERROR:  relation "x" does not exist
              test=> explain analyze select 1;;
                                                   QUERY PLAN
              ------------------------------------------------------------------------------------
               Result  (cost=0.00..0.01 rows=1 width=0) (actual time=0.006..0.007 rows=1 loops=1)
               Total runtime: 0.046 ms
              (2 rows)
      
              test=> explain analyze update test set x=1;
              LOG:  statement: explain analyze update test set x=1;
              ERROR:  relation "test" does not exist
              test=> explain update test set x=1;
              ERROR:  relation "test" does not exist
      
      It checks PREPARE and EXECUTE ANALYZE too.  The log_statement values are
      'none', 'mod', 'ddl', and 'all'.  For 'all', it prints before the query
      is parsed, and for ddl/mod, it does it right after parsing using the
      node tag (or command tag for CREATE/ALTER/DROP), so any non-parse errors
      will print after the log line.
      6a25c6e1
  3. Apr 06, 2004
  4. Apr 05, 2004
  5. Apr 04, 2004
  6. Apr 03, 2004
  7. Apr 02, 2004
  8. Apr 01, 2004
Loading