Valeriia Bolotova Lurunchik
akostylev0
/ gist:11260435
Created
April 24, 2014 16:18
— forked from Lurunchik/gist:11256656
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --partitioning like http://www.postgresql.org/docs/9.3/static/ddl-partitioning.html | |
| --create master table | |
| CREATE TABLE master_table | |
| ( | |
| id serial, | |
| key character varying NOT NULL, | |
| value character varying NOT NULL, | |
| CONSTRAINT master_table_pkey PRIMARY KEY (id) | |
| ); | |
| --create slave tables with constraint |
Lurunchik
/ gist:11256656
Last active
August 29, 2015 14:00
PostgreSQL: Partition with returning <column> solved "0 rows problem"
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --partitioning like http://www.postgresql.org/docs/9.3/static/ddl-partitioning.html | |
| --create master table | |
| CREATE TABLE master_table | |
| ( | |
| id serial, | |
| key character varying NOT NULL, | |
| value character varying NOT NULL, | |
| CONSTRAINT master_table_pkey PRIMARY KEY (id) | |
| ); | |
| --create slave tables with constraint |