• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

babelfish-for-postgresql / babelfish_extensions / 16285796618
76%
BABEL_5_X_DEV: 77%

Build:
Build:
LAST BUILD BRANCH: 5577-5x
DEFAULT BRANCH: BABEL_5_X_DEV
Ran 15 Jul 2025 07:00AM UTC
Jobs 1
Files 120
Run time 2min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

15 Jul 2025 06:26AM UTC coverage: 75.891% (+0.1%) from 75.796%
16285796618

push

github

web-flow
Support for weak binding views to allow dropping of underlying objects BABEL_4_X_DEV (#3965)

* Support for weak binding views to allow dropping of underlying objects.This commit introduces support for both strong and weak view binding in Babelfish, aligning more closely with SQL Server's default behavior while maintaining flexibility. (#3806)

Description
Currently, Babelfish only supports strong binding for views, which prevents dropping or altering referenced objects when views depend on them. This behavior differs from SQL Server, which by default allows dropping underlying tables or views unless WITH SCHEMABINDING is explicitly specified.
With this change, Babelfish now supports configurable view binding modes:

Strong binding (default): Prevents dropping referenced objects if views depend on them
Weak binding: Allows dropping of referenced objects
This feature aligns Babelfish more closely with SQL Server's behavior, providing greater flexibility
Key aspects include:

A new GUC parameter babelfishpg_tsql.weak_view_binding to control the default binding behavior (default is false)
Support for explicit WITH SCHEMABINDING to create strongly bound views regardless of the GUC setting
Ability to create weakly bound views by default when the GUC is enabled
Proper handling of ALTER VIEW operations in both binding modes
In SQL Server, views are weakly bound by default, allowing underlying objects to be dropped or altered. With our implementation, users can now choose between SQL Server's default behavior (weak binding) or the previously enforced behavior (strong binding).

Important Limitation :
This implementation currently only addresses DROP operations on tables, views, functions, procedures as well as ALTER operations on views when these objects are bound by dependent views. ALTER TABLE/ ALTER FUNCTION operations (such as dropping columns or changing data types) are still restricted when dependent views exist, regardless of binding mode. This differs... (continued)

365 of 394 new or added lines in 7 files covered. (92.64%)

3 existing lines in 2 files now uncovered.

49679 of 65461 relevant lines covered (75.89%)

325608.06 hits per line

New Missed Lines in Diff

Lines Coverage ∆ File
6
86.48
-0.12% contrib/babelfishpg_tsql/src/catalog.c
23
85.83
0.9% contrib/babelfishpg_tsql/src/hooks.c

Uncovered Existing Lines

Lines Coverage ∆ File
1
72.43
-0.2% contrib/babelfishpg_tds/src/backend/tds/tdsutils.c
2
19.04
-0.18% contrib/babelfishpg_tsql/src/pl_funcs.c
Jobs
ID Job ID Ran Files Coverage
1 16285796618.1 15 Jul 2025 07:00AM UTC 120
75.89
GitHub Action Run
Source Files on build 16285796618
  • Tree
  • List 120
  • Changed 10
  • Source Changed 7
  • Coverage Changed 10
Coverage ∆ File Lines Relevant Covered Missed Hits/Line
  • Back to Repo
  • Github Actions Build #16285796618
  • 5c9c04f0 on github
  • Prev Build on BABEL_4_X_DEV (#16259706357)
  • Next Build on BABEL_4_X_DEV (#16450029439)
  • Delete
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc