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.

Sign up for GitHub

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

Jump to bottom

Cannot make changes in Redshift (Postgres engine) #139

Open
r0wdiggity opened this issue Dec 3, 2024 · 4 comments · May be fixed by #140
Open

Cannot make changes in Redshift (Postgres engine) #139

r0wdiggity opened this issue Dec 3, 2024 · 4 comments · May be fixed by #140

Comments

@r0wdiggity
Copy link

I was unable to make changes in either Postgres or Redshift, then I read through this issue and updated from 0.3.1 to 0.3.2 and that fixed the issue for Postgres, however I still cannot edit Redshift anymore (I used to be able to make changes in Redshift)
@jorgerojas26
Copy link
Owner

Hi, can you post the error message?

@r0wdiggity
Copy link
Author

I dont get an error message, the interface just locks up and I have to close the terminal

@r0wdiggity
Copy link
Author

r0wdiggity commented Dec 4, 2024 •
edited
Loading

ok found the log file and log level options, i ran with -loglevel "debug"

{"timestamp":"2024-12-04T09:37:29-06:00","level":"INFO","message":"Starting LazySQL..."}
{"timestamp":"2024-12-04T09:37:50-06:00","level":"INFO","message":"GetTables","additional_info":{"database":"icd"}}
{"timestamp":"2024-12-04T09:38:21-06:00","level":"ERROR","message":"GetPrimaryKeyColumnNames","additional_info":{"error":"pq: op ANY/ALL (array) requires array on right side"}}
{"timestamp":"2024-12-04T09:38:21-06:00","level":"INFO","message":"FetchRecords","additional_info":{"primaryKeyColumnNames":null}}
{"timestamp":"2024-12-04T09:38:23-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":1,"row":1}}
{"timestamp":"2024-12-04T09:38:23-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":2,"row":1}}
{"timestamp":"2024-12-04T09:38:23-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":3,"row":1}}
{"timestamp":"2024-12-04T09:38:23-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":4,"row":1}}
{"timestamp":"2024-12-04T09:38:23-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":5,"row":1}}
{"timestamp":"2024-12-04T09:38:24-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":6,"row":1}}
{"timestamp":"2024-12-04T09:38:24-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":5,"row":1}}
{"timestamp":"2024-12-04T09:38:25-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":4,"row":1}}
{"timestamp":"2024-12-04T09:38:25-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":3,"row":1}}
{"timestamp":"2024-12-04T09:38:25-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":2,"row":1}}
{"timestamp":"2024-12-04T09:38:26-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":1,"row":1}}
{"timestamp":"2024-12-04T09:38:26-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":0,"row":1}}
{"timestamp":"2024-12-04T09:38:27-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":1,"row":1}}
{"timestamp":"2024-12-04T09:38:28-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":2,"row":1}}
{"timestamp":"2024-12-04T09:38:28-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":3,"row":1}}
{"timestamp":"2024-12-04T09:38:28-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":4,"row":1}}
{"timestamp":"2024-12-04T09:38:28-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":5,"row":1}}
{"timestamp":"2024-12-04T09:38:28-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":6,"row":1}}
{"timestamp":"2024-12-04T09:38:30-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":5,"row":1}}
{"timestamp":"2024-12-04T09:38:30-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":4,"row":1}}
{"timestamp":"2024-12-04T09:38:30-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":5,"row":1}}
{"timestamp":"2024-12-04T09:38:31-06:00","level":"INFO","message":"table.SetSelectionChangedFunc","additional_info":{"col":6,"row":1}}

@jorgerojas26 jorgerojas26 linked a pull request Dec 4, 2024 that will close this issue
Open
@jorgerojas26
Copy link
Owner

Can you check if #140 solves the problem?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

fix: changes postgres query to support redshift jorgerojas26/lazysql
2 participants
@r0wdiggity @jorgerojas26