On 13/05/14 11:44, Oliver Kohll - Mailing Lists wrote:
The problem came when someone entered a record with no subject, but left it
null. When this was copied over and present in both tables, the *next* time the
join was done, a duplicate was created because the join didn't see them as
On 2014-04-01 04:20, Jeff Janes wrote:
On Sunday, March 30, 2014, Stefan Keller sfkel...@gmail.com
mailto:sfkel...@gmail.com wrote:
Hi Jeff
2013/11/20 Jeff Janes jeff.ja...@gmail.com
javascript:_e(%7B%7D,'cvml','jeff.ja...@gmail.com');
I don't know what you mean about
On 2012-06-16 19:11, Bill House wrote:
Would someone please point me to (or supply) some working examples of
UPDATE commands using the WITH clause syntax as described in the manual
(pdf version page 1560) and referring to Section 7.8 (pdf version page 104)?
not be dropped on extension drop.
regards,
Yeb
--
Yeb Havinga
http://www.mgrid.net/
Mastering Medical Data
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 2012-04-10 09:40, John R Pierce wrote:
On 04/09/12 11:39 PM, Eye Gee wrote:
We would like to implement the security-enhanced postgresql
(SEPostgreSQL ) on SUSE SP1. However we are unable to find the rpm
packages.
Is SEPostgreSQL still available? We are using postgreSQL 9.1 and
would like
On 2011-11-24 14:20, Yeb Havinga wrote:
I really wonder at which point SSD life left will change to 99 on
this drive..
Bingo! On the OCZ Vertex 2 PRO, SSD life left to 99 after just over
100PB written.
230 Life_Curve_Status 0x0013 100 100 000Pre-fail
Always
On 2011-11-04 16:24, David Boreham wrote:
On 11/4/2011 8:26 AM, Yeb Havinga wrote:
First, if your'e interested in doing a test like this yourself, I'm
testing on ubuntu 11.10, but even though this is a brand new
distribution, the smart database was a few months old.
'update-smart-drivedb
On 2011-11-04 04:21, Kurt Buff wrote:
Oddly enough, Tom's Hardware has a review of the Intel offering today
- might be worth your while to take a look at it. Kurt
Thanks for that link! Seeing media wearout comparisons between 'consumer
grade' and 'enterprise' disks was enough for me to stop
On 2011-11-03 04:02, Benjamin Smith wrote:
Which is what we're trying next, X25E. 710's apparently have 1/5th the rated
write endurance, without much speed increase, so don't seem like such an
exciting product.
I've tested the 710 with diskchecker.pl and it doesn't lie about it's
cache
On 2011-11-02 18:01, Benjamin Smith wrote:
So after months of using this SSD without any issues at all, we tentatively
rolled this out to production, and had blissful, sweet beauty until about 2
weeks ago, now we are running into sudden death scenarios.
Could you tell a bit more about the
to add this, but it
just hasn't been programmed yet. So a trigger check to prevent these
deletions also has to be made in user space.
I'd very much appreciate any feedback you have on the patch, if it
matches your usecase.
regards,
--
Yeb Havinga
http://www.mgrid.net/
Mastering Medical Data
, since they vary a lot.
(*) http://www.xs4all.nl/~wpd/symon/
--
Yeb Havinga
http://www.mgrid.net/
Mastering Medical Data
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
for something like that.
--
Yeb Havinga
http://www.mgrid.net/
Mastering Medical Data
). It enabled me to write
http://arxiv.org/PS_cache/arxiv/pdf/0705/0705.3949v1.pdf
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/rdkit/trunk/Code/PgSQL/rdkit/rdkit_gist.c?revision=1481view=markup
and then line 651: that's the error being thrown. You need to extend
gmol_consistent to handle the strategy 6 number.
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
that they are
not written to the WAL? In that case I'd say: yes.
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of executing the to_tsvector
function. In that case it might be interesting to see if changing
ts_vectors cost (see ALTER FUNCTION ... COST .../
http://developer.postgresql.org/pgdocs/postgres/sql-alterfunction.html)
again helps the planner to favor the second plan over the first.
regards,
Yeb
inserted data is visible to other clients?
Not before it is committed. To which clients the just committed data is
visible depends on the transaction isolation level (see link above).
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
.
It sounds a bit like the (commercial) ChronicDB add-on that was on the
announce list a while ago, http://chronicdb.com/
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
A. Kretschmer wrote:
In response to Gauthier, Dave :
Is there a way to select a list of column values directly into an array?
create table foo (col1 text);
insert into foo (col1) values (?aaa?),(?bbb?),(?ccc?),(?ddd?),(?eee?);
I?d like to load up an array with
A. Kretschmer wrote:
In response to Gauthier, Dave :
Is there a way to select a list of column values directly into an array?
create table foo (col1 text);
insert into foo (col1) values (?aaa?),(?bbb?),(?ccc?),(?ddd?),(?eee?);
I?d like to load up an array with
Howard Rogers wrote:
insert into coloursample values (2,10,'Yellow and Orange');
But how do I find records which are ONLY yellow and orange
what about
select * from coloursample where colour = 10;
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
, I found the PQtrace facility
very useful, to debug what's actually going on (or not).
regards,
Yeb Havinga
Here is my testbed:
int
main (register int const argc, register char *const argv[])
{
PGconn *conn;
PGresult*res;
conn = PQsetdbLogin(PGHOST
is on approach 3 to be the fastest since it does not require a join
node and has shorter target list / memory to move around.
regards
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
version, press '+' and 'g'. I just verified this on a test fresh
10.4 installation and after 'g' I get no conflicts at all, however, 9.10
(karmic) does not have postgres 8.4, but 9.04 (jaunty) does.
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
Leif Biberg Kristensen wrote:
Now I only need a list of the built-in functions. There doesn't seem to be a
pg_get functions()?
Try psql -E postgres
(-E shows all queries psql does on the catalog)
then \df
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general
to be another SELECT command, and cannot
e.g. be a INSERT followed by a SELECT.
Something similar is mentioned in this thread:
http://archives.postgresql.org/pgsql-performance/2008-07/msg00144.php
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
, it must call this routine to
* undo the decision made by use_physical_tlist(). Currently, Hash, Sort,
* and Material nodes want this, so they don't have to store useless columns.
*/
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
lists in a --build, --create, or
--add command will be flagged as 'write-mostly'. This is valid for
RAID1 only and means that
the 'md' driver will avoid reading from these devices if
at all possible. This can be useful if mirroring over a slow link.
regards,
Yeb Havinga
--
Sent
Ognjen Blagojevic wrote:
Hi,
How do you name a table which sole purpose is to store a list of
values? E.g.
Is this:
a. Lookup table
b. Classifier
c. Cypher(er)?
d. valueset?
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
waiting for results, then as
soon as data is ready, get results and display.
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Greg Stark wrote:
You can do \set FETCH_COUNT to have psql use a cursor automatically.
It seems like a big win in this case. What would be the downside of
having a fetch_count set default in psql?
regards
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general
that an actual big difference between the processors exists,
and it more likely was something in our test setup. Still: the
difference was *only* in index creation, which is kindoff like a qsort yes?
egards
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
it is something for the docs)
You need to add a cast from the type to itself, e.g.
-- typmod coercion
CREATE CAST (complex AS complex)
WITH FUNCTION complextypmod(complex,int4)
AS IMPLICIT;
Where complextypemod would be the typmod apply functions (int4 is the
typmod)
Regards,
Yeb Havinga
--
Sent via
, and the
size can be queried with the VARSIZE_ * macros - doxygen.postgresql.org
is your friend here. Take a look at e.g. contrib/cube for examples.
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Carsten Kropf wrote:
Actually, I thought, I did this using the int32 variable called
dimension which should be exactly this field.
yes.
in = (PointND *) palloc(sizeof(float8) * dimensions + VARHDRSZ);
SET_VARSIZE(in, dimensions);
What about
len = sizeof(float8) * dimensions + VARHDRSZ;
in =
Carsten Kropf wrote:
Oh, I see, does the VARSIZE length field have to be the total number of bytes occupied
(including VARHDRSZ and the size of the structure) or only the size that is used by
my datatype?
Yes
Then it would become pretty much obvious, why this is not supposed to work.
I'll
' ||
NULL easy.
What about adding something like operator ||| in the orafce package for
concat?
Regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
event for several executions
of NOTIFY.
So if your notify for instance could also add a unique number to the
notification name, then it will probably work as expected.
Regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
for several executions
of NOTIFY.
So if your notify for instance could also add a unique number to the
notification name, then it will probably work as expected.
Regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
41 matches
Mail list logo