Thanks, not sure how to download and apply this patch, not getting any down
load link. ?
On Wed, Jul 10, 2013 at 9:16 AM, Michael Paquier
michael.paqu...@gmail.comwrote:
On Tue, Jul 9, 2013 at 6:26 PM, itishree sukla itishree.su...@gmail.com
wrote:
Hello Every one,
I have a requirement
On Wed, Jul 10, 2013 at 3:10 PM, itishree sukla
itishree.su...@gmail.com wrote:
Thanks, not sure how to download and apply this patch, not getting any down
load link. ?
In the section Comments, some of the lines are referred by patch.
Click on the latest one. You will be redirected to the email
I have used this method successfully on another table but this one is not
working.
I have a table of nearly 800 million records with some duplicates in.
Here is an example:
select rart_id, r9, ra, ry, rw, rv, rp, rs, ri
from isi.rcited_ref
where rart_id = 'A1986D733500019';
renders a result of
On Tue, Jul 9, 2013 at 11:16 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
Where are you connecting from? If you are connecting locally using
sockets(local above) or host(line 3,4,5 above) then you are bypassing ssl.
I'm connecting from 192.168.0.74 and I commented line5 as following:
local
On Tue, Jul 9, 2013 at 11:21 PM, Jeff Janes jeff.ja...@gmail.com wrote:
From your original email:
db.setHostName(localhost);
So localhost is probably matching 127.0.0.1/32 or ::1/128, which
are explicitly allowed.
I'm using this and still able to connect without SSL
Hello all,
Is there a parameter to log any SQL query as a single
line in audit logs? I have some problems in my SIEM application. If a
DBA sends the query as a single line I can gather the whole query, but
if he enters like
UPDATE x ...
y=Z ..
where ..
I
On Wed, Jul 10, 2013 at 12:04 PM, Muhammad Bashir Al-Noimi
mbno...@gmail.com wrote:
On Tue, Jul 9, 2013 at 11:21 PM, Jeff Janes jeff.ja...@gmail.com wrote:
From your original email:
db.setHostName(localhost);
So localhost is probably matching 127.0.0.1/32 or ::1/128, which
are explicitly
On Wed, Jul 10, 2013 at 12:16 PM, Magnus Hagander mag...@hagander.net wrote:
requiressl=0 doesn't mean what you think it means, and that's one
reason it has been deprecated since at least 8.2.
requiressl=0 means negotiate. use ssl if the server asks for it, but
accept not using ssl. So this
Robert James srobertja...@gmail.com wrote:
In relational algebra, I have relation R and relation S, and want
to find the cardinality of R, of S, and of R-intersect-S.
I know the SQL for R and S. What's the best way to compute the
cardinality of each relation (query) and of their
On 07/10/2013 03:20 AM, Muhammad Bashir Al-Noimi wrote:
On Wed, Jul 10, 2013 at 12:16 PM, Magnus Hagander mag...@hagander.net wrote:
requiressl=0 doesn't mean what you think it means, and that's one
reason it has been deprecated since at least 8.2.
requiressl=0 means negotiate. use ssl if the
hello again!
since there was a problem with my email and the reply
was not sent, so I'm re-posting my reply..
Again.. the structure as I exported it from phpPgAdmin is:
*-- My table 'foo'
*
*CREATE TABLE foo (
*
*foo_id integer NOT NULL,*
*blaa_id integer NOT NULL,*
*blaa_num
Dear Johann,
I tried (with PostgreSQL 9.2) to run the two DELETE statements you
describe in your mail (the first based on the id field, the second on
the ctid) and they work! I have to point out that if you use the DELETE
based on the id field YOU'LL DELETE ALL RECORDS having at least one
On Wed, Jul 10, 2013 at 3:04 AM, Muhammad Bashir Al-Noimi
mbno...@gmail.com wrote:
On Tue, Jul 9, 2013 at 11:21 PM, Jeff Janes jeff.ja...@gmail.com wrote:
From your original email:
db.setHostName(localhost);
So localhost is probably matching 127.0.0.1/32 or ::1/128, which
are explicitly
giozh gi...@yahoo.it wrote:
ok, it works. But why on error message i had that two unknown
data type? if was an error on date type, why it don't signal
that?
Because PostgreSQL treats a quoted literal as being of unknown type
-- each of these could have matched a parameter of any type, and
Hi,
You can try following query on test database to remove duplicates.
DELETE FROM isi.rcited_ref a
WHERE a.ctid (SELECT min(ctid) FROM isi.rcited_ref b
WHERE a.rart_id = b.rart_id
AND a.r9 = b.r9
AND a.ra = b.ra
AND a.ry = b.ry
AND a.rw =
Hi Emre,
Am 10.07.2013 12:16, schrieb Emre ÖZTÜRK:
Hello all,
Is there a parameter to log any SQL query as a single line in audit
logs? I have some problems in my SIEM application. If a DBA sends the
query as a single line I can gather the whole query, but if he enters like
UPDATE x
Hi:
v9.0.1 on linux
Is there a way to query on synonyms of a value transparent to the user?
For example, a column called animal can have any text value, including
'horse' and 'cow' and 'pig'. But I want the user to find all the animal='pig'
records if they specify 'hog' instead.
So..
http://www.postgresql.org/message-id/440d446e.7040...@cybertec.at
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, July 10, 2013 3:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to implement a value
Also this:
http://www.postgresql.org/docs/9.2/static/textsearch-configuration.html
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, July 10, 2013 3:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to
Hi,
We are try to connect to Greenplum database from PostgreSQL 9.3 beta2 via
postgres_fdw, but the Greenplum Database does not support REPEATABLE READ
transactions, can we specify other isolation leves?
Regards,
Xiaobo Gu
20 matches
Mail list logo