IIRC, service failure creates some event logs information in windows. And
also you can verify the bit rock installer log files from %TEMP% location.
Regards,
Dinesh
manojadinesh.blogspot.com
On Mon, Mar 25, 2013 at 5:05 PM, jayaram s <123jaya...@gmail.com> wrote:
> Hello
> I have installed Postg
Hi all
is it possible to introduce similar solution for Windows systems in future?
I am aware it is not available because of lack of posix_fadvise function,
but I believe there is a way to introduce this feature for Win systems.
Regards,
Bartek
Hi,
We are currently evaluating the feasibility of executing long-running
scripts written in shell-script (plsh) called by triggers (after
update/insert) to synchronize two databases. Will triggers (after
update specifically) cause the execution of SQL-commands to pause
until the trigger-function
Emanuel Araújo wrote:
> I'm having trouble making a base to access Oracle via dbi-link, because when
> installing DBD::Oracle
> version 1.58 the same mistakes some missing files. Ago as "oci.h", it is
> being called within the
> oracle.h
>
> The purpose would be to sync data between two tools fo
On 26/03/13 08:52, Clemens Eisserer wrote:
Hi,
We are currently evaluating the feasibility of executing long-running
scripts written in shell-script (plsh) called by triggers (after
update/insert) to synchronize two databases. Will triggers (after
update specifically) cause the execution of SQL-
On 26/03/13 05:55, adrian.kitching...@dse.vic.gov.au wrote:
I'm hoping I can get some info on a query which terminates my PostgreSQL
service.
The query is a relatively simple PostGIS query:
The log text when the service crashes is:
2013-03-26 15:49:55 EST LOG: server process (PID 3536) was
Well, I did it:
explain (analyze, buffers)
select count(*) from turma.aula_confirmacao where
inicio_aula::DATE BETWEEN DATE_TRUNC('YEAR', CURRENT_TIMESTAMP) AND
CURRENT_TIMESTAMP; -- changed name because of a conflict in some queries
http://explain.depesz.com/s/Fzr
And just to update, this is th
Hi Richard,
>> Will triggers (after
>> update specifically) cause the execution of SQL-commands to pause
>> until the trigger-function has returned (at statement execution time
>> or commit)?
>
> The trigger will block. If it didn't then it couldn't abort the transaction
> if it needed to.
Thank
On Tue, Mar 26, 2013 at 3:35 AM, Bartosz Dmytrak wrote:
> Hi all
> is it possible to introduce similar solution for Windows systems in future?
> I am aware it is not available because of lack of posix_fadvise function,
> but I believe there is a way to introduce this feature for Win systems.
Prob
On 26/03/13 13:24, Clemens Eisserer wrote:
Hi Richard,
Will triggers (after
update specifically) cause the execution of SQL-commands to pause
until the trigger-function has returned (at statement execution time
or commit)?
The trigger will block. If it didn't then it couldn't abort the tran
Hi Richard,
> Might be worth looking at PgQ - a queueing system underlying Londiste. That
> would handle tracking the changes in PostgreSQL leaving you to just handle
> the MySQL end. Timestamps will do the job as long as you are careful to
> allow enough slack to deal with clock updates.
Thanks
Hi,
I was a bit surprised that the following DDL will work:
create table parent (id integer not null primary key);
create table child (id integer not null primary key, pid integer not null);
alter table child
add constraint fk_child_parent
foreign key (pid) references parent(id);
alt
Thomas Kellerer writes:
> While I agree that this SQL should not have been written like this in the
> first place, I wonder why Postgres doesn't actively prevent this (like e.g.
> Oracle).
If Oracle does that, they're violating the SQL standard --- there is
nothing in the standard that supports
Tom Lane, 26.03.2013 17:03:
While I agree that this SQL should not have been written like this
in the first place, I wonder why Postgres doesn't actively prevent
this (like e.g. Oracle).
If Oracle does that, they're violating the SQL standard --- there is
nothing in the standard that supports r
Thomas Kellerer writes:
> Tom Lane, 26.03.2013 17:03:
>> If Oracle does that, they're violating the SQL standard --- there is
>> nothing in the standard that supports rejecting an ALTER TABLE ADD
>> CONSTRAINT on the grounds that it's redundant. The spec only says
>> you can't give two constraint
On 26 March 2013 17:07, Thomas Kellerer wrote:
> Is there anything in the standard that actively requires that you can
>>> create two "identical" constraints?
>>
>>
> Because technically it simply doesn't make sense, does it?
>
It can make sense during a maintenance window, if you create a new
(
psql -U postgres
psql (9.2.3)
Type "help" for help.
postgres=# select encode('can''t', 'escape');
encode
can't
(1 row)
I observed the same behaviour on one of our older systems (8.3.11) as well.
Am I missing something? I expected "can''t" as the output.
--
Bill Moran
http://www.p
On Tue, Mar 26, 2013 at 12:47 PM, Bill Moran wrote:
>
> psql -U postgres
> psql (9.2.3)
> Type "help" for help.
>
> postgres=# select encode('can''t', 'escape');
> encode
>
> can't
> (1 row)
>
> I observed the same behaviour on one of our older systems (8.3.11) as well.
>
> Am I missing
CR Lender wrote:
> According to the manual (9.1), pg_stat_get_last_vacuum_time() returns
>
> timestamptz | Time of the last non-FULL vacuum initiated by the
> | user on this table
>
> Why are full vacuums excluded from this statistic? It looks like there's
> no way to get the
In response to Merlin Moncure :
> On Tue, Mar 26, 2013 at 12:47 PM, Bill Moran wrote:
> >
> > psql -U postgres
> > psql (9.2.3)
> > Type "help" for help.
> >
> > postgres=# select encode('can''t', 'escape');
> > encode
> >
> > can't
> > (1 row)
> >
> > I observed the same behaviour on
On Tue, Mar 26, 2013 at 1:36 PM, Bill Moran wrote:
> I get "can't" which is what I'd expect. I would then expect
> encode to escape the ' somehow.
nope -- encode/escape doesn't escape single quotes. it's not designed
to produce output that can be fed directly back into the database (at
least, no
Bill Moran writes:
> If I just do:
> SELECT 'can''t'::text;
> I get "can't" which is what I'd expect. I would then expect
> encode to escape the ' somehow. Even c-style escaping, like
> "can\'t" would have been less surprising to me.
> If there's something I'm missing, I'm still missing it.
Th
I'd like to cache parts of my database locally on each client. To keep
those caches in sync I'd like to implement an invalidation queue.
A naïve approach would be to simply create a table of (txn_id,
invalidated_object_ids), then have the clients query this table for
txn_ids > last_queried_txn_id.
On Mar 12, 2013, at 4:13 PM, Tom Lane wrote:
> Erik Jones writes:
>> What's the best way to determine the age of the current WAL? Not the
>> current segment, but the whole thing. Put another way: is there a way to
>> determine a timestamp for the oldest available transaction in the WAL?
>
Erik Jones writes:
> On Mar 12, 2013, at 4:13 PM, Tom Lane wrote:
>> Transaction commit and abort records carry timestamps, so you could
>> figure this out with something like pg_xlogdump. I don't know of any
>> canned solution though.
> Anyway, will pg_xlogdump work with any previous versions o
On 26 March 2013 22:21, Tom Lane wrote:
> The version recently added to contrib is only meant to work with the
> current server release, AFAIK. However, it's derived from older
> standalone programs that are out there somewhere --- did you look around
> on pgfoundry?
Actually, I think the versio
Thanks for the suggestion Richard.
I dumped the two tables in question and restored them which got the query
working for a while until it eventually crashed the service again at
another gid. I'll do a RAM check tonight.
I transferred the whole database to another computer and so far the query
i
Hi,
is there any way to use a module within a pltcl script, i.e. have
load /path/to/mystuff.so
or
package require mystuff
in a script.
The reason why I am asking: I have recently converted a fairly slow script
(lots of regex) into one compiled module that basically does all regex at once,
and cr
I've been working on some queries involving multiple unnested columns. At
first, I expected the number of rows returned would be the product of the
array lengths, so that this query would return 4 rows:
SELECT unnest2(array['a','b']),unnest2(array['1','2']);
when in fact it returns 2:
unnest2
2013/3/27 Ken Tanzer
>
> I've been working on some queries involving multiple unnested columns. At
> first, I expected the number of rows returned would be the product of the
> array lengths, so that this query would return 4 rows:
>
> SELECT unnest2(array['a','b']),unnest2(array['1','2']);
>
>
30 matches
Mail list logo
