Hi guys,
I am running a background task on my DB, which will copy data from tableA
to tableB. For that, I'm writing a PL/PGSQL function which basically needs
to do the following:
1. Select the data from tableA
2. The limit will be put when calling the function
3. insert the selected dat
Mac OSX,
No query tools on right click on database or via the tool menu.
Possible issues:
I installed postgresql-9.6.3-1-osx.dmg after I installed pgAdmin in order to
setup a localhosted db.
Previous to this I was using pgAdmin4 on a remote server to an acceptable
standard.
Thanks
--
View
On 05/28/2017 11:54 AM, Michelle Konzack wrote:
On 2017-05-28 11:23:47 Adrian Klaver hacked into the keyboard:
On 05/28/2017 10:53 AM, Michelle Konzack wrote:
SELECT * FROM products WHERE category IN
(SELECT categories.cat FROM categories WHERE
categories.serial = products.category);
On Sun, May 28, 2017 at 11:54 AM, Michelle Konzack wrote:
>
> I want to replace in the output the numerical ID from "products.category"
> with the value of "categories.cat", where the "products.category" match
> the "categories.serial"
>
Then go and read the first response in this thread, Amit
>> Cluster comparison would only occur if you have two or more clusters on
>> the same server, although it's possible to compare across servers,
>
>
> Explain, because as I understand it a server = one cluster:
>
I think he was using server in the server=one machine sense, ie a
single machine/serv
>
>
> Cluster comparison would only occur if you have two or more clusters on
> the same server, although it's possible to compare across servers,
> but that would involve a lot more work. AFAIK, the only differences for a
> cluster would be:
> 1. PostgreSQL version
> 2. path to database
> 3. datab
On 2017-05-28 20:19:59 m...@ft-c.de hacked into the keyboard:
> Hallo,
>
> SELECT *
> FROM products
> WHERE exists
> (SELECT categories.cat FROM categories WHERE
> categories.serial==products.category);
This does not give an error but does nothing
> or
> SELECT * FROM products
> WHERE
On 2017-05-28 11:23:47 Adrian Klaver hacked into the keyboard:
> On 05/28/2017 10:53 AM, Michelle Konzack wrote:
> >>
> >>SELECT * FROM products WHERE category IN
> >> (SELECT categories.cat FROM categories WHERE
> >> categories.serial = products.category);
> Because you are comparing cate
On 28.05.2017 20:19, m...@ft-c.de wrote:
Hallo,
SELECT *
FROM products
WHERE exists
(SELECT categories.cat FROM categories WHERE
categories.serial==products.category);
categories.serial = products.category); -- one equal sign
or
SELECT * FROM products
WHERE category IN
On 05/28/2017 10:53 AM, Michelle Konzack wrote:
On 2017-05-29 03:24:54 rob stone hacked into the keyboard:
You only need a single equals sign in SQL.
SELECT * FROM products WHERE category IN
(SELECT categories.cat FROM categories WHERE
categories.serial = products.category);
I have
Hallo,
SELECT *
FROM products
WHERE exists
(SELECT categories.cat FROM categories WHERE
categories.serial==products.category);
or
SELECT * FROM products
WHERE category IN
(SELECT categories.cat FROM categories);
On 28.05.2017 19:03, Michelle Konzack wrote:
Hello *,
I try to get
On 2017-05-29 03:24:54 rob stone hacked into the keyboard:
> You only need a single equals sign in SQL.
>
> SELECT * FROM products WHERE category IN
> (SELECT categories.cat FROM categories WHERE
> categories.serial = products.category);
I have tried this too, but then I get:
ERROR: o
Hello,
On Sun, 2017-05-28 at 20:03 +0300, Michelle Konzack wrote:
> Hello *,
>
> I try to get columns from my database with a singel SELECT, but I
> stuck.
>
> I have 3 tables like:
>
>
> 1) categories (serial,cat)
>
> 2) manufacturers (serial,m_name)
>
> 3) products (serial,category,manu
On Sun, May 28, 2017 at 10:33 PM, Michelle Konzack wrote:
> Hello *,
>
> I try to get columns from my database with a singel SELECT, but I stuck.
>
> I have 3 tables like:
>
>
> 1) categories (serial,cat)
>
> 2) manufacturers (serial,m_name)
>
> 3) products (serial,category,manufacturer,p_name
Adrian Klaver schrieb am 28.05.2017 um 17:51:
After I finally found the EnterpriseDB Beta binaries (they are pretty well
hidden) I tested with those, and everything works fine there.
For those following along, where would that be?
Here they are:
https://www.enterprisedb.com/products-service
Hello *,
I try to get columns from my database with a singel SELECT, but I stuck.
I have 3 tables like:
1) categories (serial,cat)
2) manufacturers (serial,m_name)
3) products (serial,category,manufacturer,p_name)
where the "category" and "manufacturer"
are numerical IDs from the two tab
Hi Tom,
Thanks, I’ll read this page.
> On May 28, 2017, at 8:36 PM, Tom Lane wrote:
>
> Arup Rakshit writes:
>> I was reading to day how indexing works. And I was trying some query, for
>> example below one. What the range basically means (cost=0.28..8.30 ? I don’t
>> understand this.
>
Thomas Kellerer writes:
> Tom Lane schrieb am 26.05.2017 um 20:18:
>>> The error message reported in the logfile is:
>>> pg_dump: unrecognized collation provider: p
>> Ugh :-( ... seems like a rather obvious typo in dumpCollation().
>> Thanks for finding it!
> When I drop that collation from the
On 05/28/2017 08:41 AM, Thomas Kellerer wrote:
Tom Lane schrieb am 26.05.2017 um 20:18:
Apparently BigSQL forgot to include contrib/xml2 in their distribution;
you should ping them about that one.
I can confirm that it's a BigSQL problem.
After I finally found the EnterpriseDB Beta binaries
Tom Lane schrieb am 26.05.2017 um 20:18:
I just tried pg_upgrade from the Postgres 10 Beta1 (from the BigSQL
distribution) to upgrade a 9.6 cluster.
pg_upgrade --check fails with the following messages:
could not load library "$libdir/pgxml":
ERROR: could not load library
"d:/etc/po
On 05/28/2017 07:53 AM, Melvin Davidson wrote:
Cluster comparison would only occur if you have two or more clusters on
the same server, although it's possible to compare across servers,
Explain, because as I understand it a server = one cluster:
https://www.postgresql.org/docs/9.6/s
Neil Anderson writes:
> I guess I don't know what is the most common way to say that it
> compares everything but the data. Any suggestions from your
> experience?
FWIW, I think it's pretty common to use "schema" in an abstract way
to mean "the structure of your database", ie everything but the d
Arup Rakshit writes:
> I was reading to day how indexing works. And I was trying some query, for
> example below one. What the range basically means (cost=0.28..8.30 ? I don’t
> understand this.
https://www.postgresql.org/docs/current/static/using-explain.html
regards,
On Sun, May 28, 2017 at 9:51 AM, Adrian Klaver
wrote:
> On 05/28/2017 05:49 AM, Neil Anderson wrote:
>
>> Hi,
>>
>> I'm working on a tool that can compare the properties of Postgres
>> objects from different instances, finding the differences and
>> outputting the update SQL.
>>
>> It can compare
Hi,
I was reading to day how indexing works. And I was trying some query, for
example below one. What the range basically means (cost=0.28..8.30 ? I don’t
understand this.
———
arup@ror ~/part-time-projects/entrylvl (add_index_to_job_sources)$ rails db
psql (9.5.0)
Type "help" for he
On 05/28/2017 05:49 AM, Neil Anderson wrote:
Hi,
I'm working on a tool that can compare the properties of Postgres
objects from different instances, finding the differences and
outputting the update SQL.
It can compare objects that are defined at the cluster, database or
schema level. As such I
On Sun, May 28, 2017 at 9:49 AM, Ludovic Vaugeois-Pepin
wrote:
>
>
> On Sun, May 28, 2017 at 6:54 AM, Michael Paquier
> wrote:
>>
>> On Sat, May 27, 2017 at 2:40 PM, Ludovic Vaugeois-Pepin
>> wrote:
>> > Say, with 9.6.2, a hot_standby fails to connect to a replication slot:
>> > FATAL: co
Hi,
I'm working on a tool that can compare the properties of Postgres
objects from different instances, finding the differences and
outputting the update SQL.
It can compare objects that are defined at the cluster, database or
schema level. As such I'm finding it difficult to describe what the
to
On Sun, May 28, 2017 at 6:54 AM, Michael Paquier
wrote:
> On Sat, May 27, 2017 at 2:40 PM, Ludovic Vaugeois-Pepin
> wrote:
> > Say, with 9.6.2, a hot_standby fails to connect to a replication slot:
> > FATAL: could not start WAL streaming: ERROR: replication slot
> "test3"
> > does not ex
29 matches
Mail list logo