HAVING query structured wrong

o how do I get all transactions for each case_pkey? I've read the documentation on WITH clauses (CTEs), but that just left my head spinning. Chuck Martin Avondale Software

Re: HAVING query structured wrong

On Mon, Feb 18, 2019 at 12:37 PM Andrew Gierth wrote: > >>>>> "Chuck" == Chuck Martin writes: > > Chuck> I am trying to create a query that returns all transactions for > Chuck> each person who has a balance over a given amount. I thought > Ch

crosstab function

EXTENSION IF NOT EXISTS tablefunc; but it did nothing. It doesn’t seem to work as import statements in Python do - Martin Mueller Professor emeritus of English and Classics Northwestern University

Re: crosstab function

26/19, 8:04 PM, "Adrian Klaver" wrote: On 2/26/19 5:51 PM, Martin Mueller wrote: > I run Postgres 10.5. I understand that there is something called > tablefunc and it includes a crosstab function. On Stack Overflow I learn > that you import this function. But

Re: Where to store Blobs?

I store them as bytea in the database despite the fact that there are benefits to storing them in the file system. The reason is that it is easier to secure access to the database than to secure both the database and provide secure access to the file system. Chuck Martin Avondale Software On

Re: software or hardware RAID?

screen. I never know if adding an HD to an exiting raid will wipe it or > maintain it. > 4) I setup smartctl to watch and report on drives. Even a 50% chance it > detects before failure is a net benefit. You cant always to that through > hardware raid > > You can always start with

Is it possible to have a cascade upwards query?

As per title, is this possible? Scenario being two tables with a linking pair of fields, where one table is a superset of the other and key is generated by the second table I would like to have the record in table two deleted when I delete the record in table 1 Thanks

analyze causes query planner to choose suboptimal plan for a select query in separate transaction

rows=1 width=8) (actual time=0.003..0.057 rows=1000 loops=100900) -> Seq Scan on a a8 (cost=0.00..5.00 rows=1 width=8) (actual time=0.003..0.057 rows=1000 loops=100900) Planning Time: 0.522 ms Execution Time: 81483.797 ms (36 rows) What do you think, is this intended behavior or a potential bug ? Regards, Martin *Martin Kováčik* *CEO* *redByte*, s.r.o. +421 904 236 791 kova...@redbyte.eu, www.redbyte.eu <http://redbyte.eu>

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

rwise fine select query. I was puzzled by this behavior back then but now it makes sense. *Martin Kováčik* *CEO* *redByte*, s.r.o. +421 904 236 791 kova...@redbyte.eu, www.redbyte.eu <http://redbyte.eu> On Thu, Apr 25, 2019 at 5:26 PM Michael Lewis wrote: > I assume it is in the docume

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

ooses wrong plans. *Martin Kováčik* *CEO* *redByte*, s.r.o. +421 904 236 791 kova...@redbyte.eu, www.redbyte.eu <http://redbyte.eu> On Thu, Apr 25, 2019 at 9:28 PM Michael Lewis wrote: > > > On Thu, Apr 25, 2019, 11:34 AM Martin Kováčik wrote: > >> Turning off autova

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

my own analyze after bulk insert as you suggested. Initially I thought that inside a transaction stats are automatically updated after the inserts because the query ran much faster than the query which was based on statistics with no rows. I did not realize the planner chooses a "default" pla

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

ion was it is isolated like other statements. *Martin Kováčik* *CEO* *redByte*, s.r.o. +421 904 236 791 kova...@redbyte.eu, www.redbyte.eu <http://redbyte.eu> On Thu, Apr 25, 2019 at 9:58 PM Adrian Klaver wrote: > On 4/25/19 12:47 PM, Martin Kováčik wrote: > > As my example shows y

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

I’ve got it now, thank you for the clarification. You are right. Martin Kováčik +421904236791 > On 26 Apr 2019, at 00:25, Adrian Klaver wrote: > >> On 4/25/19 1:28 PM, Martin Kováčik wrote: >> I'm not sure if I understand what you mean. My initial thought was that

