Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  bin 3361 over 12 years Aaron Marcuse-Kubitza pg_dump_vegbien: Added data option for backing ...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 3363 over 12 years Aaron Marcuse-Kubitza inputs/SALVIAS/maps/VegX.stems.csv: Fixed PlotO...
  lib 3360 over 12 years Aaron Marcuse-Kubitza sql_io.py: cast(): Don't output warnings for er...
  mappings 3337 over 12 years Aaron Marcuse-Kubitza mappings/VegX-VegBIEN.stems.csv: Reattached loc...
  schemas 3366 over 12 years Aaron Marcuse-Kubitza schemas: Ignore *.backup files for svn
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.8 KB 3365 over 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: Schemas: schemas/%/b...
README.TXT 2.96 KB 3205 over 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Import data into VegBI...
map 1.21 KB 3140 over 12 years Aaron Marcuse-Kubitza top-level map: Added support for custom public ...

Latest revisions

# Date Author Comment
3366 07/12/2012 03:19 PM Aaron Marcuse-Kubitza

schemas: Ignore *.backup files for svn

3365 07/12/2012 03:00 PM Aaron Marcuse-Kubitza

root Makefile: VegBIEN DB: Schemas: schemas/%/backup: Documented that it can't be used for the current (unrotated) public schema because pg_dump doesn't back up the CREATE SCHEMA statement for it

3364 07/12/2012 02:45 PM Aaron Marcuse-Kubitza

root Makefile: VegBIEN DB: Schemas: schemas/%/backup: Changed file extension to .backup to match what pgAdmin3 expects

3363 07/12/2012 02:40 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/maps/VegX.stems.csv: Fixed PlotObsID mapping to point to sourceAccessionCode so that it would map to the same place as organisms' PlotObsID and the entries would be merged. This will hopefully also fix a SALVIAS stems import bug where the specimenreplicate join on existing/inserted rows matched multiple rows, in spite of using the specimenreplicate_unique_catalognumber UNIQUE INDEX.

3362 07/12/2012 02:35 PM Aaron Marcuse-Kubitza

root Makefile: VegBIEN DB: Schemas: Added schemas/%/backup for backing up an import's schema

3361 07/12/2012 02:34 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Added data option for backing up an import's schema

3360 07/12/2012 01:32 PM Aaron Marcuse-Kubitza

sql_io.py: cast(): Don't output warnings for errors that are stored in the errors table, because this clutters the log output unnecessarily. Warnings are still output when there is no errors table.

3359 07/12/2012 01:20 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: party: party_unique UNIQUE INDEX: Moved surname before givenname, middlename to enable the index to be used when just the person's last name is known. (Note that if the organization is not known, and explicit NULL would need to be put in for that field to use the index.)

3358 07/12/2012 01:14 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): DuplicateKeyException: Uniquifying input table to avoid internal duplicate keys: Include all join columns (including literal values) in the unique index, not just table columns, to encourage PostgreSQL to use the index in a merge join.

3357 07/12/2012 01:11 PM Aaron Marcuse-Kubitza

sql.py: distinct_table(): Support literal values as column expressions. Filter out untyped NULLs because the type unknown can't be indexed.

View all revisions | View revisions

Also available in: Atom