pg_shard icon indicating copy to clipboard operation
pg_shard copied to clipboard

Make zero-shard SELECT consistent with CitusDB

Open jasonmp85 opened this issue 10 years ago • 0 comments

Making a query against a table that has been marked as "distributed" (either by CREATE TABLE ... DISTRIBUTE BY ... or using master_create_distributed_table) which does not yet have any shards (created using either \stage or master_create_worker_shards) results in different behavior depending upon whether the active planner is CitusDB's or pg_shard's:

  • Under CitusDB, the query returns zero rows
  • pg_shard raises an error directing the user to call master_create_worker_shards

The latter is obviously helpful under pg_shard (especially for users who have missed this step), but is confusing under CitusDB. Now that integration is tighter, we need to figure out what the best approach is.

jasonmp85 avatar Aug 13 '15 21:08 jasonmp85