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

On 16 Sep 2021, at 9:31, Gavin Flower wrote: > would assign the value of 42 to x. > Which brings up another topic, e.g., https://news.mit.edu/2019/answer-life-universe-and-everything-sum-three-cubes-mathematics-0910 > Never tried it, I now wish I had! > You could see if it’s accurately

Re: The tragedy of SQL

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 not intend to disparage anyone.  People,

Re: The tragedy of SQL

On Wed, Sep 15, 2021 at 7:31 PM FWS Neil wrote: > > Programmers create a dozens of new languages every 10 years or so. Only a > few have stood the test of time. SQL is one of those. For all its faults, > it still is amazingly powerful. > > Neil > www.fairwindsoft.com > > Dennis Ritchie was

Re: The tragedy of SQL

> On Sep 15, 2021, at 2:44 PM, Merlin Moncure wrote: > > On Tue, Sep 14, 2021 at 3:16 PM FWS Neil > wrote: >> >>> On Sep 14, 2021, at 11:10 AM, Michael Nolan wrote: >>> >>> I started programming in 1967, and over the last 50+ years I've programmed >>> in more

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

On 16/09/21 05:47, Michael Nolan wrote: When I was working at the help desk at the computer center as an undergrad, the professor in charge of that group used to give us interesting little language tests for things we needed to watch out for, especially with beginning programmers. One of his

Re: The tragedy of SQL

On Tue, Sep 14, 2021 at 3:16 PM FWS Neil wrote: > > > On Sep 14, 2021, at 11:10 AM, Michael Nolan wrote: > > > > I started programming in 1967, and over the last 50+ years I've programmed > > in more languages than I would want to list. I spent a decade writing in > > FORTRAN on a GA 18/30

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

On 9/15/21 11:52 AM, 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! MOVE

Re: Roles

Thanks alot On Wed, 15 Sep 2021, 07:36 Simon Riggs, wrote: > On Wed, 15 Sept 2021 at 00:11, Adrian Klaver > wrote: > > > > On 9/14/21 1:13 PM, Gambhir Singh wrote: > > > Hi, > > > > > > I'm having 4 Databases in the AWS RDS Cluster. Just wanna to know how > to > > > create roles which are

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

When I was working at the help desk at the computer center as an undergrad, the professor in charge of that group used to give us interesting little language tests for things we needed to watch out for, especially with beginning programmers. One of his favorite ploys was to use the EQUIVALENCE

RE: How to restore roles into new Database server?

Thank you, Thomas! -Original Message- From: Thomas Kellerer Sent: Wednesday, September 15, 2021 10:55 AM To: pgsql-general@lists.postgresql.org Subject: Re: How to restore roles into new Database server? EXTERNAL Sridhar Parepalli schrieb am 15.09.2021 um 15:53: > Hello Pros, > Is

RE: How to restore roles into new Database server?

Thank you, Adrian! -Original Message- From: Adrian Klaver Sent: Wednesday, September 15, 2021 10:13 AM To: Sridhar Parepalli ; pgsql-general@lists.postgresql.org Subject: Re: How to restore roles into new Database server? EXTERNAL On 9/15/21 6:53 AM, Sridhar Parepalli wrote: > Hello

RE: How to restore roles into new Database server?

Thank you! Ninad From: Ninad Shah Sent: Wednesday, September 15, 2021 10:11 AM To: Sridhar Parepalli Cc: pgsql-general@lists.postgresql.org Subject: Re: How to restore roles into new Database server? EXTERNAL This can be accomplished by taking a global dump. pg_dumpall utility has an option

Alter and move corresponding: was The tragedy of SQL

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 site that was banned as

Re: SQL queries as sets: was The tragedy of SQL

On Wed, Sep 15, 2021 at 12:55 AM Steve Litt wrote: > 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. I'll take a crack at this. Going through the setup will require a little patience, but I

Re: How to restore roles into new Database server?

Sridhar Parepalli schrieb am 15.09.2021 um 15:53: Hello Pros, Is there a quick way to create roles from database server to another db server? You can use pg_dumpall with the --globals-only parameter to create a SQL script that contains all roles from the source server

Re: Basic Questions about PostgreSQL.

On 9/14/21 10:10 PM, 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? Roles, groups and users have to do with project history more then anything

Re: How to restore roles into new Database server?

On 9/15/21 6:53 AM, Sridhar Parepalli wrote: Hello Pros, Is there a quick way to create roles from database server to another db server? pg_dumpall -g the_database -f globals.sql psql -d other_database -f globals.sql Though this will include other global objects e.g. tablespaces. See:

Re: How to restore roles into new Database server?

This can be accomplished by taking a global dump. pg_dumpall utility has an option "-g" to accomplish that. Regards, Ninad Shah On Wed, 15 Sept 2021 at 19:24, Sridhar Parepalli wrote: > Hello Pros, > Is there a quick way to create roles from database server to another db > server? > Regards,

How to restore roles into new Database server?

Hello Pros, Is there a quick way to create roles from database server to another db server? Regards, Sridhar Parepalli

Re: Basic Questions about PostgreSQL.

On Wed, 15 Sept 2021 at 06:10, A Z wrote: > -Is there a simple, immediate, straightforward way to temporarily disable > PostgreSQL database > use of all other users, except development users, or in fact just one user > (one developer, yourself) > so that maintenance on the data or the data

Re: SQL queries as sets: was The tragedy of SQL

On Wed, 15 Sep 2021, Steve Litt wrote: 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. SteveT, In the 1980s, when there were computer magazines such as Byte and Database Administrator (among

Re: SQL queries as sets: was The tragedy of SQL

> > 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

Re: Roles

On Wed, 15 Sept 2021 at 00:11, Adrian Klaver wrote: > > On 9/14/21 1:13 PM, Gambhir Singh wrote: > > Hi, > > > > I'm having 4 Databases in the AWS RDS Cluster. Just wanna to know how to > > create roles which are specific to each database, because when I'm > > creating roles in one Database, they

Re: Basic Questions about PostgreSQL.

rob stone writes: > On Wed, 2021-09-15 at 05:10 +, A Z wrote: >> -Is there a simple, immediate, straightforward way to temporarily >> disable PostgreSQL database >> use of all other users, except development users, or in fact just one >> user (one developer, yourself) >> so that maintenance

Re: SQL queries as sets: was The tragedy of SQL

I agree. I've always thought SQL was a great example of set theory put into practice. You specify the elements (select items) and conditions (where clause) to return the (sub)sets you want. Spatial data is also about sets - a polygon is theoretically defined as the set of points contained by

Re: Basic Questions about PostgreSQL.

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

Re: The tragedy of SQL

On Wed, Sep 15, 2021 at 8:31 AM Raymond Brinzer wrote: > > So, on a practical note: I'd like it if PostgreSQL supported > alternate languages for queries, as it does for stored procedures. I agree, and actually sent a patch some time ago to allow usage of third-party parser(s). They can