Comments (4)
ha, finally an easy one! There is another system func that returns the args WITHOUT DEFAULTS!
This is now fixed.
from pg-clone-schema.
well I think it's because the prototype header for the function definition itself includes DEFAULT keywords, but the function header for dropping or doing other actions on a function/procedure will barf if DEFAULT language is used.
CREATE FUNCTION whatever(akey integer default 0)... is OK
but
DROP FUNCTION whatever(akey integer default 0) wont work, neither GRANT on it with the default keywords
Let me work on this again...
from pg-clone-schema.
Great! now everything is working! thank you very much @MichaelDBA
from pg-clone-schema.
from pg-clone-schema.
Related Issues (20)
- Handle Special Characters in `tb.grantee` Column HOT 1
- Bug - Setting default value per column in create table statement HOT 2
- Bug - The triggers have to be cloned only after the eventual tables rows cloning HOT 1
- Enhancement - Simple select statements to compare source and target schema HOT 3
- Error when using in supabase HOT 17
- Error with citext and array in the same table HOT 2
- Materialized view with index causes error HOT 3
- Table permissions for public role invalidly assigned to non-existing "PUBLIC" role HOT 3
- Syntax error search path HOT 7
- Sequence owner is lost after second copy HOT 9
- TSVector Columns lead to multiple create statements for the same table HOT 12
- Duplicate sequences generated for SERIAL column tables HOT 1
- Redundant permissions granted to predefined roles HOT 1
- INSERT Problem with Identity columns HOT 1
- Problem execution clone schema HOT 5
- operator does not exist: public.ltree @> public.ltree HOT 2
- Error when udt is not in the source or public schema HOT 3
- Not all triggers cloned HOT 6
- Apply fix to pg_get_tabledef() HOT 1
- Owner with special characters
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pg-clone-schema.