[Bug]: Failing to build extension using projects/extension/build.py install

[Abhayraj-pipesort]

What happened?

Followed all steps for installation from source but after installing the build.py file using projects/extension/build.py install command it is failing to create extension properly.
It is expecting a file to be there named as pgai/projects/extension/sql/ai--0.4.2.-dev.sql

pgai extension affected

0.4.2

pgai library affected

No response

PostgreSQL version used

16

What operating system did you use?

Windows 11

What installation method did you use?

Source

What platform did you run on?

Other

Relevant log output and stack trace

No response

How can we reproduce the bug?

Followed official docs and installed

Are you going to work on the bugfix?

None

[JamesGuthrie]

@Abhayraj-pipesort thanks for your interest in pgai. We're aware that it's currently not possible to use it on Windows. My colleague was recently working on fixing this here: #237.

I'm not sure how sonn we'll get that change merged, but you might be able to use some of the pieces of that pull request in the meantime.

[alejandrodnm]

Hey @Abhayraj-pipesort I was working on the Windows PR, I was trying to add the Windows tests as part of the Ci, but failed to do it. The github actions that installed PostgreSQL in windows didn't have some packages I needed to install pgvector, which is a dependency. The one action that's the same that pgvector uses, only supports PG14 and we require 16 or greater.

I had to stop work on this branch. I plan to retake it, just to do some manual tests. I was testing everything via the windows-latest github runner, while trying to implement the Ci.

It would be really helpful if you can test the branch locally.