Pyrseas
Pyrseas copied to clipboard
Provides utilities for Postgres database schema versioning.
Would be very nice to have information about function arguments and types. For instance ``` create table foo( a int unique ); create table bar( b int primary key references...
from issue #191. My process is: from database create yaml, and from that compare with other database and create sql. The problem is sql: ALTER TABLE xxx OWNER H-dlb no...
For some functions, it is possible that the functions it depends upon are not explicitly present, e.g. for the following aggregate function, the dependency is upon pg_catalog.array_cat, so should not...
Added a proper parser for a sequence of dot-separated quoted names. Let quote_id do the merging back into dot-separated quoted names string, minimising the use of ad-hoc `%s.%s` where sometimes...
See issue #163. In order to release 0.8, support for partitions defined using expressions, e.g., `extract(year FROM some_date)`, will be addressed separately, either in 0.9 or some maintenance release of...
This can be seen in `tests.dbobject.test_eventtrig.EventTriggerToSqlTestCase` `test_create_event_trigger_func_schema`. The function `s1.f1()` is split into `('public, 's1.f1', '')` instead of `('s1', 'f1', '')`. This test has been disabled until a fix is...
Issue #175, the `test_operclass.py` tests that were marked `xfail` in the last phase of dealing with #176 and issue #183 (probably also #184) all point to deficiencies in Pyrseas knowledge...
Differencing database versions is insufficient in some cases, e.g., ALTER TABLE ALTER COLUMN datatype, so Pyrseas should incorporate non-differencing approaches to handle these cases. See [The Future of Pyrseas –...
The deptrack changes fetch OIDs for all database objects. However, input objects lack OIDs. This inconsistency needs to be reconciled or explained. It is presumed that in some cases we...
Hi, We have created the following aggregate which works well on its own: ```sql --/ CREATE OR REPLACE FUNCTION sum_distinct_on (arg1 numeric, arg2 anyarray) RETURNS numeric VOLATILE AS $body$ DECLARE...