Redshift Postgress with Heidi

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

Hi,

Is there any updates as to when Redshift Postgres would be supported in Heidi?

ansgar's profile image ansgar posted 3 weeks ago Permalink

PostgreSQL is already supported by HeidiSQL. I never heard of Redshift Postgres. Is it a drop-in-replacement? Is HeidiSQL incompatible to it?

feverpitch's profile image feverpitch posted 3 weeks ago Permalink

our DB is hosted via AWS Redshift,

i am able to add the connection and shows the databases/schema's but when i select it i get the following error.

1 attachment(s):
  • error
ansgar's profile image ansgar posted 3 weeks ago Permalink

Documentation says PG on Amazon Redshift supports search_path.

Probably the escaping using E prefix is just not supported. Could you try to fire that SET.. command without these Es in a query tab?

feverpitch's profile image feverpitch posted 2 weeks ago Permalink

I tried that and i was able to get the query working, however i still cant browse table objects?

is there a way of fixing that?

ansgar's profile image ansgar posted 2 weeks ago Permalink

I just pushed some changes for issue #62, which probably also helps here. At least if you say that query works without the E prefix. I removed this prefix, using a less error-prone approach for string escaping. So, the next build should have this slightly modified query:

SET search_path TO 'phoenix', '$user';

Please update HeidiSQL to the latest build and report back if that works now.

feverpitch's profile image feverpitch posted 2 weeks ago Permalink

So i don't need to update the search path for the query anymore, but i am still unable to browse object tables.

1 attachment(s):
  • no-browse
ansgar's profile image ansgar posted 2 weeks ago Permalink

I can see an error in your SQL log at the bottom saying

ERROR: function pg_relation_size(text) does not exist

I suppose that's the next issue here. Due to the complex solution here, you could be so nice and file an issue report in the bugtracker, please.

ansgar's profile image ansgar posted 2 weeks ago Permalink

It seems this Redshift PostgreSQL is based on a very old PostgreSQL release, as the function pg_relation_size() was introduced in PG 8.1, back in 2005. Previous v8.0 versions (without support for pg_relation_size()) get no support since 2010.

Server release lifecycles and support: https://www.postgresql.org/support/versioning/

What does this command return on your server:

SELECT VERSION();

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