Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Can't edit anything in database

varvara_kisel's profile image varvara_kisel posted 3 weeks ago in General Permalink

Hi, i can't edit any tables, names of columns, or even allow NULL and etc.

If i'm trying to allow NULL, I'm getting an error: ERROR: syntax error at or near "type of data" LINE 2: ALTER COLUMN "name of column" TIME NOT NULL

If i'm trying to edit data in a new line, the error is: 0 rows updated when that should have been 1.

This database is on Heroku

2 attachment(s):
  • -
  • omg
ansgar's profile image ansgar posted 3 weeks ago Permalink

Looks like issue #595, which I intended to fix for the upcoming v10.3 release.

Please login to leave a reply, or register at first.