On 10/18/19 7:18 PM, Ariadne Conill wrote:
Hello,
On Fri, Oct 18, 2019 at 7:04 PM Adrian Klaver wrote:
On 10/18/19 4:31 PM, Ariadne Conill wrote:
Hello,
On Fri, Oct 18, 2019 at 6:01 PM Adrian Klaver wrote:
On 10/18/19 3:11 PM, Ariadne Conill wrote:
Hello,
On Fri, Oct 18, 2019 at 5:01
9.6.15, you're 13 minor
versions (~30 months) of fixes behind. You might want to consider
upgrading ...
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/19/19 4:51 PM, Julie Nishimura wrote:
an entire cluster
*From:* Adrian Klaver
*Sent:* Saturday, October 19, 2019 4:34 PM
*To:* Julie Nishimura ; Tomas Vondra
*Cc:* pgsql-general@lists.postgresql.org
; pgsql
(select gid, played from word_moves where mid = 39146) AS m_id
ON
word_moves.gid = m_id.gid
WHERE
...
Thank you
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
n the above to me as I thought there are exception blocks
in stored functions and now sub-transactions in stored procedures.
--
Adrian Klaver
adrian.kla...@aklaver.com
net.
Taking Offline Backups is not the only right way to ensure Reliable
Backups.
We are way ahead of the days where you need to face downtime to take
backups.
Online Backups are reliable in PostgreSQL.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/21/19 12:50 PM, Tomas Vondra wrote:
On Mon, Oct 21, 2019 at 08:06:46AM -0700, Adrian Klaver wrote:
On 10/20/19 11:07 PM, Tomas Vondra wrote:
On Sun, Oct 20, 2019 at 06:51:05PM -0400, Andrew Dunstan wrote:
True. And AFAIK catching exceptions is not really possible in some code,
e.g
b -> 0 -> 'one';
pg_typeof | ?column?
---+--
text | 1
words_ru=> \i src/slova/dict/words_get_move.sql
psql:src/slova/dict/words_get_move.sql:28: ERROR: cannot cast type
jsonb to integer
LINE 17: (t.tile->'col')::int
are of the dependencies.
2) Are you using a home built method to populate the database?
In that case you take responsibility for dependencies.
--
Adrian Klaver
adrian.kla...@aklaver.com
t order by fld_1 ;
id | fld_1
+---
(0 rows)
test=# select * from trg_str order by fld_1 ;
fld_1
-
trigger_1_check_nocycle
trigger_1_update_fts
trigger_2
trigger_3
Is this how you want them to fire as it does not match what you say above?:
"The
/contrib-dblink-get-connections.html
dblink_get_connections — returns the names of all open named dblink
connections
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
ings are run on a higher level do something like:
pg_dump -Fc -d some_db -f db.out
pg_restore -l db_out > db_toc.txt
-l on pg_restore creates a TOC(table of contents) showing the ordering
of the schema recreation.
--
Adrian Klaver
adrian.kla...@aklaver.com
use the new data you inserted
after the restore was using PK values that overlapped the old data. That
is probably down to some script not starting at a value > max(PK).
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/22/19 1:35 PM, stan wrote:
On Tue, Oct 22, 2019 at 12:48:41PM -0700, Adrian Klaver wrote:
On 10/22/19 10:48 AM, stan wrote:
Please reply to list also:
Ccing list.
Sorry if my description was not clear.
No, we do not mix test, and production data. Let me try to clarify the
question
At:
https://www.postgresql.org/docs/11/functions-formatting.html
I would read the section starting :
"Usage notes for date/time formatting: ..."
several times. There a lot of 'if and or buts' in there.
--
Adrian Klaver
adrian.kla...@aklaver.com
1"
Behavior changed in v10:
https://www.postgresql.org/docs/10/release-10.html
"
Make to_timestamp() and to_date() reject out-of-range input fields
(Artur Zakirov)
For example, previously to_date('2009-06-40','-MM-DD') was accepted
and returned 2009-07-
-linux-gnu, compiled by gcc (SUSE Linux)
7.4.1 20190424 [gcc-7-branch revision 270538], 64-bit
(1 row)
test_(postgres)# select to_date('2018150X','MMDD');
ERROR: date/time field value out of range: "2018150X"
--
Adrian Klaver
adrian.kla...@aklaver.com
] stan@stan=[0m> \dt
Did not find any relations.
[1m[local] stan@stan=[0m> \q
]0;stan@smokey: ~stan@smokey:~$ exit
Script done on 2019-10-24 06:30:48-0400
quiting psql and reconecting shows that the obkects ARE there, with the
taks)instance table empty.
What am I doing wrong?
--
Adrian Klaver
adrian.kla...@aklaver.com
3.4.0-2pgdg.rhel6.x86_64.rpm etc. is
PostgreSQL extension and should be installed into PostgreSQL server.
Please use suitable one depending on PostgreSQL version presented by
"-pgXX"."
Regards
Vikas
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/24/19 7:32 AM, stan wrote:
On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote:
On 10/24/19 3:52 AM, stan wrote:
I have a very confusing isse. I am trying to backup and restre a signle
table .
first I dump the table.
Actually you are just dumping the table data.
More
On 10/22/19 8:26 AM, Andreas Joseph Krogh wrote:
På tirsdag 22. oktober 2019 kl. 17:12:59, skrev Adrian Klaver
mailto:adrian.kla...@aklaver.com>>:
[snip]
No.
When I sort the triggers I get:
test=# create table trg_str(fld_1 varchar);
CREATE TABLE
test=# inser
g-client.html
so it works for clients that connect to Postgres not just psql. I can
confirm it works with Access.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/24/19 2:58 PM, stan wrote:
On Thu, Oct 24, 2019 at 07:40:29AM -0700, Adrian Klaver wrote:
On 10/24/19 7:32 AM, stan wrote:
On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote:
On 10/24/19 3:52 AM, stan wrote:
I have a very confusing isse. I am trying to backup and restre a
n the .sql
file but have not before learned how/whether I can change a database name
using psql. What's the best approach to changing the existing hypephenated
name?
This?:
https://www.postgresql.org/docs/11/sql-alterdatabase.html
ALTER DATABASE name RENAME TO new_name
TIA,
Rich
-
er" statement 1
Not sure how that can be answered without knowing what ComputeComputer
is doing?
Thanks
Jacky
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/26/19 10:39 AM, Rich Shepard wrote:
On Sat, 26 Oct 2019, Adrian Klaver wrote:
That depends on how you ran pg_dumpall. For instance did you use -c?:
Adrian,
Yes. Always.
Then the question is, do you really want to overwrite the new database?
https://www.postgresql.org/docs/11/sql
On 10/26/19 1:39 PM, Rich Shepard wrote:
On Sat, 26 Oct 2019, Adrian Klaver wrote:
Then the question is, do you really want to overwrite the new database?
Adrian,
I want to overwrite the old databases with the new .sql file. I _think_
there's only one database that's ch
reaks, and does some formatting.
Development being done in an Ubuntu Linux environment.
Anyone have a recommendation?
http://sqlformat.darold.net/
https://sourceforge.net/projects/pgformatter/
--
Adrian Klaver
adrian.kla...@aklaver.com
ete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
--
Adrian Klaver
adrian.kla...@aklaver.com
es are in the
current search
> path.
> Is it possible to either have the definition always qualify all
tables
> independent of the search_path (or else provide a new column that
does
> that)?
Why don't you just change the search path to empt
Hong Kong, Italy, and Palestine.
This update also adds support for zic's new -b slim option to reduce the
size of the installed zone files, though it is not currently being used
by PostgreSQL."
cheers,
Chris
--
Adrian Klaver
adrian.kla...@aklaver.com
/obtain its timezone zone information and
how would this be updated?
As to where it gets its timezone info:
https://www.postgresql.org/docs/11/datetime-config-files.html
cheers,
Chris
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/5/19 3:00 PM, Chris Withers wrote:
On 05/11/2019 22:54, Adrian Klaver wrote:
On 11/5/19 2:46 PM, Chris Withers wrote:
Hi All,
Brazil recently abolished daylight savings time, resulting in updates
to system timezone information packages.
Does postgres use these? If so, does it need a
ission denied for schema public
How can this happen? I don't think I twiddled anything with schemas,
in fact I never used them in any way.
cheers,
PMc
--
Adrian Klaver
adrian.kla...@aklaver.com
ATION-PARAMETERS
https://www.postgresql.org/docs/11/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
If that does not help then post an example of what you are trying to do.
--
Adrian Klaver
adrian.kla...@aklaver.com
e that the whole wal sequence trail will be backuped? any
idea?
Probably best to ask the Patroni folks:
https://github.com/zalando/patroni#community
- Markus
--
Adrian Klaver
adrian.kla...@aklaver.com
e that the whole wal sequence trail will be backuped? any
idea?
Probably best to ask the Patroni folks:
https://github.com/zalando/patroni#community
- Markus
--
Adrian Klaver
adrian.kla...@aklaver.com
I have sued this, having
used pg_dump in the past. Database is fairly small with just one
tablespace if that matters.
Thanks for anyone's input.
--
Adrian Klaver
adrian.kla...@aklaver.com
y first and moved to tape
afterwards.
we got a case where Patroni switched back and forth sides quickly, e.g.:
12:00h: primary - standby
12:05h: standby - primary
12:10h: primary - standby
we realised that we will not have a wal backup of those wal's generated between
12:05h and 12:10h in this scenario.
how can we make sure that the whole wal sequence trail will be backuped? any
idea?
Probably best to ask the Patroni folks:
https://github.com/zalando/patroni#community
- Markus
--
Adrian Klaver
adrian.kla...@aklaver.com
bl_employees" ;
END;
$$ LANGUAGE plpgsql;
I can not create that because of inout parameters.
Another place;
do $$
DECLARE b integer = 1;
DECLARE d integer = 2 ;
BEGIN
select * from public."test"();
END;
$$;
Anybody have an idea ?
--
Adrian Klaver
adrian.kla...@aklaver.com
around looking for values within the range,
whereas the OP is looking for two discrete values. The two field method
you suggest above also encapsulates that.
--
Adrian Klaver
adrian.kla...@aklaver.com
icle.howto80775.html
Thanks.
Ross Boylan
--
Adrian Klaver
adrian.kla...@aklaver.com
-etl/tree/master/spark-postgres
--
Adrian Klaver
adrian.kla...@aklaver.com
s_dir('/home')) a;
count
---
2
(1 row)
SELinux (or equivalent) in play?
My postgres version is 11.5, running on Arch Linux.
--
Adrian Klaver
adrian.kla...@aklaver.com
way to copy the old Postgres server, dependencies, and
executables to our new server, in case the source was modified?
Brandon Ragland
Software Engineer
BREAKFRONT SOFTWARE
Office: 704.688.4085 | Mobile: 240.608.9701 | Fax: 704.973.0607
--
Adrian Klaver
adrian.kla...@aklaver.com
w query must generate the same
columns that were generated by the existing view query (that is, the
same column names in the same order and with the same data types), but
it may add additional columns to the end of the list. The calculations
giving rise to the output columns may be completely
On 11/14/19 7:12 AM, Tom Lane wrote:
Adrian Klaver writes:
On 11/14/19 5:53 AM, stan wrote:
I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
getting the following error:
ERROR: cannot change name of view column "descrip" to "contact_person_1"
Am
NOUT
"y"text)RETURNS TABLE("id"integer,"filesize"character
varying(36))AS$$BEGINRETURNQUERY
SELECT*FROMpublic."tbl_employees";END;$$LANGUAGE plpgsql;|
|I need to call table and inout parameters together at another place.|
Adrian Klaver <mailto:adrian.kla..
On 11/14/19 7:45 AM, Tom Lane wrote:
Adrian Klaver writes:
On 11/14/19 7:12 AM, Tom Lane wrote:
If you actually want to rename an existing view column, use
ALTER TABLE ... RENAME COLUMN ... for that.
Alright, I'm missing something here:
test=# alter table up_test rename COLUMN co
On 11/14/19 7:54 AM, Adrian Klaver wrote:
On 11/14/19 7:45 AM, Tom Lane wrote:
Adrian Klaver writes:
On 11/14/19 7:12 AM, Tom Lane wrote:
If you actually want to rename an existing view column, use
ALTER TABLE ... RENAME COLUMN ... for that.
Alright, I'm missing something here:
the same kind are defined for the same event,
they will be fired in alphabetical order by name."
Use appropriate naming or combine/nest the functions.
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
e ERROR. In other words run the
jsonb_array_elements() independently and then start adding them together.
Thanks,
Arup Rakshit
a...@zeit.io
--
Adrian Klaver
adrian.kla...@aklaver.com
!
What Linux distro and version?
How was Postgres installed?
Do you have more then one instance of Postgres installed?
Thanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
ot possible.
I am looking for some self-contained way in trigger or similar code.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/15/19 12:57 PM, John Lumby wrote:
Adrian Klaver wrote :
On 11/15/19 10:37 AM, John Lumby wrote:
Suppose the original statement is
UPDATE myview VW set VW.counter = 11 where VW.primary_key = and
VW.counter = 10;
and my trigger constructs this statement
UPDATE
On 11/15/19 1:54 PM, John Lumby wrote:
Adrian Klaver wrote :
Seems you are looking for Serializable Isolation Level:
True , that would solve the race condition, but it is too drastic.
We need to run with Read Committed.
I am looking for a solution which does not alter the application or
not the way i would like
to use, because it leads to more issues to solve (invalidation, for instance)
--
Adrian Klaver
adrian.kla...@aklaver.com
ROR: there is no unique constraint matching given keys for
referenced table "audit_p"*
The PK(UNIQUE constraint) on audit_logging.audit_p is:
"audit_pk1" PRIMARY KEY, btree (id, create_dtt)
You are only specifying id:
REFERENCES audit_logging.audit_p(id)
sd_tems
match at least one -t switch but no -T switches. If -T
appears without -t, then tables matching -T are excluded from what is
otherwise a normal dump.
Thank you
--
Adrian Klaver
adrian.kla...@aklaver.com
://www.postgresql.org/message-id/ofcecdfa08.38a13a4f-onc1256c5d.00544...@axxessit.no
--
Adrian Klaver
adrian.kla...@aklaver.com
misunderstanding on my part, i suppose.
NULL is a value so it should 'show' up.
Thank you for your help.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
e, only the
whole cluster.
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
e, only the
whole cluster.
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
bu.statusrech IN (0,1) )
GROUP BY ha.hnr;
The -L logfilename flag of psql is not sufficient enough. It logs only
the query and the final result.
client_min_messages?:
https://www.postgresql.org/docs/11/runtime-config-client.html#GUC-CLIENT-MIN-MESSAGES
Thanks
matthias
--
Adrian
ve the same name.
I would greatly appreciated any pointers to reference material on these
issues or advises on how to approach this.
Thank you in advance for your time.
--
Adrian Klaver
adrian.kla...@aklaver.com
you want to test password connection then use
a -h localhost to get a host connection.
--
Adrian Klaver
adrian.kla...@aklaver.com
I would like to be able to connect to my Ubuntu PostgreSQL server from
all Windows 10 machines as well as from a client on my Android phone
while away from home. That is my goal now. I am hoping that someone can
help me to get this working. This is been very frustrating.
--
Adrian Kl
On 11/21/19 8:12 AM, stan wrote:
Please reply to list also
Ccing list.
On Thu, Nov 21, 2019 at 07:56:10AM -0800, Adrian Klaver wrote:
On 11/21/19 6:35 AM, stan wrote:
If the 1st rule matches, I am thinking this will override any rule I put in
after such as:
local all postgres md5
Is my
only connect on the local
socket as the db postgres user if they are also the os postgres user.
You can work around that by having other users connect to the database
using a -h(host) connection that requires a password.
--
Adrian Klaver
adrian.kla...@aklaver.com
: Tom Lane
Sent: Thursday, November 21, 2019 02:42 PM
To: Jason L. Amerson
Cc: 'Steve Crawford' ; 'Adrian Klaver'
; 'PostgreSQL'
Subject: Re: Remote Connection Help
"Jason L. Amerson" writes:
Yes "listen_addresses" is not commented. I did n
What Postgres version did you install from source?
2) In /usr/local/pgsql/data what is the exact setting for
listen_addresses and port in postgresql.conf
sudo ./configure
--
Adrian Klaver
adrian.kla...@aklaver.com
.PGSQL.5432"
-2019-11-21 13:49:30.322 PST-0LOG: redirecting log output to logging
collector process
-2019-11-21 13:49:30.322 PST-0HINT: Future log output will appear in
directory "log".
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/21/19 1:52 PM, stan wrote:
On Thu, Nov 21, 2019 at 12:14:16PM -0800, Adrian Klaver wrote:
5) Now in your case you have peer auth(first in the list) for local socket
connections which means a user can only connect on the local socket as the
db postgres user if they are also the os
ile is NULL. This is either because the value is not coming from
a file or because you where not a superuser when you did the select on
pg_settings. Can you run the select as a superuser?
Jason L. Amerson
-Original Message-
From: Adrian Klaver
Sent: Thursday, November 21, 2019
2/sql-createtrigger.html
Regards,
Aliaksei.
--
Adrian Klaver
adrian.kla...@aklaver.com
show the server is running. But otherwise, all I see
is that it just goes to a new line with no confirmation or errors.
Jason L. Amerson
-Original Message-
From: Adrian Klaver
Sent: Thursday, November 21, 2019 04:53 PM
To: Jason L. Amerson
Cc: 'Steve Crawford' ; 'Postgr
ws 10 computers that will be clients, need PostgreSQL
installed in order to connect remotely to my server or is pgAdmin or some other
client all I need?
Jason L. Amerson
-Original Message-
From: Adrian Klaver
Sent: Friday, November 22, 2019 09:56 AM
To: Jason L. Amerson
Cc: 'PostgreSQL
/
constraints)
I'd be glad to have some feedback / pointers to tools in plpgsql or even
plpython.
Thank you very much
Remi
--
Adrian Klaver
adrian.kla...@aklaver.com
ot; during startup
How can I solve this issue?
If the above is the entire function I am not seeing that you need to SET
search_path as there is no object that needs schema qualification. I
would comment it out and run it.
If that fails then set the function volatile.
--
Adrian Klaver
adrian.kla...@aklaver.com
usted schema(s), then 'pg_temp'.
SET search_path = admin, pg_temp;
Put the SET outside the function body.
--
Adrian Klaver
adrian.kla...@aklaver.com
tgres community could add
this functionality in the nearest releases.
Regards,
Aliaksei.
On Fri, Nov 22, 2019 at 4:25 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 11/22/19 6:32 AM, aleksey ksenzov wrote:
> Hi team.
> Latest time we faced several i
are shown; supply a pattern or the S modifier to include system
objects. If + is appended to the command name, each object is listed
with its associated permissions and description, if any.
Thank you
--
Adrian Klaver
adrian.kla...@aklaver.com
aight approach do not use CONNECTION LIMIT 0 is this case, but
change ALLOW_CONNECTIONS to accept values: false, true, superuser. ("Superuser"
to accept connections from superuser only).
Why not use pg_hba.conf to allow only connection from superuser for
duration?
--
Adrian Kl
Thanks for any help!
--
Tom Carter
--
Adrian Klaver
adrian.kla...@aklaver.com
more then one installer, which one?
Do you have another instance of Postgres installed?
I’m not sure if I would have the same issue right now if I used rpm —prefix.
Tom Carter
On Nov 27, 2019, at 2:00 PM, Adrian Klaver wrote:
On 11/27/19 10:49 AM, Thomas Carter wrote:
I installed Postgres
7;;
CREATE ROLE
ts_test| Cannot login
+| {}
| Password valid until 2020-12-31 00:00:00-08
|
Best guess it operates like if specifying a value for a timestamptz field.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/27/19 2:25 PM, Adrian Klaver wrote:
On 11/27/19 2:19 PM, Ron wrote:
Hi,
In 9.6, does it default to UTC, the postgresql.conf timezone value
(US/Eastern) value or to local system time?
test_(postgres)# show timezone;
TimeZone
US/Pacific
test_(postgres)# create role
not want to invoke during data reload.
...
"
How do I proceed from here - Do I just delete the inconsistent rows or
is there something more I have to do?
Thanks for your help.
Regards,
Nanda
--
Adrian Klaver
adrian.kla...@aklaver.com
updated to
the latest versions.
This might help:
https://support.office.com/en-us/article/Manage-linked-tables-1d9346d6-953d-4f85-a9ce-4caec2262797
Thank you,
Jason L. Amerson
--
Adrian Klaver
adrian.kla...@aklaver.com
ds_moves_score_check" CHECK (score >= 0)
Foreign-key constraints:
"words_moves_gid_fkey" FOREIGN KEY (gid) REFERENCES
words_games(gid) ON DELETE CASCADE
"words_moves_uid_fkey" FOREIGN KEY (uid) REFERENCES
words_users(uid) ON DELETE CASCADE
Referenced by:
or the mid to display and so it throws the error.
To go forward it would help to know what it is you are trying to achieve?
Regards
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
8dee | 6767 | 40
May 2018 | 3 | f | 86180 |
4d47a65263331cf4e2d2956886b6a72f | 6706 | 26
May 2018 | 3 | f | 85736 |
debb1efd673c91947a8aa7f38be4217c | 6680 | 28
May 2018 | 3 | f | 82522 |
e55ec68a5a5dacc2bc463e397198cb1c | 6550 | 27
Apr 2018 | 0 | f | 78406 |
f5d264ccfe94aaccd90ce6c019716d4d | 5702 | 58
Apr 2018 | 0 | f | 77461 |
404886e913b698596f9cf3648ddf6fa4 | 1048 | 26
(415 rows)
--
Adrian Klaver
adrian.kla...@aklaver.com
On 11/30/19 3:15 AM, Tim Clarke wrote:
On 29/11/2019 17:30, Adrian Klaver wrote:
On 11/29/19 9:23 AM, Jason L. Amerson wrote:
I am trying to setup MS Access as a frontend so that it would be
easier on my wife and children to interact with PostgreSQL. I looked
online for some tutorials but the
erson
--
Adrian Klaver
adrian.kla...@aklaver.com
/docs/11/unsupported-features-sql-standard.html
So what are you referring to?
2) Comment on field definition is what exactly?
3) How are you fetching the metadata?
--
Adrian Klaver
adrian.kla...@aklaver.com
performance delta is so significant that i feel like i'm missing something
It would help to have more information:
1) The schema of the table e.g. the output of \d in psql.
2) The actual INSERT query.
3) An EXPLAIN ANALYZE of the INSERT query.
--
Adrian Klaver
adrian.kla...@aklaver.com
afety."
-- Benjamin Franklin
--
Adrian Klaver
adrian.kla...@aklaver.com
dden space issue or something.
(or otherwise, in very strange cases - the SQL would fail and my
java-servlet would throw SQLException)
Regards
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
On 12/3/19 8:24 AM, Alexander Farber wrote:
Thanks for your replies!
Tom has hinted that STRICT is pl/pgSQL syntax and not SQL
I finally read the full function and see you declared the LANGUAGE as
sql. Now things make sense:)
Regards
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
1001 - 1100 of 4936 matches
Mail list logo