Mob: 070-5530148
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to get better answers.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
--- Get your facts first, then you can distort them as you please.--
--
Adrian Klaver
adrian.kla...@aklaver.com
then you can distort them as you please.--
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 01/25/2017 09:57 AM, Shailesh Singh wrote:
Dear Adrian Klaver,
I have used pg_dump to take backup
eg: pg_dump my_db > /dbbackup/audit_table.sql
To be clear you dumped the entire database, not just the audit table,
correct?
Meant to ask before, are you dumping/restoring between the s
is the error you get if you use something other then -h localhost?
What is in pg_hba.conf?
Thanks in advance
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
d data?
**
--
With Regards!
Shailesh Singh
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Lane <t...@sss.pgh.pa.us
<mailto:t...@sss.pgh.pa.us>> wrote:
Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> writes:
> On 01/23/2017 05:14 PM, David G. Johnston wrote:
>> To your example - testing in UTC is going to alwa
On 01/23/2017 05:14 PM, David G. Johnston wrote:
On Mon, Jan 23, 2017 at 6:08 PM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>wrote:
production=# show timezone;
TimeZone
--
UTC
(1 row)
production=# select ' 2011
On 01/23/2017 05:01 PM, David G. Johnston wrote:
On Mon, Jan 23, 2017 at 5:57 PM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>wrote:
* this the constraint: "time_stamp_201012ad" CHECK
(time_stamp >=
ther thought, do you have a .psqlrc file that is changing the timezone?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 01/23/2017 04:30 PM, Edmundo Robles wrote:
On Mon, Jan 23, 2017 at 6:02 PM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
On 01/23/2017 03:45 PM, Edmundo Robles wrote:
Hi!
I have backed up a database with a 'UTC' tim
DETAIL: Failing row contains (..., 2011-01-01 00:00:03.925+00, .., 0).
* this the constraint: "time_stamp_201012ad" CHECK (time_stamp >=
'2010-12-01'::date AND time_stamp < '2011-01-01'::date)
if change 2011-01-01 00:00:03.925+00 to 2011-01-01 00:00:03.925-06 works ok
--
paragraph under the heading below:
http://postgis.org/
What is PostGIS?
Thanks,
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
..!
*-Pawan*
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
then what are steps required and is it done by
any patching or we have to completely upgrade from. 9.5 to 9.6
Complete upgrade.
-Pawan
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
e comparison to the
9.5 plan?
OP, if you want to contribute to the investigation of fix, "git bisect"
is the way to proceed...is that feasible?
merlin
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
end
of the table ...i need update row without change row position if any
possible please rply .
In Postgres UPDATE is actually DELETE old row, INSERT new row so the row
position will change.
Why is the new row being in a new position a problem?
--
Kumar
--
Adrian Klaver
adrian.kla..
ing tblcnaccounts_pkey on tblcnaccounts
a (cost=0.08..0.36 rows=1 width=4)
Index Cond: (master_user_id = d.master_user_id)
Filter: ((user_name)::text = 'dd'::text)
(19 rows)
Regards,
ravi
--
Adrian Klaver
adrian.kla...@aklaver.com
--
starting up. With off,
huge pages will not be used.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
ent XML document to the
standard output. osx will warn about SGML constructs which have no XML
equivalent.
So it seems you need to install osx on your system.
***
Makefile:250: recipe for target 'postgres.xml' failed
Kindly help me out with the same.
Thanks
--
Adrian Klaver
adrian.kl
/bin/sh ../../../config/missing osx -D. -x lower -i include-xslt-index
postgres.sgml >postgres.xmltmp
***
ERROR: `osx' is missing on your system.
***
Makefile:250: recipe for target 'postgres.xml' failed
Kindly help me out with the same.
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
--
S
an index on record_timestamp.
>
> can anyone suggest a better approach?
>
> I considered copying everything to a tmp table then inserting/deleting based
> on that table -- but there's a lot of disk-io on that approach too.
>
>
> fwiw we're on postgres9.6.1
>
--
Adrian K
by the owning user is closed.
Aah, now I see, thanks for this.
George
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 01/11/2017 05:30 PM, Ian Lewis wrote:
Ccing list
On Wed, Jan 11, 2017 at 4:38 PM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
So what makes them temporary as they seem to persist between sessions?
They are temporary in the sense that
On 01/11/2017 04:31 PM, Patrick B wrote:
2017-01-12 13:23 GMT+13:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
It is not the same DB if it is on two different servers not
connected by replication. More to the point statement_timeout is
On 01/11/2017 04:31 PM, Patrick B wrote:
2017-01-12 13:23 GMT+13:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 01/11/2017 04:08 PM, Patrick B wrote:
Hi guys,
I'm using PostgreSQL 9.2 in two different servers.
ser
SQL?
If so, is there documentation somewhere on how to manage access
to temporary tables across function calls from the client?
Ian Lewis (www.mstarlabs.com <http://www.mstarlabs.com>)
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
that indicates
something is setting statement_timeout?
Patrick
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ve as
resources cost?
The view or the materialized view?
If are running tests as you state above, you should know or am I missing
something?
The view has about 500K lines.
Thank you!
/F
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@pos
)
Rows Removed by Filter: 1
Planning time: 14.996 ms
Execution time: 436.840 ms
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
idth=29) (actual time=0.770..0.770 rows=1 loops=1)
And it seems to be the main cost for the whole query.
Which kind of index should i use for that condition/fields?
As before, giving just snippets of the information is going to prolong
or prevent arriving at an answer. So:
1) What is the comple
I had already read that doc but I can't answer clearly to my
questions 2,4 and 5.
The answer would seem to depend on what you consider 'a consistency
state position'. Is it possible to be more explicit about what you mean?
Regards
Pupillo
--
Adrian Klaver
adrian.kla...@aklaver.com
-
elect relname,last_vacuum, last_autovacuum, last_analyze,
last_autoanalyze from pg_stat_user_tables where relname like 'sta%';"
last_vacuum=>2017-01-05 10:40:34.228633-06
last_autovacuum => null
last_analyze=> 2017-01-04 15:02:47.438715-06
last_autoanalyze=> 2017-01-09 10:35:51.391
tation.
O doubled conditions, without reason!
I think making good queries is an art, at the moment i am not an artist! :)
Again,thank you very much!
/F
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
t the last
checkpoint. So the transactions are there it is just a matter of if they
need to be replayed or not. This is subject to caveats:
https://www.postgresql.org/docs/9.5/static/wal-reliability.html
Regards
Pupillo
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general m
checkpoint's position (NOT the record)is saved in the file
pg_control" then I had some doubt.
Yes it is just one piece of information stored in the file.
To see what else is stored there do:
pg_controldata -D your_cluster_data_directory
Regards
Pupillo
--
Adrian Klaver
adrian.kla...
BD7580, desc: INSERT_LEAF off 60, blkref #0: rel
1663/16384/16490 blk 2722
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
eject_codgruppo_idx
> (cost=0.00..40.44 rows=21 width=0) (never executed)
> Index Cond: ((codgruppo)::text = 'f50132'::text)
> -> Bitmap Index Scan on listef_reject_country_idx
> (cost=0.00..40.76 rows=63 width=0) (never executed)
>
the info about the values of all
parameters specified at database level.
Maybe this?:
https://www.postgresql.org/docs/9.5/static/view-pg-settings.html
If not can you be more specific about what parameters you are referring to?
Thanks and Regards.
--
Shrikant Bhende
+91-9975543712
--
Adrian
ostgres 9.6.1 machine average workload return at about 2.0/3.0!
The problem is not the single query, but the massive queries!
Thank you again and excuse me for my bad explanation!
/F
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@p
son
makes a mistake someone else will eventually make the same mistake.
Michael.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
date, most of which are numeric."
In retrospect I should have pressed for was a more complete description
of the data. I underestimated this description:
"And some the values in the csv file contain nulls, do this null values
matter? "
--
Adrian Klaver
adrian.kla...@aklav
me three days. I have lots of csv data to COPY.
You solved the problem so it was not entirely wasted and it provided
information for future reference when folks hit this list with a similar
issue.
---- On 星期三, 04 一月 2017 08:39:42 -0800 *Adrian Klaver
<adrian.kla...@aklaver.com>* w
archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
has never seen my standby connected to him, doesn't keep WALs.
Any idea?
Regards
Pupillo
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
with possibly
flawed input data and then validating and migrating the data in
subsequent steps. In that case, an ETL solution may be a better
approach. Many options, both open- closed- and hybrid-source exist.
Cheers,
Steve
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general
On 01/04/2017 08:00 AM, rob stone wrote:
Hello,
On Wed, 2017-01-04 at 07:11 -0800, Adrian Klaver wrote:
On 01/04/2017 06:54 AM, Pavel Stehule wrote:
Hi
2017-01-04 14:00 GMT+01:00 vod vos <vod...@zoho.com
<mailto:vod...@zoho.com>>:
__
Now I am confused about I can create
bastará.
Rozvo Ware Solutions
--
View this message in context:
http://postgresql.nabble.com/could-not-load-library-libdir-sslutils-in-pg-upgrade-process-tp5937304p5937324.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
gresql.org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
<http://www.postgresql.org/mailpref/pgsql-general>
--
There’s no obfuscated Perl contest because it’s pointless.
—Jeff Polk
Maranat
/ deleted.
--
Sent via pgsql-general mailing list
(pgsql-general@postgresql.org <mailto:pgsql-general@postgresql.org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
There’s no obfuscated Perl co
tils": No such file or directory
/
I restarted SO, unseted enviroment variables, but the same error.
Any Suggestions?
Best Regards.
DrakoRod
-
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
View this message in context:
http://postgresql.nabble.com/could-not-load-library-libdir-sslutils-in-pg-upgrade-process-tp5937304.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ndex would not be rebuilt, assuming all conditions are
the same.
The part that has me questioning is this:
* This is tailored to the needs of ALTER TABLE ALTER TYPE, ..
Someone who knows the internals better will have to verify this.
>
>
> On Tue, Jan 3, 2017 at 11:2
postgres scan entire table to create index from scratch or does
it simply copy the first index?
2. Does postgres lock the table to create this index?
thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
to update the model?
So my questions are:
If I create a 2nd index on one column,
1. Does postgres scan entire table to create index from scratch or does
it simply copy the first index?
2. Does postgres lock the table to create this index?
thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
o wonder if has something to do with too
many arguments in a function?
Thanks!
Regards,
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
stgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the old one."
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
*>https://docs.djangoproject.com/en/1.10/ref/models/fields/#primary-key
<https://docs.djangoproject.com/en/1.10/ref/models/fields/#primary-key>
*
*You are quoting from a django
y
"The primary key field is read-only. If you change the value of the
primary key on an existing object and then save it, a new object will be
created alongside the old one."
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
:
COPY rius, line 2
rius is the table.
I have searched the mailing list, but seems no solutions founded.
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
it as completing the loop. A table creates a composite type, a
composite type creates a table. Not sure where that falls on the useful
scale.
Thomas
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
cceed."
NULL == "UNKNOWN"
David,
I forgot about that. Thanks for pointing it out to me.
What it comes down to is if you do not want NULL values in a column then
specify NOT NULL on the column.
Regards,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via p
L
constraint is required.
>
> TIA,
>
> Rich
>
>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
varying |
TIA,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ter then arbitrarily bolting on
new/different methods on a whim.
Regards,
Christoph
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
51 live rows and 0 dead rows; 3 rows in sample, 62560215
estimated total rows
Any ideas why?
I would say because the '300 rows in sample' where spread out over
all 2133350 pages.
Thnx.
Ciao,
Gerhard
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-gener
ON changes
FOR EACH ROW
EXECUTE PROCEDURE add_new_user();
I hoping for some recommendations on how to fix or at where I'm going wrong.
Thanks,
Clifford
--
@osm_seattle
osm_seattle.snowandsnow.us <http://osm_seattle.snowandsnow.us>
OpenStreetMap: Maps with a human touch
--
Adrian
ate, test, and establish a
connection to the databases and examine their E-R diagrams. They're now
saved as .png files.
Thanks very much for your pointer and my wishes for a healthy, happy, and
prosperous 2017 to you and all who responded to my question,
Rich
--
Adrian Klaver
adrian.kla...@ak
on a machine
and or across the network.
That is a large question that depends to a great deal on what the rules
say for whatever legal jurisdictions you are working in. Assuming you do
not like spending time in court.
Thank you,
Chris
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent
?
If it is the standard contact information then the previously mentioned
tools are sufficient.
If it is data specific to a field of study then things might get trickier.
Much appreciated,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general
On 12/27/2016 02:23 PM, Adrian Klaver wrote:
On 12/27/2016 12:03 PM, Rich Shepard wrote:
On Tue, 27 Dec 2016, Greg Navis wrote:
In the Ruby land there's a gem called faker
<https://github.com/stympy/faker> that allows you to generate fake data.
However, I'm not sure it can generate data
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tallations do run on Windows 7 Pro x64.
Best regards,
Thomas Deboben
--
Adrian Klaver
adrian.kla...@aklaver.com
Many thanks,
Thomas
--
Adrian Klaver
adrian.kla...@aklaver.com
Thanks,
Thomas
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-g
ed query I've other queries to the same db on other
tables and works without problem.
Then I've only this db and only this host.
Another thought, do you have this table in more then one schema and
maybe you are running into a search_path issue:
https://www.postgresql.org/docs/9.5/static/runti
ed query I've other queries to the same db on other
tables and works without problem.
Might want to set log_statement to 'all' at least temporarily:
https://www.postgresql.org/docs/9.5/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
Then I've only this db and only this
srcaddr
= $1
DETAIL: parameters: $1 = '192.168.1.1'
I've tried also to use pg_last_error and errors are not printed.
Can someone put me on the right way?
Thanks in advance.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On 12/21/2016 06:53 PM, n...@olansoft.com wrote:
22.12.2016, 06:31, "Adrian Klaver" <adrian.kla...@aklaver.com>:
Alright looks like it doing the correct thing.
Now if I am following you say you see the issue starting with 9.5+. As
it so happens that is when checkpoint_segme
On 12/21/2016 04:16 PM, n...@olansoft.com wrote:
22.12.2016, 04:21, "Adrian Klaver" <adrian.kla...@aklaver.com>:
On 12/21/2016 02:17 PM, n...@olansoft.com wrote:
Hi.
Perhaps i've sent it to wrong mail-list previously.
After the upgrade postgresql had a strange behavior.
suggestion at this time. Maybe this rings a bell with someone else.
Regards
Pupillo
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
f8; require "utf8_heavy.pl";'
## end of config
Sorry for my eng :)
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
se, whereas there's
no big deal with psql connecting to a default database.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ver I get an odd result I head to
the bottom of the docs under the Notes section. This is usually where
the exceptions are called out.
Regards
Daniel
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
s seems to working (the copy from stdin is displayed on
the screen):
postgres@pgbox:/home/postgres/ [PG961] pg_restore -h localhost -p
=== -F d -C /var/tmp/exp/
Thanks
Daniel
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
ginopino=# select * from stato where id=409;
id | ... dati ...
-+-- ...
409 | \x4a735300db8f4b31ab8660f85192bc
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
Thanks
Pupillo
-
16384/29153 actually is. So in the database
where stato is:
select relname from pg_class where relfilenode = 29153;
0 of 8192 bytes
ginopino=# select * from stato where id=409; <<< IT WORKS FINE
But does it have the updated info?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent v
ex
person_entity_id_key
HINT: Use DROP ... CASCADE to drop the dependent objects too.
--
*Andreas Joseph Krogh*
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
On 12/16/2016 07:01 AM, thomas.deboben@rohde-schwarz.com wrote:
Von:Adrian Klaver <adrian.kla...@aklaver.com>
An:thomas.deboben@rohde-schwarz.com,
pgsql-general@postgresql.org
Datum:09.12.2016 22:21
Betreff:Re: [GENERAL] Windows installation -
imply a stored function written in TCL
which takes 4 arguments of type 'text' (Who is it from, who is it
to, subject, and body of message), contacts the email server via
TCL sockets, and transmits your email (Now UTF-8 Compatible!).
"
this.
Regards,
Nidhi
--
Adrian Klaver
adrian.kla...@a
142670086
11 | 29 | 5142670086
10 | 40 | 5142670086
(3 rows)
Regards,
Arup Rakshit
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.p
em or to put it another way, what is the
problem you are trying to solve?
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
Hi Adrian,
I haven't got a problem. I'm just trying to estimate a worst case of
total IO writes of my DB on the field, over the y
nged fields are
normally preserved as-is; so an UPDATE of a row with out-of-line
values incurs no TOAST costs if none of the out-of-line values change."
Pupillo
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
I see. But in my
On 12/15/2016 07:48 AM, Tom DalPozzo wrote:
2016-12-15 16:23 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 12/15/2016 07:17 AM, Tom DalPozzo wrote:
Hi,
it's not clear to me when tuple data (ma
://www.postgresql.org/docs/9.5/static/storage-toast.html
It seems to work but sometimes the tuples seem compressed and sometime not.
I tried both with constant data and random bytes.
Thanks
Pupillo
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general
On 12/14/2016 11:37 PM, Thomas Kellerer wrote:
Adrian Klaver schrieb am 14.12.2016 um 15:32:
I'm suspicious that you're not actually typing plain-ASCII single and
double quotes, but some fancy curly quote character.
Definitely not. I typed this manually on the command line using Putty
So
date_start ||'_logs.csv'''
USING date_start, date_end;
end
$$ language 'plpgsql';
select l_extract('20161115'::date, '20161215'::date);
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
sql/'|| date_start ||'_logs.csv''';
end
$$ language 'plpgsql';
select l_extract('201611015', '201612015');
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
_start::text
AND
date_end::text
Or change the argument types to text and then:
BETWEEN
date_start
AND
date_end
In either case you will have your original query.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
2. To call the function, I have to login to postgres and then
run: select logextract(201612015, 201612015);
How can I do it on cron? because the dates will be different every time.
Thanks
Patrick
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-gene
ssues/2018
Thanks,
Shakti Singh
On Wed, Dec 14, 2016 at 9:45 AM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
On 12/14/2016 05:19 AM, Shakti Singh wrote:
Hi,
I am working on a POC to port Oracle database to PostG
ad form to link directly to a page
that starts downloading a 120MB software executable when you
navigate to it. Wasn't there a landing page with information that
you could have linked to instead?
David J.
--
Jovi
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-
value of the
shared_preload_libraries parameter:
shared_preload_libraries = ‘$libdir/other_libraries/plugin_debugger’
After modifying the shared_preload_libraries parameter, restart the
server to apply the changes."
Any help is appreciated.
Thanks
Shakti Singh
--
Adrian Klaver
501 - 600 of 4904 matches
Mail list logo