Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver <
adrian.kla...@aklaver.com> escreveu:
> test(5432)=# set role maura;
> ERROR: role "maura" does not exist
> test(5432)=# SET SESSION AUTHORIZATION 'maura';
> ERROR: role "maura" does not exist
>
> No, I was asking about an error occurring late
I'm working on an implementation of PostgreSQL 13.8 on a Linux RHEL8 sandbox
environment.
The server & PostgreSQL have all been configured.
I started PostgreSQL & got the following messages in the log file:
2022-09-16 02:00:16 EDT [1918984]: [3-1] db=,user= LOG: starting PostgreSQL
13.8 on x86
After working between Appeon for Powerbuilder and SAP for Sybase ASE 15.7, I
finally figured out the issue.
In the ODBC Driver Administrator, if I configure the postgres ODBC driver and
go to Datasource, the Max Varchar limit is 255 by default. I changed this to
1000 and now everything works.
## Hilbert, Karin (i...@psu.edu):
> 2022-09-16 02:00:16 EDT [1918984]: [7-1] db=,user= LOG: listening on Unix
> socket "/tmp/.s.PGSQL.5432"
> 2022-09-16 02:00:17 EDT [1918984]: [8-1] db=,user= LOG: test message did not
> get through on socket for statistics collector
> 2022-09-16 02:00:17 EDT
Christoph,
Thank you for your explanation.
That puts my mind at ease.
Regards, Karin
From: Christoph Moench-Tegeder
Sent: Friday, September 16, 2022 3:43 PM
To: Hilbert, Karin
Cc: pgsql-general@lists.postgresql.org
Subject: Re: New message in PostgreSQL log regar
I'm attempting to build the pgspider JDBC foreign data wrapper on MacOS, and
not having an enormously successful time. The driver source is at:
https://github.com/pgspider/jdbc_fdw
It (unsurprisingly) needs to link with libjvm.dylib, so I've included the path
to it in the PostgreSQL ./
Christophe Pettus writes:
> Has anyone encountered this situation (not libjvm in particular, just an
> external library using @rpath) during an extension build?
Yeah ... IIRC, I've hit that from trying to use the Apple-supplied
libpython to underlie PL/Python. I've not found a workaround. I su
> On Sep 16, 2022, at 14:20, Tom Lane wrote:
> IOW: I think they want you to get that from macports or homebrew instead.
> It certainly works a lot easier if you do.
Yeah, I installed openjdk8 using MacPorts, but it puts its stuff in a rather
idiosyncratic location. I guess it's "create-a-sy
Hi,
You can use log_line_prefix in postgresql.conf to log the user name into
the logs.
Regards,
Ganesh Korde.
On Fri, 16 Sep 2022, 6:31 pm Marcos Pegoraro, wrote:
> Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver <
> adrian.kla...@aklaver.com> escreveu:
>
>> test(5432)=# set role maura;
Hello,
My query is like this
Select a.field1, a.field2, a.field3From (Select a.field1, b.field2, c.field3
From table1 a Join table2 b on b.something =
a.something Join table3 c On c.something = a.something
Where a.field7 = 'value'
10 matches
Mail list logo
