://pgtap.org/
--
Regards,
Raghavendra Rao J S V
--
Adrian Klaver
adrian.kla...@aklaver.com
hat are other ways to do it, but changing
track_functions to 'all' I would expect all calls will be tracked...
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/03/2018 02:34 AM, Raghavendra Rao J S V wrote:
Hi,
How to install pgTAP on Centos machine.? I tried to install but no luck.
What did you do to install and where did it fail?
Please guide me to proceed further.
--
Regards,
Raghavendra Rao J S V
--
Adrian Klaver
adrian.kla
On 04/03/2018 07:35 AM, hmidi slim wrote:
I tried it and I got the same result.
Tried what?
--
Adrian Klaver
adrian.kla...@aklaver.com
nsactions are short, as they should be, it should not be
a big deal to add or drop a column, for example.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
<https://www.cybertec-postgresql.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
eruser then there is host of other
things you could do to compromise security as well.
Thanks for any comments.
Regards
Rory
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/08/2018 03:40 AM, Rory Campbell-Lange wrote:
On 07/04/18, Adrian Klaver (adrian.kla...@aklaver.com) wrote:
(I'm aware that the reasons behind the change made to the dump format
due to CVE-2018-1058 are set out here:
https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018
uot;:\"john\",\"fullname\":\"John\"}","{\"id\":2,\"username\":\"anna\",\"fullname\":\"Anna\"}","{\"id\":3,\"username\":\"sussi\",\"fullname\":\"Sussi\"}","{\"id\":4,\"username\":\"david\",\"fullname\":\"David
Beckham\"}","{\"id\":5,\"username\":\"wayne\",\"fullname\":\"Wayne
Rooney\"}"}
(1 row)
which then gets turned back into JSON:
select ARRAY_TO_JSON(array_agg(row_to_json(t))) from test_table t;
[{"id":1,"username":"john","fullname":"John"},{"id":2,"username":"anna","fullname":"Anna"},{"id":3,"username":"sussi","fullname":"Sussi"},{"id":4,"username":"david","fullname":"David
Beckham"},{"id":5,"username":"wayne","fullname":"Wayne Rooney"}]
Please help me give me your idea. Am I wrong or this is really a bug?
Thank you and best regards,
Đỗ Ngọc Trí*Cường*(Mr.)
*Software Development Dept.*
Mobile: +84 9 3800 3394
Phone: +84 28 3715 6322
Email: dntcu...@digi-texx.vn
DIGI-TEXX | a global BPO provider
Address: Anna Building, Quang Trung Software City,
District. 12, Ho Chi Minh City, Vietnam
Website: www.digi-texx.vn <http://www.digi-texx.vn/>
//
/IMPORTANT NOTICE:/
/*This e-mail and any attachments may contain confidential and/or
privileged information. If you are not the intended recipient, please
delete it and notify the sender immediately. Any unauthorized copying,
disclosure or distribution of the material in this e-mail is strictly
forbidden./
/*Please consider the environment before printing./
--
Adrian Klaver
adrian.kla...@aklaver.com
posts that covered similar ground I would say other people
would agree. I am guessing the response you will get from those that can
make the changes is that would be just delaying the inevitable. You can
always ask though:)
Thanks again
Rory
--
Adrian Klaver
adrian.kla...@aklaver.com
simple SQL model that
can work over multiple database engines. So again you end up with the
database as a data bucket.
--
Adrian Klaver
adrian.kla...@aklaver.com
bles to be up to date? To
give a bit of context I was planning to use this information in the
assertion part of a test case I wrote to check vacuum were executed as
expected but my test is flaky because of this behaviour.
-Seb
--
Adrian Klaver
adrian.kla...@aklaver.com
n. Since 9.4, we have
"JSON_AGG" already. So I want to rewrite and reduce the length of the
query. But it is don't work as I expected with command COPY.
Thank you and best regards,
Đỗ Ngọc Trí*Cường*(Mr.) | *Software Development Department*| +84 28 3715
5325
--
Adrian Klaver
adrian.kla...@aklaver.com
,"username":"john","fullname":"John"},{"id":2,"username":"anna","fullname":"Anna"},{"id":3,"username":"sussi","fullname":"Sussi"},{"id":4,"username":"david","fullname":"David
Beckham"},{"id":5,"username":"wayne","fullname":"Wayne Rooney"}]}
Thank you and best regards,
Đỗ Ngọc Trí*Cường*(Mr.) | *Software Development Department*| +84 28 3715
5325
--
Adrian Klaver
adrian.kla...@aklaver.com
--+
| 1 |
++
SQLRowCount returns -1
1 rows fetched
SQL> quit
root@a92a3741d40e:/home/pg# cat /etc/odbc.ini
[SAMPLE]
Description = DB2 remote SAMPLE Database
Driver=/home/db2inst1/sqllib/lib64/libdb2.so
SERVERNAME=MYDB2
UID=db2inst1
PWD=db2inst1
port=5
Thanks,
Karthik.
--
Adrian Klaver
adrian.kla...@aklaver.com
b2inst1');
to this?:
CREATE USER MAPPING FOR pg SERVER odbc_db2 OPTIONS (username
'db2inst1', password 'db2inst1');
Thanks,
Karthik.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/09/2018 02:37 PM, karthik kumar wrote:
On Mon, Apr 9, 2018 at 5:13 PM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 04/09/2018 02:10 PM, karthik kumar wrote:
Assuming using this:
https://github.com/ZhengYang/odbc_fdw
I bel
On 04/09/2018 04:52 PM, Adrian Klaver wrote:
On 04/09/2018 02:37 PM, karthik kumar wrote:
On Mon, Apr 9, 2018 at 5:13 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 04/09/2018 02:10 PM, karthik kumar wrote:
Assuming using this:
https://gith
updates to the postgres databases.
It might help to know how the two masters received data when they where
operating independently.
Regards
Vikas Sharma
--
Adrian Klaver
adrian.kla...@aklaver.com
, you really have a
split brain issue. Each master would have it's own view of the data and
latest update would really only be relevant for that master.
Regards
Vikas
On 10 April 2018 at 15:26, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 04/10/2018 06:50 AM
data at different points in time. Just because the count is higher does
not mean the data is actually valid.
Thanks and Regards
Vikas
On Tue, Apr 10, 2018, 17:29 Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 04/10/2018 08:04 AM, Vikas Sharma wrote:
&g
dump of the data from the same table from each master.
2) Diff the data dumps.
Regards
--
Adrian Klaver
adrian.kla...@aklaver.com
er Default Schema: act
Kind regards
Thiemo
--
Adrian Klaver
adrian.kla...@aklaver.com
abase: act
User: act
User Default Schema: act
Kind regards
Thiemo
--
Adrian Klaver
adrian.kla...@aklaver.com
ery interested to
hear what others might be doing for tasks like this.
Don.
--
Don Seiler
www.seiler.us <http://www.seiler.us>
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/11/2018 11:13 AM, Don Seiler wrote:
On Wed, Apr 11, 2018 at 12:58 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
"F.33.3. Transaction Management
During a query that references any remote tables on a foreign
server, postgres_fdw opens a transaction on
l/connect/odbc/linux-mac/data-access-tracing-with-the-odbc-driver-on-linux
--
Adrian Klaver
adrian.kla...@aklaver.com
0.077 ms
Execution time: 164.735 ms
(3 rows)
I am planning to use postgres_fdw but if it is going by one row at a
time there will be a lot of round trip and defeat the purpose.
Regards,
Virendra.
*From:*Don Seiler [mailto:d...@seiler.us]
*Sent:* Wednesday, April 11, 2018 2:53
= MYDB3
Description = DB2 ODBC Driver
Driver = /home/db2inst1/sqllib/lib64/libdb2.so
CommLog = 1
FileUsage = 1
#DontDLClose = 1
--
Adrian Klaver
adrian.kla...@aklaver.com
FileUsage = 1
#DontDLClose = 1
--
Adrian Klaver
adrian.kla...@aklaver.com
my Ubuntu 16.04 instance I have:
lrwxrwxrwx 1 root root 37 Feb 8 04:55 /usr/bin/psql ->
../share/postgresql-common/pg_wrapper*
--
Adrian Klaver
adrian.kla...@aklaver.com
environment variable set for your
user1?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/11/2018 04:49 PM, Jonathan Leroy - Inikup wrote:
2018-04-12 1:38 GMT+02:00 Adrian Klaver :
Another thought do you have the PGDATA environment variable set for your
user1?
Nope.
Maybe I will try to "dissect" pg_wrapper to find where the error
occurs, but the script is qui
On 04/11/2018 04:49 PM, Jonathan Leroy - Inikup wrote:
2018-04-12 1:38 GMT+02:00 Adrian Klaver :
Another thought do you have the PGDATA environment variable set for your
user1?
Nope.
Maybe I will try to "dissect" pg_wrapper to find where the error
occurs, but the script is qui
uction postgresql.conf files have a chmod 640 vs 644 on my new VM.
After digging, I've found that the SaltStack recipe who configure all
my servers force the file chmod to 640...
I've fixed it: everything works now. :)
Great. Thanks for the follow up.
Thank you all for your help!
--
Adrian Klaver
adrian.kla...@aklaver.com
host replication csidba 0.0.0.0/0 md5
local replication repuser md5
host replication repuser 127.0.0.1/32 md5
host replication repuser 0.0.0.0/0 md5
local all repuser md5
host all repuser 127.0.0.1/32 md5
host all repuser 0.0.0.0/0 md5
Did I run in somthing similar to a racong condition ?
Any ideas ?
Is the process using the correct password?
Many thanks
— Armand
--
Adrian Klaver
adrian.kla...@aklaver.com
and see if there are not too many hands in the cookie jar so
to speak and things happen without being communicated
On Apr 12, 2018, at 8:56 AM, Adrian Klaver wrote:
On 04/12/2018 06:51 AM, armand pirvu wrote:
Hi there
I have a process in place which runs several queries from one host to
ons in the process go through, but at
some point they start failing. Is that correct?
The timeout could be an issue. It would helpful to also see what
max_connections setting is.
So if the server gets a bit oveloaded this could play a role ?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/12/2018 07:37 AM, armand pirvu wrote:
On Apr 12, 2018, at 9:28 AM, Adrian Klaver wrote:
On 04/12/2018 07:15 AM, armand pirvu wrote:
Sorry for the double posting but could it be from
#authentication_timeout = 1min# 1s-600s
From you previous post:
"It is almost lik
will give you a better idea of what is going on connection wise.
--
Adrian Klaver
adrian.kla...@aklaver.com
Will do so and report back
Also, in a previous post you mentioned:
"Yes and worked fine until two days ago"
Is the code under version control so you can see if anything c
-07
6 | 2018-04-07 00:00:00-07
2 | 2018-04-10 00:00:00-07
3 | 2018-04-11 00:00:00-07
5 | 2018-04-13 00:00:00-07
6 | 2018-04-14 00:00:00-07
(8 rows)
|
||
||
--
Adrian Klaver
adrian.kla...@aklaver.com
ng me the error in my ways.
Now where's that dunce cap gone ? Maybe I don't deserve to use
anything better than MySQL. ;-)
Or read the below and be illuminated:)
https://www.postgresql.org/docs/10/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
--
Adrian Klaver
adrian.kla...@aklaver.com
column the answer is yes - though it's
nothing but a text value with runtime limitations.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
...
Assuming someone is in your database as a superuser, access to the
password field in pg_shadow is pretty much moot.
Thanks in advance
--
Adrian Klaver
adrian.kla...@aklaver.com
e resolved eventually. Namely that the procedure is
using enough resources to impact the authentication process.
Thank you for the help
Armand
--
Adrian Klaver
adrian.kla...@aklaver.com
re on the old 8.3 database? The
pg_database catalog does not have these values stored back then.
If I remember correctly:
https://www.postgresql.org/docs/8.3/static/app-pgcontroldata.html
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
--
Adrian Klaver
adria
US.UTF-8. Could this be having an affect? Is there any
way to see what these values were on the old 8.3 database? The
pg_database catalog does not have these values stored back then.
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
--
Adrian Klaver
adrian.kla...@aklaver.com
nt variable
on Unix systems). If this doesn't work out as expected, the client
encoding can be overridden using the environment variable PGCLIENTENCODING."
If you want to override set the PGCLIENTENCODING env variable to SQL_ASCII.
--
Keith Fiske
Senior Database Engineer
Crunchy Data
ts are used.
...
"
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
--
Adrian Klaver
adrian.kla...@aklaver.com
ference to a non-version-specific file.
"
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
--
Adrian Klaver
adrian.kla...@aklaver.com
ase up to "equality" with the 8.4 production system.)
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/16/2018 06:43 PM, Ron wrote:
On 04/16/2018 07:18 PM, Adrian Klaver wrote:
On 04/16/2018 04:58 PM, Ron wrote:
We're upgrading from v8.4 to 9.6 on a new VM in a different DC. The
dump file will be more than 1TB, and there's not enough disk space on
the current system for the
On 04/17/2018 12:35 AM, Ron wrote:
On 04/16/2018 11:07 PM, Adrian Klaver wrote:
On 04/16/2018 06:43 PM, Ron wrote:
More promising would be the suggestion from Michael Nolan:
https://www.postgresql.org/message-id/CAOzAqu%2BVpOfzBHwcqptSzm3PkeZAjkqqc0XqB%2BA-jBNioU6x%2Bg%40mail.gmail.com
1.6,
Java 7 = JDK 1.7, and so on)."
So what you are seeing here:
https://jdbc.postgresql.org/download.html
is JDK 8 which is actually equal to JDK 1.8.
Regards,
Vaibhav Zaveri
--
Adrian Klaver
adrian.kla...@aklaver.com
message is in:
src/backend/utils/cache/catcache.c
elog(DEBUG1, "rehashing catalog cache id %d for %s; %d tups, %d buckets",
cp->id, cp->cc_relname, cp->cc_ntup, cp->cc_nbuckets);
If I am following correctly it is fairly low level message.
Kind reg
? What could have caused
them being still active?
Can we see the data from pg_stat_activity for those queries?
This has become an issue as we started getting "FATAL: remaining
connection slots are reserved for non-replication superuser connections"
Thanks,
-hans
--
Adrian Klaver
,
How to fetch data from tables in PostgreSQL.
Regards,
Vaibhav Zaveri
--
Adrian Klaver
adrian.kla...@aklaver.com
og" -D
"/var/ericsson/esm-data/postgresql-data" -o "-p 50432 -c autovacuum=off
-c autovacuum_freeze_max_age=20 -c listen_addresses='' -c
unix_socket_permissions=0700" start
Failure, exiting
With Best Regards
Akshay
--
Adrian Klaver
adrian.kla...@aklaver.com
r? Don't we have some reproducer for this
kind of issues?
[1]
https://ask.fedoraproject.org/en/question/69316/postgresql-doesnt-work-after-upgrade-to-f22/
[2] https://bugzilla.redhat.com/show_bug.cgi?id=1557490
Thank for hints,
Pavel
--
Adrian Klaver
adrian.kla...@aklaver.com
ge
to include the contrib modules for the old server version. If I didn't,
it was an oversight :-(.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/18/2018 08:04 AM, Pavel Raiskup wrote:
On Wednesday, April 18, 2018 4:43:01 PM CEST Adrian Klaver wrote:
I am obviously missing something. If the old server was using hstore in
a database how could hstore.so could be accessible to it but not pg_dump?
Because on Fedora we usually run
I would contact the Webmaster but Contact goes to a big image of an
elephant head. That is also where Downloads, Support and Donate lands.
Might have been a good idea to roll out a demo site for testing first.
Will reserve judgment on the site design until it is functioning.
--
Adrian Klaver
On 04/18/2018 03:06 PM, David G. Johnston wrote:
On Wed, Apr 18, 2018 at 3:03 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>>wrote:
I would contact the Webmaster but Contact goes to a big image of an
elephant head. That is also where Downloads, Support and Donate
lands.
On 04/18/2018 03:07 PM, Peter Geoghegan wrote:
On Wed, Apr 18, 2018 at 3:03 PM, Adrian Klaver
wrote:
I would contact the Webmaster but Contact goes to a big image of an elephant
head. That is also where Downloads, Support and Donate lands. Might have
been a good idea to roll out a demo site
On 04/18/2018 03:07 PM, Peter Geoghegan wrote:
On Wed, Apr 18, 2018 at 3:03 PM, Adrian Klaver
wrote:
I would contact the Webmaster but Contact goes to a big image of an elephant
head. That is also where Downloads, Support and Donate lands. Might have
been a good idea to roll out a demo site
On 04/18/2018 05:22 PM, Jonathan S. Katz wrote:
On Apr 18, 2018, at 6:40 PM, Adrian Klaver wrote:
On 04/18/2018 03:07 PM, Peter Geoghegan wrote:
On Wed, Apr 18, 2018 at 3:03 PM, Adrian Klaver
wrote:
I would contact the Webmaster but Contact goes to a big image of an elephant
head. That is
On 04/18/2018 05:31 PM, Peter Geoghegan wrote:
On Wed, Apr 18, 2018 at 3:40 PM, Adrian Klaver
wrote:
And to get to the mailing list archives(arguably one of the most important
links) you have to:
Click on Community, click on Mailing Lists on the left sidebar, then scroll
to the bottom of page
ue?
And I have a program that loads stored functions from disk
when they are different to what's in the database and I have
just loaded a very old database backup, brought the schema up
to date, and tried to bring the stored functions up to date.
cheers,
raf
--
Adrian Klaver
adrian.kla...@aklaver.com
debian host recently.
And it's not just the old backup. The same is happening with other copies of
essentially the same database.
And all the other stored functions were loaded fine. It's just this one that
went wrong.
Thanks in advance for any insights you can share.
cheers,
raf
--
Adrian Klaver
adrian.kla...@aklaver.com
no information could be
executed.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
. Running as separate
clusters would give you some redundancy.
thanks in advance.
regards!
--
--
Adrian Klaver
adrian.kla...@aklaver.com
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
deletion and it
was rolled back, how could be a parent record be deleted ?
Another thought, are there are any other triggers on the Master and/or
Detail tables?
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
get entire
database restored properly.
Myself, having written more then my fair share of poorly thought out
trigger functions, I test new ones extensively before I release them
into the wild.
Well, I´ll review all my triggers. And I have hundreds of them.
--
Adrian Klaver
adrian.kla
On 04/20/2018 07:21 AM, David G. Johnston wrote:
On 04/19/2018 06:49 PM, PegoraroF10 wrote:
On Fri, Apr 20, 2018 at 6:55 AM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>>wrote:
I know I did that trigger incorrectly but referential integrity is
obligatory.
I
On 04/20/2018 11:33 AM, Jonathan S. Katz wrote:
On Apr 18, 2018, at 8:38 PM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Clicking on the Mailing List link on front page should take you to
page that includes the archives.
We’ve added a button that brings you to the
how things work. Instead as has already
been indicated there maybe better documentation on the way detailing all
the above.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
pgarchives
pglister
In which all 3 serve different purposes and we need to iron out the workflow
a bit more between all 3.
Jonathan
--
Adrian Klaver
adrian.kla...@aklaver.com
in user?
As a double-check on a different PC with Windows 10 Pro, I get no error
message, and the database is installed correctly.
Dale Seaburg
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/20/2018 07:52 PM, Dale Seaburg wrote:
Please also reply to list.
Ccing list to put it front of more eyes.
Thanks, Adrian, for suggestion(s).
On 4/20/2018 9:35 PM, Adrian Klaver wrote:
On 04/20/2018 07:16 PM, Dale Seaburg wrote:
I am attempting to install a fresh copy of
postgresql
talling.
Dale
On 4/20/2018 11:03 PM, Adrian Klaver wrote:
On 04/20/2018 07:52 PM, Dale Seaburg wrote:
Please also reply to list.
Ccing list to put it front of more eyes.
Thanks, Adrian, for suggestion(s).
On 4/20/2018 9:35 PM, Adrian Klaver wrote:
On 04/20/2018 07:16 PM, Dale Seaburg wrote:
ng, or whether
it was successful or not in the bad install.
As you can see, I even took Igor's suggestion to install in a non-system
(Program Files) path, to no success.
Again, not sure what to do. Open for suggestions... I'm almost ready
to call Dell and complain about a &q
ld be appreciated.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
ute requirement without needing downtime for physical
backups..
Any advise?
Take a look here:
https://www.postgresql.org/docs/9.5/static/continuous-archiving.html
Thanks in Advance.
--
Adrian Klaver
adrian.kla...@aklaver.com
please? or refer any user
oriented documentation about index size estimations
--
Adrian Klaver
adrian.kla...@aklaver.com
On 04/25/2018 05:33 AM, raf wrote:
Adrian Klaver wrote:
On 04/18/2018 06:02 PM, r...@raf.org wrote:
Hmm, wonder if there is an oops in the below:
http://www.pygresql.org/contents/changelog.html
Version 5.0 (2016-03-20)
Changes in the DB-API 2 module (pgdb):
"SQL commands are a
, the template1 doesn't contain schema public.
I have restored db1 on cluster C2 and i saw public role had the
privilege create on the schéma public.
What was the restore command?
I cannot explain this
Thank you.
Thomas?
--
Adrian Klaver
adrian.kla...@aklaver.com
and create for
public role on schema public if it found it. Is that correct?
Regards
Thomas
**
--
Adrian Klaver
adrian.kla...@aklaver.com
t present in table "...".
SELECT .. FOR UPDATE?:
https://www.postgresql.org/docs/10/static/sql-select.html#SQL-FOR-UPDATE-SHARE
https://www.postgresql.org/docs/10/static/explicit-locking.html#LOCKING-ROWS
Who do we make sure that such aggregating query would not fail?
Regar
de would
drop and recreate it, again causing headaches for non-superuser usage."
You might want to try without the --clean on the restore.
Thanks for the 'no-op' .
Thomas
--
Adrian Klaver
adrian.kla...@aklaver.com
PDATE, FOR SHARE and FOR
KEY SHARE cannot be specified with GROUP BY."
Without the query we are flying blind, so suggestions will have a ?
Regards,
Vitaliy
--
Adrian Klaver
adrian.kla...@aklaver.com
quot;s"."software" IS NULL))
AND ((NOT ("s"."os" = TRUE))
OR ("s"."os" IS NULL)))
AND ("usage"."usage_date" >= quarter.start_date)
AND ("usage"."usage_date" <
om TestLtree( 'a.b.c' );
--
Adrian Klaver
adrian.kla...@aklaver.com
turn means the result will continually changing.
As David and Alvaro have also suggested your best bet is to pick a point
in time and work off that.
Regards,
Vitaliy
--
Adrian Klaver
adrian.kla...@aklaver.com
SELECT 1 INTO _testvar FROM TableLtree WHERE MyPath = text2ltree( MyArg
) LIMIT 1;
raise notice '_testVar = %', _testVar;
end;
$$ language plpgsql;
I'm tapped out. You might want to get hold of the pgAdmin folks directly:
https://www.pgadmin.org/support/list/
Ian
-
://www.postgresql.org/docs/10/static/trigger-interface.html
--
Adrian Klaver
adrian.kla...@aklaver.com
cific about what parameters you are looking to pass in?
-- Original --
*From:* "Adrian Klaver";
*Date:* Friday, Apr 27, 2018 9:36 AM
*To:* "a"<372660...@qq.com>; "pgsql-general";
*Subject:* Re: Parameter passing in trigger funct
_user nameuser name of current execution context"
Password?:
https://www.postgresql.org/docs/10/static/view-pg-shadow.html
Though if you are using password encryption it will be encrypted.
-- Original ------
*From:* "Adrian Klaver";
*Date:* Fri
ble.
PS I’m running Red Hat 7.4
Regards,
Jonas
--
Jonas Pedersen
Øresundsvej 47A, 4th
2300 København S
Denmark
Tlf. +45 51212034
Skype name. jp2650
--
Adrian Klaver
adrian.kla...@aklaver.com
On 05/02/2018 02:29 PM, Jim Michaels wrote:
- the microsoft patented CSV would be required for implementation. it
handles special data with commas and double-quotes in them
Huh?:
https://en.wikipedia.org/wiki/Comma-separated_values#History
--
Adrian Klaver
adrian.kla...@aklaver.com
101 - 200 of 4934 matches
Mail list logo
