a
fixed postgresql error and changed views