Stefan Hornburg (Racke)
racke at linuxia.de
Sat Dec 14 09:22:39 UTC 2013
On 12/14/2013 09:22 AM, Jon Jensen wrote:
> On Sat, 14 Dec 2013, Kaare Rasmussen wrote:
>> I just tried to create an ic6 database as part of my table editor review. One thing that I noticed was that all tables are dropped unconditionally, producing errors all over when using PostgreSQL.
>> That's not pretty and makes it impossible to create the schema in one transaction, e.g.
> While I understand the annoyance, that is exactly how pg_dump does its output as well: unconditional DROP (if -c option given), and not wrapped in a transaction.
> That doesn't mean this should necessarily behave the same way, but I don't think it's something PostgreSQL DBAs should be surprised by either.
> Having said that, if you want to work up a patch to the script that generates the SQL, bin/interchange6-create-database, that would be great. Perhaps a similar -c / --clean option like pg_dump has that would include/exclude those DROP statements? I think it would be a better default to not include any kind of DROP statements, even with IF EXISTS, to avoid losing data by accident.
SQL::Translator produces the SQL statements. So please look there for a corresponding option.
Github issue or even better pull request welcome.
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users