I did insert using following:
postgres=# insert into busbar_version(objectid,ver_id) values (5,5);
INSERT 0 1
postgres=# insert into busbar_version(objectid,ver_id) values (6,6);
INSERT 0 1
I was of the opinion that the above rows were inserted into busbar_version5 and busbar_version6, but I'm wrong.
postgres=# select * from busbar_version;
objectid | ver_id
----------+--------
5 | 5
6 | 6
(2 rows)
postgres=# select * from busbar_version5;
objectid | ver_id
----------+--------
5 | 5
(1 row)
postgres=# select * from busbar_version6;
objectid | ver_id
----------+--------
(0 rows)
postgres=# select * from busbar_version7;
objectid | ver_id
----------+--------
6 | 6
(1 row)
Why second insert has gone to table busbar_version7 instead of busbar_version6?
If it helps, I am trying on the "psql (12.3 (Debian 12.3-1.pgdg100+1))" container.