field-addedit-postgresql.xql

  • last updated 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- Realized I made a boo-boo by adding the keyword_id column that allows

per-category custom fields to the wrong table. Moved it to ca_attributes

and changed pl/pgsql and tcl api's accordingly.

- Create index in ca_attributes to improve speed. Still need to assess

where else we need indices.

- Changed API a bit. A couple functions named _exists_p were not boolean

at all, hence confusing.

- Updated user/admin files to reflect changes.

- Adding of custom fields now lets site-wide admin add site-wide custom

fields, otherwise only package-wise custom-fields.

- Improved fields UI. Needs more work.

- Updated Tcl callbacks.

  1. … 20 more files in changeset.
- Retrieving ads now returns all the custom fields for the category

asked for.

- New proc categories::get_custom_fields to return list of custom fields.

- Adding of custom fields now completely integrated with per-category

custom fields, plus improved UI.

  1. … 9 more files in changeset.
- Updated user categories page. Not final.

- Moved posgresql-specific queries to field-addedit-postgresql.xql

- Update TODO in documentation.

    • -0
    • +16
    ./field-addedit-postgresql.xql
  1. … 5 more files in changeset.