Query not producing expected result

g the data comparison correctly, but don't know why. Chuck Martin Avondale Software

Re: Query not producing expected result

Thanks, guys. It should have been obvious to me, but wasn't. I found the correct result was returned with either AND event.DateTime <= 'May-1-2019 24:00' or AND event.DateTime::date <= 'May-1-2019' The latter seems best. Chuck Martin Avondale Software On W

Re: Query not producing expected result

;May 2, 2019' wouldn't it? I'm not sure one is easier to implement than the other. Chuck Martin Avondale Software On Wed, May 1, 2019 at 1:16 PM Francisco Olarte wrote: > Chuck: > > On Wed, May 1, 2019 at 6:56 PM Chuck Martin > wrote: > > Thanks, guys. It

Re: Query not producing expected result

(given the advice received here) inclined to check the value entered when searching for a date, and if no time is entered, add '24:00' to the date. Chuck Martin Avondale Software On Wed, May 1, 2019 at 1:32 PM Adrian Klaver wrote: > On 5/1/19 10:15 AM, Francisco Olarte wrote: > >

Re: Query not producing expected result

where I once lived). Chuck Martin Avondale Software On Wed, May 1, 2019 at 1:52 PM Francisco Olarte wrote: > On Wed, May 1, 2019 at 7:37 PM Chuck Martin > wrote: > > > > Something like daterange would be a solution in some circumstances, but > this query is a user-generated

Column type changed "spontanously"?

reSQL 9.3.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit" What other information would help solve this? Chuck Martin Avondale Software

INSERT where not exists with foreign key

work because the subquery returned more than one value. Of course I want it to return all values, but just one per insert. I can do this outside of Postgres, but would like to learn how to do this with SQL. Chuck Martin Avondale Software

a simple-minded question about updating

ment, which handles up to 10 million rows quite comfortably. A I right in thinking that given my tasks and equipment it would be a waste of time to update? Or is there something I’m missing? Martin Mueller Professor emeritus of English and Classiccs Northwestern University

Re: a simple-minded question about updating

I currently work with Postgres 13. I forgot to mention that. From which I gather that around version 18 it would be time to upgrade. But in the interim I’d be OK. Right? From: Adrian Klaver Date: Thursday, May 18, 2023 at 11:21 PM To: Martin Mueller , pgsql-general@lists.postgresql.org

a really dumb password question

grateful for advice. Martin Muelleer Professor emeritus of English and Classics Northwestern Univerrsity

update from 13 to16

data via Aqua Data Studio, as if they were very large spreadsheets. Is that a correct analysis? I just want to make sure. Martin Mueller Professor emeritus of English and Classsics Northwestern University

Re: Tips on troubleshooting slow DELETE (suspect cascades)

Add an index to parent_id. What is likely happening is each time a row is deleted, it has to scan the entire table to make sure it is not referenced by any parent_id records. On Thu, Jan 18, 2024 at 12:04 PM Jim Vanns wrote: > After dropping the constraint entirely the DELETE completes in 4 > m

Password complexity/history - credcheck?

obviously, but some indication of whether or not it's worth looking at first would be greatly appreciated. Is this something that the community would recommend? Many thanks! -- Martin Goodson. "Have you thought up some clever plan, Doctor?" "Yes, Jamie, I believe I have." "What're you going to do?" "Bung a rock at it."

Re: Password complexity/history - credcheck?

g at, but I'm not sure whether or not it is well adopted, reliable, and without significant issues. I only heard about it a few days ago from a friend/colleague, so I was wondering if anybody else was using it and what experiences with it might be. Regards, Martin. -- Martin Goodson.

Re: Password complexity/history - credcheck?

... until they went down and looked at what might have to be done, after which it all became very quiet ... Regards, Martin.

A simple question about text fields

Are there performance issues with the choice of 'text' vs. varchar and some character limit? For instance, if I have a table with ten million records and text fields that may range in length from 15 to 150, can I expect a measurable improvement in response time for using varchar(150) or will t

