ltering the search_path setting.
Up until 5 minutes ago I did not have a ~/.psqlrc file. And there is no system
psqlrc file.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/5/20 9:46 AM, James B. Byrne wrote:
On Mon, October 5, 2020 12:08, Adrian Klaver wrote:
On 10/5/20 8:57 AM, James B. Byrne wrote:
On Mon, October 5, 2020 11:15, Adrian Klaver wrote:
Per Tom's post this does not make sense.
What if you connect doing?:
psql --dbname=idem
On 10/5/20 9:31 AM, James B. Byrne wrote:
On Mon, October 5, 2020 11:52, Adrian Klaver wrote:
That is the natural order of events. The database has to exist before
you can add an extension to it. Unless you are saying that you did not
build the extension until after the database was created
On 10/5/20 12:09 PM, James B. Byrne wrote:
On Mon, October 5, 2020 13:46, Adrian Klaver wrote:
The thing is, from upstream:
idempiere=# \df+ uuid_generate_v4
List
of
functions
Schema | Name | Result data type | Argument data types |
Type |
Volatility | Parallel
fact, have the Superuser privilege? This is
not something that I am conscious of having granted. For that matter, I first
would have to research the exact command syntax to carry it out.
Something in the installer must be doing something to the adempiere role, but I
cannot find where.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/7/20 6:01 AM, Ron wrote:
On 10/7/20 2:52 AM, WanCheng wrote:
Is same to the SemVer?(https://semver.org/)
It used to be, but starting with v10 it's
MAJOR
PATCH
Was it?
Pre-10 it was:
MAJOR.MAJOR.PATCH
--
Adrian Klaver
adrian.kla...@aklaver.com
where to migrate I would say create an independent
serial/identity column. Then point the dependent objects at that. After
all have been converted drop the old column.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/7/20 6:58 AM, Hemil Ruparel wrote:
Please reply to list also.
Ccing list
Yes. The id is stored as uuid. Thanks for the suggestion. Should work
On Wed, Oct 7, 2020 at 7:27 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 10/7/20 5:48 AM, Hemil Ruparel wrote:
On 10/7/20 6:53 AM, Magnus Hagander wrote:
On Wed, Oct 7, 2020 at 3:47 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 10/7/20 6:01 AM, Ron wrote:
> On 10/7/20 2:52 AM, WanCheng wrote:
>> Is same to the SemVer?(https://semver.org/)
>
-pgdg main 12
Thanks,
Nick
--
Adrian Klaver
adrian.kla...@aklaver.com
e either. Probably means one of the packagers will
need to chime in.
-Nick
--
Adrian Klaver
adrian.kla...@aklaver.com
packaging list:
https://www.postgresql.org/list/pgsql-pkg-debian/
FWIW, I am able to access older v12 libpq-dev by using the archive apt
list: https://apt-archive.postgresql.org/ -- so we will do that going
forward until this is resolved.
-Nick
On Wed, Oct 7, 2020 at 3:23 PM Adrian Klaver
as there. The problem
was the hide and seek with the search_path. The idempiere_dbadmin role
had a database setting that overrode the default search_path and
prevented non-schema qualified calls to the functions to fail for that role.
--
Adrian Klaver
adrian.kla...@aklaver.com
this page:
https://www.postgresql.org/download/linux/redhat/
Postgres 9.4.5 starts during startup .
Please help
Thanks
Deepthi
--
Adrian Klaver
adrian.kla...@aklaver.com
org/docs/current/typeconv-query.html
"... bpchar (“blank-padded char”, the internal name of the character
data type) ..."
--
Adrian Klaver
adrian.kla...@aklaver.com
mance (index usage?).
Or is
TO_TIMESTAMP('-12-31-00.00.00.00', '-MM-DD-HH24.MI.SS.US')
the only way? And isn't it possible to define this like NLS parameters in Oracle
system wide?
Thanks
Dirk
--
Adrian Klaver
adrian.kla...@aklaver.com
ackslash is a
psql meta-command that is processed by psql itself. These commands make
psql more useful for administration or scripting. Meta-commands are
often called slash or backslash commands.
"
\ commands are a psql feature, so they are potentially affected.
Thanks
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
no difference in CREATE DATABASE between 9.5 an 11. Can you
provide the command(s) you ran and the errors?
Laurent.
--
Adrian Klaver
adrian.kla...@aklaver.com
c
packages like "postgresql-11" instead of "postgresql". "
Best regards,
Hubert
--
Adrian Klaver
adrian.kla...@aklaver.com
try at
Contact here:
https://wiki.postgresql.org/wiki/Apt#Contact
Or by filing an issue here:
https://redmine.postgresql.org/projects/pgapt/issues
FYI, for the above you will need a community account.
Best regards,
Hubert
--
Adrian Klaver
adrian.kla...@aklaver.com
nthesis immediately in front of the semi-colon and
emacs
shows it matches the opening parenthesis.
Pretty sure the thinking is that the opening parenthesis is further
upstream, say around VALUES?
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
dealing with, but it
might be helpful to break them down into smaller batches to isolate the
problem.
Thanks,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/29/20 9:59 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Adrian Klaver wrote:
INSERT INTO products (product_no, name, price) VALUES
(
(1, 'Cheese', 9.99),
(2, 'Bread', 1.99),
(3, 'Milk', 2.99)
);
then you should have gotten a different error. S
o a syntax error?
Is orgs-1.sql just the INSERT?
How is that file being fed to psql?
Whew!
Stay well all ... and VOTE!
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/29/20 10:52 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Is orgs-1.sql just the INSERT?
Yes.
Is it just the 50 line version?
If it is, what happens if you go back to original 1925 line version and
correct the NULL issue in the line 26 and run it again?
How
server after making changes to pg_hba.conf?
Are you sure you are pointing at the right database?
What are the contents of your pg_hba.conf file?
Please help.
Regards,
Atul
--
Adrian Klaver
adrian.kla...@aklaver.com
'constraint_name';
Where you can find 'constraint_name' from:
\d locations
but this is wrong.
Trying 'alter table locations alter column loc_nbr drop constraint
unique;' also
failed.
What's the proper syntax to drop the unique constraint on a table column?
On 10/30/20 8:54 AM, Rich Shepard wrote:
On Fri, 30 Oct 2020, Adrian Klaver wrote:
It should be:
alter table locations drop constraint 'constraint_name';
Adrian,
Yes, I forgot to quote the constraint_name, And, I used the DDL name
'unique' rather th
now.us>
OpenStreetMap: Maps with a human touch
--
Adrian Klaver
adrian.kla...@aklaver.com
Every line prior to this one is terminated with a comma'
not colon.
I've not encountered this issue before. Where should I look for the error?
TIA,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
ew missing terminating parentheses and commas which were
fixed. I expected this last run to successfully complete.
Regards,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
someone turned an AV program
loose on this machine?
Thanks is advance,
Shani Israeli - Software Developer
+972 54 6689920
sisra...@illusivenetworks.com
www.illusivenetworks.com <https://www.illusivenetworks.com/>
--
Adrian Klaver
adrian.kla...@aklaver.com
. select * from table_1 where start_date between '1 Oct 2020' and '5
Nov 2020 23:59:59'
Run EXPLAIN ANALYZE(https://www.postgresql.org/docs/13/sql-explain.html)
on each and let us know.
--
Adrian Klaver
adrian.kla...@aklaver.com
he JSON object space,
you can't rely on the object keys being in a consistent order.
You'll want to have a step when ingesting the JSON object into a
report that lines up the key values appropriately with the right
presentation in the report.
--
-- Christophe Pettu
gent what is the job doing and when? Could it be it hasn't run
because it has not reached it's scheduled time.
Thanks,
Gabi
--
Adrian Klaver
adrian.kla...@aklaver.com
Regards,
Gabi
On Thu, Nov 5, 2020 at 11:34 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 11/5/20 1:07 PM, Gabi Draghici wrote:
>
> Hi,
>
> I have installed postgresql 12 on sles 15 for some tests. Now I'm
> interested in
now() AND (jobhostagent = ''
OR jobhostagent = 'dbdocs-prd') ORDER BY jobnextrun
2020-11-06 18:07:04.466 EET postgres postgres [2104]LOG: statement:
/*pga4dash*/
The above is from when you click 'Run now'?
Regards,
Gabi
--
Adrian Klaver
adrian.kla...@aklaver.com
lease.
Did full os restart for the DB server?
Thanks
Sri.
--
Adrian Klaver
adrian.kla...@aklaver.com
e the case. In PARALLEL mode, who knows?
In any case I would be dubious of any process that overwrites and
depends strictly on ordering to do the right thing. You are putting a
lot of confidence in the data in the CSV file being correctly ordered.
Thanks!
Leandro Guimarães
--
Adr
messages?
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_line_prefix = '%m %u %d [%p]: '
shared_preload_libraries = 'pgaudit' # (change requires restart)
pgaudit.log = 'write, role, ddl, misc_set'
pgaudit.log_catalog = on
pgaudit.log_client = on
pgaudit
581) (based on
LLVM 8.0.1), 64-bit'
Thanks for your help!
Sue
--
Adrian Klaver
adrian.kla...@aklaver.com
wrapper "stp_to_geo" does not exist
Looks like I need to study a bit more.
Sue
---
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hu...@brookhurstdata.com
Mobile: 314-486-3261
On 2020-11-07 14:51, Adrian Klaver wrote
/does_anyone_else_feel_like_the_v13_docs_are_a/
Yeah, I would agree with the mobile first design comments. Then again
that plague is hitting most sites these days. My 2 cents is it is a step
backwards. You can cover more ground quickly and digest it faster in the
old format.
Thomas
--
Adrian Klaver
adrian.kla...@aklaver.com
ks,
Yuriy Buzenets
--
Adrian Klaver
adrian.kla...@aklaver.com
tabase"?.in pg_hba.conf?
https://www.postgresql.org/docs/12/sql-createserver.html
---
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hu...@brookhurstdata.com
Mobile: 314-486-3261
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/9/20 12:06 PM, Alvaro Herrera wrote:
On 2020-Nov-08, Adrian Klaver wrote:
On 11/8/20 1:57 PM, Thomas Kellerer wrote:
In case someone is interested: there is a little discussion going on on
Reddit whether the new format of presenting functions in V13 is a step
backwards:
https
On 11/9/20 12:35 PM, Alvaro Herrera wrote:
On 2020-Nov-09, Adrian Klaver wrote:
If you have suggestion on how to improve the new format, I'm sure we can
discuss that. It seems pretty clear to me that we're not going back to
the old format.
Improve it by going back to old format
discover this in specific host.
Regards
Raul
--
Adrian Klaver
adrian.kla...@aklaver.com
he initdb for the 13 instance did not complete
successfully. Have you tried clearing /var/lib/pgsql/13/data and doing
the init over again? If you do try it monitor the output carefully.
I can’t use the dump/restore method to upgrade this server as the data in
question is fairly massive and in
On 11/13/20 7:02 AM, Jeremy Wilson wrote:
On Nov 13, 2020, at 9:58 AM, Adrian Klaver wrote:
To me it seems the initdb for the 13 instance did not complete successfully.
Have you tried clearing /var/lib/pgsql/13/data and doing the init over again?
If you do try it monitor the output
3)
Type "help" for help.
template1=#
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/13/20 8:19 AM, Jeremy Wilson wrote:
On Nov 13, 2020, at 11:06 AM, Adrian Klaver wrote:
When you manually run the pg_upgrade pg_ctl script the server starts but you
cannot connect to any database in it correct?
Yes.
What does pg_upgrade_server.log show when you do above
On 11/13/20 8:27 AM, Jeremy Wilson wrote:
On Nov 13, 2020, at 11:26 AM, Adrian Klaver wrote:
What shows up in the log file in "log" directory when you try to connect to a
database?
2020-11-13 10:14:35.821 EST [204797] LOG: starting PostgreSQL 13.0 on
x86_64-pc-linux-gnu, c
On 11/13/20 8:31 AM, Jeremy Wilson wrote:
On Nov 13, 2020, at 11:26 AM, Adrian Klaver wrote:
What shows up in the log file in "log" directory when you try to connect to a
database?
I did a completely fresh initdb to get clean logs:
Was the below from starting using the
On 11/13/20 8:37 AM, Jeremy Wilson wrote:
On Nov 13, 2020, at 11:35 AM, Adrian Klaver wrote:
On 11/13/20 8:31 AM, Jeremy Wilson wrote:
On Nov 13, 2020, at 11:26 AM, Adrian Klaver wrote:
What shows up in the log file in "log" directory when you try to connect to a
database
On 11/13/20 8:40 AM, Jeremy Wilson wrote:
On Nov 13, 2020, at 11:39 AM, Adrian Klaver wrote:
This does not show trying to connect to a database. It would help to list the
commands run and then the corresponding log portions.
bash-4.4$ "/usr/pgsql-13/bin/pg_ctl&q
On 11/13/20 9:12 AM, Jeremy Wilson wrote:
On Nov 13, 2020, at 12:06 PM, Adrian Klaver wrote:
Hmm. You can still connect if you use?:
/usr/pgsql-13/bin/pg_ctl -D /var/lib/pgsql/13/data/ -l logfile start
Same result.
bash-4.4$ /usr/pgsql-13/bin/pg_ctl -D /var/lib/pgsql/13/data/ -l logfile
On 11/13/20 11:20 AM, Kevin Brannen wrote:
From: David G. Johnston
On Mon, Nov 9, 2020 at 1:41 PM Tom Lane <mailto:t...@sss.pgh.pa.us> wrote:
Alvaro Herrera <mailto:alvhe...@alvh.no-ip.org> writes:
On 2020-Nov-08, Adrian Klaver wrote:
Yeah, I would agree with the mobile
b where the left/right
margins are so wide half of your screen is wasted instead of letting
the text flow and resize).]
It is just as bad it is so wide that one has to move their head instead
of just moving their eyes. If anything our tables could probably be
improved by enforcing a maxim
S_ROOT.jz" a value name: "Content Type" in
"Reg SZ" type and it's data is "text/javascript" .Previously there
was just"default" value name and it's data was "JSFile" Ihaven't
deleted this yet.
Thank you in advance for your help.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/14/20 8:24 PM, David G. Johnston wrote:
On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Which is an indication that for changes of this scope it would be
prudent to create a mock up and have end users see and comment on
.40GHz
x64
Thank you for your reply.
Ece
Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 15 Kas 2020 Paz, 03:08 tarihinde
şunu yazdı:
On 11/14/20 3:45 PM, Ecenur Corlu wrote:
> *I have just downloaded the latest version of PostgreSQL
(vs.13.1) and
Where did you d
On 11/14/20 8:24 PM, David G. Johnston wrote:
On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Which is an indication that for changes of this scope it would be
prudent to create a mock up and have end users see and comment on
On 11/15/20 9:00 AM, David G. Johnston wrote:
On Sun, Nov 15, 2020 at 9:39 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 11/14/20 8:24 PM, David G. Johnston wrote:
> On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver
mailto:adrian.kla...
; serially
The query I was executing was:
SELECT lower( f::text ) || lower( t::text ) FROM crashy_table
WHERE id = '16385'
via a plpgsql PERFORM.
Thanks,
Luca
--
Adrian Klaver
adrian.kla...@aklaver.com
has changed.
I looked at system logs but I couldn't find the relevant error log.
So, I downloaded PostgreSQL on somebody else's computer.
So did it work there?
If so what was OS and version on that computer?
Thank you, for your help. I really appreciate it.
Ece
Adrian Klav
al, 08:26 tarihinde şunu yazdı:
--
Adrian Klaver
adrian.kla...@aklaver.com
rly shut
down; automatic recovery in progress
2020-11-17 11:51:42.906 EST [96585] LOG: redo starts at E0/DB6B2960
2020-11-17 11:51:42.907 EST [96545] LOG: abnormal database system shutdown
2020-11-17 11:51:42.909 EST [96545] LOG: database system is shut down
—
So I’m assuming it’s that free() ca
not access
file "$libdir/plpython2": No such file or directory
I dropped PL/Python support along with PostgreSQL 13 RPMs.
This was announced where and when?
Regards,
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/17/20 12:49 PM, Devrim Gündüz wrote:
Hi,
On Tue, 2020-11-17 at 12:18 -0800, Adrian Klaver wrote:
This was announced where and when?
https://www.postgresql.org/message-id/333f3aa334ba93019c75fffaec373f2bf4275d28.camel%40gunduz.org
So to be clear what was dropped was plpythonu, which
On 11/17/20 1:23 PM, Tom Lane wrote:
Adrian Klaver writes:
It would be nice to mention this on --announce and here as this still
exists:
https://www.postgresql.org/docs/13/plpython-python23.html
You're confusing what the source code can do (which is what the
manual documents) versus
PY 2 support. This is
for PostgreSQL 13 only.
[1] :
https://www.postgresql.org/message-id/20200522080114.GA449430%40msg.df7cb.de
Regards,
--
Adrian Klaver
adrian.kla...@aklaver.com
placeholder, not sure how well that
would work in a created type.
Correct? It seems to be a feature for plpgsql programing only, right?
But wouldn't that be a good thing to be able to do? Or would it cause
too many problems?
Best regards
--
Adrian Klaver
adrian.kla...@aklaver.com
esql.org/docs/12/sql-altersequence.html
ALTER SEQUENCE people_person_nbr_seq RESTART 485;
TIA,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
ype;
Correct? It seems to be a feature for plpgsql programing only, right?
But wouldn't that be a good thing to be able to do? Or would it cause
too many problems?
Best regards
--
Adrian Klaver
adrian.kla...@aklaver.com
ons(10+) go
back to Postgres 8.0. You can dump the old server at anytime. The
important thing to remember is to dump the old server using the new
servers version of pg_dump. So in your case pg_dump(9.6) against
server(8.4).
Thanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
hanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/18/20 1:08 PM, Post Gresql wrote:
On 2020-11-18 17:07, Adrian Klaver wrote:
\d cell_per
Foreign table "public.cell_per"
Column | Type | Collation | Nullable | Default | FD
can do that by using the table
composite type. Since RETURNS TABLE is essentially an alias for RETURNS
SETOF you can use it to return a set of the table composite type. Though
in RETURNS TABLE you can also 'create' your own table that has nothing
to do with an existing table composite t
onnections."
Andreas
--
Adrian Klaver
adrian.kla...@aklaver.com
required by Postgres will
continue to be updated.
-Markus
--
Adrian Klaver
adrian.kla...@aklaver.com
he dump is
based on a snapshot. Said snapshot is based on visible transactions not
time. So for practical purposes they all occur at the same 'time'.
Thank you for any information you can provide!
dd
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/20/20 1:00 PM, Ron wrote:
On 11/20/20 2:56 PM, Adrian Klaver wrote:
On 11/20/20 10:01 AM, Durumdara wrote:
Hello!
We need to log the pg_dump's state.
What objects are in copy, and what are the starting and ending times.
But when I try to redirect the output, the result doesn&#
DATE. Also I thought when the values matched you did
not want INSERT?
Instead:
IF NEW.ndealid = OLD.ndealid AND NEW.revusd = OLD.revusd
AND NEW.stage = OLD.stage THEN
RETURN NULL; --Will cancel INSERT
ELSE
RETURN NEW;
END IF;
Hagen
Larimer County, CO
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/21/20 8:20 AM, Adrian Klaver wrote:
On 11/21/20 8:00 AM, Hagen Finley wrote:
Hello,
Instead:
IF NEW.ndealid = OLD.ndealid AND NEW.revusd = OLD.revusd
AND NEW.stage = OLD.stage THEN
RETURN NULL; --Will cancel INSERT
ELSE
RETURN NEW;
END IF;
Well this is what
On 11/21/20 8:47 AM, Adrian Klaver wrote:
On 11/21/20 8:20 AM, Adrian Klaver wrote:
On 11/21/20 8:00 AM, Hagen Finley wrote:
Hello,
Instead:
IF NEW.ndealid = OLD.ndealid AND NEW.revusd = OLD.revusd
AND NEW.stage = OLD.stage THEN
RETURN NULL; --Will cancel INSERT
ELSE
those
conditions?
Could we UPDATE the existing record (per my fledgling chk UPDATE and
then RETURN NULL? (More proof I don't know what I am talking about ;-).
The INSERT won't happen so I'm not sure what you want to check against?
Hagen
On 11/21/20 10:11 AM, Adrian Klaver wrot
n"
field and call insert on conflict (unique index) do nothing.
This should give the behavior you want.
--
Adrian Klaver
adrian.kla...@aklaver.com
only display the last result.
Regards
Muthukumar
--
Adrian Klaver
adrian.kla...@aklaver.com
JOB',
v_log_count);
COMMIT;
END;
$BODY$;
I'm still trying to figure out transaction management in procedures, so
bear with me. Not sure what the purpose of the second COMMIT is? Also
wonder if it is no the cause of the issue?
--
*Best Regards,*
Jagmohan
Senior Consultant, TecoreLabs.
--
Adrian Klaver
adrian.kla...@aklaver.com
need to achieve Same multiple result set in postgreSql.. Kindly advise me..
Regards
Muthukumar.GK
On Mon, Nov 23, 2020, 8:49 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 11/22/20 8:53 PM, Muthukumar.GK wrote:
> Hi Team,
>
> I have created
monitoring
not really processing.
Thanks in Advance for any help !
--
Adrian Klaver
adrian.kla...@aklaver.com
AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 11/24/20 6:36 AM, David Gauthier wrote:
> Hi:
>
> 11.3 on linux
>
> I've come up with a plan to archive data from my main DB which
involves
> creating other DBs
ts into a array and then run a 'FOR d in
dealids' LOOP to feed the FUNCTION parameter but I'd like to learn how
to do that with nested SQL statements or FUNCTIONS.
Thanks!
Hagen
--
Adrian Klaver
adrian.kla...@aklaver.com
en setting this up? Very curious to hear experiences from
the community when doing read/write and not just read from foreign sources.
Best regards,
--
Mats
CTO @ Dune Analytics
We're hiring: https://careers.duneanalytics.com
<https://careers.duneanalytics.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
-> Index Only Scan using
labels_address_id_type_name_key on labels labels_1 (cost=0.42..24068.85
rows=219145 width=31) (actual time=0.054..0.414 rows=201 loops=1)
Heap Fetches: 0
Planning Time: 0.102 ms
Execution Time: 12797.143 ms
Best,
--
Adrian Klaver
adrian.kla...@aklaver.com
e status too.
Before continuing with the function I would try some SELECT functions
that do what you want.
Does that articulate the thought process adequately?
Best,
Hagen
-Original Message-
From: Adrian Klaver
Sent: Wednesday, November 25, 2020 9:07 AM
To: Hagen Finley ; pgsql-gen
On 11/25/20 9:13 AM, Adrian Klaver wrote:
On 11/25/20 8:43 AM, ha...@datasundae.com wrote:
Adrian,
Until the previous questions are addressed the above is not doable.
3. Not positive the IF is doing what I want, but if I copy a
sfdc.dealid into the same_test() parameter field the
ls
GROUP BY 1
LIMIT 100;
down into something like this:
INSERT INTO foreign.labels (address, labels)
VALUES (), (), (), ();
postgres_fdw would send it as individual INSERTs?
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
trust
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
<https://www.cybertec-postgresql.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
1801 - 1900 of 4935 matches
Mail list logo
