Can't write a condition to the database?

J

JohOconnor2019-04-03 03:05:11

PostgreSQL

JohOconnor, 2019-04-03 03:05:11

Good night everyone, I have a problem, I can't save any changes in the table, even if I expose those that were, it gives me the same error, I can't save changes in the "Indexes" section. Why does this error pop up and how to fix / work around it? In the screenshot, I'm trying to enter custom conditions and save, and I get this error

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

I

idShura, 2019-04-03
@idShura

A very informative question, at least show what you have in the default column.
It would also be nice to see the request in full (show what's on the Alter code tab).

M

Melkij, 2019-04-03
@melkij

alter column "id" what? According to the syntax , there is a description of the action, and not the word INTEGER, which comes from somewhere.
If this is an initiative of your gui, then this application does not know how to work with postgresql, that's all. Take something appropriate. psql for example.
Well, default should not be in quotes, but rather a function call, set default nextval(...

J

JohOconnor, 2019-04-11
@JohOconnor

Guys, you looked in the wrong direction, apparently you did not come across databases, everything was quite simple