Support of Postgres < 8.2

[lc0]

Hi guys,

Thanks for the interesting project. Unfortunately, we have PostgreSQL version < 8.2, so we can't use position_in_unique_constraint.
modelq crashes with next error message:

2015/04/23 12:16:15 [Postgres Driver] Start to load tables schema from database, name, tables=tables
2015/04/23 12:16:16 Cannot load table schemas from database.
2015/04/23 12:16:16 pq: column keycolumnusage.position_in_unique_constraint does not exist

I found, that these are generated in https://github.com/mijia/modelq/blob/master/drivers/postgres/key_column_usage.go#L24 What do you think is the best way to adapt this to my case?

Regards,
Sergii

[mijia]

Hi @lc0 ,

This is quite a problem since I build this driver around PostgreSQL 9.4. I cannot see an easy way to support different version of drivers so would that be ok if you can just fork the project and remove that fields and all the references from key_column_usage.go?

Sorry for that, :(

[lc0]

that file is generated, right? What is the process there? Also how do you use this particular field?

I can see the process, that people with different version could re-generate a driver around the use-case.

[mijia]

Yeah, that file is generated so I didn't pick those fields but generated from the information_schema. I first create a raw-hand-written-sql version of the driver code and make all the generation work, then I use that code to generate the driver code, then replace the raw code with the generated code and toss away the raw code part. So it is kinda frozen code on that part since I have no way to go back, :)

Any suggestions?

[lc0]

If you describe your process of generation in detail I will try to generate it on my own. Right now, I started to change the file manually in order to get it running with Amazon Redshift.

They use Postgres-compatible protocol, unfortunately, version is only 8.0.2. I solved issues with position_in_unique_constraint. There are some other limitations. For instance, currently I have the issue with:

pq: must be superuser to examine "max_index_keys"