Problem with connecting with named host parameter

Hi I am getting the following error when I connect with hostname on localhost psql -h capture -U -p 5432 psql: error: FATAL: no pg_hba.conf entry for host "fe80::7285:c2ff:feb0:cd4%eth0", user "usevideo", database "usevideos", SSL off The hba.conf is local all all

Re: Problem with connecting with named host parameter

On Fri, 27 Aug 2021 at 15:00, Tom Lane wrote: > Mike Martin writes: > > I am getting the following error when I connect with hostname on > localhost > > > psql -h capture -U -p 5432 > > psql: error: FATAL: no pg_hba.conf entry for host > > "fe80::72

Re: The tragedy of SQL

javascript.. gross! Martin Ritchie *Geotab* Senior DBA Direct +1 (519) 741-7660 Toll-free +1 (877) 436-8221 Visit www.geotab.com Twitter <https://twitter.com/geotab> | Facebook <https://www.facebook.com/Geotab> | YouTube <https://www.youtube.com/user/MyGeotab> | LinkedIn <https://www

a very naive question about table names in Postgres

mapping and how can I query it? On what page of the documentation do I find the answer? I much prefer Postgres to Mysql for a variety of reasons, but mostly for its elegant string functions. But in Mysql it seems to be much easier to keep track of tables. Martin Mueller Professor emeritus of

Re: *subscribe

PLS unsubscribe via https://lists.postgresql.org/manage/ thx Am 20.11.2017 um 19:20 schrieb Rasha Osman: *From:* Yang, Xiaoguang *Sent:* 20 November 2017 18:16 *To:* pgsql-general@lists.postgresql.org *Subject:* unsub

To all who wish to unsubscribe

-- FERNAUSOFT GmbH Gartenstraße 42 - 37269 Eschwege Telefon (0 56 51) 95 99-0 Telefax (0 56 51) 95 99-90 eMail martin.fer...@fernausoft.de Internet http://www.fernausoft.de Handelsregister Eschwege, HRB 1585 Geschäftsführer: Axel Fernau, Ulrich Fernau, Martin Fernau Steuernummer 025 233 00041

Unsubscribe

Please unsubscribe me to all PostgreSQL mailing lists. Thanks and best regards [http://www.firmasdecorreo.com/dyndata/images/firmasdecorreo.com-2013-11-09_17:06:25_8847-02.jpg] ING. MARTIN PAREDES DOMINGUEZ MAPASAC & MAPASOFT ERP-SOFTWARE-DEVELOPER FREELANCE SE

a question about oddities in the data directory

table that I know as ‘earlyprinttuples With thanks in advance for any advice Martin Mueller Professor emeritus of English and Classics

Replication causing publisher node to use excessive cpu over time

% today) and having a big impact on the system performance even when doing very little. Logging on to the subscriber and removing the subscription sees this value drop to an expect small value. I can’t see that this can be anything but a bug, but happy for any thoughts :) Martin Moore

Re: Replication causing publisher node to use excessive cpu over time

OK, have installed perf and will report back when the problem gets noticeable. Martin. On 04/12/2017, 12:40, "Michael Paquier" wrote: On Mon, Dec 4, 2017 at 9:03 PM, Martin Moore wrote: > After a few days, it’s noticeable that the Postgres on the publisher node is con

a back up question

Are there rules for thumb for deciding when you can dump a whole database and when you’d be better off dumping groups of tables? I have a database that has around 100 tables, some of them quite large, and right now the data directory is well over 100GB. My hunch is that I should divide and conqu

Re: a back up question

. Is that likely in Postgres if you go from ~ 10 GB to ~100 GB? There isn’t any interdependence among my tables beyond queries I construct on the fly, because I use the database in a single user environment From: "David G. Johnston" Date: Tuesday, December 5, 2017 at 3:59 PM

Re: a back up question

On 12/6/17, 4:39 AM, "karsten.hilb...@gmx.net" wrote: On Tue, Dec 05, 2017 at 09:52:28PM +0000, Martin Mueller wrote: > Are there rules for thumb for deciding when you can dump a > whole database and when you’d be better off dumping groups of > tables?

