/
NEWS
167 lines (109 loc) · 4.4 KB
/
NEWS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
0.6.0beta (16-Aug-2012)
* Added support for:
- EXTENSIONs
- COLLATIONs
- OWNER information
- Access privileges (GRANT and REVOKE)
- TABLESPACEs for tables, primary keys and indexes
- MATCH attributes for foreign keys (#34)
- ALTER composite TYPE ADD/DROP/RENAME ATTRIBUTE
- ENUMs with no labels (#31)
* Correctly support index functions/expressions (#3).
* Fix DbConnection exception handling under Python 3 (#25).
* dbtoyaml
- Fix -t option to output sequences owned by table and the schema
description.
- Use pg_user_mappings view to allow usage by non-superusers.
* yamltodb
- Schema-qualify table when dropping columns (#26).
- Correct column drop/add case in middle of table (#8).
- Fix adding and dropping of columns in inherited tables (#33).
- Enable renaming of indexes (#38).
- Ignore all temp schemas (#37)
* dbtoyaml/yamltodb
- Give PGUSER precedence over USER environment variable.
0.5.0 (10-Mar-2012)
* Added support for:
- TEXTSEARCH parsers, dictionaries, configurations and templates
- FOREIGN DATA WRAPPERs, SERVERs, USER MAPPINGs and FOREIGN TABLEs
- ROWS clause in set-returning functions (issue #11)
- Deferrable/deferred constraints (#13)
- CATEGORY and PREFERRED clauses for TYPEs,
SORTOP clause for AGGREGATEs
HASHES and MERGES clauses for OPERATORs (#15)
- Operator class qualifiers for INDEXes (#16)
- Python 3.2 and later
* Correct schema normalization for constraints (#9) and indexes.
* Fix COMMENTs generated for constraints (#12).
* Fix DEFAULT clause for OPERATOR CLASS.
* dbtoyaml
- When restricting to specific schemas or tables, include
non-schema objects (e.g., languages).
* yamltodb
- Add -n/--schema option (#6).
- Add -u/--update option to apply SQL statements to target
database.
- Exclude database-wide objects when -n/--schema is used (#21).
- Allow YAML spec argument to be read from standard input.
* dbtoyaml/yamltodb
- Add -o/--output option
- Add -W/--password option (#18)
0.4.1 (27-Oct-2011)
* Make the initial SET search_path persistent.
* Correct exclusion of PG internal schemas in various queries.
* Fix generation of COMMENTs with single quotes in the text.
* For inherited tables, only generate constraints that are defined
locally.
* Correct generation of ALTER TABLE ADD/DROP COLUMN when input
columns are in different order than original.
* Support PG 9.1 (add description for PL/pgSQL language).
0.4.0 (26-Sep-2011)
* Added support for:
- CASTs
- CONSTRAINT TRIGGERs
- CONVERSIONs
- OPERATORs, OPERATOR CLASSes and OPERATOR FAMILies
- Dynamically loaded C language functions
- Composite and base TYPEs
* Clean up and enhance documentation and redundant methods.
* Use obj_description/col_description functions instead of querying
pg_description directly.
0.3.1 (26-Aug-2011)
* Added workaround for incorrect assumption that 'public' schema is
always present (issue #4).
* Added support for delimited (or quoted) identifiers, e.g., those
with embedded spaces, upper case characters, etc. (except for SQL
keywords) (issue #5).
0.3.0 (30-Jun-2011)
* Added support for:
- AGGREGATE functions
- DOMAINs
- ENUMerated TYPEs
- Functions returning table row types
- INDEXes on expressions (issue #3)
- Rewrite RULEs
- SECURITY DEFINER functions
- TRIGGERs
* Enhanced host/port defaults to use sockets, resulting in noticeable
performance improvement.
0.2.1 (7-Jun-2011)
* Fixed problem with mapping a FOREIGN KEY in a table with a dropped
column (issue #2).
0.2.0 (19-May-2011)
* Added support for:
- COMMENTs on schemas, tables, columns and functions
- FOREIGN KEY ON UPDATE and ON DELETE actions
- ALTER TABLE RENAME COLUMN and enhanced support for other ALTER
object RENAME statements.
- VIEWs
- INHERITed tables, and by extension, partitioned tables.
- PROCEDURAL LANGUAGEs
- FUNCTIONs.
* Added files for release via PGXN.
* Added support for testing against multiple PostgreSQL versions.
* Fixed cross-schema REFERENCES failure in dbtoyaml (issue #1).
0.1.0 (5-Apr-2011)
* Initial release
- dbtoyaml and yamltodb support PostgreSQL schemas, tables,
sequences, check constraints, primary keys, foreign keys, unique
constraints and indexes.