Proposed French Translation of Code of Conduct Policy

The PostgreSQL Community Code of Conduct Committee has received a draft of the French translation of the Code of Conduct Policy updated August 18, 2020 for review. The English version of the Policy is at: *https://www.postgresql.org/about/policies/coc/

Re: The tragedy of SQL

My $5.00 on this discussion (quite fascinating and nostalgic actually). This is a little long granted, but it was fun. As someone who cut their IT in general and programmer teeth in particular on the HP 3000 platform, in the time (and a land) BEFORE SQL, where we had only a single database

pg_upgrade problem as locale difference in data centers

Hello, We want to upgrade some PG9.6 DB to PG13, the databases locale are different in data centers, some are C, some are ru_RU.UTF-8 and so on... as below postgres=# select datname,datcollate,datctype from pg_database; datname| datcollate | datctype

Re: The tragedy of SQL

On 9/16/21 6:29 PM, Guyren Howe wrote: [snip] Missing my original point here. The set theory is the _point_. SQL is a gargantuan distraction from using it efficiently. Imagine if COBOL was the only widely-available programming language with functions. You might use it, because functions are

Re: The tragedy of SQL

On 9/16/21 3:21 PM, Gavin Flower wrote: On 17/09/21 04:26, Michael Nolan wrote: In the same 1971 seminar where we studied Algol-68, we had to read and write a short paper on the 1970 Codd paper on relational  theory, which had only been out for about a year.  The professor running the seminar

Re: The tragedy of SQL

On 17/09/21 11:29, Guyren Howe wrote: [...] The set theory is the _point_. SQL is a gargantuan distraction from using it efficiently. Imagine if COBOL was the only widely-available programming language with functions. You might use it, because functions are really great abstraction for

Re: Alter and move corresponding: was The tragedy of SQL

On 17/09/21 11:22, Rob Sargent wrote: As far as alter, in 1981, before I became a programmer, I asked my Cobol Programmer friend if there was anything you could put in a program that would get you fired. He said yes, the alter statement :-). In my 3 semesters of Cobol, I never once used the

Re: autocommit for multi call store procedure

On Thursday, September 16, 2021, Trang Le wrote > > > Could you double check it? > We’re testing your failing code, not that PostgreSQL is working as intended. Suggest you get rid of all the stuff that doesn’t produce errors and focus on trying to supply a minimal script that produces the

Re: The tragedy of SQL

On 9/16/21 19:29, Guyren Howe wrote: Missing my original point here. The set theory is the _point_. SQL is a gargantuan distraction from using it efficiently. Imagine if COBOL was the only widely-available programming language with functions. You might use it, because functions are really

Re: The tragedy of SQL

Missing my original point here. The set theory is the _point_. SQL is a gargantuan distraction from using it efficiently. Imagine if COBOL was the only widely-available programming language with functions. You might use it, because functions are really great abstraction for programming.

Re: The tragedy of SQL

On Sep 16, 2021, at 7:31 , Merlin Moncure wrote: > > On Wed, Sep 15, 2021 at 7:31 PM FWS Neil wrote: >> On Sep 15, 2021, at 2:44 PM, Merlin Moncure wrote: >>> I think you ought to recognize that many people on this list make >>> money directly from managing that complexity :-). >> >> I did

Re: Alter and move corresponding: was The tragedy of SQL

As far as alter, in 1981, before I became a programmer, I asked my Cobol Programmer friend if there was anything you could put in a program that would get you fired. He said yes, the alter statement :-). In my 3 semesters of Cobol, I never once used the Alter statement. [...] I was very proud

Re: Alter and move corresponding: was The tragedy of SQL

On 16/09/21 04:52, Steve Litt wrote: Gavin Flower said on Wed, 15 Sep 2021 13:49:39 +1200 Hi Michael, [snip] COBOL has strange verbs like 'move corresponding' that could accomplish complicated tasks in a few lines but you have to be careful that you knew what you were asking for! In our

Re: The tragedy of SQL

On 17/09/21 04:26, Michael Nolan wrote: In the same 1971 seminar where we studied Algol-68, we had to read and write a short paper on the 1970 Codd paper on relational  theory, which had only been out for about a year.  The professor running the seminar noted that Codd proved that the

Re: Alter and move corresponding: was The tragedy of SQL

One of the grad students in the computer center had a sign on his wall: God is real, but Man is only an integer. -- Mike Nolan

Re: The tragedy of SQL

In the same 1971 seminar where we studied Algol-68, we had to read and write a short paper on the 1970 Codd paper on relational theory, which had only been out for about a year. The professor running the seminar noted that Codd proved that the relational model worked, but didn't guarantee that

Re: The tragedy of SQL

On Wed, Sep 15, 2021 at 7:31 PM FWS Neil wrote: > On Sep 15, 2021, at 2:44 PM, Merlin Moncure wrote: > > I think you ought to recognize that many people on this list make > > money directly from managing that complexity :-). > > I did not intend to disparage anyone. People, including myself,

Re: autocommit for multi call store procedure

On 9/16/21 12:36 AM, Trang Le wrote: Hi guys, I am using pgadmin4 to interact with Postgres database. For now I would like to run 2 store procedure (those have commit statement in begin end block). I enable autocommit and run call 2 store procedures at the same time. However, there is an

Re: The tragedy of SQL

Em 15/09/2021 21:55, Adrian Klaver escreveu: On 9/15/21 5:30 PM, FWS Neil wrote: On Sep 15, 2021, at 2:44 PM, Merlin Moncure > wrote: I think you ought to recognize that many people on this list make money directly from managing that complexity :-). I did

Re: autocommit for multi call store procedure

Have you used an EXCEPTION block in the procedure? Regards, Ninad Shah On Thu, 16 Sept 2021 at 13:06, Trang Le wrote: > Hi guys, > > I am using pgadmin4 to interact with Postgres database. For now I would > like to run 2 store procedure (those have commit statement in begin end > block). I

autocommit for multi call store procedure

Hi guys, I am using pgadmin4 to interact with Postgres database. For now I would like to run 2 store procedure (those have commit statement in begin end block). I enable autocommit and run call 2 store procedures at the same time. However, there is an error with invalid transaction termination.