Timeline for PostgreSQL: Add or drop column under load give wrong number of columns errors
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 9, 2017 at 12:00 | comment | added | viblo | There are some problems to this workaround. If there are 10 functions returning the same columns, then all of them have to list all columns instead of using the shared table type ("setof a" in my example). Also I think it wont be possible to do it without renaming the function each time its updated (since if you return record you must query out all returned columns in the select ... from myfunc query) | |
| Mar 8, 2017 at 14:04 | history | edited | András Váczi | CC BY-SA 3.0 | added 23 characters in body |
| Mar 8, 2017 at 9:50 | history | answered | Dave Poole | CC BY-SA 3.0 |