Re: \dt shows table but \d says the table doesn't exist ?

"David G. Johnston" writes: > ... I’d welcome > a modifier like “*” (like the ~* operator) to enable case-insensitive > matching. We could talk about that idea, certainly. I'm afraid it's the sort of edge case that would mainly be useful to newbies who haven't read the docs closely enough to kno

Re: \dt shows table but \d says the table doesn't exist ?

On Friday, May 3, 2024, Adrian Klaver wrote: > > Have you met people? > I really don’t care enough to try and actually make converts here. It would have been a perfectly justifiable design choice to make our “pattern” matching case-insensitive by default, probably with a case-sensitive mode and

Re: \dt shows table but \d says the table doesn't exist ?

On 5/3/24 21:06, David G. Johnston wrote: On Friday, May 3, 2024, Tom Lane > wrote: By and large, I'd expect people using mixed-case table names to get accustomed pretty quickly to the fact that they have to double-quote those names in SQL.  I don't see wh

Re: \dt shows table but \d says the table doesn't exist ?

"David G. Johnston" writes: > On Friday, May 3, 2024, Tom Lane wrote: >> By and large, I'd expect people using mixed-case table names to get >> accustomed pretty quickly to the fact that they have to double-quote >> those names in SQL. I don't see why it's a surprise that that is also >> true in

Re: \dt shows table but \d says the table doesn't exist ?

On Friday, May 3, 2024, Tom Lane wrote: > > > By and large, I'd expect people using mixed-case table names to get > accustomed pretty quickly to the fact that they have to double-quote > those names in SQL. I don't see why it's a surprise that that is also > true in \d commands. > > Every day the

Re: \dt shows table but \d says the table doesn't exist ?

jian he writes: > make it case insensitive? That would just move the problem around; that is, now we'd have people complaining because they'd asked for "\d foo" and were getting results for tables Foo and FOO. By and large, I'd expect people using mixed-case table names to get accustomed pretty

Re: \dt shows table but \d says the table doesn't exist ?

On Sat, May 4, 2024 at 5:15 AM Tom Lane wrote: > > Adrian Klaver writes: > > On 5/3/24 14:06, Magnus Hagander wrote: > >> Looks like you might need a \d "some_idIds" (include the quotes) since > >> it has an uppercase characters? > > > This: > > "Did not find any relation named "public.some_idIds

Re: Question regarding how databases support atomicity

"David G. Johnston" writes: > On Friday, May 3, 2024, Siddharth Jain wrote: >> The way I understand this is that if there is a failure in-between, we >>> start undoing and reverting the previous operations one by one. > Not in PostgreSQL. All work performed is considered provisional until a > c

Re: Question regarding how databases support atomicity

> On May 3, 2024, at 20:02, Siddharth Jain wrote: > > > The way I understand this is that if there is a failure in-between, we start > undoing and reverting the previous operations one by one. But what if there > is a failure and we are not able to revert an operation. How is that > situat

Re: Question regarding how databases support atomicity

On Friday, May 3, 2024, David G. Johnston wrote: > On Friday, May 3, 2024, Siddharth Jain wrote: > >> >> >> On Fri, May 3, 2024 at 8:00 PM Siddharth Jain wrote: >> >>> >>> >>> The way I understand this is that if there is a failure in-between, we >>> start undoing and reverting the previous ope

Re: Question regarding how databases support atomicity

On Friday, May 3, 2024, Siddharth Jain wrote: > > > On Fri, May 3, 2024 at 8:00 PM Siddharth Jain wrote: > >> I am trying to sharpen my understanding of databases. Let's say there is >> an operation foo as part of the public API that internally translates to >> more than 1 operation - I am sure

Re: Question regarding how databases support atomicity

On Fri, May 3, 2024 at 8:00 PM Siddharth Jain wrote: > I am trying to sharpen my understanding of databases. Let's say there is > an operation foo as part of the public API that internally translates to > more than 1 operation - I am sure there are examples like this in postgres. > So to do foo w

Re: How to Build Postgres in a Portable / Relocatable fashion?

AJ ONeal writes: > It seems like the first bit of magic I need is: > `--prefix=/doesntexist/postgres` No, you want an actual path so that "make install" will succeed. The point is that then you can tar up that installation tree (relative to its top) and untar it somewhere else. > I'd like to bui

