PG Doc comments form writes:
> I have noted that, in order for constraint exclusion to work correctly when
> partitioning using inheritance, we must use simple comparisons in check
> constraints (e.g., =, >=, <=, BETWEEN, etc.). If conditions are combined
> using AND or OR, unnecessary partitions
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/ddl-partitioning.html
Description:
Hello,
I have noted that, in order for constraint exclusion to work correctly when
partitioning using inheritance, we must use simple comparisons in che
rt ON invoice FOR EACH ROW EXECUTE
PROCEDURE get_num('inv_num');
CREATE TRIGGER get_pro_number before insert ON proforma FOR EACH ROW
EXECUTE PROCEDURE get_num('pro_num');
CREATE TRIGGER get_pay_number before insert ON payment FOR EACH ROW EXECUTE
PROCEDURE get_num('
PG Doc comments form writes:
> Example on this page is not working
> https://www.postgresql.org/docs/13/pltcl-trigger.html
> Gives ERROR: bind message supplies 1 parameters, but prepared statement ""
> requires 0
Works fine for me, when copied-and-pasted into psql.
The e
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/pltcl-trigger.html
Description:
Example on this page is not working
https://www.postgresql.org/docs/13/pltcl-trigger.html
Gives ERROR: bind message supplies 1 parameters, but prepared
On Thu, Feb 25, 2021 at 5:06 PM PG Doc comments form
wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/ecpg-sql-set-autocommit.html
> Description:
>
> I tested with " PostgreSQL 13.2 on x86_64-pc-linux-gnu, compiled by gcc
>
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/ecpg-sql-set-autocommit.html
Description:
I tested with " PostgreSQL 13.2 on x86_64-pc-linux-gnu, compiled by gcc
(GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit"
The result is below.
pos
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/tutorial-accessdb.html
Description:
As you stated in the tutorial it is not working.
createdb mydb
psql mydb
the prompt of mydb is not showing.
On Mon, Jan 21, 2019 at 7:39 PM Bruce Momjian wrote:
> You have not explained what "does not work" means.
True...but assuming it is true would we accept placing a
driver-specific warning here? We do not do so anywhere else in the
documentation that I am aware.
The main issue, IIUC, is that Prepa
On Mon, Dec 10, 2018 at 10:21:26AM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/citext.html
> Description:
>
> The citext plugin does not work in combination with jdbc. Thus it does not
> work
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/citext.html
Description:
The citext plugin does not work in combination with jdbc. Thus it does not
work with Java applications. It does work in pgadmin because that is python.
I am using
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/8.3/static/textsearch-controls.html
Description:
Its not giving the appropriate results:
I want to search within 2 columns (psc_code & psc_name). I want to retrieve
the psc_code data first a
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-notify.html
Description:
LISTEN virtual;
NOTIFY virtual;
Asynchronous notification "virtual" received from server process with
PID
8448.
NOTIFY virtual, 'This is the payload';
13 matches
Mail list logo
