Tag Info

Hot answers tagged


This solution works for IPv4 / IPv6 nano /var/lib/pgsql/data/pg_hba.conf add at final host all all ::1/128 md5 host all postgres md5 /etc/init.d/postgresql restart


For me the way to go is that you create a pre-insert trigger that will set the BILL_ID for that department when no BILL_ID was given. To get the next BILL_ID you could use a table that holds the last BILL_ID per department. An other way is to get the MAX(BILL_ID) for that department and add 1 to it. When you work with multiple users then the first solution ...

Only top voted, non community-wiki answers of a minimum length are eligible