Re: Column does not exists? - Mailing list pgsql-general

From Francisco Olarte
Subject Re: Column does not exists?
Date
Msg-id CA+bJJbyvMFLNiSvjjqm8c8MPeC+eYw6P6t_8AHefFNZjKJOTwA@mail.gmail.com
Whole thread Raw
In response to Re: Column does not exists?  ("Leonardo M. Ramé" <l.rame@griensu.com>)
List pgsql-general
Hi Leonardo:

> Aha, the problem, then, was caused by the Create statement. This table was
> copied from a MySql dump where all columns were named "column".

In part. The problem was caused by non-uniform quote usaga, quotes in
create, no quotes elsewhere.

Had you used quotes in delete or not used quotes in create everything
would have go well. You can try to game the system, but it'e easier if
you  use them always or never, and always use the same case. I mean,
create table "a", delete from A may work in postgres but fail in other
db . create a, delete A normally works everywhere ( case folding, in
either direction, but you are asking for problems if you decide to
quote identifiers for any reason ), and create "a" delete "A" should
fail everywhere.

Francisco Olarte.


pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: 9.4+ partial log-shipping possible?
Next
From: Erik Jones
Date:
Subject: 9.4's limited logical replication, anyone actually used it, yet?