/ - Repository - BIEN 3 - NCEAS Projects

root @ 12662

Name	Revision	Age	Author	Comment
branches	11969	about 11 years	Aaron Marcuse-Kubitza	added standard svn dirs branches, tags, trunk
tags	11969	about 11 years	Aaron Marcuse-Kubitza	added standard svn dirs branches, tags, trunk
trunk	12662	almost 11 years	Aaron Marcuse-Kubitza	schemas/util.sql: auto_rm_freq(): accept multip...

#	Date	Author	Comment
12662	03/12/2014 05:38 PM	Aaron Marcuse-Kubitza	schemas/util.sql: auto_rm_freq(): accept multiple tables, so the freq column is only dropped if all tables have all 1s
12661	03/12/2014 05:36 PM	Aaron Marcuse-Kubitza	schemas/util.sql: added freq_always_1(regclass[])
12660	03/12/2014 05:35 PM	Aaron Marcuse-Kubitza	schemas/util.sql: added drop_column(regclass[])
12659	03/12/2014 05:04 PM	Aaron Marcuse-Kubitza	schemas/util.sql: added parent(regclass)
12658	03/12/2014 04:48 PM	Aaron Marcuse-Kubitza	schemas/util.sql: try_create(): also handle not_null_violation, which is thrown when trying to add a NOT NULL column to a parent table, which cascades to a child table whose values for the new column will be NULL
12657	03/12/2014 04:44 PM	Aaron Marcuse-Kubitza	bugfix: schemas/util.sql: diff(text, text): also need to cast left_/right_ to base type for the IS DISTINCT FROM filter, because the WHERE clause apparently does not use columns from the SELECT list, even though GROUP BY and ORDER BY do
12656	03/12/2014 04:13 PM	Aaron Marcuse-Kubitza	schemas/util.sql: added to_freq(regclass, drop_if_always_1)
12655	03/12/2014 04:04 PM	Aaron Marcuse-Kubitza	schemas/util.sql: added auto_rm_freq(regclass)
12654	03/12/2014 03:53 PM	Aaron Marcuse-Kubitza	schemas/util.sql: added freq_always_1(regclass)
12653	03/12/2014 03:00 PM	Aaron Marcuse-Kubitza	bugfix: schemas/util.sql: diff(regclass, regclass): need to create a diff when the # of copies of a row differs between the tables. this uses new util.to_freq().

Also available in: Atom