Re: Deadlock between concurrent index builds on different tables

El 23/12/17 a las 08:08, Alban Hertroys escribió: > >> On 22 Dec 2017, at 22:53, Jeremy Finzel wrote: >> >> 2017-12-22 15:48:07.669 CST,"CREATE INDEX",2017-12-22 15:48:02 >> CST,8/32,0,ERROR,40P01,"deadlock detected","Process 4470 waits for ShareLock >> on virtual transaction 4/262; blocked by

Re: Deadlock between concurrent index builds on different tables

El 22/12/17 a las 18:53, Jeremy Finzel escribió: > I am attempting to build several indexes in parallel, guaranteeing that > I never build one on the same table twice.  I understand I can't build > two on the same table at once or I will get a deadlock.  However, I am > also getting a deadlock when

Re: Stand by server (9.6.6) with corrupt file

El 22/12/17 a las 10:29, Edson Carlos Ericksson Richter escribió: > Environment: PostgreSQL 9.6.6 installed from yum repository. Oracle > Linux 7 EL x64. Dell servers with Raid 5 (hw). > > > I was testing our database backup system (based on pgBarman), and > discovered that one base file is corru

Re: Does PostgreSQL check database integrity at startup?

El 26/12/17 a las 09:52, Edson Carlos Ericksson Richter escribió: > Recently I had a problem with a base file with size 0 in a standby server. > > This raised one question: does PostgreSQL (9.6.6) check base integrity > at startup? > > At least if there are 0 byte size files in base dir? Or CRC?

Re: Does PostgreSQL check database integrity at startup?

El 26/12/17 a las 14:46, Edson Carlos Ericksson Richter escribió: > > Usually, or by "pg_basebackup" or by "rsync" as described in PostgreSQL > Wiki. > Right now, I'm doing via pg_basebackup. > Nothing extraordinary. > > When using rsync: > > rsync -e "ssh -2 -C -p slave_ssh_port" --progress --p

Re: Find duplicates in a column then print Information to a file

ile: \COPY aria_precis TO '/home/sherman/aria_precis_2.csv' WITH DELIMITER '#,' CSV HEADER; Thank you; Sherman On the cmdline just do: psql arias -c ‘SELECT aria FROM aria_precis WHERE aria IN (SELECT aria FROM aria_precis GROUP BY aria HAVING COUNT(aria)>1)‘   > outfile.txt Martin.

Slow system due to ReorderBufferGetTupleBuf?

[.] ReorderBufferGetTupleBuf 6.14% postgres [.] ReorderBufferReturnChange When ReorderBufferReturnChange is no longer running: 14.35% postgres [.] ReorderBufferGetTupleBuf Can someone shed some light on this and advise how to prevent it reoccurring? Cheers, Martin.

Re: Slow system due to ReorderBufferGetTupleBuf?

On 01/01/2018, 17:45, "Peter Geoghegan" wrote: On Mon, Jan 1, 2018 at 8:56 AM, Martin Moore wrote: > Can someone shed some light on this and advise how to prevent it reoccurring? You're using v10, which has these two commits: https://git.postgr

Re: Slow system due to ReorderBufferGetTupleBuf?

On 02/01/2018, 12:09, "Martin Moore" wrote: On 01/01/2018, 17:45, "Peter Geoghegan" wrote: On Mon, Jan 1, 2018 at 8:56 AM, Martin Moore wrote: > Can someone shed some light on this and advise how to prevent it reoccurring?

Changing locale/charset

I created a 10.1 cluster on Debian using UTF8. I’d like to convert it to LATIN1, but am having various issues. So, it’s probably easiest to start again (I have a dump of the DB). To ensure I get it right, what is the correct way to create a cluster with LATIN1 encoding, how to remove the exist

Re: FW: Setting up streaming replication problems

