-Original Message-
From: Matthias Apitz [mailto:g...@unixarea.de]
Sent: Wednesday, January 22, 2020 3:05 PM
To: Igor Neyman
Cc: pgsql-general@lists.postgresql.org
Subject: Re: calculating the MD5 hash of role passwords in C
> --
> Matthias Apitz, ✉ g...@unixarea.de
-Original Message-
From: Matthias Apitz [mailto:g...@unixarea.de]
Sent: Wednesday, January 22, 2020 2:41 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: calculating the MD5 hash of role passwords in C
.
--
Matthias Apitz, ✉ g...@unixarea.
sion();
PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10)
4.9.2, 64-bit
Try increasing the following parameters to 14 (or even 16, if you are not sure
about number of tables involved):
geqo_threshold = 14
from_collapse_limit = 14
join_collapse_limit = 14
“about 12” is too close to default limit, 12.
Regards,
Igor Neyman
From: Igor Neyman [mailto:iney...@perceptron.com]
Sent: Thursday, October 03, 2019 12:27 PM
To: pgsql-general@lists.postgresql.org
Subject: PG12
Main page (https://www.postgresql.org/) announces new release, but Downloads
for Windows page (https://www.postgresql.org/download/windows/) doesn&#
Main page (https://www.postgresql.org/) announces new release, but Downloads
for Windows page (https://www.postgresql.org/download/windows/) doesn't list
PG12.
Any clarification?
Regards,
Igor Neyman
to test (c2) values(4);
ERROR: duplicate key value violates unique constraint "one_row"
DETAIL: Key (c1)=(1) already exists.
SQL state: 23505
Regards,
Igor Neyman
or batch file.
Installation script doesn’t find on your machine ICACLS, Windows utility that
is being used by installation script to grant proper permissions.
Something’s wrong with your Windows OS.
Regards,
Igor Neyman
s/11/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
Regards,
Igor Neyman
Ramamoorthi
Some are listed here:
https://stackshare.io/postgresql/in-stacks
Or, just do google search.
Regards,
Igor Neyman
. The MySQL documentation is better on this simple operation.
-
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
There is nothing odd about:
select (12345678.1234/32.5678)::numeric(10,4);
Regards,
Igor Neyman
-Original Message-
From: Igor Korot [mailto:ikoro...@gmail.com]
Sent: Tuesday, December 04, 2018 11:07 AM
To: Igor Neyman
Cc: Adrian Klaver ; pgsql-general
Subject: Re: How to watch for schema changes
Igor,
On Tue, Dec 4, 2018 at 8:20 AM Igor Neyman wrote:
>
>
>
ting to PG through native interface libpq.dll,
ODBC didn't work for that purpose, at least at the time.
Regards,
Igor Neyman
-Original Message-
From: Ravi Krishna [mailto:srkrish...@icloud.com]
Sent: Friday, November 16, 2018 9:28 AM
To: Thomas Kellerer
Cc: pgsql-general
Subject: Re: BDR and PostgreSQL 12 and Windows support
WARNING: This email originated from outside of Perceptron! Please be mindful of
PH
the data is under "x"KB an index is overhead not help? I am not
worried about space, more interested in performance.
I think, partial/conditional indexes: …. Where greeting = ‘…’ – may help.
Regards,
Igor Neyman
3-01') TO ('2006-04-01')
Thanks,
Yuxia
Better yet:
SELECT relname, pg_get_expr(relpartbound, oid) FROM pg_class WHERE relpartbound
IS NOT NULL;
Regards,
Igor Neyman
surement'::regclass;
My question is: how to get the value boundary for each partition table like
bellow?
measurement_y2006m02 FROM ('2006-02-01') TO ('2006-03-01')
measurement_y2006m03 FROM ('2006-03-01') TO ('2006-04-01')
Thanks,
Yuxia
Take a look at relpartbound in pg_class.
Regards,
Igor Neyman
ou specify?
Regards,
Igor Neyman
__
select prosrc from pg_proc where proname = 'function_name';
You can pronamespace to WHERE clause to specify schema.
Regards,
Igor Neyman
n_distance -- returned as NUMERIC
FROM pg_catalog.pg_replication_slots
WHERE slot_name = 'Slot NAME';
Regards,
Igor Neyman
tation only!
That is simply not true: shared_buffers have this name for a reason. What’s not
shared is work_mem used for sorting, etc…
Also OS cache is shared too.
Regards,
Igor Neyman
27;))
How about:
'''INSERT INTO my_table(name, age)
VALUES( %s, %s)
WHERE NOT EXISTS(SELECT name FROM my_table WHERE name=%s)''', ('Scott', 23,
'Scott'))
Regards,
Igor Neyman
this feature in Win OS, ask someone who’s more
familiar with windows environment.
Pretty sure that’s the solution of your problem.
Regards,
Igor Neyman
On system hard drive search for the file called
bitrock_installer_.log.
You should find it in Users\\AppData\Local\Temp.
This log should provide you with more specific details explaining why data
folder is empty.
Regards,
Igor
From: Dale Seaburg [mailto:kg...@verizon.net]
Sent: Saturday, April
catch a "duplicate key" exception in your app.
Regards,
Igor Neyman
g "PARTITION BY ..." clause.
3. Drop old "parent" table.
4. Rename new partitioned table giving it .
5. Finally, "old" partitions to new partitioned table (previously "parent"):
ALTER TABLE < parent_table_name > ATTACHE PARTITION
FOR VALUES ...
Regards,
Igor Neyman
25 matches
Mail list logo
