Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

postgres-lambda-diff

  • Clone with SSH
  • Clone with HTTPS
  • user avatar
    Bruce Momjian authored
    changes to the SQL to retrieve attributes for older versions of Postgres is
    probably wise.  Also, please make sure that I have mapped the storage types
    to the correct storage names, as this is relatively poorly documented.
    
    I think that this patch might need to be considered for back-porting to
    7.3.3 since at the moment, people will be losing valuable information after
    upgrades.
    
    Will dump:
    
    CREATE TABLE test (
        a text,
        b text,
        c text,
        d text
    );
    ALTER TABLE ONLY test ALTER COLUMN a SET STATISTICS 55;
    ALTER TABLE ONLY test ALTER COLUMN a SET STORAGE PLAIN;
    ALTER TABLE ONLY test ALTER COLUMN b SET STATISTICS 1000;
    ALTER TABLE ONLY test ALTER COLUMN c SET STORAGE EXTERNAL;
    ALTER TABLE ONLY test ALTER COLUMN d SET STORAGE MAIN;
    
    Christopher Kings-Lynne
    1b3d4cef
    History
    Name Last commit Last update