On Thursday, July 2, 2020, Anders Steinlein wrote:
>
>
>> Thanks for the tip, but I'm having a hard time thinking that's the case,
>> seeing as I'm unable to trigger the wrong result no matter how hard I try
>> with a new definition/manual query. I've introduced random ordering to the
>> first CT
On Thu, Jul 2, 2020 at 8:06 AM Anders Steinlein wrote:
> On Thu, Jul 2, 2020 at 3:55 PM David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Thursday, July 2, 2020, Anders Steinlein wrote:
>>>
>>>
>>> I just wanted to add that we
On Thu, Jul 2, 2020 at 8:44 AM Tom Lane wrote:
> A plausible explanation for how things got that way is that citext's
> equality operator wasn't in your search_path when you created the original
> matview, but it is in view when you make the new one, allowing that
> equality operator to capture t
On Thu, Jul 2, 2020 at 8:54 AM Jeremy Schneider wrote:
>
> https://www.postgresql.org/message-id/flat/CABTbUpiAOKZ405uArt8cJFtC72RhzthmvWETQK_6Qw0Ad-HquQ%40mail.gmail.com
>
> This thread on hackers actually seemed kindof short to me. Not nearly
> enough bike-shedding to call it a closed case.
>
On Monday, July 6, 2020, Michael Lewis wrote:
> Did you say you have an index on c1?
> [...]
> I don't know the data, but I assume there may be many rows with the same
> c1 value, so then you would likely benefit from getting that distinct set
> first like below as your FROM table.
>
Re-reading
On Monday, July 6, 2020, Sebastien Arod wrote:
> I would have expected postgresql to "share" a preliminary sort on c1 that
> would then be useful to reduce the work on all window functions but it
> doesn't.
>
The plan shown does share - the output of one sort goes into another.
Subsequent sorts
On Tue, Jul 7, 2020 at 4:41 AM Robert Inder
wrote:
> So how should I structure my chunks of SQL so that I can have "safe"
> (all-or-nothing) blocks,
> AND use them from within one another?
>
While there are more advanced constructs that may aid here I would suggest
just following two rules:
top
On Wed, Jul 8, 2020 at 8:18 AM Yorwerth, Adam
wrote:
> Is it possible for two transactions to interleave their issuance of these
> two variables?
>
>
>
> Is it possible for transaction 1 to be issued txid 1001 and offset 12 and
> transaction 2 to be issued txid 1002 and offset 11?
>
Given all of
On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe Chenel
wrote:
> Hi,
>
> I try to give userA privileges on userB objects and same thing to the
> userB, giving privileges on userA objects.
>
> Grant userB to userA; —ok
> Grant userA to userB; —error: role userB is already member of role userA
>
Crea
On Tue, Jul 14, 2020 at 8:15 AM Marc Millas wrote:
> select id, prenom from prenoms where id=ceiling(random()*2582);
>
> expecting to get, allways, one line.
> But its not the case.
> around 15% of time I get 0 lines which is already quite strange to me.
> but 10% of time, I get a random number o
On Tue, Jul 14, 2020 at 8:25 AM David Gasa i Castell
wrote:
> And my surprise went when I see the connection done while there is no user
> granted to connect the database...
>
https://www.postgresql.org/docs/12/ddl-priv.html
"""
PostgreSQL grants privileges on some types of objects to PUBLIC by
Please don't top-post. Inline (with trim) is better but at minimum
bottom-post.
On Tue, Jul 14, 2020 at 9:01 AM Marc Millas wrote:
> Hi,
> your answer helps me understand my first problem.
> so, I rewrote a simple loop so as to avoid the "volatile" behaviour.
> (at least I was thinking I did...
On Tuesday, July 14, 2020, Julie Nishimura wrote:
> Hello, we currently have 9.4 hot_standby master-slave pair. Going forward,
> we can keep only one server. How can I convert the system properly?
>
If you are keeping the primary you shouldn’t have to do anything. The
absence of a secondary ser
On Thu, Jul 16, 2020 at 1:24 PM Adrian Klaver
wrote:
> On 7/16/20 1:17 PM, Devraj B wrote:
>
> Please reply to list also.
> Ccing list.
> > Thanks Adrian,
> >
> > I had granted LOGIN to PostgreSQL user firstname.lastname but do Not
> > want to provide a database password,
> > rather I wanna acc
On Fri, Jul 17, 2020 at 7:49 AM Edmundo Robles wrote:
> To backup a database I do:
> nice -n +19 pg_dump -Fc database | nice -n +19 gzip --rsyncable -nc
> > database.dump
>
> If -Fc option is compressed by default I dont need gzip the backup,
> but I need pass --rsyncable and -n opti
On Fri, Jul 17, 2020 at 9:16 AM FOUTE K. Jaurès
wrote:
> It is make sense that PostgreSQL make too long to start, About 20
> minutes. I'm using PostgreSQL 12 intalling on Ubuntu Server 18.04 and my
> database is about 25 GO of data.
>
Every time? How are you shutting down the server?
Additio
On Sun, Jul 19, 2020 at 11:04 AM Abraham, Danny
wrote:
>
> Customer is using 10.4 , not 9.5.5.
>
> Does the same argument apply for upgrading to 10.12 ?
>
Running the current minor release of PostgreSQL is a pre-req when reporting
problems; moreso when it's largely impractical for someone else t
On Wed, Jul 22, 2020 at 8:24 AM Samuel Nelson
wrote:
> Is there a way to force the delete to cascade to tables in a specific
> order?
>
No really, but you can defer constraint checking.
https://www.postgresql.org/docs/12/sql-set-constraints.html
David J.
On Wed, Jul 22, 2020 at 9:03 AM Samuel Nelson
wrote:
> seems to fix it to work as we were expecting. Is that particularly
> costly? Should I only set the constraint to be deferred when we really
> need it? Would it be more efficient to perform the deletes explicitly
> within a transaction rath
On Wed, Jul 22, 2020 at 3:50 AM Andrus wrote:
> val function should return numeric value from string up to first non-digit
> character, considering first decimal point also:
>
> val('1,2TEST') should return 1.2
> val('1,2,3') should return 1.2
> val('-1,2,3') should return -1.2
>
>
On Wednesday, July 22, 2020, Emanuel Araújo wrote:
>
> \r
> \e
> -> Open temp file with the same last command "select 1;"
> is it right?
>
>
Documentation since v10:
Or, if the current query buffer is empty, the most recently executed query
is copied to a temporary file and edited in the same fa
On Wednesday, July 22, 2020, David G. Johnston
wrote:
> On Wednesday, July 22, 2020, Emanuel Araújo wrote:
>
>>
>> \r
>> \e
>> -> Open temp file with the same last command "select 1;"
>> is it right?
>>
>>
> Documentation s
On Thu, Jul 23, 2020 at 6:12 AM Michał Lis wrote:
> Hello,
>
> The server is located in the lan and runs on Windows 7x64 Ultimate.
> On this server I created pg_service.conf file and set the environment
> variable of PGSERVICEFILE.
>
The server software (postgres) doesn't use PGSERVICEFILE, only
On Tue, Jul 28, 2020 at 2:19 PM Ken Tanzer wrote:
> So here's my question. Will the upper_inc function always return false
> for a non-null daterange? And if so, what's the point of the function?
> And/or is it different for other kinds of ranges?
>
Ranges over discrete types are always canoni
On Mon, Aug 10, 2020 at 10:54 AM Shankar Bhaskaran
wrote:
> How does psql import the server certificate?
>
See:
https://www.postgresql.org/docs/12/libpq-envars.html
Namely the "PGSSL*" prefixed environment variables.
It works by default because both the server and client are usually
installed
The convention on these lists is to inline or bottom-post.
On Mon, Aug 10, 2020 at 11:11 AM Martin Gainty wrote:
> cant you use keytool ?
>
That wasn't the question, the OP already indicated they can do this
successfully in JDBC.
David J.
On Thursday, August 13, 2020, Naveen Kumar wrote:
> Can someone please give me an example on byteA data type.
>
> 1. How to import a image/text file into Bytea data type.?
> 2. How to export the same?
>
At a simple level its no different than importing and exporting character
data using a “text/
On Sun, Aug 16, 2020 at 10:11 AM Naveen Kumar wrote:
> *"PostgreSQL 12.3, compiled by Visual C++ build 1914, 64-bit"*
>
> I am just trying to practice LOB objects, like byteA data type, in
> PostgreSQL. Unfortunately, I didn't find good links regarding this so I
> raised the issue. Nothing else I
On Mon, Aug 17, 2020 at 12:53 PM David Gauthier
wrote:
> Looking at psql command line options, I see "-v" (lowercase) which is
> described as...
>
> -v assignment
> --set=assignment
> --variable=assignment
>
> Perform a variable assignment, like the \set meta-command. Note that you
> must separat
On Monday, August 17, 2020, David Gauthier wrote:
> OK, trying to piece together something that might work but I don't see the
> pieces falling into place.
> From the link you provided...
>
> "The most fundamental way to set these parameters is to edit the file
> postgresql.conf"
> So I'm fine wi
On Mon, Aug 17, 2020 at 5:46 PM David Gauthier
wrote:
> >> You lass in the $USER to you client software where it executes a
> post-connect hook SQL script populating a temp table with that value,
> usually via a function.
>
> A "post-connect hook SQF script" ?
> My (limited) understanding of this
On Mon, Aug 17, 2020 at 5:46 PM David Gauthier
wrote:
> Users will connect to the DB and then update a table using SQL at the
> prompt. And I want a post update trigger to identify who (linux user on
> the client side) just made that change.I was sort of hoping that this 8
> character string
On Tue, Aug 18, 2020 at 8:27 AM PASCAL CROZET <
pascal.cro...@qualis-consulting.com> wrote:
> I want to import XML file into PG database table.
> I've find functions to get the XML content of a cell after imported an XML
> file with the pg_get_file function.
> But, I want to explode the XML conten
On Wednesday, August 19, 2020, Laura Smith <
n5d9xq3ti233xiyif...@protonmail.ch> wrote:
> Hi,
>
> Let's say we've got a fairly basic table :
>
> create table networks (
> lan_id text not null,
> net_id text not null,
> port_id text not null
> );
> create index net_uniq on networks(lan_id,port_id);
On Wed, Aug 19, 2020 at 8:19 AM Laura Smith <
n5d9xq3ti233xiyif...@protonmail.ch> wrote:
> On Wednesday, 19 August 2020 15:09, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
> > On Wednesday, August 19, 2020, Laura Smith <
> n5d9xq3ti233xiyif...@p
On Wed, Aug 19, 2020 at 11:51 AM Pól Ua Laoínecháin wrote:
>
> I think my *MAJOR* problem is that I've developed what is,
> essentially, a totally brute force approach - and this simply won't
> work at the scenario becomes more complex - take a look at the CASE
> statement - it's horrible and wou
On Monday, August 24, 2020, harish supare wrote:
> Hi Team,
>
> Would like to know what the substitute/input variable available in psql.
>
>
> Oracle we use & - select a, b , c from table where a like &a;
>
> Is there an alternative in psql?
>
>
> Colon - read the documentation, psql section, fo
On Mon, Aug 24, 2020 at 7:21 AM harish supare
wrote:
> thanks for the reply David.
>
> In case of Colon I need to set the variable first, my requirement is my
> select query should prompt for the input.
>
>
Please don't top-post.
psql does not have a feature that will prompt users during the exe
On Fri, Sep 18, 2020 at 1:18 PM Igor Korot wrote:
> As I said - Access does it without changing the query internally (I
> presume).
>
> I want to do the same with PostgreSQL.
>
I suspect they basically do the equivalent of:
UPDATE ... WHERE CURRENT OF ;
https://www.postgresql.org/docs/12/sql-u
On Tue, Sep 22, 2020 at 6:34 PM raf wrote:
> Hi,
>
> I just wrote a query that I didn't expect to work but I
> was pleasantly surprised that it did. It looked
> something like this:
>
> select
> a.aaa,
> c.ccc,
> d.ddd1,
> d.ddd2
> from
> tbla a,
> tblb b,
> tblc c
The convention on these lists is to inline or bottom-post, please do not
top-post.
On Thu, Oct 1, 2020 at 10:41 AM Jonathan Strong
wrote:
> I've been away from coding for several years, but dusting off my chops and
> getting back up to speed with PostgreSQL (love it!). So please forgive me
> if
On Wed, Sep 30, 2020 at 7:41 AM Tom Lane wrote:
> If you really really need to do this, I'd counsel using EXECUTE to
> ensure no caching happens. But I concur with Michael that it's
> fundamentally a bad idea.
>
Agreed, though the documentation seems a bit loose here. The fact that the
temp ta
On Thursday, October 1, 2020, Fabio Pardi wrote:
> Hi Rama,
>
> On 02/10/2020 01:42, Rama Krishnan wrote:
>
> Hi Friends,
>
> By using pg bouncer can we split read and queries
>
>
> pgbouncer is just a connection pooler.
>
> The logic where to send the reads and where the writes, should be in our
On Fri, Oct 2, 2020 at 9:11 AM Eduard Català
wrote:
> If no one else gives an opinion I will open a bug for at least, force an
> update of the documentation.
>
It's been seen and begun to be discussed over on -hackers [1].
[1]
https://www.postgresql.org/message-id/flat/CA%2BHiwqFvkBCmfwkQX_yBqv
On Tue, Mar 3, 2020 at 4:19 PM David G. Johnston
wrote:
> On Tue, Mar 3, 2020 at 4:11 PM Adrian Klaver
> wrote:
>
>> On 3/3/20 3:06 PM, David G. Johnston wrote:
>> > On Tue, Mar 3, 2020 at 3:48 PM Adrian Klaver > > <mailto:adrian.kla...@aklaver.com>>
On Fri, Oct 2, 2020 at 1:43 PM Brajendra Pratap Singh <
singh.bpratap...@gmail.com> wrote:
> How can we create a user profile in open postgresql db?
>
?
CREATE TABLE user_profile (...);
INSERT INTO user_profile VALUES (...);
David J.
On Sunday, October 4, 2020, Robert Inder wrote:
> than shipping an empty file every few minutes?
>
The file is not empty. We’re talking 16 megabytes in a default setup...
David J.
On Monday, October 5, 2020, Robert Inder wrote:
> But the change Adrian Klaverd highlighted suggests that this is
> deliberately no longer the case,
> and I am left wondering what it does, in fact do/mean now.
>
“If no WAL has been written since the previous checkpoint, new checkpoints
will be s
On Monday, October 5, 2020, James B. Byrne wrote:
>
>
> I am so confused by this. I tried to do this:
>
> [root@accounting-2 ~ (master)]# psql -E --dbname=idempiere
> --username=idempiere_dbadmin --host=localhost
> Password for user idempiere_dbadmin:
> psql (11.8)
> Type "help" for help.
>
> i
On Monday, October 5, 2020, James B. Byrne wrote:
>
> idempiere(5432)=# alter role "idempiere_dbadmin" set search_path =
> 'adempiere,
> public';
> ALTER ROLE
> idempiere(5432)=# select current_schemas(true);
> current_schemas
> -
> {pg_catalog}
> (1 row)
>
> This does not look
On Fri, Oct 9, 2020 at 5:20 PM Yessica Brinkmann <
brinkmann.yess...@gmail.com> wrote:
> I am using Postgresql 8.3.23, I really use this version because the Index
> Adviser only works with this version of Postgresql.
>
I suggest first figuring out whether you are able to successfully install
the
On Sat, Oct 10, 2020 at 9:13 AM Olivier Leprêtre
wrote:
This has nothing to do with pgAdmin, or any other client interface.
In other words, a wrong query returns a valid result. This happens because
> v1 is a column from test1, (select vx from test2) will return an error as
> expected.
>
https:
On Wed, Oct 14, 2020 at 10:08 AM Atul Kumar wrote:
> Please share a clean example of installing, configuring and testing
> pgBouncer.
>
> Your official links are not organized so I need an example of
> PgBouncer with organized steps.
>
As I said on your exact same posting to the -admin list; not
On Monday, October 19, 2020, Atul Kumar wrote:
> Hi,
>
> I am configuring repmgr, so in postgresql.conf when i changed the
> parameter share_preload_libraries='repmgr', my database server is not
> starting.
>
> When i comment that parameter, database server started.
>
>
> Please help why that par
Moving this over to -hackers and the commitfest
https://www.postgresql.org/message-id/CAKFQuwaZjsaQ9KdDKjcwgGo3axg2t0BdBVYJiHf%3DH9nbvsxQbQ%40mail.gmail.com
David J.
On Thu, Oct 1, 2020 at 5:14 PM David G. Johnston
wrote:
> On Wed, Sep 30, 2020 at 7:41 AM Tom Lane wrote:
>
>> I
On Fri, Oct 23, 2020 at 8:47 AM Nikhil Benesch
wrote:
> Is there another option I'm missing? Would there be interest in
> extending split part so that negative indices counted from the end, as
> in:
>
> split_part('foo bar baz', ' ', -1) -> 'baz'
>
Some thoughts:
I'm torn here because this
On Mon, Oct 26, 2020 at 1:10 PM Rushikesh socha
wrote:
> Any suggestions on copying .json which is exported from couchbase
> using cbexport json. I used copy command but most of them are throwing
> error.
>
> pgdocstore=# copy schaname.tablename from 'path/filename.json';
> ERROR: invalid input
On Thu, Oct 29, 2020 at 9:16 AM Paul Förster
wrote:
> But I guess that Emacs shows the matching closing bracket at the beginning
> of the line, which matches that single tuple. But you also need a closing
> bracket for the set of tuples like this:
>
> insert ...
> (
> (v1, v2, v3),
> (v4,
On Thu, Oct 29, 2020 at 9:37 AM Rich Shepard
wrote:
> On Thu, 29 Oct 2020, David G. Johnston wrote:
>
> > That said seeing the first few rows, in addition to the last few, would
> > help.
>
> David,
>
> insert into organizations
> (org_nbr,org_name,org_url,
On Thu, Oct 29, 2020, 10:39 Rich Shepard wrote:
> On Thu, 29 Oct 2020, Rich Shepard wrote:
>
> > psql:organizations.sql:1926: ERROR: syntax error at or near ";"
> > LINE 1925: ...m',null,'Port','Opportunity',null);
> ^
> > I'm not seeing why that'
On Fri, Oct 30, 2020 at 9:03 AM David Gauthier
wrote:
> I was thinking of a pre-insert and pre-update trigger which could make the
> translation. But I'd rather not try to do this one char at a time...
> translate "..." today to fix today's issue, then "--" tomorrow when that
> pops up, then the
On Sun, Nov 1, 2020 at 11:54 AM Rich Shepard
wrote:
> When trying to populate the locations table I get this error:
> psql:locations.sql:2105: ERROR: syntax error at or near ";"
> LINE 2105: ...E Airport Way',null,'Portland','OR','97218',null,null,null);
>
On Thu, Nov 5, 2020 at 8:46 AM Tony Shelver wrote:
>
>
> -- Forwarded message -
> From: Tony Shelver
> Date: Thu, 5 Nov 2020 at 17:45
> Subject: Re: JSONB order?
> To: Christophe Pettus
>
>
> Thanks Christophe, that's what I thought.
> Just seemed weird that they were 'disordere
On Friday, November 6, 2020, Sri Linux wrote:
> Hi All
>
> I have to start Postgres 9.4.5 vacuum for our production environment. Got
> interrupted with the Linux session, is there a way I can monitor if the
> vacuum is progressing while I reconnect to the Linux box?
>
>>
>>>
Please start new emai
On Fri, Nov 6, 2020 at 2:34 PM Sri Linux wrote:
> Could you please provide me the link to start new questions?
>
>>
>>>
Assuming you are using Gmail...
https://business.tutsplus.com/tutorials/how-to-compose-and-send-your-first-email-with-gmail--cms-27678
David J.
On Friday, November 6, 2020, Sri Linux wrote:
> Added''
>
> when I log in to the Linux terminal and grep process, I can only see the
> single-user mode process running but not sure about vacuum status. I can't
> run a pg_stat commands from pgsql as the db is in single-user mode.
>
> ps -ef|grep
On Friday, November 6, 2020, Sri Linux wrote:
> Thank you David
>
> vacuum is done but the application is very slow, is this normal behavior?
> Will it run any background process after vacuum causing this slowness?
>
Please don’t top-post.
Are you still running under single-user?
David J.
On Friday, November 6, 2020, Sri Linux wrote:
> Thank you very much David,
> No, vacuum activity wiht single-mode user is completed. I restarted all
> services and the application is online but pretty slow.I will open a new
> case but confused about how to do a new post in the Postgres community.
On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hej...@gmail.com> wrote:
>
> How to set up a schema default date (now) to '2020-01-01'? Whatever
> timezone would be OK.
>
What is a "schema default" (date or otherwise)?
David J.
On Mon, Nov 9, 2020 at 1:33 PM Adrian Klaver
wrote:
> On 11/9/20 12:06 PM, Alvaro Herrera wrote:
>
> > If you have suggestion on how to improve the new format, I'm sure we can
> > discuss that. It seems pretty clear to me that we're not going back to
> > the old format.
>
> Improve it by going b
On Mon, Nov 9, 2020 at 1:41 PM Tom Lane wrote:
> Alvaro Herrera writes:
> > On 2020-Nov-08, Adrian Klaver wrote:
> >> Yeah, I would agree with the mobile first design comments. Then again
> that
> >> plague is hitting most sites these days. My 2 cents is it is a step
> >> backwards. You can cove
On Mon, Nov 9, 2020 at 2:01 PM Ron wrote:
> My suggestion is to add a "table of contents" at the top of non-trivial
> sections that simply lists available functions by name (generally ignoring
> argument variations) and a quick one line description of purpose. Once a
> person finds the name of t
On Mon, Nov 9, 2020 at 3:30 PM Ron wrote:
> On 11/9/20 3:05 PM, David G. Johnston wrote:
>
> On Mon, Nov 9, 2020 at 2:01 PM Ron wrote:
>
>> My suggestion is to add a "table of contents" at the top of non-trivial
>> sections that simply lists available fun
On Mon, Nov 9, 2020 at 10:21 PM mark armon <1994hej...@gmail.com> wrote:
> like I create a schema: test, I want the default date to 2020-01-01, so
> when I do
>
> select test.now;
>
> the result is 2020-01-01
>
That is not presently a feature that PostgreSQL implements.
While you can leverage pro
On Wed, Nov 11, 2020 at 10:49 PM Saurav Sarkar
wrote:
> We have a multi tenant application where for each tenant we create
> separate tables . So for e.g. if i have 100 tenants then i have 100 tables.
>
> Now we want to have encryption for the data in the tables with the tenant
> provided key. Is
On Fri, Nov 13, 2020 at 12:20 PM Kevin Brannen wrote:
> Go to the string funcs/ops page in v13, and try to quickly find the ones
> that return an "int" (because your goal is to find the position of
> something in a string so you know the return value will have to be an
> "int").
>
That is not so
On Fri, Nov 13, 2020 at 1:29 PM Edson Richter
wrote:
> "Range Partitioning
>
> The table is partitioned into “ranges” defined by a key column or set of
> columns, with no overlap between the ranges of values assigned to different
> partitions. For example, one might partition by date ranges, or b
On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver
wrote:
> Which is an indication that for changes of this scope it would be
> prudent to create a mock up and have end users see and comment on before
> rolling them out.
>
There were mockups and people did provide comments. Do you have any
concrete
On Fri, Nov 13, 2020 at 1:56 PM Maksim Fomin wrote:
> Later, I stopped the service and moved backup folder to the usual place.
> For some reason psql shows that there are no relations found in the
> database, although the database is listed. My next step was to copy data
> from file-system level
On Fri, Nov 13, 2020 at 2:08 PM Edson Richter
wrote:
> *De:* Tom Lane
> *Enviado:* sexta-feira, 13 de novembro de 2020 17:58
> *Para:* Edson Richter
> *Cc:* David G. Johnston ; pgsql-general <
> pgsql-gene...@postgresql.org>
> *Assunto:* Re: Range partitioning and o
On Sunday, November 15, 2020, Maksim Fomin wrote:
>
> > plsql -d tsvt
> psql (12.5)
> Type "help" for help.
>
> tsvt=# \dt+
> List of relations
> Schema | Name | Type | Owner | Size | Description
> +--+---+--+-+-
> public | te
On Sunday, November 15, 2020, Maksim Fomin wrote:
> ‐‐‐ Original Message ‐‐‐
> On Sunday, November 15, 2020 7:27 AM, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
> On Sunday, November 15, 2020, Maksim Fomin wrote:
>
>>
>> > plsql -d
On Sun, Nov 15, 2020 at 9:39 AM Adrian Klaver
wrote:
> On 11/14/20 8:24 PM, David G. Johnston wrote:
> > On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
> >
> > Which is an indication that for changes of this sco
On Sunday, November 15, 2020, Maksim Fomin wrote:
>
>
> ‐‐‐ Original Message ‐‐‐
> On Sunday, November 15, 2020 4:32 PM, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
> On Sunday, November 15, 2020, Maksim Fomin wrote:
>
>> ‐‐‐ O
On Mon, Nov 16, 2020 at 3:57 PM Atul Kumar wrote:
> I only have this one big table in the database of size 3113 GB with rows
> 7661353111.
>
> Right Now the autovacuum setting for that table is set to
>
> {autovacuum_enabled=true,autovacuum_vacuum_scale_factor=0.2,autovacuum_analyze_scale_factor=
(resending to include the list)
On Tue, Nov 17, 2020 at 3:12 PM Post Gresql wrote:
> create type my_type as my_table%rowtype;
>
This would be redundant with existing behavior - all tables have a
corresponding type already
create type my_type as my_table.my_column%type;
>
What does the indirec
On Wednesday, November 18, 2020, Snjezana Frketic <
frketic.snjez...@gmail.com> wrote:
>
>
> SELECT targeting#>'{targets,0,audienceSegments,0,includes,0,
> segments,allOf,0,ids}'FROM campaigns;
>
> and that works, but, I don’t want to have a fixed path because positions
> could change like 0 could
On Wed, Nov 18, 2020 at 1:33 AM Atul Kumar wrote:
> Hi,
>
> We have a table of 3113GB, and we are planning to vacuum it in non
>
Just making sure that isn't a typo (repeated 1s)...
business hours i.e. 12AM to 4AM, So my queries are:
>
> 1. What should be perform on the table Vacuum or Vacuum fu
On Wed, Nov 18, 2020 at 12:34 AM Post Gresql wrote:
> or even a complete table row as return type.
>
As mentioned, this is already possible.
> create type my_type (a int, b my_table.my_column%type);
>
> The real reason: you will be sure you are using the same type everywhere.
> And it is easier
On Wed, Nov 18, 2020 at 9:05 AM Stephen Haddock
wrote:
> It appears that 9.6 is able to run against the older cluster (DB service
> starts, queries work, etc)
>
If this is indeed what you've observed you've found a bug because a 9.6
service should not start at all if the data directory it is bei
On Wed, Nov 18, 2020 at 9:16 AM Adrian Klaver
wrote:
> On 11/18/20 8:05 AM, Stephen Haddock wrote:
> > Hello,
> >
> > When upgrading an older version of postgres, version 8.4 for example, to
> > a newer version such as 9.6, does the data have to be migrated
> immediately?
> >
> > It looks like th
On Wed, Nov 18, 2020 at 9:23 AM Snjezana Frketic
wrote:
> Unfortunately, I also can not update my version :)
>
Then probably the answer to your original question is no :)
There are possibly other ways to make something that works but if you
aren't willing to upgrade off of a discontinued versio
On Wed, Nov 18, 2020 at 9:30 AM Laurenz Albe
wrote:
> On Wed, 2020-11-18 at 11:05 -0500, Stephen Haddock wrote:
> > When upgrading an older version of postgres, version 8.4 for example, to
> a newer
> > version such as 9.6, does the data have to be migrated immediately?
>
> Since nobody mentione
On Wednesday, November 18, 2020, Post Gresql wrote:
>
> On 2020-11-18 17:07, Adrian Klaver wrote:
>
>
> \d cell_per
>Foreign table "public.cell_per"
> Column | Type| Collation | Nullable | Default | FDW
> options
> --+---+--
On Friday, November 20, 2020, Srinivasa T N wrote:
> Hi,
>I have the following in my log files:
>
> 2020-11-20 11:20:46.216 IST [38207] LOG: execute S_1/C_2: SELECT
> "gid",encode(ST_AsBinary(ST_Simplify(ST_Force2D("shape"),
> 14.929338247701526, true)),'base64') as "shape" FROM
> "ami_smart_
On Friday, November 20, 2020, Paul Förster wrote:
>
>
> > On 20. Nov, 2020, at 10:03, Thomas Kellerer wrote:
>
> >
> > select pg_is_in_recovery();
>
> I usually don't recommend using pg_is_in_recovery() only because a
> database cluster can be in recovery for other reasons. This is why I always
On Friday, November 20, 2020, Paul Förster wrote:
> Hi David,
>
> > On 20. Nov, 2020, at 10:34, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
> >
> >
> > On Friday, November 20, 2020, Paul Förster
> wrote:
> >
> >
On Fri, Nov 20, 2020 at 3:58 PM George Weaver wrote:
> What am I missing?
>
>
Release notes.
https://www.postgresql.org/docs/11/release-11.html
"pg_dump and pg_restore, without --create, no longer dump/restore
database-level comments and security labels; those are now treated as
properties of t
On Saturday, November 21, 2020, Hagen Finley wrote:
>
> I pull a new forecast spreadsheet each Monday. 80% of the records are the
> same as the existing records from the week before.
>
> Here’s what I (REALLY) want:
>
> Trigger looks at three fields prior to new insert: Deal ID (numeric),
> reven
On Saturday, November 21, 2020, Hagen Finley wrote:
> David,
>
> That's an interesting idea. I WOULD like to retain the OLD records that
> are the same and only INSERT new or changed records. Is there a way to
> compare the old and the new records without a trigger?
>
A where clause?
David J.
401 - 500 of 1642 matches
Mail list logo