The following bug has been logged on the website:
Bug reference: 7605
Logged by: James
Email address: jameshun...@163.com
PostgreSQL version: 9.2.1
Operating system: CentOS 6.2
Description:
When I modify the "listen_addresse" from 'localhost' to '*', postgresql
servic
The following bug has been logged on the website:
Bug reference: 7606
Logged by: James
Email address: jameshun...@163.com
PostgreSQL version: 9.2.1
Operating system: CentOS 6.2
Description:
When I modify the "listen_addresse" from 'localhost' to '*', postgresql
servic
On 10/15/2012 11:10 PM, seancompusult wrote:
Does anyone have a solution for people like me who must use Java 5?
I had no problems building current git head of the JDBC driver with Java
SE 5, nor the REL_9_2_STABLE branch.
export PATH=$HOME/java/jdk1.5.0_22/bin:$HOME/java/jdk1.5.0_22/jre/bi
On 10/15/2012 10:54 PM, devenmtha...@gmail.com wrote:
The following bug has been logged on the website:
Bug reference: 7603
Logged by: Deven
Email address: devenmtha...@gmail.com
PostgreSQL version: 9.0.3
Operating system: Windows 2003 R2 64 BITS
Description:
Hi,
My applica
On 10/15/2012 06:55 PM, daniel.he...@sweco.se wrote:
The following bug has been logged on the website:
Bug reference: 7602
Logged by: Daniel Hedén
Email address: daniel.he...@sweco.se
PostgreSQL version: 9.2.1
Operating system: Windows 7 / Vista 64-Bit
Description:
Select w
On Mon, Oct 15, 2012 at 05:41:36AM -0400, Noah Misch wrote:
> > --- a/src/port/sprompt.c
> > +++ b/src/port/sprompt.c
> > @@ -60,8 +60,13 @@ simple_prompt(const char *prompt, int maxlen, bool echo)
> > * Do not try to collapse these into one "w+" mode file. Doesn't work on
> > * some plat
On Sun, Oct 14, 2012 at 09:56:46AM -0700, Josh Kupershmidt wrote:
> On Sat, Oct 13, 2012 at 3:56 PM, Thom Brown wrote:
>
> > I have noticed that, using pg_ctl, if you start Postgres using a
> > relative path, then attempt to restart it from anywhere else, it
> > fails.
>
> Yeah, I was complainin
Bill MacArthur writes:
> Update, I started placing primary keys on the testcase tables and watched the
> planner output. Once I put a PK on one of the tables in particular, the
> planner revised the plan to use the PK. At that point, the results become
> erroneous as the planner also moves anot
On 10/15/2012 2:29 PM, Tom Lane wrote:
Bill MacArthur writes:
Tom, in preparation for a test case I created a new schema (testcase) and
copied 6 tables to that, including only the columns significant to enable the
VIEWs to be created. I took the 3 VIEWs involved and tweaked them into the new
Bill MacArthur writes:
> Tom, in preparation for a test case I created a new schema (testcase) and
> copied 6 tables to that, including only the columns significant to enable the
> VIEWs to be created. I took the 3 VIEWs involved and tweaked them into the
> new schema (just renamed to testcase.
On 10/15/2012 12:18 PM, Tom Lane wrote:
webmas...@dhs-club.com writes:
vip_declines_mailers_base is another VIEW that merely adds some criteria to
limit the result set of the 'base' VIEW. In versions 9.0 and back it did
just that. After upgrading to 9.2, the criteria actually expand the result
s
On Mon, Oct 15, 2012 at 11:27 PM, Heikki Linnakangas
wrote:
> On 15.10.2012 13:13, Heikki Linnakangas wrote:
>>
>> On 13.10.2012 19:35, Fujii Masao wrote:
>>>
>>> ISTM you need to update the protocol.sgml because you added
>>> the field 'replyRequested' to WalSndrMessage and StandbyReplyMessage.
>
webmas...@dhs-club.com writes:
> vip_declines_mailers_base is another VIEW that merely adds some criteria to
> limit the result set of the 'base' VIEW. In versions 9.0 and back it did
> just that. After upgrading to 9.2, the criteria actually expand the result
> set.
This doesn't seem to match any
The following bug has been logged on the website:
Bug reference: 7604
Logged by: Bill MacArthur
Email address: webmas...@dhs-club.com
PostgreSQL version: 9.2.1
Operating system: CentOS 5.8
Description:
vip_declines_mailers_base is a VIEW that itself uses another VIEW
Vaclav Juza writes:
> I have modified the test case (it is more similar to the real-word
> query), so that now it is slower on 9.2.1 than on 9.1.4 (the version
> with the explicit cast):
FWIW, testing this on HEAD (with the patch I committed last week),
I get a plan that's about 10% faster than 9
To add to this, it's not just a question of making more sense. Compiling the
code with Java 7 means the generated class files are version 51, which is
not acceptable to a Java 5 JRE - it wants version 49. So the existing
pre-built jar cannot simply be dropped into a Java 5 app.
To get around thi
Thanks craig,
Since we got response from other community guys that i have to upgrade to
9.0.10 to resolve this issue. Since many permission related issues have
been fixed till this release. So planning to upgrade to 9.0.10.
Regards
Deven
On Sun, Oct 14, 2012 at 11:19 AM, Craig Ringer wrote:
> O
Hi,
My application takes longer time (we see time out even) when data to be
fetched from Postgresql 9.0.3 is around 190 records. I am doing an
improvement at application level, but from database side any performance
tuning do i need to do?
I have not changed any parameters in postgresql.conf, s
The following bug has been logged on the website:
Bug reference: 7603
Logged by: Deven
Email address: devenmtha...@gmail.com
PostgreSQL version: 9.0.3
Operating system: Windows 2003 R2 64 BITS
Description:
Hi,
My application takes longer time (we see time out even) wh
On Mon, Oct 15, 2012 at 3:31 PM, Craig Ringer wrote:
>
> OK, that sounds more like a problem. It wasn't clear from your original
> post that it was replaying used sequence values.
>
> SIGINT should normally just terminate the statement, eg:
>
> regress=# SELECT pg_sleep(100);
> ERROR: canceling
The following bug has been logged on the website:
Bug reference: 7602
Logged by: Daniel Hedén
Email address: daniel.he...@sweco.se
PostgreSQL version: 9.2.1
Operating system: Windows 7 / Vista 64-Bit
Description:
Select with many joins against the same table is very s
You misunderstand me.
According to the server logs I have sent in the first message process
received signal 2 (it is SIGINT) and according to the documentation this
signal should not couse server crash. Wrong values of sequences does not
mean hole in generated values, but sequence started to genera
On 15.10.2012 13:13, Heikki Linnakangas wrote:
On 13.10.2012 19:35, Fujii Masao wrote:
ISTM you need to update the protocol.sgml because you added
the field 'replyRequested' to WalSndrMessage and StandbyReplyMessage.
Oh, I didn't remember that we've documented the specific structs that we
pass
On 10/15/2012 04:17 PM, Michał Hankiewicz wrote:
You misunderstand me.
According to the server logs I have sent in the first message process
received signal 2 (it is SIGINT) and according to the documentation this
signal should not couse server crash. Wrong values of sequences does not
mean hole
On 12/10/2012 23:24, Tom Lane wrote:
> vaclav.j...@xitee.com writes:
>
>> In the real case we faced this problem, the performance loss was much higher
>> on PostgreSQL 9.2.1 (3 seconds vs. 3 minutes) than on 9.1.4 (1.3 seconds vs.
>> 7 seconds) and both variants were slower on 9.2.1 than on 9.1.4.
At first week, I can `t even compile. But now I compiled it without
errors. Then I built the installer. But during installation there is an
error. Library not loaded. I want to get a full cycle from compile to
install. I need my own distribution. I need my own installer. I tried
to do it on VS
On 13.10.2012 19:35, Fujii Masao wrote:
On Thu, Oct 11, 2012 at 11:52 PM, Heikki Linnakangas
wrote:
Ok, thanks. Committed.
I found one typo. The attached patch fixes that typo.
Thanks, fixed.
ISTM you need to update the protocol.sgml because you added
the field 'replyRequested' to WalSnd
On Sun, Oct 14, 2012 at 12:10:42PM -0400, Tom Lane wrote:
> Alexander Law writes:
>
> > +#ifdef WIN32
> > + termin = fopen("CONIN$", "r");
> > + termout = fopen("CONOUT$", "w+");
> > +#else
> > termin = fopen(DEVTTY, "r");
> > termout = fopen(DEVTTY, "w");
> > +#endif
> > if (!ter
On Sun, Oct 14, 2012 at 10:35:04AM +0400, Alexander Law wrote:
> I agree with you, CONOUT$ way is much simpler. Please look at the patch.
See comments below.
> Regarding msys - yes, that check was not correct.
> In fact you can use "con" with msys, if you run sh.exe, not a graphical
> terminal.
On 11.10.2012 22:36, Tom Lane wrote:
Heikki Linnakangas writes:
Hmm, starting with 9.3, postmaster can not only create and append to the
end of file, it can also inject a line in the middle, shifting the
following lines forwards. In theory, if a new line is injected into the
middle of the file
30 matches
Mail list logo
