Thanks for your explanation.
Laurenz Albe 于2023年7月13日周四 17:48写道：
> On Thu, 2023-07-13 at 13:12 +0800, 黄宁 wrote:
> > I want to create some temporary tables in SPI, but after I created the
> table and inserted the data, I can’t query any data, why?
> >
> > the postgres version:
> > PostgreSQL 13.6
Hi community,
I am reading the 'Generate code for query jumbling through gen_node_support.pl'
(https://www.postgresql.org/message-id/E1pMk51-000puf-55%40gemulon.postgresql.org)
to understand the principle of the postgres's node, but I really don't know
the meaning of the word 'query jumbling'.
I think maybe you can check the pg_hba.conf, change the method to the 'trust'.
(Allow the connection unconditionally. This method allows anyone that can
connect to the PostgreSQL database server to login as any PostgreSQL user they
wish, without the need for a password or any other authentication
You can use a DO block or write a function do to this.
It takes some practice (and you need to use EXECUTE FORMAT())
If users need to be able to change their own users, something like this
works:
CREATE FUNCTION change_my_password(in_password, text)
returns void language plpgsql as
$$
begin
E
Hello,
I use volkszaehler.org (a DIY Smartmeter) on postgres.
The hardware is a Dual-core 2,4 GHz amd64-CPU and 6 GB RAM.
The databse is approx. 1.5 GB on SSD
my local config looks like:
root@vz:~# cat /etc/postgresql/15/main/conf.d/local.conf
# DB Version: 15
# OS Type: linux
# Total Memory (
On 7/17/23 05:23, Wen Yi wrote:
> Hi community,
> I am reading the 'Generate code for query jumbling through
> gen_node_support.pl'
> (https://www.postgresql.org/message-id/E1pMk51-000puf-55%40gemulon.postgresql.org)
> to understand the principle of the postgres's node, but I really don't know
On 7/17/23 11:13, basti wrote:
> Hello,
>
> I use volkszaehler.org (a DIY Smartmeter) on postgres.
>
> The hardware is a Dual-core 2,4 GHz amd64-CPU and 6 GB RAM.
> The databse is approx. 1.5 GB on SSD
>
> my local config looks like:
>
> root@vz:~# cat /etc/postgresql/15/main/conf.d/local.co
On 7/17/23 13:20, Tomas Vondra wrote:
> ...
>
> It's always going to be slow with the COUNT(DISTINCT), I'm afraid.
>
> Not sure how much you can modify the query / database, and how accurate
> results you need. If you're OK with estimates, you can try postgres-hll
> extension [2] which estimates
On 7/17/23 04:13, basti wrote:
[snip]
The Indexes:
volkszaehler=# SELECT tablename,indexname,indexdef FROM pg_indexes WHERE
tablename LIKE 'data%' ORDER BY tablename,indexname;
tablename | indexname | indexdef
---++---
Hello guys,
Our read only user is okay to be granted read only permission of tables.
How to grant read only functions execute permission to read only user, is
there a simple way to do it please? If not, how to get the list of read
only functions please? Then can grant one by one based on the list
On 7/16/23 23:47, Baskar Muthu wrote:
Reply to list also.
Ccing list.
I tried many times but they showed the same things and it ran for more
than 3 hours. how to resolve this issue. If you have any idea please let
me know.Thanking you..
OS version - Windows 11
Postgre sql version - 14.3
I
On 7/17/23 16:11, Yi Sun wrote:
> Hello guys,
>
> Our read only user is okay to be granted read only permission of tables.
>
> How to grant read only functions execute permission to read only user,
> is there a simple way to do it please? If not, how to get the list of
> read only functions pl
On Mon, Jul 17, 2023, 08:44 Tomas Vondra
wrote:
>
>
> On 7/17/23 16:11, Yi Sun wrote:
> > Hello guys,
> >
> > Our read only user is okay to be granted read only permission of tables.
> >
> > How to grant read only functions execute permission to read only user,
> > is there a simple way to do it
> On 17/07/2023 16:30 CEST Adrian Klaver wrote:
>
>
> The other screenshot is a pgAdmin issue. I have seen quite a few
> questions about this on Stack Overflow recently. Seems to be related to
> version 7.4. My suggestion would be to file an issue here:
>
> https://github.com/pgadmin-org/pgadmin4/
I too had problems with 7.4. They went away when I downgraded to 7.2
C E Eriksson
Sent from iPhone
> On 17 Jul 2023, at 18:31, Erik Wienhold wrote:
>
>
>>
>> On 17/07/2023 16:30 CEST Adrian Klaver wrote:
>>
>>
>> The other screenshot is a pgAdmin issue. I have seen quite a few
>> questio
Thanks a lot tomas, i will try it.
I have find out that there is a 'aggregation' function in the frontend.
But this is MySQL specific and I have no idea the transform it to postgres.
It looks like:
'REPLACE INTO aggregate (channel_id, type, timestamp, value, count)
SELECT channel_id, ? AS type
For future reference, this parameter was removed in v17 via commit 884eee5.
--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
Hi, suggest to automatically rename backup_manifest to backup_manifest.old
like backup_label when postgres start up successfully because it has no use
anymore for pg_verifybackup after postgres has been started.
Dear all,
I'm looking for ideas here, and it could be someone already stepped
into declarative partitioning of an existing database where Hibernate
(a Java ORM) handles the tables.
The situation is as follows:
create table foo( id primary key, a_date date, ... );
Now, the trivial way to partition
On 7/18/23 01:18, Luca Ferrari wrote:
Dear all,
I'm looking for ideas here, and it could be someone already stepped
into declarative partitioning of an existing database where Hibernate
(a Java ORM) handles the tables.
The situation is as follows:
create table foo( id primary key, a_date date, .
20 matches
Mail list logo
