Hi,
Please try to replace the
\web\pgadmin\tools\sqleditor\templates\sqleditor\sql\default\primary_keys.sql
file with the attached file and do not forget to take a backup of the
original file.
Restart the server and check the issue gets resolved or not.
Thanks,
Khushboo
On Tue, Sep 3, 2019 at
Hi,
On Tue, Sep 3, 2019 at 7:31 PM Holger Kopp-Musick wrote:
> Hi,
>
> I'm using pgAdmin 4.12 in desktop mode on Win 10 1809, databases are 10.9
> on CentOS 7.6. When executing any SELECT in the query editor, I get no data
> but the following error message:
> Operator does not exist: - oid
>
>
yes, what you need is a full outer join. How are your actual results
different from the expected ones?
On Wed, Sep 4, 2019 at 4:18 AM Michel Feinstein
wrote:
> Also, be aware that this is NOT the postgresql email list, but the pgAdmin
> email list, you would get a lot more help about SQL there.
Also, be aware that this is NOT the postgresql email list, but the pgAdmin
email list, you would get a lot more help about SQL there.
On Tue, Sep 3, 2019, 19:44 Jack Royal-Gordon wrote:
> Let me step back a bit, as I realize upon further reflection that the
> first method will not work.
>
> As f
Let me step back a bit, as I realize upon further reflection that the first
method will not work.
As far as the issue about two “Ted” records, read it as though I said two “Ted
D” records. It refers to two records in the same table with the same key value.
If “Ted D” appeared twice in table 1 a
Not having unique IDs from the source tables will present a problem in
that you could have more than one record in one of the tables with the
same data.
It looks like you will need to determine the fields that make each row
unique but common in all three tables. Then, you can match up records
Perfect, thanks!
Enviado do meu Telefone LG
-- Mensagem original--
De: Murtuza Zabuawala
Data: ter, 3 de set de 2019 14:04
Para: Edson Richter;
Cc:Pgadmin-Support@Postgresql. Org;
Assunto:Re: pgAdmin - migration
Hi,
Please refer
https://www.pgadmin.org/docs/pgadmin4/4.12/import_export_
Hi,
Please refer
https://www.pgadmin.org/docs/pgadmin4/4.12/import_export_servers.html
Configurations are stored in the "%APPDATA%\pgAdmin\pgadmin4.db" file.
--
Murtuza
On Tue, Sep 3, 2019 at 8:14 PM Edson Richter
wrote:
> Hi!
>
>
>
> I’ve pgAdmin 4.12 running on Windows Server 2008r2. Run s
Hi Jack
I'm not sure if I understand your comment about two 'Ted' fields and
duplication of rows. In the example below there is 'Ted' twice in Table3 1
and 3 and must appear twice as I've shown in the result as the data in the
rest of the row is different. I agree with no duplication of rows if al
Hi Ted,
In essence, you want to merge the three tables, removing records that are
duplicated by another table, right?
Here are two approaches:
1) SELECT DISTINCT (field list) FROM (SELECT * from table1 UNION SELECT * from
table2 UNION SELECT * from table 3).
This will remove all duplicates, re
Hi!
I’ve pgAdmin 4.12 running on Windows Server 2008r2. Run smoothly.
Right now, we are migrating from this 8 yrs old server to a new one, running
Windows Server 2019.
Since each db developers already have about 40 servers registered in old
server, I would like to know if is possible to migrat
Hi,
I'm using pgAdmin 4.12 in desktop mode on Win 10 1809, databases are 10.9 on
CentOS 7.6. When executing any SELECT in the query editor, I get no data but
the following error message:
Operator does not exist: - oid
I understand that converting the negative value of attrelid causes that error
Hi Patrick
Thanks for your response. The tables that I gave were just an example and
there is no relevance in the friend/yes or names/contact details in
different tables.
To clarity, another example would be three tables - shop1, shop2 and shop3.
Each would have products so that would be a common
13 matches
Mail list logo
