Description

The select all rows button that appears after clicking in the top left corner of the database in the UI selects every row in the table, not just the ones in the UI.

Steps to reproduce the behavior

1. Create a table with a timestamp column
2. Insert 10000 rows each with different timestamp, each on different day - ex:

INSERT INTO public.table (timestamp)
SELECT TIMESTAMP '2025-02-01 00:00:00' - INTERVAL '3 seconds' * generate_series(1, 10000);
INSERT INTO public.table (timestamp)
SELECT TIMESTAMP '2025-02-02 00:00:00' - INTERVAL '3 seconds' * generate_series(1, 10000);

3. Select the rows with timestamp less than the later date

SELECT * FROM public.table WHERE timestamp < '2025-02-02'

4. Click the top left corner of the table in the Data Output tab of the UI
5. Click Select All 10000 rows
6. Click Delete
7. Click Save Data Changes
8. Select all rows

SELECT * FROM public.table

9. See that all rows were deleted.

Expected behavior

Expectation is that only the 10000 selected in the UI should have been deleted.

Screenshots

Desktop (please complete the following information):

• OS: Windows 11
• Version: pgadmin version 8.14, postgres version 17.2 on TrueNAS Scale
• Mode: Desktop