Commit Graph

  • 93d4a6ead0 Restrict SECURITY DEFINER to overview registration Javier Goizueta 2016-01-28 17:04:06 +01:00
  • 66387c2d44 Make CDB_CreateOverviews a SECURITY DEFINER function Javier Goizueta 2016-01-28 16:32:40 +01:00
  • 26c95347cd Merge branch 'master' into overviews Javier Goizueta 2016-01-27 16:56:15 +01:00
  • 6a5e4b0460 Fix overviews tests Javier Goizueta 2016-01-27 16:54:30 +01:00
  • b8d50204dd Avoid aggregation which causes out-of-memory crashes in PostgreSQL Javier Goizueta 2016-01-27 15:24:04 +01:00
  • 845ac6dc9a Release 0.12.0 0.12.0 Alejandro Martínez 2016-01-27 14:25:07 +01:00
  • 350f101c3d Merge pull request #190 from CartoDB/remove_schema_triggers Alejandro Martínez 2016-01-27 14:19:21 +01:00
  • 474de01757 Change the overview table naming scheme Javier Goizueta 2016-01-26 13:20:28 +01:00
  • 1ebaeb76ac Overload CDB_Overviews to accept either a single table or an array Javier Goizueta 2016-01-26 10:39:26 +01:00
  • eb1222729d Remove ddl triggers specs Alejandro Martínez 2016-01-21 11:46:39 +01:00
  • 7033a8d9ac Fixes for table names that require quotes or which include a schema name Javier Goizueta 2016-01-13 18:49:27 +01:00
  • 46bc774d38 Fix CDB_Overviews for the case that the table name requires quoting Javier Goizueta 2016-01-13 18:24:06 +01:00
  • a9e2d19918 Document CDB_DropOverviews Javier Goizueta 2016-01-12 16:20:11 +01:00
  • d352e1c463 Update Overviews tests Javier Goizueta 2016-01-12 15:36:07 +01:00
  • 5b47c51221 Add function to drop overviews Javier Goizueta 2016-01-12 15:35:50 +01:00
  • ebaded0c7a Merge branch 'master' into overviews Javier Goizueta 2016-01-12 13:34:26 +01:00
  • ccdf8de59e Enhance documentation, update comments Javier Goizueta 2016-01-12 12:08:41 +01:00
  • a2f6cb4c04 Fix documentation Javier Goizueta 2016-01-12 11:59:57 +01:00
  • 02f386be33 Regard the GridCluster reduction strategy as private Javier Goizueta 2016-01-12 11:59:42 +01:00
  • a7c70fe497 Fix: CDB_ZoomFromScale deviation for lowest zoom levels Javier Goizueta 2016-01-12 11:46:47 +01:00
  • 0a066e0126 Change the default overview reduction strategy to GridCluster Javier Goizueta 2016-01-11 15:35:04 +01:00
  • 913640e2dc Preserve the column ordering of the base table in overviews Javier Goizueta 2016-01-11 15:34:10 +01:00
  • ef7e613d41 Change CDB_ColumnNames to order columns names as in table Javier Goizueta 2016-01-11 15:28:27 +01:00
  • fd7a8cff71 Change regular expression for consistency Javier Goizueta 2016-01-11 15:27:05 +01:00
  • 6ea63af974 Add function to obtain existing overviews of a table Javier Goizueta 2016-01-11 14:50:10 +01:00
  • 496f079b1c Copy dataset privileges to overview tables Javier Goizueta 2016-01-04 18:06:56 +01:00
  • 4580c9cd5c Change the cartodb_ids of aggregated overviews Javier Goizueta 2016-01-04 10:33:39 +01:00
  • 08828b8b7d Set owner of overlays to the owner of the base table Javier Goizueta 2015-12-29 15:22:12 +01:00
  • cecba655eb Preserve aggregated attributes of singleton groups Javier Goizueta 2015-12-29 14:56:47 +01:00
  • b34a752172 Generate overviews for all Z levels Javier Goizueta 2015-12-29 14:56:04 +01:00
  • 8ba9e74c4a Order columns of aggregated overlays as in the base table Javier Goizueta 2015-12-29 13:38:07 +01:00
  • 045ede6908 Remove schema_triggers from travis.yml Alejandro Martínez 2015-12-29 10:43:37 +01:00
  • cd5c8f2904 Remove outdated references to schema triggers and change triggers Alejandro Martínez 2015-12-29 10:42:54 +01:00
  • 172ca45ea5 Merge remote-tracking branch 'origin/master' into remove_schema_triggers Alejandro Martínez 2015-12-29 10:41:13 +01:00
  • 6a6a5bc96a Fix Sampling reduction to avoid RandomTids problems Javier Goizueta 2015-12-28 19:41:14 +01:00
  • 2ff686de27 Clean up: remove spurious comment Javier Goizueta 2015-12-28 19:30:20 +01:00
  • 07326626b7 More efficient sampling strategy Javier Goizueta 2015-12-28 19:28:20 +01:00
  • 4afc427008 Rename Ref. Z strategy function Javier Goizueta 2015-12-28 17:47:57 +01:00
  • 2ab059460b Merge pull request #189 from pnorman/fix_travis Paul Norman 2015-12-23 10:56:56 -08:00
  • 2a2a7d534a Merge remote-tracking branch 'origin/master' into remove_schema_triggers Alejandro Martínez 2015-12-23 17:09:41 +01:00
  • 8d1bbc63fa Add overview tests Javier Goizueta 2015-12-23 16:33:34 +01:00
  • 06ca4f74ee Enable Overviews module in the extension Javier Goizueta 2015-12-23 16:32:44 +01:00
  • a8a2c04d71 Remove invalid comment Javier Goizueta 2015-12-23 14:20:57 +01:00
  • a5bca7d715 Add function for post-processing new overview tables Javier Goizueta 2015-12-23 14:17:50 +01:00
  • 552206464e Make strategy function public Javier Goizueta 2015-12-23 12:50:04 +01:00
  • 2af0b9a57f Add function comments Javier Goizueta 2015-12-23 12:42:40 +01:00
  • 1b5de84c9a Add missing attribute-aggregationto the point reduction strategy Javier Goizueta 2015-12-23 12:17:37 +01:00
  • 3b48acf60c Round extent outputs in test Paul Norman 2015-12-22 16:22:03 -08:00
  • efb319074a Add constraint to QueryTablesTest Paul Norman 2015-12-22 16:21:49 -08:00
  • c36a5d35c3 Merge branch 'overviews' of github.com:CartoDB/cartodb-postgresql into overviews Javier Goizueta 2015-12-22 18:02:16 +01:00
  • 5a78ee2896 Optimize the gridded clustering strategy Javier Goizueta 2015-12-22 17:59:49 +01:00
  • 480e2d0979 Merge pull request #187 from CartoDB/overviews-rtorre Rafa de la Torre 2015-12-22 17:45:14 +01:00
  • c8a1ef6f68 Slight optimization of gridded clustering Javier Goizueta 2015-12-22 15:25:21 +01:00
  • ea7c16fbaf Convert some simple functions from plpgsql to sql Paul Norman 2015-12-21 23:59:26 -08:00
  • 564ab75d2d Use _cdb_estimated_extent instead of ST_Extent Rafa de la Torre 2015-12-21 18:34:26 +01:00
  • 5010109c7d Add _cdb_estimated_extent to get the extent from stats Rafa de la Torre 2015-12-21 17:41:28 +01:00
  • a9f6e26fed Merge pull request #184 from pnorman/readme_url Paul Norman 2015-12-21 08:35:01 -08:00
  • e60f73a31b A bit of internal documentation Rafa de la Torre 2015-12-21 13:16:57 +01:00
  • 415a09392f Gridded clustering aggregation strategy for overviews Javier Goizueta 2015-12-16 17:45:36 +01:00
  • e5cc9ef0bd Fix: typo Javier Goizueta 2015-12-16 17:26:17 +01:00
  • f7857945c1 Change feature density computation algorithm Javier Goizueta 2015-12-16 16:39:38 +01:00
  • 554464e43e Use tile-recursive computation of feature density Javier Goizueta 2015-12-16 12:14:37 +01:00
  • d7c8f3d7e8 Fix: overlay generation was not using the proper scale Javier Goizueta 2015-12-15 19:13:39 +01:00
  • 4c85d7f3ad Compute the reference Z level for a table Javier Goizueta 2015-12-15 19:12:48 +01:00
  • d0e66910a0 Sketch for new Overview-creation functionality Javier Goizueta 2015-12-15 17:36:27 +01:00
  • dcf0b684e2 Update wiki URL Paul Norman 2015-12-08 10:08:17 -08:00
  • 0ecbbd8e71 Make sure that empty arrays or arrays with all the same entry return 0 for Skewness and Kurtosis rather than throwing a division by zero error Stuart Lynn 2015-12-04 14:54:15 -05:00
  • a88bfc51a3 Upgrade version to 0.11.5 0.11.5 Javier Goizueta 2015-11-27 17:03:51 +01:00
  • 21d5ee5813 Merge pull request #178 from CartoDB/disable-log-invalidation-time Javier Goizueta 2015-11-27 15:03:46 +01:00
  • 9a58c03ac0 Upgrade version to 0.11.4 0.11.4 Javier Goizueta 2015-11-24 17:00:45 +01:00
  • 53acee4ddb Merge pull request #180 from CartoDB/174_cartodbfy Rafa de la Torre 2015-11-24 16:38:13 +01:00
  • 68099e780c Merge remote-tracking branch 'origin' into 174_cartodbfy Javier Goizueta 2015-11-24 16:29:32 +01:00
  • 9dba6fa7c4 Merge pull request #175 from CartoDB/155-fix-wrong-delimiters Rafa de la Torre 2015-11-24 15:58:54 +01:00
  • bf711d5c9b Merge pull request #171 from CartoDB/great_circle_generator Rafa de la Torre 2015-11-24 15:54:47 +01:00
  • f14fc057e2 Add optional parameter for max. great circle segment length Javier Goizueta 2015-11-23 17:13:17 +01:00
  • aa81c6a1ab Add comment to CDB_GreatCircle Javier Goizueta 2015-11-23 17:07:24 +01:00
  • 1b8ced22a5 Fix name of expected results file Javier Goizueta 2015-11-23 16:57:34 +01:00
  • 2d13903d50 Cleanup coding style Javier Goizueta 2015-11-23 16:51:34 +01:00
  • 3bc92d4046 Fix CDB_GreatCircle syntax Javier Goizueta 2015-11-23 16:40:42 +01:00
  • a684c37f6d Merge pull request #151 from CartoDB/cartobdfy-requirements-doc Carla 2015-11-23 15:51:09 +01:00
  • bcfe8d8f3b Adds not null constraint for cartodb_id Carla Iriberri 2015-11-20 17:24:01 +01:00
  • 333a408199 Add Paul and Rafa feedback Carla Iriberri 2015-11-20 17:15:37 +01:00
  • 83ac8f4502 Fix: Allow dots in column names to be cartodbfied Javier Goizueta 2015-11-20 13:05:15 +01:00
  • a0ca2288f4 Fix: Cartodbfication failed with existing PK Javier Goizueta 2015-11-20 12:56:52 +01:00
  • ea9503bd32 Allow dots in column names to be cartodbfied Javier Goizueta 2015-11-20 12:24:46 +01:00
  • d597f0fe6d removing comments Stuart Lynn 2015-11-18 15:56:31 +00:00
  • f43d1cc3c4 Merge branch 'master' into great_circle_generator Stuart Lynn 2015-11-18 15:36:51 +00:00
  • f36f1ab536 formatting Stuart Lynn 2015-11-18 15:30:16 +00:00
  • d39a032024 Revert "Write invalidation duration in postgresql log" Luis Bosque 2015-11-17 13:10:19 +01:00
  • 4cceb2a21f Revert "Optimize invalidation time logging" Luis Bosque 2015-11-17 13:10:15 +01:00
  • 4803abf365 Fix typo in expected 155 Guido Fioravantti 2015-11-06 16:32:56 +01:00
  • cce63f0eae Adds ::integer cast for USING 155 Guido Fioravantti 2015-11-06 16:26:03 +01:00
  • 7cf0d02935 Fixes expected 155 Guido Fioravantti 2015-11-06 15:11:08 +01:00
  • 545196811f Changes logger level to error 155 Guido Fioravantti 2015-11-06 14:41:12 +01:00
  • 6252907de2 Rises verbosity level before tests for _CDB_create_cartodb_id_column 155 Guido Fioravantti 2015-11-05 17:11:27 +01:00
  • 2a8d467949 Merge remote-tracking branch 'origin/master' into remove_schema_triggers Alejandro Martínez 2015-11-05 14:49:46 +01:00
  • 8895d9f3af Remove DDL from Makefile Alejandro Martínez 2015-11-04 17:26:38 +01:00
  • ef376fd243 Remove schema_triggers Alejandro Martínez 2015-11-04 17:06:54 +01:00
  • 081ed36aae Fixes NULL max in rec 155 Guido Fioravantti 2015-11-02 11:47:14 +01:00
  • 453b3af872 Removes extra d in delimiter 155 Guido Fioravantti 2015-10-30 17:49:27 +01:00