Re: Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)

2022-12-28 Thread Ron
On 12/28/22 20:15, rob stone wrote: On Wed, 2022-12-28 at 09:45 -0800, Adrian Klaver wrote: On 12/23/22 01:37, Chetan Kosanam wrote: TCS Confidential See here: https://www.postgresql.org/support/professional_support/ Also there is ora2pg. See https://ora2pg.darold.net/ That does a gre

Re: Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)

2022-12-28 Thread rob stone
On Wed, 2022-12-28 at 09:45 -0800, Adrian Klaver wrote: > On 12/23/22 01:37, Chetan Kosanam wrote: > > TCS Confidential > > > > > > See here: > > https://www.postgresql.org/support/professional_support/ > > Also there is ora2pg. See https://ora2pg.darold.net/

Re: Updating column default values in code

2022-12-28 Thread Adrian Klaver
On 12/28/22 16:15, Brad White wrote: RECAP I'm running an Access front end against the Postgres back end. Copying and updating a record succeeds in 9.4 but fails in 9.5 and everything after. It was the precision of the timestamp fields after all. Turns out the initial data wasn't coming fro

Re: Updating column default values in code

2022-12-28 Thread David G. Johnston
On Wednesday, December 28, 2022, Brad White wrote: > > On timestamp fields, I need to update the column default from the current > "Now()" to "LOCALTIMESTAMP(0)" > > I could just manually make the change on every table, but then we would > still fail if we ever needed to restore a database. So I

Updating column default values in code

2022-12-28 Thread Brad White
RECAP I'm running an Access front end against the Postgres back end. Copying and updating a record succeeds in 9.4 but fails in 9.5 and everything after. It was the precision of the timestamp fields after all. Turns out the initial data wasn't coming from Access, but from the field default valu

Re: Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)

2022-12-28 Thread Adrian Klaver
On 12/23/22 01:37, Chetan Kosanam wrote: TCS Confidential Hi *Support*@ *PostgreSQL* Team, *Greetings* *!!* ** **We are operating within one of the /AWS business/ units of *TCS*. Our team is working on the *Database migration from Oracle(on Amazon EC2) to PostgreSQL*. The reason for this e

Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)

2022-12-28 Thread Chetan Kosanam
TCS Confidential Hi Support@ PostgreSQL Team, Greetings !! We are operating within one of the AWS business units of TCS. Our team is working on the Database migration from Oracle(on Amazon EC2) to PostgreSQL. The reason for this e-mailer is to seek your earnest required support from you on

https://wiki.postgresql.org/wiki/Working_with_Git link one link cannot open, another link is unrelated.

2022-12-28 Thread jian he
Hi. It's more like a git question less like a postgres question.. I executed the following commands rm /home/jian/Downloads/001_psql_parse_only_test.patch git checkout master git branch --delete --force feature_to_review git checkout -b feature_to_review patch -p1 --batch < /home/jian/Downloads/0