RE: Sequences part 2

From: Karl Martin Skoldebrand <KS0C77263(at)TechMahindra(dot)com>
To: "karsten(dot)hilbert(at)gmx(dot)net" <karsten(dot)hilbert(at)gmx(dot)net>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: Sequences part 2
Date: 2019-07-02 11:42:57
Message-ID: c4eea2e934cf43e9ae25faaf71e39f85@UKEXCHMBX003.TechMahindra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Yes, I'm fairly aware of this. However the application the database table belongs to seems to rely on a specific order in the database. I.e. if I just add value to the table they end up, possibly due to how the application is coded in an undesireable spot on the web page.
> That is why I wanted them to be inserted with the previous records.

rename the table

install a view with the name of the table and appropriate triggers and/or rules between app and database enforcing whatever questionable assumptions the app thinks it needs -- if at all logically possible

--------------
Hmm, that could be a possible avenue.
The true horror of the database table is that it contains mixed data, so it could possibly be "easier" to just remodel the database table (split it into several) for this function. If things are in fact the way they look to us at the moment. Either way it's not a quick fix for someone fairly inexperienced with PostgreSQL and having a couple of days to holiday.

//Martin S

============================================================================================================================

Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html <http://www.techmahindra.com/Disclaimer.html> externally http://tim.techmahindra.com/tim/disclaimer.html <http://tim.techmahindra.com/tim/disclaimer.html> internally within TechMahindra.

============================================================================================================================

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2019-07-02 11:53:10 Re: Sequences part 2
Previous Message Karsten Hilbert 2019-07-02 11:25:36 Re: Sequences part 2