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



Subject: Postgres alter table for column types is wrong
Download (untitled) / with headers
text/plain 259b
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
Download (untitled) / with headers
text/plain 423b
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...


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.