On Tue, Mar 4, 2014 at 1:13 PM, Sameer Kumar sameer.ku...@ashnik.comwrote:
On Tue, Mar 4, 2014 at 2:57 PM, Adarsh Sharma eddy.ada...@gmail.comwrote:
I tried creating simple and gin indexes on the column(t_ids) but still
not helping. Anyone has any idea or faced this before. Postgresql
On Tue, Mar 4, 2014 at 4:19 PM, Adarsh Sharma eddy.ada...@gmail.com wrote:
Is dere any way i can rewrite the query so that i need not to set
seqscan-off, because i dont want to embed one more line in application
code and also dont want to change global setting in postgresql.conf to
disable
I wonder how to quickly recovery failed master? If I directly startup the
failed master as slave ( assign proper parameter), is there any problem? For
example, I don't do any copy operation in script of
recovery_1st_stage_command and recovery_2st_stage_command.
According to this document:
2014-03-04 10:19 GMT+02:00 Adarsh Sharma eddy.ada...@gmail.com:
PLAN
-
HashAggregate
Hello,
I would like to log statements that modify a small subset of tables in a
databases.
(not all tables, because the log files become too big in that case and I
also worry about performance)
I currently use log_statement='mod' but I didn't find a way to limit
this to the set of tables I
So, there's no way to do this?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Read-tables-of-sql-server-with-postgres-tp5793046p5794581.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list
On Tue, Mar 4, 2014 at 6:48 AM, loref85 lore...@yahoo.com.ar wrote:
So, there's no way to do this?
You might want to give jdbc-fdw a try. not sure what's wrong with
odbc -- looks like a driver mismatch issue.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Le 2014-03-03 à 10:53, Adrian Klaver a écrit :
On 03/02/2014 08:48 PM, François Beausoleil wrote:
Hi all,
I have four roles involved:
meetphil - the database owner, should not login
mpwebui - the role the web application logs in as, should have very limited
privileges, but should be
On 03/04/2014 04:48 AM, loref85 wrote:
So, there's no way to do this?
In your original post you said you found a version of odbc_fdw that
compiled for 9.2+, but hung on a select due to this error:
ERROR: odbc_fdw::odbcGetTableSize: Could not retrieve table size
Have you tried to contact
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
balance',5);
now when i am trying to paste this in postgres in Solaris , it is giving me
error
fm_db_Server1-# insert into
On Mar 4, 2014, at 2:19 AM, David Janssens davi...@almacom.co.th wrote:
Hello,
I would like to log statements that modify a small subset of tables in a
databases.
(not all tables, because the log files become too big in that case and I also
worry about performance)
I currently use
Tom Lane wrote:
Albe Laurenz laurenz.a...@wien.gv.at writes:
Is there anything that varchar_pattern_ops is needed for that
text_pattern_ops cannot provide?
Lack of surprise? If you're creating a pattern index on a varchar column,
you'd likely expect to need to mention varchar_pattern_ops.
ajay akmani1...@gmail.com writes:
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','Øب|welcome|à¤à¤ªà¤à¤¾à¤¸à¥à¤µà¤¾à¤à¤¤à¤¹à¥','bye','goodbye','low
balance',5);
now when i am trying to paste this in postgres
On 03/04/2014 03:03 AM, ajay wrote:
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
balance',5);
now when i am trying to paste this in postgres in Solaris , it is giving me
On 03/04/2014 07:39 AM, Adrian Klaver wrote:
CCing list:
quote author='Adrian Klaver-4'
On 03/04/2014 03:03 AM, ajay wrote:
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
Hello,
I ran into trouble with an xpath expression on a large XML file:
SELECT id, xpath('//tei:div/descendant::tei:head/text()', x, ARRAY[ARRAY['tei',
'http://www.tei-c.org/ns/1.0']]) AS stuff FROM test WHERE id=1;
returns:
ERROR: could not parse XML document
DETAIL: line 491482: internal
On 03/04/2014 06:00 AM, François Beausoleil wrote:
Le 2014-03-03 à 10:53, Adrian Klaver a écrit :
On 03/02/2014 08:48 PM, François Beausoleil wrote:
Hi all,
I have four roles involved:
meetphil - the database owner, should not login
mpwebui - the role the web application logs in as, should
thanks for the reply ,..
When i am trying to enter anything else other then some Arabic , Hindi ..
that case it does not give this error.
like if i enter..
insert into table values('welcome',1);
then it does not give any error and get successfully
Thanks
--
View this message in context:
Hi all:
I have a table that has multiple records for a single owner_id. I'm able to
use array_arg to combine the records into a single row, which works fine. I'm
using this sql:
select owner_id, array_agg(trim(maplot)), array_agg(revallandvalue +
revalbuildingvalues) from parcel group by
On Tue, Mar 4, 2014 at 1:49 PM, Owen Hartnett o...@clipboardinc.com wrote:
Hi all:
I have a table that has multiple records for a single owner_id. I'm able to
use array_arg to combine the records into a single row, which works fine.
I'm using this sql:
select owner_id,
David Janssens davi...@almacom.co.th writes:
Hello,
I would like to log statements that modify a small subset of tables in
a databases.
(not all tables, because the log files become too big in that case and
I also worry about performance)
I currently use log_statement='mod' but I didn't
Roy Anderson roy.ander...@gmail.com wrote:
We have an OLTP database and no data warehouse. We are currently
planning out a build for a data warehouse however (possibly using
Hadoop). X is recommending that we convert our current,
normalized OLTP database into a flattened Star Schema.
I'm not
On Tue, Mar 4, 2014 at 2:15 PM, Kevin Grittner kgri...@ymail.com wrote:
Roy Anderson roy.ander...@gmail.com wrote:
We have an OLTP database and no data warehouse. We are currently
planning out a build for a data warehouse however (possibly using
Hadoop). X is recommending that we convert our
Merlin Moncure-2 wrote
On Tue, Mar 4, 2014 at 1:49 PM, Owen Hartnett lt;
owen@
gt; wrote:
It looks like I should be able to use the window function to do this,
but
I've been unsuccessful. The following runs, but doesn't seem to have any
effect:
select owner_id,
On 03/04/2014 01:40 PM, Merlin Moncure wrote:
On Tue, Mar 4, 2014 at 2:15 PM, Kevin Grittner kgri...@ymail.com wrote:
Roy Anderson roy.ander...@gmail.com wrote:
We have an OLTP database and no data warehouse. We are currently
planning out a build for a data warehouse however (possibly using
On Tue, Mar 4, 2014 at 9:19 PM, David Janssens davi...@almacom.co.thwrote:
Hello,
I would like to log statements that modify a small subset of tables in a
databases.
(not all tables, because the log files become too big in that case and I
also worry about performance)
I currently use
On Tue, Mar 4, 2014 at 6:26 PM, leo dazhou...@gmail.com wrote:
I wonder how to quickly recovery failed master? If I directly startup the
failed master as slave ( assign proper parameter), is there any problem?
Yep, if the master has got ahead of the slave in term of WAL replay
where WAL forked
I find a solution to short the recover time by configure parameter
Synchronous Transfer. Refer to :
https://wiki.postgresql.org/wiki/Synchronous_Transfer.
But I don't which postgreSQL will enable this parameter, I install
9.3.3-1 on redhat, but I don't find this parameter in postgresql.conf.
On Wed, Mar 5, 2014 at 2:14 PM, leo dazhou...@gmail.com wrote:
I find a solution to short the recover time by configure parameter
Synchronous Transfer. Refer to :
https://wiki.postgresql.org/wiki/Synchronous_Transfer.
But I don't which postgreSQL will enable this parameter, I install
29 matches
Mail list logo