On Mon, 2025-02-10 at 16:06 +0530, Mukesh Tanuku wrote:
> Thanks for your quick responses.
>
> I have just added the session related timeout parameters in the
> postgresql.conf file also tried tweaking with different
> values/patterns like ('1min', '1 min', 8, 10s, '10s', '10 s')
>
> but i
Hello,
On Sat, 2024-09-21 at 10:20 -0700, Adrian Klaver wrote:
> On 9/21/24 02:36, veem v wrote:
> >
> >
>
> >
> > Actually here the application is using kafka and flink stream and
> > is
> > using one of existing code in which it was doing row by row commit
> > which
> > is now changed to
On Wed, 2024-01-03 at 15:59 +0900, Taek Oh wrote:
> Hi there,
>
> I would like to make an inquiry regarding the encoding option for the
> database backup.
> When I was using the previous version of PGADMIN 4, I had a
> dropbar for the encoding format for the backup option.
> But I recently star
Hello,
On Tue, 2023-10-03 at 08:57 +0900, Michael Paquier wrote:
> On Mon, Oct 02, 2023 at 04:42:15PM +0200, Dominique Devienne wrote:
> > According to the doc, the table is NOT changed.
> > In my case, I DO want to have the bytea column rewritten
> > according to the new STORAGE and/or COMPRESSIO
Hello,
On Tue, 2023-08-15 at 08:49 +, [Quipsy] Markus Karg wrote:
>
>
>
> Hello PostgreSQL Community,
>
> I have 25+ years of experience with some other RDBMS, but I am a
> PostgreSQL starter, so I assume the following is rather a simple
> beginner’s question…:
>
> I like to store jus
Hello,
> -
> -
> PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc
> (Debian
> 4.8.3-2) 4.8.3, 64-bit
>
>
> -
> -
On Wed, 2022-12-28 at 09:45 -0800, Adrian Klaver wrote:
> On 12/23/22 01:37, Chetan Kosanam wrote:
> > TCS Confidential
> >
> >
>
> See here:
>
> https://www.postgresql.org/support/professional_support/
>
>
Also there is ora2pg. See https://ora2pg.darold.net/
Hello,
On Mon, 2022-08-08 at 15:52 +0800, Wind wrote:
> hi~
> I test "tablesample" feature on pg9.5 and found that tablesample
> doesnt support to be applied to subquery.
> for example this sql doesnt work on pg9.5:
> ```
> create table t1(
> c1 int,
> c2 int
> );
> select c2 from (select
Hello Ray,
On Tue, 2021-09-28 at 09:24 -0400, Raymond Brinzer wrote:
> Greetings.
>
>
>
> I'm wondering whether such a feature could be added, without breaking
> either existing code, or compliance with the SQL standard. For
> instance, borrowing :: from languages like Ruby and Perl:
>
> SELE
>
> Rich, could you please elaborate on SQL queries being based on sets?
> I
> never thought of it that way, and would like to hear your related
> thoughts.
>
When Codd & Date elaborated the relational model, it was based on set
theory.
You have sets of data. Is there a relationship between the
On Wed, 2021-09-15 at 05:10 +, A Z wrote:
> -In PostgreSQL, what is the difference between Roles, Groups, and
> Policies exactly? What are they each, how do they relate to one
> another, and which one(s) can be assigned to another?
>
> -Is there a simple, immediate, straightforward way to t
On Sun, 2021-09-05 at 11:21 -0400, Tom Lane wrote:
> "David G. Johnston" writes:
> > On Friday, September 3, 2021, Philippe Doussot <
> > philippe.dous...@up.coop>
> > wrote:
> > > I don't understand why disabling all index from the table speed
> > > up the
> > > update because the boolean colu
Hello,
On Wed, 2021-08-11 at 11:09 +, ourdiaspora wrote:
>
>
> The connection to postgresql seems OK now (thank you), but the php
> web page continues to fail to connect to the database:
>
> "
>
>
> Generic CPAC database
>
>
>
Hello,
On Mon, 2021-08-09 at 02:16 +, Masih Tavassoli wrote:
> Hi experts,
>
> I am trying to find a way to decode a URL request header and extract
> its JSON fields in postgreql .
>
> I can do this in Oracle sql using
>
> select (utl_raw.cast_to_varchar2 (utl_encode.base64_decode(
> ut
Hello Ken,
On Fri, 2021-07-09 at 13:27 -0500, Kenneth Marshall wrote:
> On Fri, Jul 09, 2021 at 01:16:16PM +1000, rob stone wrote:
> > Hello,
> >
> > I am curious.
> >
> > NVL, DECODE and SELECT FROM dual are Oracle methods and these
> > appear in
> &g
Hello,
I am curious.
NVL, DECODE and SELECT FROM dual are Oracle methods and these appear in
your code.
How did you make these work in Postgres?
Cheers,
Rob
Hello,
On Fri, 2021-04-02 at 22:01 +, Allie Crawford wrote:
> Hi,
> I am new in postgresql and I am trying to install PostgreSQL on Linux
> server but instead of using the default location for the binaries I
> want to install them in a different directory.
> I have research for a while and I c
Hello,
On Mon, 2021-02-01 at 18:03 +0100, Jiří Pavlovský wrote:
>
>
> Thanks for the answer.
>
>
> I don't think triggers or constraints are the issue.
>
> The exact same code works if I create a small test program with the
> same
> query and the same parameters.
>
> But when used in the co
Hi,
On Thu, 2021-01-14 at 20:48 +, Phil Florent wrote:
> Hi,
>
> I read that on Jonathan Lewis' blog :
>
> (I believe that there may be some RDBMS which will treat (e.g.) “X
> between 20 and 10” as being identical to“X between 10 and 20” )
>
> I am puzzled. PostgreSQL seems NOT to treat X b
Hello,
On Thu, 2020-03-19 at 14:36 -0700, pabloa98 wrote:
> Hello,
>
> My schema requires a counter for each combination of 2 values.
> Something like:
>
> CREATE TABLE counter(
> group INT NOT NULL,
> element INT NOT NULL,
> seq_number INT NOT NULL default 0,
> CONSTRAINT PRIMARY KEY (group, el
Hello,
On Fri, 2020-02-28 at 01:10 +, sivapostg...@yahoo.com wrote:
> Then clearly I've misunderstood what advisory lock could do. We
> used to put locks in SQL server to avoid deadlock situations. I
> thought advisory lock is a similar one. [ New to Postgres ]
>
> The report is arrived
On Fri, 2020-02-07 at 00:48 -0500, Tom Lane wrote:
> rob stone writes:
> > 2020-02-07 15:42:55 AEDT ERROR: syntax error at or near
> > "'AIT1581050529'" at character 13
> > 2020-02-07 15:42:55 AEDT STATEMENT: DEALLOCATE 'AIT1581050529'
&g
Hello,
Version:-
PostgreSQL 12.1 (Debian 12.1-2) on x86_64-pc-linux-gnu, compiled by gcc
(Debian 9.2.1-22) 9.2.1 20200104, 64-bit
Log:-
2020-02-07 15:42:55 AEDT LOG: statement: SELECT COUNT(*) AS ps_count
FROM pg_prepared_statements WHERE name = 'AIT1581050529'
2020-02-07 15:42:55 AEDT ERROR:
Hello,
PostgreSQL 11.6 (Debian 11.6-2~sid1) on x86_64-pc-linux-gnu, compiled
by gcc (Debian 9.2.1-21) 9.2.1 20191130, 64-bit
Is there something awry with the pg_prepared_statements view?
This is the only row found and it is NOT created by the application.
namestatement prepare_time
Hello,
On Wed, 2019-10-23 at 20:33 +0200, Peter J. Holzer wrote:
>
> I grant that SQL NULL takes a bit to get used to. However, it is a
> core
> part of the SQL language and everyone who uses SQL must understand it
> (I
> don't remember when I first stumbled across "select * from t where c
> =
>
Hello,
On Sun, 2019-10-20 at 18:51 -0400, Andrew Dunstan wrote:
> On 10/20/19 4:18 PM, Tomas Vondra wrote:
> >
> >https://www.postgresql.org/docs/12/functions-json.html
> >
> > but that says nothing about how jsonb_set works with NULL values :-
> > (
>
>
> We should certainly fix that. I a
Hi,
On Thu, 2019-09-26 at 16:21 +0200, Marco Ippolito wrote:
>
> db:
> type: postgres
> datasource: host=localhost port=5433 user=fabmnet_admin
> password=password dbname=fabmnetdb sslmode=verify-full
>
>
> (base) marco@pc:~/fabric/fabric-ca$ fabric-ca-server start -b
> admin:adminpw
On Wed, 2019-09-25 at 10:12 +1000, Paul McGarry wrote:
>
> On Wed, Sep 25, 2019 at 5:44 AM Adrian Klaver <
> adrian.kla...@aklaver.com> wrote:
> >
> Andrew's function seems plausible and I need to find some time to
> test it, but I am slightly surprised there isn't a native way to get
> the o
On Thu, 2019-09-19 at 15:23 +0200, Matthias Apitz wrote:
> El día Thursday, September 19, 2019 a las 10:31:01PM +1000, rob stone
> escribió:
>
> >
> > https://www.postgresql.org/docs/11/auth-password.html
> >
> > Chapters 20.5 and 20.6 may give you more
Hello,
On Thu, 2019-09-19 at 12:30 +0200, Matthias Apitz wrote:
> Hello,
>
> Our software, a huge ILS, is running on Linux with DBS Sybase. To
> connect to the Sybase server (over the network, even on localhost),
> credentials must be known: a user (say 'sisis') and its password.
>
> For Sybase
Hello Howard,
On Sat, 2019-09-07 at 22:17 +, Howard Wells wrote:
> I have my php files in the web root, and the Postgres 10 logon
> credentials are in the php file. I want to put them outside the web
> root for security, because a malicious robot could easily read the
> credentials.
>
> Aft
Hello,
On Fri, 2019-08-16 at 07:39 -0400, stan wrote:
> First let me say a huge THANK YOU to all the helpful people that
> hanging out
> on this.
>
> I am changing from one type of work, going back to some database work
> for a
> project, as my old job was eliminated. I have made great progress o
Hello,
On Sat, 2019-08-10 at 14:53 -0400, stan wrote:
> I apologize for asking, what I suspect will turn out to be a newbie
> question, but I have managed to get myself quite confused on this.
>
> I am defining a view as follows
>
>
> CREATE OR REPLACE view purchase_view as
> select
> p
Hello,
On Thu, 2019-07-04 at 05:58 +, Dirk Mika wrote:
> Hi,
>
> if I add the following check constraint to a table:
>
> ALTER TABLE public.times_places
>ADD CONSTRAINT ck_tp_ratified CHECK
> (ratified IS NULL OR (ratified IN ('Y', 'N')));
>
> It becomes the following when
On Tue, 2019-04-23 at 09:15 +0700, Soni wrote:
> I install the contrib module from the postgres repo using yum
> install.
> creating extension run as postgres superuser.
>
> Thanks,
> Soni
>
1) Is there a uuid-ossp.control file sitting in the $SHAREDIR/extension
path?
2) Does its name exist
Hello,
On Thu, 2019-02-21 at 13:10 +0900, s4...@yahoo.co.jp wrote:
> I am having hard time to connect to PostgreSQL server using client
> certificate from within a Java program.
> Any insight would be helpful.
>
> I can connect to the server using psql command line from a client
> machine(192.168
On Wed, 2019-02-13 at 05:32 -0700, PegoraroF10 wrote:
> is a sql FROM VALUES, why do you need tables ?
>
>
I can see that, however:-
ERROR: relation "col_diasaula" does not exist
Position: 7477
[SQL State: 42P01]
Is that a table, view or a missing CTE?
Hello Marcos,
On Wed, 2019-02-13 at 04:41 -0700, PegoraroF10 wrote:
> Here is a SQL which will get that recovery mode. You can run it on
> any database because we created it with FROM VALUES, so ...
> But this one is that one which grows and grows memory use until all
> memory and swap space are g
Hi,
On Sat, 2019-02-09 at 15:46 -0600, Justin Pryzby wrote:
> Hi,
>
>
>
> "segfault" seems to mean you hit a bug, which we'll want more
> information to
> diagnose. Could you install debugging symbols ? Ubuntu calls their
> package
> postgresql-10-dbg or similar. And start server with coredu
Olá Marcos,
On Mon, 2019-02-04 at 08:33 -0700, PegoraroF10 wrote:
> About replication ... Logical Replication with CREATE
> PUBLICATION/SUBSCRIPTION.
>
> Yes, some DDL commands were ran on that server but none of them were
> related
> with that select.
> Let me explain better. We have a single se
Olá Marcos,
> My original query, which worked for some days and then went to
> recovery mode
> was ...
If it was working and then ceased to function, did any of the following
occur:-
1) Postgres version changed?
2) OS version changed?
3) Schema changes affecting the tables/views used in your q
Hello,
On Fri, 2019-02-01 at 14:01 +, Brad Leupen wrote:
> Hello,
>
> We are using RLS on Postgres 11 to implement multi tenancy in our
> application. We have a tenant table whose id matches the tenant’s
> user role. Each table has a tenant_id FKA that defaults to
> “current_user”. All of ou
Hello,
On Mon, 2018-12-17 at 21:34 +0900, s4...@yahoo.co.jp wrote:
> Hello Good People of the Forum!
>
> I am trying to insert some data into a PostgreSQL database using PHP
> and struggling to create an array so that pg_copy_from function will
> accept and process the data.
>
> I can insert dat
Hello,
On Thu, 2018-12-06 at 21:29 -0800, Adrian Klaver wrote:
> On 12/6/18 7:54 PM, s4...@yahoo.co.jp wrote:
>
> Most GUI tools I am familiar with quote identifiers by default.
> > How/where can I tell the phpPgAdmin not to add that extra "" around
> > the
> > field name?
>
> I don't know. I h
On Tue, 2018-11-06 at 15:17 +0900, Michael Paquier wrote:
> On Tue, Nov 06, 2018 at 04:27:35PM +1100, rob stone wrote:
> > Logged in as user postgres and postgres owns the files created by
> > initdb, so is this a permissions problem or am I having a brain
> > fade?
>
Hello,
Trying to run pg_upgrade from version 10 to version 11 on the test
server and pulling the following error:-
could not open version file: /home/postgres/testing/data_v10/PG_VERSION
Failure, exiting
O/S is:- Debian 4.18.10-2 (2018-11-02) x86_64 GNU/Linux
Running pg_upgrade as user postgres
Hi
On Mon, 2018-09-24 at 10:46 +0100, Mark Williams wrote:
> Hi thanks,
>
> Sadly PHP and IIS isn't the issue. It’s when you bring Postgres into
> the fold that I am getting a problem. But thanks.
>
> Mark
>
>
I'm not a Windows user and no little about setting up Postgres using
IIS, but you mi
Hello
On Tue, 2018-08-28 at 08:32 +0200, Johann Spies wrote:
> I see this in /var/log/postgresql/postgresql-10-main.log:
>
> postgres postgres@template1 ERROR: could not open directory
> "pg_xlog": No such file or directory
>
> postgres postgres@template1 STATEMENT: SELECT count(*) AS segments
Hello,
On Tue, 2018-08-14 at 07:48 +, Jarosław Torbicki wrote:
> Hello,
> I used PostgreSQL 9.3 but I executed upgrade few days ago.
> Now, I am using 10.4 PostgreSQL and:
> doctrine/annotations v1.2.7
> doctrine/cache v1.4.2
Hello,
On Mon, 2018-07-30 at 09:01 +0300, vardenis pavardenis wrote:
>
> tadas@ubuntu:~$ dpkg -l | grep postgres
> ii pgdg-keyring
> 2017.3
>
Hello Bob,
On Sat, 2018-04-14 at 15:44 +0100, Bob Jones wrote:
> Hello,
>
>
>
> P.S. As a side-question, if anyone here has experience in using
> Postgres as a backend to PHP, are refcursors the way to go or should
> I
> be thinking of SETOF or other return styles ?
>
If you have a business
Hello,
On Fri, 2018-04-06 at 11:32 +0100, hmidi slim wrote:
> Hi,
> I have a table availability: id (integer), product varchar(255),
> period (daterange)
> I want to extract dates from a given period matching a given day.
> E.g: for the period from 01/04/2018 - 30/04/2018 and for day =
> Monday
Hello Blake,
On Tue, 2018-03-27 at 06:23 -0500, Blake McBride wrote:
> I should also mention that I am using PostgreSQL 9.3.22 on a 64 bit
> Linux box.
>
> On Tue, Mar 27, 2018 at 6:22 AM, Blake McBride
> wrote:
> > Hi,
> >
> > I have been using PostgreSQL for many years but all of a sudden a
>
o
alter eln.pl_id to a value that doesn't exist in pl.pl_id will cause an
exception to occur due to the constraint.
Cheers,
Rob
> commit;
>
>
> -- process 2:
> start transaction;
> update eln set pl_id = 3 where event_id = 303;
> update eln set pl_id = 2 where even
Hello Phil,
I've run your sample script on 9.6.5 and 10.3.
The only thing that I added was a commit; after the initial inserts
just to ensure the rows were saved.
No errors were reported for either version.
The output of \dp after running was:-
Access privileges
Hello Phil,
On Wed, 2018-03-21 at 15:26 +, HORDER Phil wrote:
> OK,
> Let's try again, with a full script, and including the bit that makes
> the difference…
>
> Hi,
> I’m trying to understand why I’m getting a deadlock issue, and how to
> work around it.
>
> At base, I think the problem i
Hello Phil,
On Tue, 2018-03-20 at 11:46 +, HORDER Phil wrote:
> Hi,
> I’m trying to understand why I’m getting a deadlock issue, and how to
> work around it.
>
> At base, I think the problem is:
> 1. Updates to a parent table are creating row level write
> locks,
> 2. updates to
Hello Marc-Antoine,
On Thu, 2018-03-15 at 10:43 +0100, Marc-Antoine Nüssli wrote:
> Hi there,
>
> I saw there was a question about a similar topic recently but my use
> case is quite different so there may be a different answer.
> Roughly, I have a database which is updated by a single stream of
Hi Gunnar,
On Mon, 2018-03-05 at 12:27 +0100, Gunnar Halvorsen wrote:
> Dear Sirs,
> As quite new in this discussiongroup I have red a lot about
> statement_timeout, but I can't find any answer on the following
> problem:
>
> My JavaEE-code responds the fpllowing Error message:
>
> Method
> or
Hi,
On Tue, 2018-02-13 at 14:28 +0530, Vinodh NV wrote:
> Hi,
>
> Require assistance on the below:
>
> Code snippet:
> Map ic;
> //Populate values for ic
> long count = ((BigDecimal)ic.get(“EB”)).longValue();
>
>
> Getting the below error:
> java.math.BigInteger cannot be cast to java.math
On Mon, 2018-02-05 at 11:26 +0100, Thomas Poty wrote:
> Hello,
>
> I m running 9.5.10 on centos 7.
>
> I have a colmun "TestFields", its type is an array of an enum.
>
> I would like to change the type of this column by an array of text.
>
> So i execute -> alter table "controldetailpromoter
On Tue, 2018-01-30 at 15:41 +0530, Abhra Kar wrote:
> Hi,
>Sorry for late reply. Below options I tried ---
> 1>pg_terminate_backend --> Successful execution.
> 2> Increase max_connection to 900 in
> /var/lib/pgsql/9.5/data/postgresql.conf .After modify restart psql
> service---
> servic
Hello,
On Fri, 2018-01-05 at 12:19 -0800, Adrian Klaver wrote:
> On 01/05/2018 11:57 AM, Travis Allison wrote:
> > Distro and version: Ubuntu 16.04 LTS.
> >
> > If memory serves, I installed 9.5 using synaptic and 9.6 using apt-
> > get,
> > where I followed the instructions from this site:
>
Hello,
On Tue, 2017-12-26 at 18:58 -0300, Alvaro Herrera wrote:Hello,
> David Steele wrote:
>
> > pgBackRest will validate all page checksums (including indexes,
> > etc.) in the
> > cluster during backup. Full backups check everything,
> > incr/differential
> > backups check only the files tha
On Wed, 2017-12-20 at 16:05 -0700, support-tiger wrote:
> can someone please help ?
>
> postgresql-10
>
> fedora 27
>
> our hba_conf that worked with pg 9x
>
> localall all postgrespeer
>
> hostallall 127.0.0.1/32 md5
>
> hostallall
On Mon, 2017-12-04 at 14:03 +1100, Bharanee Rathna wrote:
> To be more specific, I expected the output of both these queries to
> be the same.
>
> # select '2017-12-01 11:00:00 +11:00'::timestamp with time zone at
> time zone '+11:00';
> timezone
> -
> 2017-11-3
On Sun, 2017-12-03 at 23:18 +, Yuri Budilov wrote:
> Posted on Stack Overflow, sadly no replies, so trying here
>
> CREATE TABLE X AS
> SELECT json_array_elements(json_rmq -> 'orders'::text) AS order
> FROM table_name
> WHERE blah;
> I get out of memory error.
>
> Is there anything I c
67 matches
Mail list logo
