Re: Convert Existing Table to a Partition Table in PG10

2018-07-01 Thread Francisco Olarte
On Sun, Jul 1, 2018 at 12:15 AM, Clifford Snow wrote: . > I also leaned that my range partition value I used on a timestamp needed to > have fractional seconds. I used a range of 2017-01-01 00:00:00 to > 2017-23:59:59 which failed when I attempted to add a record that had a > timestamp of 2017

Re: Convert Existing Table to a Partition Table in PG10

2018-07-01 Thread David Rowley
On 1 July 2018 at 10:15, Clifford Snow wrote: > I also leaned that my range partition value I used on a timestamp needed to > have fractional seconds. I used a range of 2017-01-01 00:00:00 to > 2017-23:59:59 which failed when I attempted to add a record that had a > timestamp of 2017-23:59:59. Add

Re: Convert Existing Table to a Partition Table in PG10

2018-07-01 Thread Clifford Snow
David, Thanks for the suggestion. That really simplifies creating the RANGE. For all, I'm pretty much a postgresql novice, but I've tried to document what I've learned in the hopes that it can help someone else. You can read my blog post at https://osm_seattle.snowandsnow.us/articles/Partitioning

Re: Convert Existing Table to a Partition Table in PG10

2018-07-01 Thread Vik Fearing
On 02/07/18 01:43, Clifford Snow wrote: > David, > Thanks for the suggestion. That really simplifies creating the RANGE.  > > For all, I'm pretty much a postgresql novice, but I've tried to document > what I've learned in the hopes that it can help someone else. > > You can read my blog post > at

Re: Convert Existing Table to a Partition Table in PG10

2018-07-01 Thread Clifford Snow
Vic, I'd be happy to add my blog to planet.postgresql.org but my of my articles are not on postgresql. I'm using github pages for my blog and I do have tags for each article. Is there someone to filter on those tags? Clifford On Sun, Jul 1, 2018 at 5:13 PM Vik Fearing wrote: > On 02/07/18 01:43

Re: Call for Papers - PGConf.ASIA 2018

2018-07-01 Thread Tatsuo Ishii
Hi PostgreSQL lovers, The call for papers for PGConf.ASIA 2018 will be closed on 31st July, 2018 (Japan time). I am looking forward to receiving your great proposals! -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp > Hi, > > PGc