r, at least, that's what's been working for me :) Even better, I guess, would be to not put a password in there at all and use a .pgpass. -- Martin Goodson "Have you thought up some clever plan, Doctor?" "Yes, Jamie, I believe I have." "What're you going to do?" "Bung a rock at it."

Re: FW: Setting up streaming replication problems

On 23/01/2018 18:08, Pavan Teja wrote: On Jan 23, 2018 11:34 PM, "Martin Goodson" <mailto:kaema...@googlemail.com>> wrote: On 23/01/2018 07:36, Thiemo Kellner, NHC Barhufpflege wrote: 1) I am not sure whether to put the md5 value of the repus

Re: pg 10.1 missing libpq in postgresql-devel

El 25/01/18 a las 17:20, support-tiger escribió: > running postgresql 10.1 on Fedora 27.  Cannot install ruby pg gem due to > missing libpq-fe.h file.  This is usually found in postgresql-devel but > it is not in fedora 27 postgresql10-devel. If install postgresql-devel > (9.6) the gem installs wit

Re: FW: Setting up streaming replication problems

a representative sample? What are you seeing in the standby logs when you start it? What are you seeing in the master's logs at the same time? M. -- Martin Goodson "Have you thought up some clever plan, Doctor?" "Yes, Jamie, I believe I have." "What're you going to do?" "Bung a rock at it."

Re: postgres for production

How much data do you have? That’s a fundamental thing to know. Martin. From: Azimuddin Mohammed Date: Wednesday, 31 January 2018 at 16:24 To: , Subject: postgres for production Hello, I have a question for postgres hardware requirement for production installation. My org want

Re: pgBackRest backup from standby

El 19/02/18 a las 17:53, David Steele escribió: > On 2/19/18 3:41 PM, Don Seiler wrote: > >> I'm curious, why even copy the pg_log logs? They aren't needed for >> database restore or recovery. > > Also, relocating the log directory is easy using the log_directory > setting, so that's what I recom

Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later

end is moved to a separate table linked by gid. This would also help the indexing. Martin. From: Alexander Farber Date: Wednesday, 21 February 2018 at 12:16 To: pgsql-general Subject: Not sure if I should CREATE INDEX for text columns on which I plan to filter later Hello, in a 2

Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later

My point was that your explain would be the same with indexes as without as they won’t be used. Martin. From: Alexander Farber Date: Wednesday, 21 February 2018 at 12:33 Cc: pgsql-general Subject: Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later

Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later

ill Moran That's very useful to know! Martin.

Re: Issue with Password Authentication for Pgpool

assuming you are implementing kubernetes kubectl exec -it $(kubectl get pods -l app.kubernetes.io/component=pgpool,app.kubernetes.io/name=postgresql-ha -o jsonpath='{.items[0].metadata.name}') -- pg_md5 -m --config-file="/opt/bitnami/pgpool/conf/pgpool.conf" -u "foo" "bar" //cat out pgpool af

an error message that I don't understand

I get this error message: table tid from new index tuple (32586,21) overlaps with invalid duplicate tuple at offset 120 of block 4398 in index "aacorrections_tcpreading_idx" from an update query of the update table 1 set columnx = ‘yes’ where table1.xmlid in (select xmlid from table2) I have no

Re: Why is an error not thrown when the time exceeds the lock timeout for an ExclusiveLock on a transaction ?

display server side postgresql.conf varables from postgresql.conf Server-Side Timeout Configuration: 1. 1. statement_timeout

rookie question about upgrade from 13 to 17

intelligible to others like me, and there may be some. With thanks in advance Martin Mueller Professor emeritus of English and Classics Northwestern University

Re: hardcode password in connect string

Hello David, I think so, the parameter you need in psql command is -w mipassword. But, you have to understand that use this form or set PGPASSWORD aren't safer. Exist a file (pg_hba.conf) for this process ir task. Regards Obtener Outlook para Android ___

Re: Can a broken Postgresql data directory be reconstructed without losing data?

You must to restore a database from a backup. Regards. Obtener Outlook para Android From: A A Sent: Sunday, April 15, 2018 5:25:05 AM To: pgsql-general@lists.postgresql.org Subject: Can a broken Postgresql data directory be reconstructed w

