atever action you
desire on a database whose only usage stipulation is that you maintain a
copy of the license.
--
Adrian Klaver
adrian.kla...@aklaver.com
nly fails against PostgreSQL 12.10, compiled by Visual C++ build
1914, 64-bit
Succeeds against PostgreSQL 9.4.1, compiled by Visual C++ build 1800, 64-bit
I don't see anything in the data\logs folder that looks relevant. Where
else should I look?
--
Adrian Klaver
adrian.kla...@aklaver.com
--+--+---
user1 | mydb | role=group_read_only
--
Adrian Klaver
adrian.kla...@aklaver.com
bases
directory. You can't, at the file(binary) level, just rip a database out
of one cluster and graft it into another.
If you want to do this then the options are:
1) As Ron suggested dump/restore.
2) Setting up logical replication.
--
Adrian Klaver
adrian.kla...@aklaver.com
esql.org/docs/current/sql-reassign-owned.html
--
Adrian Klaver
adrian.kla...@aklaver.com
configuration? I’m pretty sure that few configurations
were made to this database.
Is there a psqlrc file that has SET ROLE group_read_only;?
See the:
Files
psqlrc and ~/.psqlrc
section here:
https://www.postgresql.org/docs/current/app-psql.html
for more information.
Murillo.
--
Adrian
user1;
After that, it was possible to change the user password.
My question is: is that a normal behavior? should I, after a normal
loggin, be logged as
group_read_only as my current_user?
Something or someone is doing SET ROLE group_read_only.
Thanks in advance.
Murillo.
--
Adrian Klaver
On 11/16/22 12:51 AM, Matthias Apitz wrote:
El día Dienstag, November 15, 2022 a las 10:28:11 -0500, Tom Lane escribió:
Adrian Klaver writes:
On 11/15/22 04:28, Matthias Apitz wrote:
I have below the full ESQL/C log and do not understand, why the
PostgreSQL server is thinking "id
t:
create function testfunction() returns setof testfunction_result as ...
I'll try the type definition and see if that helps.
--
Adrian Klaver
adrian.kla...@aklaver.com
ut.
You could perhaps work around that by defining a named composite
type:
create type testfunction_result as (firstname character(30), ...);
create function testfunction() returns setof testfunction_result as ...
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
returns as a Memo field (similar to a Text field).
Any idea what I need to do to get it to return the character(30) type?
--
Adrian Klaver
adrian.kla...@aklaver.com
ent fields?
END;
$BODY$;
And I call:
SELECT * FROM public.testFunction();
SELECT firstname from FROM public.testFunction();
Then FirstName returns as a Memo field (similar to a Text field).
Any idea what I need to do to get it to return the character(30) type?
--
Adrian Klaver
pg_execute on line 543: query:
select name from pg_cursors where name = $1 ; with 1 parameter(s) on
connection testdb
So that query is being executed after the COMMIT.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/13/22 13:07, Tom Lane wrote:
Adrian Klaver writes:
INSERT INTO books VALUES (12, 0, CURRENT_TIMESTAMP)
ON CONFLICT (id)
WHERE updated IS NULL OR updated + INTERVAL '2min' < CURRENT_TIMESTAMP
DO UPDATE
SET version = books.version + 1, updated = CURRENT_TIMESTAMP;
I have n
2:32:01.476484
PST | f
I ran this on both version 14 and 15 with same results.
The question is why did the first case just ignore the WHERE instead of
throwing a syntax error?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/12/22 22:07, Tom Lane wrote:
Ron writes:
On 11/11/22 23:09, Adrian Klaver wrote:
2) For your explanation above, pg_dump from 9.4(5432) to pg_restore
12(5433) the issue would be ...\9.4\bin\pg_dump.exe of 9.4 and pg_restore
of said dump file to version 12. When moving up in version you
as to what copies meant and where they came from.
Not sure that this is actually pertinent to the problem at hand, I was
just trying to nail down the moving pieces.
I've since hijacked it and used it to restore to other versions.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/11/22 20:59, Brad White wrote:
On Fri, Nov 11, 2022, 9:57 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Yes. The backup is from production.
V9.4 is running on 5432 on all servers.
That particular restore happens to be on the dev server. 5433 is v12.
1) This
of the database
on one cluster. The above though shows you restoring to different
cluster(5433) then the cluster(5432) you dumped from.
Also why
"C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe
vs
$pgdir\pg_restore.exe
?
Is pgdir different from "C:\Program Files\PostgreSQL\9.4\bin\ ?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/11/22 14:06, Brad White wrote:
> Can you do a pg_dump of that database?
Yes. No visible problems. No errors reported.
From your original post, what did "Not the half dozen restored copies"
mean?
In other words define the restore process.
--
Adrian Klav
n you do a pg_dump of that database?
--
Adrian Klaver
adrian.kla...@aklaver.com
ace = t.oid ORDER BY 1;
ERROR: could not access status of transaction 22316920
DETAIL: Could not read from file "pg_clog/0015" at offset 73728: No error.
--
Adrian Klaver
adrian.kla...@aklaver.com
<https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal> pgadmin4
main #
disabled on upgrade to jammy
will retry shortly.
richard
On Thu, 10 Nov 2022 10:58:12 -0500 *Adrian Klaver
mailto:adrian.kla...@aklaver.com>>*
wrote ---
On 11
orts when i ask for one.)
What repo?
Have you run apt update on the repo?
What is the command you are using to do the upgrade?
wondering when the repo might get updated, or whether i should
be concerned about it at all.
thanks,
richard
--
Adrian Klaver
adrian.kla...@aklaver.com
ema and no objects
in other schemas. Rather, it's just the target for the "execute" privilege of those few of all the user-defined subprograms that
jointly define the database's API. The point (conforming to the principle of least privilege) is that sessions that connect as
"client" must not be allowed to do arbitrary SQL. Rather, they should be able to do only what has been explicitly
"white-listed" in by the encapsulation provided by the API-defining subprograms.
All right that I get.
--
Adrian Klaver
adrian.kla...@aklaver.com
recreated if necessary.
"
"postgres" is created by default for operational convenience, but is
not essential and can
be removed if you really want to.
Regards
Ian Barwick
--
Adrian Klaver
adrian.kla...@aklaver.com
l pursue this regime further.
Have you actually done that and tried to run SQL statements?
They are called system catalogs because they are used by the system to
get the information necessary to do things. Throwing restrictions on
their access would be akin to pouring sand in a gearbox, lots of strange
behavior and then nothing.
--
Adrian Klaver
adrian.kla...@aklaver.com
said that I failed to do?
--
Adrian Klaver
adrian.kla...@aklaver.com
ate role joe
nosuperuser
noinherit
nocreaterole
nocreatedb
noreplication
nobypassrls
connection limit -1
login password 'p';
create database d1;
revoke all on database d1 from public;
grant connect on database d1 to mary;
grant joe to mary;
*
Then I did this on the client machine:
*psql -h u -p 5432 -d d1 -U mary*
*set role joe;
*
Here, too, I ended up with "Joe" as the "current_user" and "d1" (to
which Joe cannot connect) as the "current_database()".
--
Adrian Klaver
adrian.kla...@aklaver.com
efore to you(Bryn Llewellyn).
A quick search:
https://www.postgresql.org/message-id/2176817.1644613...@sss.pgh.pa.us
https://www.postgresql.org/message-id/CAKFQuwayij=aqrqxjhfuj3qejq3e-pfibjj9cohx_l_46be...@mail.gmail.com
https://www.postgresql.org/message-id/cakfquwzvq-lergmtn0e3_7mqhjwtujuzf0gsnkg32mh_qf2...@mail.gmail.com
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
told, until now the
database did not restarted again... (not sure if it's coincidence)
I did not see that post or suggestion.
What was the suggestion?
Are you saying the database does not start up now?
--
Adrian Klaver
adrian.kla...@aklaver.com
upgrades, so that is a dead end.
--
Adrian Klaver
adrian.kla...@aklaver.com
messages issued at any point in below?
A: no errors during the dump and restore.
4) Are the database clusters on the same machine?
A: No, the origin and destination were different servers at the same VPC.
Are servers using the same version of OS?
--
Adrian Klaver
adrian.kla...@aklaver.com
etter, can you construct a self-contained test case?
regards, tom lane
--
<http://www.trimble.com/>
*Willian Cezar de O. Colognesi
*
Systems Analysis Specialist, Trimble Transportation Brazil
Avenida Santos Dumont, 271 | Londrina, PR | 86039-090
--
Adrian Klaver
adrian.kla...@aklaver.com
p postgres_fdw:
https://www.postgresql.org/docs/current/postgres-fdw.html
on local machine to point at table on remote machine and then \copy or
COPY to local machine.
2) Copy the CSV file to remote machine and then do \copy or COPY there.
--
Adrian Klaver
adrian.kla...@aklaver.com
orts of errors.
That's the beauty of using a VM and file backups (or snapshots). I
suppose this is to be expected.
Hence commitment instead of involvement.
*Can I declare victory, now, with the approach that I showed above?*
You are setting the goals not us, that is your decision.
p.s
rs that were reported and the nasty outcomes that I got when I
tried to use the new cluster. There's no useful doc for that approach
and I've already established that Internet search gets me nowhere. So
I'm inclined not to use it.
Per the saying, "In a ham and eggs breakfast the chicken is involved but
the pig is committed", right now you are involved in the Debian/Ubuntu
process not committed. Until you commit you will not get the results you
want.
Rather, I want, now, simply to declare victory with the script that I
showed and return to ordinary productive work.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/3/22 08:38, Post Gresql wrote:
On 2022-11-03 15:43, Adrian Klaver wrote:
On 11/3/22 07:28, Post Gresql wrote:
Hello
I first successfully ran
pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n
my_schema --no-owner -v my_db
but then
pg_restore --single-transaction -v -U
On 11/3/22 07:45, Ron wrote:
On 11/3/22 09:28, Post Gresql wrote:
Hello
I first successfully ran
pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema
--no-owner -v my_db
What was the *complete* pg_dump command?
I'm going to say the above.
--
Adrian K
version 10.19
Is there a solution for this (apart from upgrading to a newer PG version)?
Was there another error before this?
Did the -v show the schema my_schema being created?
The only workaround I can think of is to dump in plain text and then
edit the dump file.
--
Adrian Klaver
adrian.kla...@aklaver.com
r "pg_createcluster" as a wrapper for "initdb".
They can be used as intended, though you may end up with Postgres
clusters outside the place where the packaging expects them.
Yet, somehow, "systemctl start postgresql" happily manages to find my
customized config files in the location where I did the customization.
It's hard to imagine a more confusing design. What thinking underlies it?
Don't customize, use the provided tools. The idea behind all this is to
have the provided tools allow you to run multiple clusters of the same
version or different versions of Postgres concurrently and have the
tools take care of setting up the cluster data_dir and config_dir and
assign ports.
--
Adrian Klaver
adrian.kla...@aklaver.com
s), what is the intention of
this design? In other words, when is it proper to put an O/S user in the
"postgres" group? After all, if the answer is "never" than no privileges
on "postgres/postgres" files would ever have been granted to "group".*
*»*
--
Adrian Klaver
adrian.kla...@aklaver.com
/functions-event-triggers.html#PG-EVENT-TRIGGER-SQL-DROP-FUNCTIONS
9.29.2. Processing Objects Dropped by a DDL Command
Though this will not be specific to one table.
--
Adrian Klaver
adrian.kla...@aklaver.com
correct?
This also means that the only connections to the cluster will be done as
local, is that correct?
But when I'm working interactively, I might well allow myself to type
the bare minimum, on the fly, that gets the result.
--
Adrian Klaver
adrian.kla...@aklaver.com
when I set a NOT NULL password for the role—and so it
doesn't suit my purpose.
This, on the other hand:
psql -d postgres -U 'clstr$mgr'
calls for "local", "peer" authentication as so it does NOT require a
password. That would be enough for me. But, naturally, and now that it's
working. I prefer the Peter-inspired bare "psql".
Personally, I use longer forms like above as a form of explicit is
better then implicit. There are no end of posts to this list where the
issue was someone or something had changed a 'hidden' value in a env
variable or conf file could not connect or connected to wrong cluster
and/or database.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/30/22 09:16, Karsten Hilbert wrote:
Am Sat, Oct 29, 2022 at 09:15:08PM -0700 schrieb Adrian Klaver:
*# MAPNAME SYSTEM-USERNAME PG-USERNAME*
*# --- --- ---
bllewell mary mary
*
As has been said numerous times, it is
psql command line have "-U bob"
It is not possible to make an alias mapping work without specifying "-U"
on the psql command line. Period. The -U is precisely how you tell the
server you are using an alias - without it the server expects that the
o/s user is logging in using their own name as the requested login
role. In that case either a peer entry for the user exists - and thus
authentication is successful - or it doesn't - and authentication will fail.
+1
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
3) AS h(i);
E.
Sent with Proton Mail <https://proton.me/> secure email.
--
Adrian Klaver
adrian.kla...@aklaver.com
2.168.0.0/16 ident
map=omicron
pg_ident.conf and pg_hba.conf are two separate files and the only way
information gets from the former to the latter is if you explicitly
include the map name under METHOD for the the auth line.
--
Adrian Klaver
adrian.kla...@aklaver.com
database "usr" and granting "connect" on it to
"usr".) Then I could create a new session from the O/S prompt when
"whoami" shows "user" with the bare "psql"—just as I could the moment
after the PG install finished from the O/S prompt when "whoami" shows
"postgres".
I did think that I'd tried all this at the outset. But clearly I must've
missed one of those steps or done a typo.
--
Adrian Klaver
adrian.kla...@aklaver.com
sr.
The package installation set up an OS user postgres that runs the OS
side of the operation e.g the server code. It also by default uses that
same name as the database superuser when creating a new cluster. This
user then owns the SQL side. You can, however, change the SQL 'owner'
for new cluster as you did.
*Where can I read a nice, linear, soup-to-nuts acount of this whole
business that introduces, and that consistently uses, the proper terms
of art?*
--
Adrian Klaver
adrian.kla...@aklaver.com
LICT from here:
https://www.postgresql.org/docs/current/sql-insert.html#SQL-ON-CONFLICT
insert into table tbl select id, array[fid] from staging_table on
conflict(id) DO UPDATE SET fids = array_append(fids, excluded.fid);
I would test with a smaller example data set to vetify.
--
Adri
ation needed:
1) Postgres version?
2) What client reported that error?
3) What is the index creation statement you used?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/22/22 14:45, Ron wrote:
On 10/22/22 16:29, Adrian Klaver wrote:
To pseudo for me.
What file exactly is:
pg_restore --jobs=X --no-owner $NEWDB
restoring?
And how was that file created?
Knowing this might help get at why the more straight forward method
does not work.
This is what
On 10/22/22 14:02, Ron wrote:
On 10/22/22 12:00, Adrian Klaver wrote:
On 10/22/22 09:41, Ron wrote:
On 10/22/22 11:20, Adrian Klaver wrote:
On 10/20/22 14:34, Ron wrote:
On 10/20/22 10:02, Adrian Klaver wrote:
On 10/20/22 06:20, Ron wrote:
On 10/20/22 00:12, Tom Lane wrote:
I was
On 10/22/22 09:41, Ron wrote:
On 10/22/22 11:20, Adrian Klaver wrote:
On 10/20/22 14:34, Ron wrote:
On 10/20/22 10:02, Adrian Klaver wrote:
On 10/20/22 06:20, Ron wrote:
On 10/20/22 00:12, Tom Lane wrote:
I was afraid you were going to say that.
The work-around is to:
pg_dump $SRCDB
On 10/20/22 14:34, Ron wrote:
On 10/20/22 10:02, Adrian Klaver wrote:
On 10/20/22 06:20, Ron wrote:
On 10/20/22 00:12, Tom Lane wrote:
I ran "pg_dumpall --globals-only --no-role-passwords" on the source
instance, and applied it to the new instance before doing the
pg_restore. I
any kind. This is a single instance server which
alows certification login only.
I appreciate any help to figure this out.
Thanks & Regards,
Ertan
--
Adrian Klaver
adrian.kla...@aklaver.com
ost. Also to trim out material which was covered in
previous posts.
--
Adrian Klaver
adrian.kla...@aklaver.com
y head I can't
come with a replacement.
Thank you for your response!
On Fri, 21 Oct 2022 at 19:36, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 10/21/22 10:25 AM, Dionisis Kontominas wrote:
> Hello Adam,
>
> Thank y
be wrong. Please help me!
I suspect an index problem. Have you tried reindexing the source table,
kap.course if I am following correctly.
Have there been any issues with the database lately, e.g. crash or other
significant event?
The actual test view looks like this:
--
Adrian Klaver
retain the Tomcat+ORDS portion of the stack?
Thank you for your time!
Kindest regards,
Dionisis Kontominas
--
Adrian Klaver
adrian.kla...@aklaver.com
ndest regards,
Dionisis Kontominas
--
Adrian Klaver
adrian.kla...@aklaver.com
u run without --jobs?
4) What user are you running the pg_restore as?
5) Why the --no-role-passwords in the pg_dump?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/19/22 12:58 PM, Adrian Klaver wrote:
On 10/19/22 12:48, Mark Raynsford wrote:
On 2022-10-19T12:43:31 -0700
Adrian Klaver wrote:
HINT: There is an entry for table "t", but it cannot be referenced from
this part of the query.
HINT: There is a column named "x"
On 10/19/22 12:48, Mark Raynsford wrote:
On 2022-10-19T12:43:31 -0700
Adrian Klaver wrote:
HINT: There is an entry for table "t", but it cannot be referenced from
this part of the query.
HINT: There is a column named "x" in table "t", but it cannot be
referenc
cannot be referenced from
this part of the query.
insert into t (y) values (x * 2);
ERROR: column "x" does not exist
LINE 1: insert into t (y) values (x * 2);
^
HINT: There is a column named "x" in table "t", but it cannot be
referenced from this part of the query.
--
Adrian Klaver
adrian.kla...@aklaver.com
interpreter?
So type python and hit enter.
--
Adrian Klaver
adrian.kla...@aklaver.com
47bc70ba230c8b8.jpg&items=%5B%22jacktby%40gmail.com%22%5D>
--
Adrian Klaver
adrian.kla...@aklaver.com
e it
is the "main" connection.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/15/22 08:20, Adrian Klaver wrote:
On 10/14/22 21:46, Igor Korot wrote:
Making catalog current means switching between DBs.
Remember initially I connected to (finance) DB, which made the
(finance) catalog
current.
Then I "opened a second connection" to (finance_2021), which
the purposes of
making the data visible in the foreign tables in finance.
4) The client you did this did not 'leave' the finance database, so the
only information_schema you have access to is in the finance database.
I hope now its clearer.
Thank you.
David J.
--
ap&ia=web
jacktby
jack...@gmail.com
<https://maas.mail.163.com/dashi-web-extend/html/proSignature.html?ftlId=1&name=jacktby&uid=jacktby%40gmail.com&iconUrl=https%3A%2F%2Fmail-online.nosdn.127.net%2Fsm0518731fe949f1e7d47bc70ba230c8b8.jpg&items=%5B%22jacktby%40gmail.com%22%5
/issues in a message to this mailing list and see
if someone from EDB picks it up.
Thanks,
Anthony DeBarros
--
Adrian Klaver
adrian.kla...@aklaver.com
nsion days.
Regards
Thomas
--
Adrian Klaver
adrian.kla...@aklaver.com
power(10, -18::numeric);
power
0.
Why is the cast throwing off the result?
--
Adrian Klaver
adrian.kla...@aklaver.com
n the tables or indexes, causing cost estimates to change.
I will look into that and a couple of other ideas I got from this list.
regards, tom lane
Thanks
kostas
--
Adrian Klaver
adrian.kla...@aklaver.com
above link, an answer to this
question will be nothing more then guesses.
--
Adrian Klaver
adrian.kla...@aklaver.com
using psql:
https://fedingo.com/how-to-connect-to-postgresql-server-via-ssh-tunnel/
--
Adrian Klaver
adrian.kla...@aklaver.com
iage(writing for writing's sake) takes away from any
argument you are trying to make. Less is more. I have come to the point
where I ignore most of what you write as it really does not go anywhere
other then make noise.
--
Adrian Klaver
adrian.kla...@aklaver.com
#x27;round.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/6/22 1:54 PM, Ron wrote:
On 10/6/22 14:32, Adrian Klaver wrote:
On 10/6/22 10:46, Christophe Pettus wrote:
On Oct 6, 2022, at 10:44, Ron wrote:
Sadly, that VM doesn't have nearly enough disk space to hold the
backup folder.
Use file mode, and stream the output via scp/ssh
On 10/6/22 2:03 PM, Ron wrote:
On 10/6/22 14:35, Adrian Klaver wrote:
On 10/6/22 09:46, Ron wrote:
On 10/6/22 10:20, Tom Lane wrote:
Because installing new software on production servers requires
hurdles (Service Now change ticket approved by the application
support manager, Delivery
those hoops, yet you can move the data off site with no issue?
--
Angular momentum makes the world go 'round.
--
Adrian Klaver
adrian.kla...@aklaver.com
going EOL) server
2) Set up a 9.6.24 instance somewhere you have control.
3) pg_restore to it.
4) Then use pg_dump 13.8 on the new instance.
--
Adrian Klaver
adrian.kla...@aklaver.com
---+-
text | "$dog"
The way I see is if it where an actual identifier then this:
select * from quote_ident('$dog');
quote_ident
-
"$dog"
would be equal to this:
select * from "$dog";
n
---
--
Adrian Klaver
adrian.kla...@aklaver.com
gpass file:
foobar:5432:postgres:Allegedly.Strong.Password
foobar.example.com:5432:postgres:Allegedly.Strong.Password
But I'd rather have only one line. Is there any way to do that?
Would a service file:
https://www.postgresql.org/docs/14/libpq-pgservice.html
work?
--
Adrian Klaver
adrian.kla...@aklaver.com
function that inserts the conflicts to
another table and then UNION that table to the primary for query purposes.
--
Adrian Klaver
adrian.kla...@aklaver.com
magic—as a little memo for me:
postgres --single -D /usr/local/var/postgres postgres
The world that the "backend> " prompt opened up for me was rather basic.
Which is documented here:
https://www.postgresql.org/docs/current/app-postgres.html#APP-POSTGRES-SINGLE-USER
--
Why is the "array()" constructor not found in "pg_proc"? After all,
section 4.2.12 refers to "array_agg()" as a constructor. And that *is*
found in "pg_proc".
The only place I see array_agg in 4.2.x is 4.2.7. Aggregate Expressions.
--
Adrian Klaver
adrian.kla...@aklaver.com
a select statement—and in general
together with "group by".
Lack of an explicit GROUP BY falls through to an implied one:
https://www.postgresql.org/docs/current/sql-select.html#SQL-GROUPBY
"If there are aggregate functions but no GROUP BY clause, the query is
treated as
Constructors
"It is also possible to construct an array from the results of a
subquery. In this form, the array constructor is written with the key
word ARRAY followed by a parenthesized (not bracketed) subquery. For
example:
SELECT ARRAY(SELECT oid FROM pg_proc WHERE proname LIKE 'bytea%');
..."
--
Adrian Klaver
adrian.kla...@aklaver.com
le in that library.
In short: no way.
How is it random?
Are you saying that the ESQL/C session does not 'know' the search is
coming from the ILL connection?
Thanks
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/18/22 02:30, Matthias Apitz wrote:
El día jueves, septiembre 15, 2022 a las 08:40:24a. m. -0700, Adrian Klaver
escribió:
On 9/14/22 22:33, Matthias Apitz wrote:
El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian Klaver
escribió:
On 9/14/22 01:31, Matthias Apitz
On 9/16/22 06:00, Marcos Pegoraro wrote:
Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> escreveu:
test(5432)=# set role maura;
ERROR: role "maura" does not exist
test(5432)=# SET SESSION AUTHORIZATION 'maura';
5 PDT-0STATEMENT: select 1/0;
Ganesh is looking for psql- not psql-, in
this case psql-aklaver.
Regards,
Ganesh Korde.
On Fri, 16 Sep 2022, 6:31 pm Marcos Pegoraro, <mailto:mar...@f10.com.br>> wrote:
Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver
mailto:adrian.kla.
ing different then you will need to provide a more
detailed description of what that is.
Thanks
Marcos
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/14/22 22:33, Matthias Apitz wrote:
El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian Klaver
escribió:
On 9/14/22 01:31, Matthias Apitz wrote:
Where is the inter library software, in your application or are you reaching
out to another application?
The above
mple being swapped out or whatever).
Any ideas about this?
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
ocs/14/sql-altersubscription.html
https://www.postgresql.org/docs/14/sql-alterdatabase.html
Your best bet is to look at the commands listed here:
https://www.postgresql.org/docs/14/sql-commands.html
to check before using for first time.
--
Adrian Klaver
adrian.kla...@aklaver.com
1001 - 1100 of 3990 matches
Mail list logo