ruby on rails - Heroku Postgresql SET datestyle To european -

-

i addressing issue cannot copy data postgresql in rails because date format not in matching default postgresql iso mdy.

on local machine changed datestyle european dmy data matches correctly.

as usual, not easy on heroku production server. using steps below try change datestyle, works, doesn't persist (as shown exiting, going in , asking postgres show me datestyle).

any ideas how can persist this. research has show not , change code convert data mdy pulling millions of rows legacy system defaults dmy , using postgresql copy command fastest way possible. seems easier tell postgresql change datestyle fix else :/

$ heroku pg:psql     app-name::crimson=> set datestyle 'european'; set app-name::crimson=> show datestyle;  datestyle  -----------  iso, dmy (1 row)  app-name::crimson-> \q $ heroku pg:psql ---> connecting heroku_postgresql_crimson_url (database_url) psql (9.4.1, server 9.3.6) ssl connection (protocol: tlsv1.2, cipher: jibberish, bits: 256, compression: off) type "help" help.  app-name::crimson=> show datestyle;  datestyle  -----------  iso, mdy (1 row)

any ideas how can persist this.

datestyle server setting (in postgresql.conf) client sessions can override (with set datestyle ...) single transaction or single session. there 2 ways persist change beyond single session.

  • change setting in postgresql.conf , restart server. (won't work on heroku. surely don't have privileges edit postgresql.conf, right?)
  • alter database your_database_name set datestyle 'iso, european'; (should work on heroku. i'd set stand-alone migration.)

fwiw, default isn't iso mdy, it's iso, mdy. (two values, separated comma.) first "output format specification"; second "input/output specification year/month/day ordering". (see client connection defaults)


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

[C++][SFML 2.2] Strange Performance Issues - Moving Mouse Lowers CPU Usage -

-
i've been working on making 2d map editor past 2 weeks or so, , i've run strange problem. trying optimize code, example, making functions should've been functions begin with, did made cpu usage go through roof. i've tried commenting out different sections of code thought culprits (scrolling, rendering, other calculations) no avail. think issue might trying call things within different functions, sake of making modular possible, i'd functionality. the other major change i've made since file i'm comparing i've ported variables external cpp file, since having variables global makes lot easier use within different functions. simple issue, can't life of me understand why happens. with original code, around 2-3% cpu usage. new code, around 20-35%, but, if move mouse around, it'll drop around 6-8%. tl;dr: after trying optimize code using functions, i've somehow killed performance, , found strange quirk moving mouse reduces cpu usage.. /...
Read more

ios - Possible to get UIButton sizeThatFits to work? -

-
i have been using method of resizing uibuttons depreciated, , not robust. , other reasons, want sizethatfits work uibuttons. i've read online, i'm not sure if should work (seems working some, not others, difference maybe between style, i'm using custom). here simple test code recreate issue (i put in viewdidload test, shouldn't matter, , real code part of large project): uibutton *btn = [uibutton buttonwithtype:uibuttontypecustom]; [btn settitle:@"this test long title need word wrap more single line when displayed on tiny ipod in portrait view." forstate:uicontrolstatenormal]; btn.titlelabel.linebreakmode = uilinebreakmodewordwrap; // depreciated - nothing replace it? cgrect r = btn.frame; r.origin.x = 0; r.origin.y = 0; r.size.width = 320; r.size.height = [btn.titlelabel.text sizewithfont:btn.titlelabel.font constrainedtosize:cgsizemake(r.size.width,100000) linebreakmode:btn.titlelabel.linebreakmode].height; // returns approx 86 , changes correctly ...
Read more