Databases and servers

Hi, I just discovered that a client has done this: They have two web applications A1 and A2. They have seperate hostnames/URLs. Both have a production and a test database A1p and A1t/ A2p and A2t. What they've done is have both A1p and A2p on the same actual databaser server and A1t and A2

SV: Databases and servers

On Tue, Aug 20, 2019 at 6:33 AM Karl Martin Skoldebrand mailto:ks0c77...@techmahindra.com>> wrote: Hi, I just discovered that a client has done this: They have two web applications A1 and A2. They have seperate hostnames/URLs. Both have a production and a test database A1p and A1t/ A

SV: Databases and servers

Från: Peter J. Holzer Skickat: den 20 augusti 2019 22:58 Till: pgsql-general@lists.postgresql.org Ämne: Re: Databases and servers On 2019-08-20 10:33:17 +, Karl Martin Skoldebrand wrote: > I just discovered that a client has done this: > >

integer square root function proposed

pes). I did not see an explicit enhancement request list in the PG mailing lists. Recommendations for a more specific list to post this to are welcome. Sincerely, Martin L. Buchanan software developer Laramie, WY, USA

Re: integer square root function proposed

. So something for you all to think about. Best wishes, Happy Channukah, and Merry Christmas, Martin L. Buchanan software developer and writer since 1976 Laramie, WY On Sat, Dec 17, 2022 at 8:20 PM Rob Sargent wrote: > On 12/17/22 19:39, Martin L. Buchanan wrote: > > Dear PostgreSQL c

Re: Intervals and ISO 8601 duration

docs.yugabyte.com/preview/api/ysql/datatypes/type_datetime/conceptual-background/#two-ways-of-conceiving-of-time-calendar-time-and-clock-time > > type interval_mm_dd_ss_t as (mm, dd, ss) > > https://docs.yugabyte.com/preview/api/ysql/datatypes/type_datetime/date-time-data-types-semantics/typ

Boyer-Moore string searching in LIKE, ILIKE, and/or POSITION?

s://www.postgresql.org/message-id/27645.1220635...@sss.pgh.pa.us . Sincerely, Martin L Buchanan senior software engineer Laramie, WY, USA

Re: RLS without leakproof restrictions?

r procedure that deals with tenant-specific data, is a headache that can also complicate queries and query plans. (Am speaking for myself as a PG developer for the last 2.5 years, not for my employer.) Sincerely, Martin L Buchanan Laramie, WY, USA

Recommendation for upgrading from PostgreSQL 9.3

existing application? Should we stop at 9.6 or go 10.x considering that 10.x seems almost about a year old, and 11.x is out there. I have limited experience with PG so far, but quite long experience with MySQL and OSS in general. Best regards, Martin Skjoldebrand

RE: Recommendation for upgrading from PostgreSQL 9.3

I found a note on logical replication in PostgreSQL 10.x with the caveat "There are also a number of caveats regarding what objects are actually replicated-for example, only tables are replicated, such objects as views and sequences are not." Does replication in 10.x now include views etc? We h

RE: Recommendation for upgrading from PostgreSQL 9.3

Thanks for your input. /M. Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement

RE: Recommendation for upgrading from PostgreSQL 9.3

Thanks, >https://www.postgresql.org/docs/10/release.html That's a massive list. But going for the first major release makes it manageable. > --- >To be more certain I would set up a dev database with the new version and test >against >that. Aye, we've got a production and a test server. We'r

Re: Watching for view changes

Hi, perhaps you can use triggers for some tables. Regards. Obtener Outlook para Android From: Mitar Sent: Saturday, December 22, 2018 1:21:49 AM To: Kevin Brannen Cc: pgsql-general@lists.postgresql.org Subject: Re: Watching for view changes

Re: insert into: NULL in date column

Hi, one question. Do you put explicit "NULL" in the column value? Other option is. You have to delete the column "next_contact" in your INSERT clause. So, if the column has a default value, this value Will be inserted. Else Null value will be inserted. Regards Obtener Outlook para Android