Re: How to Build Postgres in a Portable / Relocatable fashion?

On 5/3/24 17:35, Bruce Momjian wrote: On Fri, May 3, 2024 at 05:29:34PM -0700, Adrian Klaver wrote: From here: https://www.enterprisedb.com/ #1 IN POSTGRES THE MOST ADMIRED, DESIRED, & USED DATABASE. is not helpful. Though I would say the bigger issue is here: https://www.postgresql.org/d

Re: How to Build Postgres in a Portable / Relocatable fashion?

On Fri, May 3, 2024 at 05:29:34PM -0700, Adrian Klaver wrote: > From here: > > https://www.enterprisedb.com/ > > #1 IN POSTGRES > THE MOST ADMIRED, DESIRED, & USED DATABASE. > > is not helpful. > > Though I would say the bigger issue is here: > > https://www.postgresql.org/download/ > > Wher

Re: How to Build Postgres in a Portable / Relocatable fashion?

On 5/3/24 17:07, Bruce Momjian wrote: On Fri, May 3, 2024 at 11:27:12PM +, AJ ONeal wrote: Back in the good old days there was official 1st-party support for Linux: This was/is a third party site. Oh. I thought that EDB was *the* Postgres company like MySQL AB was *the* MySQL company. M

Re: How to Build Postgres in a Portable / Relocatable fashion?

> > What I want to create (and provide) is a portable tarball that has > > most of all what it needs in the tarball and will look for relevant > > libraries relative to itself. > > > See > > https://www.postgresql.org/docs/current/installation.html > > particularly the discussion of installat

Re: How to Build Postgres in a Portable / Relocatable fashion?

On Fri, May 3, 2024 at 11:27:12PM +, AJ ONeal wrote: > > > Back in the good old days there was official 1st-party support for Linux: > > This > > was/is a third party site. > > Oh. I thought that EDB was *the* Postgres company like MySQL AB was *the* > MySQL company. My mistake. How did you

Re: How to Build Postgres in a Portable / Relocatable fashion?

AJ ONeal writes: > What I want to create (and provide) is a portable tarball that has > most of all what it needs in the tarball and will look for relevant > libraries relative to itself. See https://www.postgresql.org/docs/current/installation.html particularly the discussion of installation r

Re: How to Build Postgres in a Portable / Relocatable fashion?

> > Back in the good old days there was official 1st-party support for Linux: > This > was/is a third party site. Oh. I thought that EDB was *the* Postgres company like MySQL AB was *the* MySQL company. My mistake. > and `apt`​ is always half-a-decade out-of-date I misspoke. I meant the OS repo

Re: How to Build Postgres in a Portable / Relocatable fashion?

On 5/3/24 15:57, AJ ONeal wrote: Back in the good old days there was official 1st-party support for Linux: Still there. The below is for the EDB installer, which at this point is only for MacOS and Windows as Unixen platforms have there own packaging. This was/is a third party site. http

How to Build Postgres in a Portable / Relocatable fashion?

Back in the good old days there was official 1st-party support for Linux: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads Those binaries could be tar xvf​'d and used without any fuss or muss, from any location, on any distro. I'm the core maintainer of https://webinstall.dev

Re: \dt shows table but \d says the table doesn't exist ?

On Fri, 3 May 2024 at 17:28, Tom Lane wrote: This is one of the places where it's unfortunate that our English-text > rule for quoting a string to set it off from the rest of the error > message collides with SQL's rule for quoting an identifier. Leaving > out the outer quotes would be contrary

Re: \dt shows table but \d says the table doesn't exist ?

Magnus Hagander writes: > On Fri, May 3, 2024 at 11:08 PM Adrian Klaver > wrote: >> This: >> "Did not find any relation named "public.some_idIds"." >> to me indicates it did look for the properly cased name. > That is arguably a really bad error message, because it puts those quotes > there whet

Re: \dt shows table but \d says the table doesn't exist ?

Adrian Klaver writes: > On 5/3/24 14:06, Magnus Hagander wrote: >> Looks like you might need a \d "some_idIds" (include the quotes) since >> it has an uppercase characters? > This: > "Did not find any relation named "public.some_idIds"." > to me indicates it did look for the properly cased name.

