pgx driver and initialization order

[undeconstructed]

In my project the pgx driver is initialized after the postgres adaptor. This means that https://github.com/go-rel/postgres/blob/main/postgres.go#L202 doesn't find the driver, and defaults to postgres, which isn't inlcuded. Is there either:

• a reason to search for the driver in the init function - or could this be moved to Open() ?
• a way to force the initialization order - I think not, because the adaptor doesn't depend on pgx, so it could always be initialized first.

Thanks.

[Fs02]

Hi, thanks for posting this issue

a reason to search for the driver in the init function - or could this be moved to Open() ?

There's no strong reason, feel free to send a PR to fix this

[toudi]

I stumbled upon the same problem but realized that there was another method called New:

import (
    _ "github.com/jackc/pgx/v5/stdlib"
    "github.com/go-rel/postgres"
)

conn, err := sql.Open("pgx", url.DSN)
if err != nil {
	return err
}
adapter = postgres.New(a.conn)

I tried to move the import up and down and it did not make any difference - the driver would still not be recognized. I even cloned the repository and replaced it to introduce debugging and db.Drivers() was empty