Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

v_generate_tbl_ddl : Invalid operation: value too long for type character varying(798) #647

Open
vare7 opened this issue Sep 1, 2022 · 1 comment

Comments

@vare7
Copy link

vare7 commented Sep 1, 2022

I am getting similar error. Error screenshot: https://i.imgur.com/CglvPh1.png

SQL Statement:
select ddl
from admin.v_generate_tbl_ddl
where schemaname = 'schema_name_goes_here';

@timjell
Copy link
Contributor

timjell commented Sep 13, 2022

Hi, thanks for the report. That view is quite a big view, in that it joins together lots of information. This makes it harder to work out what is going on and which section is generating the error. Are you able to run each of the selects individually from the view definition? By this I mean the view is a UNION of lots of queries, if you are able to run each query individually that might help us track down which statement is causing the issue. Thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants