Re: [EXTERNAL] Re: SSPI Feature Request

2024-07-10 Thread Ian Harding
. It would basically be a shared PostgreSQL role that members could connect as with their windows account Kerberos token. On Wed, Jul 10, 2024 at 8:03 AM Peter J. Holzer wrote: > On 2024-07-10 07:27:29 -0700, Ian Harding wrote: > > > > > > On Wed, Jul 10, 2024 at 7:10 AM Pet

Re: [EXTERNAL] Re: SSPI Feature Request

2024-07-10 Thread Ian Harding
On Wed, Jul 10, 2024 at 7:10 AM Peter J. Holzer wrote: > On 2024-07-09 03:35:33 +, Buoro, John wrote: > > I've dusted off my C books and coded a solution. > [...] > > When using SSPI you can grant access to a user by giving the login name > as > > firstname.lastname@SOMEDOMAIN for example. >

Re: Unable to find column

2024-01-15 Thread Ian Harding
On Mon, Jan 15, 2024 at 8:17 AM arun chirappurath wrote: > Dear all, > > I have a table automobile which has a column id. > > Table consists of id,make,year of manufacturing > > I use dbeaver for querying.. > > Select * from automobile provides me results > > However select id from automobile

Re: How different is AWS-RDS postgres?

2021-05-26 Thread Ian Harding
There is an option to send the logs to cloudwatch which makes it less awful to look at them. On Wed, May 26, 2021, 11:52 AM Ron wrote: > On 5/26/21 1:24 PM, Rob Sargent wrote: > > > My question is: > Should I be surprised that the initial bulk loaded table is nowhere to be > seen, given the

Re: statement_timeout issue

2018-05-05 Thread Ian Harding
On Fri, May 4, 2018 at 10:22 AM, Andres Freund <and...@anarazel.de> wrote: > Hi, > > On 2018-05-04 09:52:35 -0700, Ian Harding wrote: > > I know there are a lot of moving parts to this issue but I think I've > > eliminated most of them and the problem comes down

statement_timeout issue

2018-05-04 Thread Ian Harding
I know there are a lot of moving parts to this issue but I think I've eliminated most of them and the problem comes down to the postgresql server generating a statement_timeout error after 10 seconds when the connection statement_timeout is actually set to 15 minutes. My web server gets a

Re: AFTER UPDATE trigger updating other records

2018-01-26 Thread Ian Harding
On Thu, Jan 25, 2018 at 2:33 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Jan 25, 2018 at 3:06 PM, Ian Harding <harding@gmail.com> > wrote: > >> >> 4 |3 | Top.Bar.Blah >> 5 |4 | Top.Bar.Blah.Scooby &g

Re: AFTER UPDATE trigger updating other records

2018-01-25 Thread Ian Harding
On Thu, Jan 25, 2018 at 11:10 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, January 24, 2018, Ian Harding <harding@gmail.com> wrote: > >> >> -- This is not what I expect to see. I have even tried running the >> update >&g

Re: AFTER UPDATE trigger updating other records

2018-01-25 Thread Ian Harding
On Thu, Jan 25, 2018 at 10:51 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 01/24/2018 09:45 PM, Ian Harding wrote: > >> I have a conditional after update trigger on a table that issues an >> update statement on the same table. The trigger does not fire re

AFTER UPDATE trigger updating other records

2018-01-24 Thread Ian Harding
I have a conditional after update trigger on a table that issues an update statement on the same table. The trigger does not fire recursively, and I know the rows are being updated, but the update is not happening in the same way the statement does when run from outside the trigger.