# Error from Gnatcoll\_sql\_conf.gpr restricts GNAT studio features

**URL:** <https://forum.ada-lang.io/t/error-from-gnatcoll-sql-conf-gpr-restricts-gnat-studio-features/4969>\
**Category:** Help\
**Created:** [November 19, 2026, 7:11pm UTC](https://forum.ada-lang.io/t/error-from-gnatcoll-sql-conf-gpr-restricts-gnat-studio-features/4969 "2026-11-19T19:11:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rehartmann](https://forum.ada-lang.io/user_avatar/forum.ada-lang.io/rehartmann/32/409_2.png) [@rehartmann](https://forum.ada-lang.io/u/rehartmann)\
**Post date:** [November 19, 2026, 7:11pm UTC](https://forum.ada-lang.io/t/error-from-gnatcoll-sql-conf-gpr-restricts-gnat-studio-features/4969/1 "2026-11-19T19:11:43Z")

</div>

I’m having a Gnatcoll\_sql dependency in a project using GNAT Studio 2026.2 and Alire.  
Upon GNAT Studio startup, I’m getting errors:

> gnatcoll\_postgres\_conf.gpr 29:4 value “Production” is illegal for typed string “Build”

Each of the packages shows the error:

> 1:1 No project tree currently loaded: some features might be imprecise (e.g: Find All References) or not available (e.g: Rename).

Line 29 in gnatcoll\_postgres\_conf.gpr is:

> Build : Build\_Type := External (“BUILD”, “PROD”);

So there seems to be a problem here. Is there any way to fix or work around this issue? While this doesn’t affect compiling and running Ada code, it is quite annoying as some GNAT studio features are not available.

---

<div class="post-metadata">

**Author:** ![Irvise](https://forum.ada-lang.io/letter_avatar_proxy/v4/letter/i/7ba0ec/32.png) [@Irvise](https://forum.ada-lang.io/u/Irvise)\
**Post date:** [November 19, 2026, 7:22pm UTC](https://forum.ada-lang.io/t/error-from-gnatcoll-sql-conf-gpr-restricts-gnat-studio-features/4969/2 "2026-11-19T19:22:52Z")

</div>

It seems that somewhere in your setup you are passing “Production” instead of “PROD”. Search for “Production” in your project (with grep: `grep -Ri production` in your project root folder). Or search for “BUILD”. Since “PROD” is the default, you should not need to set “BUILD”, it will just be picked by default.

---

<div class="post-metadata">

**Author:** ![rehartmann](https://forum.ada-lang.io/user_avatar/forum.ada-lang.io/rehartmann/32/409_2.png) [@rehartmann](https://forum.ada-lang.io/u/rehartmann)\
**Post date:** [November 19, 2026, 8:15pm UTC](https://forum.ada-lang.io/t/error-from-gnatcoll-sql-conf-gpr-restricts-gnat-studio-features/4969/3 "2026-11-19T20:15:23Z")

</div>

In alire/alire.lock I see:

> XMLADA\_BUILD\_MODE = [  
> “distrib”,  
> “Debug”,  
> “Production”,  
> “profile”,  
> “coverage”,  
> “nochecks”,  
> ]

So this seems to come from Xmlada? Xmlada 25.0 is one of the (indirect) dependencies.

---

<div class="post-metadata">

**Author:** ![Irvise](https://forum.ada-lang.io/letter_avatar_proxy/v4/letter/i/7ba0ec/32.png) [@Irvise](https://forum.ada-lang.io/u/Irvise)\
**Post date:** [November 19, 2026, 8:27pm UTC](https://forum.ada-lang.io/t/error-from-gnatcoll-sql-conf-gpr-restricts-gnat-studio-features/4969/4 "2026-11-19T20:27:29Z")

</div>

Maybe it uses the same external variable and then gets picked up by gnatcoll? You would need to check that.
