- Fixed issue with indices when renaming tables #123
- Modify sampling of quota trigger #126
- Fix for
the_geom
column present but not SRID (EWKT) and other corner cases #121
- Fix for transformation to webmercator in corner cases #116
- Re-implementation of
CDB_CartodbfyTable
functions- The signature of the main function changes to
FUNCTION CDB_CartodbfyTable(destschema TEXT, reloid REGCLASS) RETURNS REGCLASS
- The
destschema
does not need to match the origin schema ofreloid
- It returns the
regclass
of the cartodbfy'ed table, if it needs to be rewritten.
- The
- There are many optimizations
- The columns
created_at
andupdated_at
will no longer be added
- The signature of the main function changes to
- Fix for CDB_UserDataSize failing due
ERROR: relation "*" does not exist.
#110 - Review test to validate permissions in public tables #112
- Fixes CDB_UserDataSize failing due
ERROR: relation "*" does not exist.
#108
- Fix for CDB_UserTables returning wrong listings when publicuser is used
- Fix for #95 cdb_usertables should return public tables when the user is publicuser
- Adds new function CDB_QueryTablesText that can deal with "schema.table_name" longer than 63 chars.
- Adds a set of statistical functions:
- CDB_DistType
- CDB_DistinctMeasure
- CDB_EqualIntervalBins
- Fix for CDB_UserTables returns 0 entries for multiuser accounts #64
Dummy transitional version.
- Fix upgrade of CDB_StringToDate function
- Add a test for to validate CDB_TableMetadataTouch usage with OID
- Fix conversion of strings to datetime
- Revert quota checks to
pg_total_relation_size
- Adds CDB_ZoomFromScale function
- Select permission in CDB_TableMetadata no longer granted to public
- New function to upsert the updated_at in CDB_TableMetadata for a regclass
- Fixed security problem related with system tables
- Changed quota checks to use
pg_relation_size
instead ofpg_total_relation_size
- Improvement: make CDB_UserDataSize functions much faster.
- Bugfix: Quota check and some organization permissions functions were not properly escaping table name.
- Support of raster tables for cartodbfication
- Modified quota functions: vector tables stay the same, raster tables count as full size (as have no the_geom + the_geom_webmercator combo) and raster overviews are not counted
- Bugfix for Cartodbfication: Set primary key of the table if not already present (e.g. tables created from SQL API)
Added CDB_Math_Mode function
Changes in versioning: no revision is attached so it no longer uses git describe
for the version.
Dummy release to solve some issues with cdb branch/tag
Inverting priority of CDB_CheckQuota qmax so gies more priority to existing user quota function over parameter value.
Fixes issue with schemas in CDB_QueryTables
- Splitting of CartodbfyTable method in subfunctions to be able to call in fragments and evade timeouts on hot zones
- Make 0.3.0dev version upgradeable
- Dummy version. We start using semantic versioning
- Permission management functions
- Adapt functions to use schemas
Enhancements:
- Do not force re-cartodbfication on CREATE FROM unpackaged
- Drop useless DEFAULT specification in plpgsql variable declarations
- List plpythonu requirement first, to get pg_catalog scanned before public
Bug fixes:
- Do not add unique index on cartodb_id if already a primary key (#38)
Important changes:
- This release adds dependency on "plpythonu" extension
- Roles are not created anymore, previously private functions for table information extraction (CDB_UserTables, CDB_TableIndexes, CDB_ColumnNames, CDB_ColumnType) will now be callable by anyone while only returning information about tables over which the calling user has SELECT privilege (#36)
Bug fixes:
- Fix recursive trigger on create table (#32)
- Ensure cartodb_id uses an associated sequence (#33)
- Fully qualify call to cdb_disable_ddl_hooks from cdb_enable_ddl_hooks
- Fully qualify call to CDB_UserDataSize from quota trigger
- Fully qualify call to CDB_TransformToWebmercator from CDB_CartodbfyTable
- Fix potential infinite loop in CDB_CartodbfyTable
- Fix potential infinite loop in CDB_QueryStatements
Enhancements:
- Include revision info in cdb_version() output (#34)
New features:
- Add a cdb_extension_reload() function
Initial release