Re: Getting wrong datetime in database using insert into table query.

On Tue, 2 Apr 2024 at 10:59, Saksham Joshi wrote: > OS: Windows 10 > Psycopg version: 2.9.9 > Python version: 3.11.6 > PostgreSQL version: 11 > pip version : 24.0 > 1: what you did > We are using 'psycopg2-binary' library to connect to my postgresql hosted > on Azure.We have created a table named

Re: replication primary writting infinite number of WAL files

On Fri, 24 Nov 2023, 17:12 Ron Johnson, wrote: > On Fri, Nov 24, 2023 at 11:00 AM Les wrote: > [snip] > >> Writing of WAL files continued after we shut down all clients, and >> restarted the primary PostgreSQL server. >> >> The order was: >> >> 1. shut down all clients >> 2. stop the primary >>

Re: Making Sure Primary and Secondary Keys Alligns

On Wed, 13 Sept 2023 at 17:30, Anthony Apollis wrote: > Yes in deed. > I am trying to make sure that the keys are aligned, but it doesnt update > or it simply shows NULL in Fact table, meaning its secondary keys. > > "-- Step 1: Drop existing foreign key constraint for Entity > ALTER TABLE system

Re: Determine if range list contains specified integer

On Fri, 27 May 2022 at 18:19, Andrus wrote: > Hi! > > > Product type table contains product types. Some ids may missing : > > create table artliik (liiginrlki char(3) primary key); > insert into artliik values('1'); > insert into artliik values('3'); > insert into artliik values('

Re: Sort question - Fractions, Metric etc

On Sat, 14 Aug 2021 at 19:03, Tom Lane wrote: > Adrian Klaver writes: > > On 8/14/21 9:37 AM, Bret Stern wrote: > >> I haven't explored doing this with numeric types, but some columns > >> needed alpha chars eg 13mm. > > > Two columns: > > > data_val(numeric) data_unit(varchar) > > 13

Re: insert ..... returning problem

On Thu, 24 Jun 2021 at 15:25, Michael Ivanov wrote: > Hallo, no. > > I am using postgres c library, namely I'm calling PQexec() > > Best regards, > > On 24.06.2021 16:14, Laurenz Albe wrote: > > On Thu, 2021-06-24 at 12:31 +0300, Michael Ivanov wrote: > >> I'm trying to insert a record returning

Re: PostgreSQL server does not increment a SERIAL internally

Hi Matthias, On Mon, 6 Jul 2020 at 11:43, Matthias Apitz wrote: > > Hello, > > Me and my team passed a full weekend hunting a bug in our Perl written > software were rows have been inserted with the same id 'acq_haushalt.hnr' > which should not have been the case because any budget year in that

Re: Table partitioning for cloud service?

Hi, On Thu, 21 May 2020 at 18:14, Christopher Browne wrote: > On Thu, 21 May 2020 at 11:53, Israel Brewster > wrote: > >> >> - Table-based tenancy (e.g. - each table has a "tenant_id" and queries > need to specify the tenant) > The database/schema per tenant solution can be tedious when you wa

Re: Estimated resources for a 500 connections instance (VM)

On Tue, 7 Apr 2020 at 21:52, David Gauthier wrote: > After looking at some of the factors that can affect this, I think it may > be important to know that most of the connections will be almost idle (in > terms of interacting with the DB). The "users" are perl/dbi scripts which > connect to the

Re: Another INSTEAD OF TRIGGER question

On Sun, 8 Mar 2020 at 15:31, stan wrote: > On Sun, Mar 08, 2020 at 10:29:09AM -0400, stan wrote: > > Still working on updateable views. > > > > Wish list item, a way to see the entire query that caused the trigger to > > fire. > > > > Now on to something i hope I can get. Can I see what the verb

Re: Invoice increment

On Wed, 26 Feb 2020 at 09:54, Søren Frisk wrote: > Hi all > > I'm trying to find a way to increment an invoice number. And i think it > would be pretty straight forward just using a SERIAL int. But as we're > selling across multiple countries, i need the invoice increment to be reset > by a count