I am partitioning a number of tables in our system and am using a view on the
real master table with 'instead of’ triggers to insert and update rows. I have
used a view because my application uses Hibernate which does not work well with
triggers that return a null to indicate no further process
Thanks Craig.
> How exactly do you restart the node?
Using "service postgresql-9.4 restart" command to do the service restart.
> Please show the full log line, not just an excerpt, along with the lines
> around
it.
> If possible run with log_error_verbosity=verbose and show the extra line(s)
pri
> Hi,
>
> my task is to search partial text in the fields mentioned in query.
Basically I have to tables t1 and t2 and I need to search in t1 all the
codes returned by a query from t2. In t1 the values could be identical as
in t2 or could be partial. For example.
>
> T1:
>
> Description
>
> 190201
Hello,
Thank you for your reply.
> We could probably use a WaitForBackgroundWorkerTermination(...) to
> correspond to WaitForBackgroundWorkerStartup(...) .
>
> I think you'll probably want to GetBackgroundWorkerPid(...) and examine
> the returned BgwHandleStatus to see if it's BGWH_STOPPED . If n
Thanks for your detailed explanation, Kevin. I will check my system again
keeping SIReadLock in mind.
By the way, does max_locks_per_transaction limit all others modes of locks
by the same way?
On 7 January 2015 at 00:34, Kevin Grittner wrote:
> Andrey Lizenko wrote:
>
> >> 2014-12-28 14:33:23
Here is the snippet of the error, I am really puzzled why I cannot install
postgres.
clang: error: unsupported option '-V -isystem/opt/boxen/homebrew/include'
clang: error: unknown argument: '-qversion’
any thoughts?
thanks a lot
This file contains any messages produced by compilers
"Jimmy Jack" writes:
> Here is the snippet of the error, I am really puzzled why I cannot install
> postgres.
> clang: error: unsupported option '-V -isystem/opt/boxen/homebrew/include'
> clang: error: unknown argument: '-qversionâ
The fragment of config.log you provided looks perfectly normal
the log is really big, full of errors and ends with error 1
Undefined symbols for architecture x86_64:
"_gethostbyname_r", referenced from:
_main in conftest-7b666a.o
ld: symbol(s) not found for architecture x86_64
clang: error: linker command failed with exit code 1 (use -v
Thanks.
I tried putting all the modules under the contrib directory to the
exclude list. Although I could compile, 3 of 153 regression tests
fail. I have attached the regression.diffs file.
Maybe some contrib modules are absolutely needed?
--
Deepak
On Wed, Jan 7, 2015 at 6:19 PM, Michael Paq
"Jimmy Jack" writes:
> the log is really big, full of errors and ends with error 1
> Undefined symbols for architecture x86_64:
> Â "_gethostbyname_r", referenced from:
That's expected too, on OS X. There are *lots* of expected failures
in a configure run.
Please, if you're unable to identify
I sent the message, it is pending review due its size… meanwhile there is the
cache part
thanks a lot!
## ##
## Cache variables. ##
## ##
ac_cv_build=x86_64-apple-darwin14.1.0
ac_cv_c_bigendian=no
ac_cv_c_compiler_gnu=yes
ac_cv_c_flexmember=ye
"Jimmy Jack" writes:
> here it is, I apologize in advance for very large email
The problem is evidently here:
configure:12997: checking test program
configure:13007: clang -o conftest -O2 -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-a
On Fri, Jan 9, 2015 at 11:00 AM, deepak wrote:
> Thanks.
>
> I tried putting all the modules under the contrib directory to the
> exclude list. Although I could compile, 3 of 153 regression tests
> fail. I have attached the regression.diffs file.
Even Postgres HEAD has just 151 tests, aren't you
thank you so much! that solved my issue
On Thu, Jan 8, 2015 at 6:23 PM, Tom Lane wrote:
> "Jimmy Jack" writes:
>> here it is, I apologize in advance for very large email
> The problem is evidently here:
> configure:12997: checking test program
> configure:13007: clang -o conftest -O2 -Wall -Wmi
On 01/09/2015 12:53 AM, Beena Emerson wrote:
> Is there any way to check if the bgworker has unregistered and freed a
> slot?
Not that I'm aware of. Anyone else have suggestions?
This is related to some other discussion we've had about needing a way
to enumerate bgworkers. The specific issue of f
On 09/17/2014 05:35 AM, Michael Paquier wrote:
> On Thu, Sep 11, 2014 at 10:25 PM, Craig Ringer wrote:
>> The PostgreSQL installer now uses the NETWORKSERVICE account on Windows
>> by default (as of 9.2), instead of creating a "postgres" account with
>> username and password. Which is a big improv
16 matches
Mail list logo
