Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 101704
Status: open
Priority: 0/
Queue: SQL-Translator
People
Owner: Nobody in particular
Requestors: rrwo [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 0.11020

History Show all quoted text
  Fri Jan 23 06:54:18 2015 rrwo [...] cpan.org - Ticket created
Subject: Postgres alter table for column types is wrong
ALTER TABLE mytable ALTER COLUMN mycol TYPE integer; should be ALTER TABLE mytable ALTER COLUMN mycol TYPE integer USING (my_col::integer); when changing a text field back to an integer. See https://github.com/frioux/DBIx-Class-DeploymentHandler/issues/32
  Thu Jun 25 07:30:57 2015 ribasushi [...] leporine.io - Correspondence added
On Fri Jan 23 12:54:18 2015, RRWO wrote: Show quoted text
> ALTER TABLE mytable ALTER COLUMN mycol TYPE integer; > > should be > > ALTER TABLE mytable ALTER COLUMN mycol TYPE integer USING (my_col::integer); > > when changing a text field back to an integer. > > See https://github.com/frioux/DBIx-Class-DeploymentHandler/issues/32
Can you translate this into an actual sqlt test? It is not clear to me how to trigger this condition...
  Thu Jun 25 07:30:57 2015 The RT System itself - Status changed from 'new' to 'open'