Re: insert into: NULL in date column

Hi, In MYSQL Null date is equal '01/01/1900' or '01/01/1970', I don't remember but you can also use the same logic for the check_constraint. Regards Obtener Outlook para Android From: Rich Shepard Sent: Saturday, January 12, 2019 1:54:47 P

RE: Connection issue

Hi, Can you do some tests in both (Mac and Windows ) ? * telnet {IP_Server} {5432} * ping {IP_Server} * tracert {IP_Server} Regards __ Saludos Ing. Ricardo Martín Gomez DBA - SysAdmin De: Adrian Klaver Enviado: martes, 5 de febrero

Re: Connection issue

Hi, Can you read the event viewer? Obtener Outlook para Android<https://aka.ms/ghei36> From: Adrian Klaver Sent: Wednesday, February 6, 2019 1:43:24 PM To: Maximilian Tyrtania Cc: Ricardo Martin Gomez; pgsql-general@lists.postgresql.org Subject: Re: Conn

Transactions

Hi, Is there a way to track "transactions" by default (i.e. without anyone having set up anything specific). The problem I am facing is that users are claiming that settings are disappearing with them doing anything to affect them. It would be good to be able to see what postgresql thinks is go

RE: Transactions

: 09 April 2019 11:41 To: pgsql-general@lists.postgresql.org Subject: Sv: Transactions På tirsdag 09. april 2019 kl. 11:26:29, skrev Karl Martin Skoldebrand mailto:ks0c77...@techmahindra.com>>: Hi, Is there a way to track “transactions” by default (i.e. without anyone having set up an

sequences

ce db_table_seq owner to dbnameuser; (all names obfuscated) To me it look like the only thing going is changing the ownership of the sequence. For unknown reasons. What is your impression the intention is with th

RE: sequences

Thanks for replies. I looked at some tutorial page and there were more instructions in that, so got confused. I was aware sequences create integers. //Martin S

Sequences part 2

be easy as I understood it? But can I achieve this: 1 Spain 2. Germany 3. France 4. Greece 5. Latvia 6. Cyprus 7. Ireland 8. Norway That is inserting records in the middle of the records, maybe even 1 Spain 2. Germany 3. France 4. Greece 5. Ireland 6. Norway 14. Latvia 24. Cyprus //Martin S

RE: Sequences part 2

Karl Martin Skoldebrand schrieb am 02.07.2019 um 12:44: > Looking more at sequences, I have some sequences that start with ID 1, > incrementing each record by 1. > > So I have e.g. 1 Spain 2. Germany 3. France 4. Ireland 5. Norway > > Now I want to insert more countries,

RE: Sequences part 2

t the moment. Either way it's not a quick fix for someone fairly inexperienced with PostgreSQL and having a couple of days to holiday. //Martin S Disclaimer: This me

Too short field

can I just go on running the app as is. Do we need to restart databases or something else that requires an interrupted service? Best regards, Martin S Disclaimer: This me

RE: Too short field

Thanks. That is what I thought - good to have a confirmation. Best regards, Martin S Disclaimer: This message and the information contained herein is proprietary and

RE: Too short field

Valid point. I've added that to the report. Best regards, Martin Skjoldebrand Disclaimer: This message and the information contained herein is proprietary

Please remove p...@mipta.com from the List

Please remove p...@mipta.com from the List Thank you Peter L Martin MIPTA ABN 74 843 345 087 p...@mipta.com <mailto:p...@mipta.com> Mobile Au: +61 (0)437 414 689 Todays problems will not be solved, if we think the same, as when we created them! - Albert Einstein Information i

Remove from distribution list

Please remove p...@mipta.com from the distribution list thank you Peter L Martin MIPTA ABN 74 843 345 087 p...@mipta.com <mailto:p...@mipta.com> Mobile Au: +61 (0)437 414 689 Todays problems will not be solved, if we think the same, as when we created them! - Albert Ei

<    1   2