Skip unpublished items in PostgresProvider and update query handling in...

Carlos Romerorequested to merge
issue/ai_vdb_provider_postgres-3562422:3562422-1.0.0-alpha2 into 1.0.x

Skip unpublished items in PostgresProvider and update query handling in PostgresPgvectorClient for vector storage compatibility

Closes #3562422

Merge request reports