Re: [GENERAL] Import Schema converting tinyint to Boolean?

2016-01-21 Thread Félix GERZAGUET
On Thu, Jan 21, 2016 at 9:52 AM, Guyren Howe wrote: > I'm converting a MySQL database to a Postgres database by doing a bunch of > CREATE TABLE… AS SELECT * FROM, but the tinyints are coming across as > tinyints. > > Seems like there ought to be an option somewhere to have them behave like > Bool

Re: [GENERAL] Regex help again (sorry, I am bad at these)

2015-12-28 Thread Félix GERZAGUET
Hello Chris, On Mon, Dec 28, 2015 at 8:10 PM, Christopher Molnar < cmol...@ourworldservices.com> wrote: > Any suggestions? > This seems to works: select regexp_replace('Complete the attached lab and submit via dropbox\rhttps://owncloud.porterchester.edu/HVACR/PCI_GasHeat/GasElectrical/HVACR1114_

Re: [GENERAL] Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable)

2015-12-21 Thread Félix GERZAGUET
On Mon, Dec 21, 2015 at 12:31 AM, Jim Nasby wrote: > On 12/20/15 1:09 PM, Félix GERZAGUET wrote: > >> After reading >> http://www.postgresql.org/docs/current/static/wal-reliability.html, I >> tried the recommended diskchecker.pl >> <http://brad.livejourn

[GENERAL] Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable)

2015-12-20 Thread Félix GERZAGUET
Hello, I am trying to assess disk reliability. After reading http://www.postgresql.org/docs/current/static/wal-reliability.html, I tried the recommended diskchecker.pl but I am not satisfied: I always get: Total errors: 0 even if I tested with with a HG