Re: \dt shows table but \d says the table doesn't exist ?

On Fri, May 3, 2024 at 2:08 PM Adrian Klaver wrote: > On 5/3/24 14:06, Magnus Hagander wrote: > > > > > > On Fri, May 3, 2024 at 10:58 PM David Gauthier > > wrote: > > > > psql (15.3, server 14.5) on linux > > > > Someone else's DB which I've been asked to l

Re: \dt shows table but \d says the table doesn't exist ?

On Fri, May 3, 2024 at 11:08 PM Adrian Klaver wrote: > On 5/3/24 14:06, Magnus Hagander wrote: > > > > > > On Fri, May 3, 2024 at 10:58 PM David Gauthier > > wrote: > > > > psql (15.3, server 14.5) on linux > > > > Someone else's DB which I've been asked to

Re: \dt shows table but \d says the table doesn't exist ?

On 5/3/24 14:06, Magnus Hagander wrote: On Fri, May 3, 2024 at 10:58 PM David Gauthier > wrote: psql (15.3, server 14.5) on linux Someone else's DB which I've been asked to look at. \dt gives many tables, here are just 3...  public | some_idId

Re: \dt shows table but \d says the table doesn't exist ?

On 5/3/24 13:58, David Gauthier wrote: psql (15.3, server 14.5) on linux Someone else's DB which I've been asked to look at. \dt gives many tables, here are just 3...  public | some_idIds                                       | table | cron_user  public | WarningIds                        

Re: \dt shows table but \d says the table doesn't exist ?

On Fri, May 3, 2024 at 10:58 PM David Gauthier wrote: > psql (15.3, server 14.5) on linux > > Someone else's DB which I've been asked to look at. > > \dt gives many tables, here are just 3... > > public | some_idIds | table | > cron_user > public | WarningI

\dt shows table but \d says the table doesn't exist ?

psql (15.3, server 14.5) on linux Someone else's DB which I've been asked to look at. \dt gives many tables, here are just 3... public | some_idIds | table | cron_user public | WarningIds | table | cron_user public |

Re: Ora2pg Delta Migration: Oracle to PostgreSQL

Thanks Avinash. Appriciate the help!! Regards Amit On Fri, May 3, 2024 at 5:38 AM Avinash Vallarapu < avinash.vallar...@gmail.com> wrote: > Hi, > > Has anyone tried delta/incremental data migration for Oracle to PostgreSQL >> using Ora2pg? Or what are the best options to run delta migration for

Re: Identity column data type difference in PostgreSQL and Oracle

Thanks for the advice. On Fri, 3 May 2024 at 16:09, Peter Eisentraut wrote: > On 03.05.24 12:57, Muhammad Ikram wrote: > > Tables which have an identity column in Oracle when migrated to > > PostgreSQL, the data type of Identity column is changed to bigint from > > number by the tools. This cau

Re: Identity column data type difference in PostgreSQL and Oracle

On 03.05.24 12:57, Muhammad Ikram wrote: Tables which have an identity column in Oracle when migrated to PostgreSQL, the data type of Identity column is changed to bigint from number by the tools. This causes the size of column to be reduced to max value supported by bigint which is way lower t

Identity column data type difference in PostgreSQL and Oracle

Hello, Tables which have an identity column in Oracle when migrated to PostgreSQL, the data type of Identity column is changed to bigint from number by the tools. This causes the size of column to be reduced to max value supported by bigint which is way lower than the oracle number max. Secondly

Re: Ora2pg Delta Migration: Oracle to PostgreSQL

Hi, Has anyone tried delta/incremental data migration for Oracle to PostgreSQL > using Ora2pg? Or what are the best options to run delta migration for > Oracle to PostgreSQL? There are a few ways of dealing with it when using Ora2Pg. *Option 1 : *Ora2Pg configuration file allows us to pass the

Re: Ora2pg Delta Migration: Oracle to PostgreSQL

Hi, Not related to Ora2PG but in the past I have used the EDB Migration toolkit for such scenarios. Filterprops option can help in specifying filter (where clause). Regards, Ikram On Fri, May 3, 2024 at 8:12 AM Ron Johnson wrote: > On Thu, May 2, 2024 at 8:28 PM Amit Sharma wrote: > >> Hello