Comments (4)
I think I know what's going on. Sometime after the last piggly release, which was a long time back, postgres added support for TABLE
arguments to stored procedures. While your procedure returns a table, under the hood I think it works like an output parameter.
If you are able, do you mind editing this source file and adding an entry to the hash "t" => "table"
? I don't know if more is needed, but that may fix your issue. If that works, I'll work on creating some test cases and a new release containing that fix. You are also welcome to submit a PR and I'll merge it, but if you don't want to I'll take care of it.
Be sure to clear any cached piggly data so it will recompile your stored proc if needed.
from piggly.
from piggly.
Our problems are aligned! Because I've been away for so long, I don't have PostgreSQL setup or available to test my changes. Before your reply I created a ticket to remind myself to make a Docker with Ruby, PostgreSQL, and piggly so I can work locally without having to set it all up.
I also think it would make sense to deploy piggly as a Docker image for users. Ideally someone can just do docker run kputnam/piggly
and people won't need to know or care that Ruby is involved. Because I'm not focused on this project I can't promise speedy progress, but I will set some weekend time aside for it.
If you need it sooner, you can work on it and I'll answer any questions you have. The particular error you pasted I think is due to a new(er) version of rake
. I think it's actually rspec that depends on that function, and upgrading rspec should address it. You can probably just comment out rspec from the Gemfile
for the time being. Or you could specify an older version of rake
, I think < 11.0
would work.
from piggly.
from piggly.
Related Issues (20)
- Parser issue - DML in WITH query HOT 13
- use of select filter HOT 3
- config.dry_run undefined HOT 1
- issue with table return types HOT 1
- error installing piggly gem on windows HOT 11
- declare statement before begin causes parse failure HOT 4
- for loop with literals violates 'loop always iterates more than once' rule HOT 2
- failing to capture calls to secondary procedure for perform call HOT 6
- Replace source using UPDATE pg_proc HOT 2
- another parse issue "RAISE {cr} USING" HOT 1
- Improve keyword parsing HOT 1
- ERROR: zero-length delimited identifier at or near """" (PG::SyntaxError) HOT 2
- No tag with id X (RuntimeError) HOT 12
- gcov/lcov support HOT 2
- Functions that declare a non-trivial cursor fail to compile HOT 2
- Improve automated testing HOT 3
- Make the reports prettier!
- Support for latest stored procedure syntax
- `defaults': Couldn't parse default arguments
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 piggly.