The following bug has been logged on the website:
Bug reference: 8213
Logged by: Eric Soroos
Email address: eric-postgre...@soroos.net
PostgreSQL version: 9.0.13
Operating system: Ubuntu 10.04, 32bit
Description:
This has been replicated on 9.2.4 and HEAD by ilmari_
orts lack of support for the FOR UPDATE
clause though, probably because it is only supported by some of their umpteen
back-end engines so it varies from one table to another :D
Eric
On 1/29/2012 3:02 AM, Dave Page wrote:
On Sat, Jan 28, 2012 at 2:47 AM, Dharmendra Goyal
wrote:
Nice analysis Eric. ANy idea why (which program set this) this particular
registry was set.
Dave, shall we consider using "%COMSPEC% /c" with 0 as second parameter..??
We can certai
On 1/27/2012 7:47 PM, Dharmendra Goyal wrote:
Nice analysis Eric. ANy idea why (which program set this) this
particular registry was set.
Thanks Dharmendra! It was pretty exhausting.
I haven't a clue how this got changed. I tried goofing around with
shift, ctrl, etc. and I wasn't ev
REG_SZ (Applications\cmd.exe)
Deleting the \UserChoice key restored my context menu and ability to run
a ".bat" directly instead of using %COMSPEC%.
I am going to un-install an re-install postgres to verify that this
solves my installation issues.
Eric
On 1/27/2012 12:41 PM,
y. So it looks
like the UserChoice registry key, however it got there, is the essence
of the problem.
Which, of course, %COMSPEC% /c would avoid because the program handling
batch files is explicit.
Thanks,
Eric
On 1/27/2012 1:16 PM, Eric Borts wrote:
I found the problem with my
menu."
http://support.microsoft.com/kb/320036
This advice would be likely to hang the PostgreSQL installer.
Cheers,
Eric
On 1/27/2012 12:32 PM, Eric Borts wrote:
Hi Dave and Dharmendra,
It is not the "%COMSPEC% /c" call that causes the window to popup, but
the WindowStyle paramete
Also, here is a link to the same issue on StackOverflow:
http://stackoverflow.com/questions/3559719/wscript-shell-run-doesnt-work-consistently
Also solved using %COMSPEC% /c, though it doesn't say why this is a problem.
Cheers,
Eric
On 1/26/2012 11:37 AM, Eric Borts wrote:
On 1/26/2012
On 1/26/2012 1:17 AM, Dave Page wrote:
Dharmendra, can you look into this please?
Eric, is there anything unusual about the configuration of your
machine? Suffice it to say, this doesn't normally happen.
Hi Dave, I'm guessing the answer to that question is "yes". The machin
On Wed, Oct 5, 2011 at 1:24 AM, Dave Page wrote:
>
>
> On Wednesday, October 5, 2011, Thomas Kellerer wrote:
> > Dave Page, 04.10.2011 21:46:
>
> >>
> >> We updated our build system to use BitRock 7 today (for unrelated
> >> reasons) which has new features for ACL management. We're going to
> >>
The following bug has been logged online:
Bug reference: 6219
Logged by: Eric Vollnogel
Email address: edvollno...@dstsystems.com
PostgreSQL version: 9.0.4 64bit
Operating system: Windows 7 SP 1 64bit
Description:date_part() function producting incorrect year
Details
The following bug has been logged online:
Bug reference: 6033
Logged by: Eric Kolotyluk
Email address: eric.koloty...@gmail.com
PostgreSQL version: 9.0.4-1 x86
Operating system: Windows XP
Description:Nonstandard Install Directory Fails
Details:
If I try to run the
(select
cs.respondent_id from chat_session cs where cs.project_id in (select project_id
from
project where company_id = 4));
Cheers,
Eric
On 2/22/2011 1:07 PM, Scott Dunbar wrote:
Yes, you're correct. I guess this makes sense but it does seem
strange that I can enter garbage in a quer
w should produce different behavior like this, and if
there were any other workarounds or caveats about what may be going on
that I should be aware of...
Regards,
Eric
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
The following bug has been logged online:
Bug reference: 5584
Logged by: BEAUSSART ERIC
Email address: eric.beauss...@orange.fr
PostgreSQL version: 8.4.4
Operating system: Windows
Description:Module unfound
Details:
Sir, I loaded PostgreSQL, as asked when I started
The following bug has been logged online:
Bug reference: 5325
Logged by: Eric Vollnogel
Email address: edvollno...@dstsystems.com
PostgreSQL version: 8.4.2
Operating system: Windows XP
Description:Timestamp w/ timezone + interval not functioning
correctly
Details
Robert Haas a écrit :
On Thu, Feb 11, 2010 at 11:25 AM, Robert Haas wrote:
I can see VACUUM making VACUUM FULL faster. I don't think VACUUM FULL
should make VACUUM FULL ANALYZE faster.
Err, let me correct myself. A second VACUUM FULL should be faster
than the first one. But the two togethe
The following bug has been logged online:
Bug reference: 5322
Logged by: Eric Pailleau
Email address: e...@numlog.fr
PostgreSQL version: 8.2.3
Operating system: linux debian
Description:Time to perform vacuums
Details:
Hello,
I really don't know if it can be
those to
avoid scanning child tables, that may help. Thank you for the quick feedback,
and I am happy that I could achieve a quick resolution.
Thanks again,
Eric
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Saturday, March 21, 2009 1:44 AM
To: Thompson, Eric
Cc
The following bug has been logged online:
Bug reference: 4721
Logged by: Eric Thompson
Email address: eric.thomp...@salliemae.com
PostgreSQL version: 8.3.7
Operating system: RedHat ES 5.2
Description:All sub-tables incorrectly included in search plan for
partitioned
older style of uuid, based on mac addresses
and time tend to generate more sequential uuid's, at least when inserting a
bunch of records at once.
In other words it would be nice to have the old fashioned style of uuid's.
Regards
Eric
-Original Message-
From: Hiroshi Sai
NFO: uuid = b52c719e-6484-49e6-87db-d885d45d7313
INFO: uuid = b52c719e-6484-49e6-87db-d885d45d7313
INFO: uuid = b52c719e-6484-49e6-87db-d885d45d7313
test_uuid
---
(1 row)
Regards
Eric
-Original Message-
From: Hiroshi Saito [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21,
Hi
I would suspect that the clock used may not be precise enough
Not with standing, why not use the windows CreateUUID??
Slower system seems to fare better... (please see results below)
Regards
Eric
---
My office system is xeon (duo core 5160) 3.00 ghz, 2 gig-ram
Hi
I just tried it, slightly better but not a runner
Here is a sample of the results I get when running my test script, note
result vary but lack of duplicates does not.
Why do you not use the CreateUUID function in windows??
Regards
Eric
result
The following bug has been logged online:
Bug reference: 4274
Logged by: eric melbardis
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3
Operating system: windows xp sp3
Description:uuid returns duplicate values
Details:
the uuid functions do not return
Hi
Just a question..
The type was declared as follows:
CREATE DOMAIN "dt_0" AS varchar(32)
NULL;
So why does the query respond with 36?
Regards
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2008 10:53 AM
To: Dave Page
The following bug has been logged online:
Bug reference: 4056
Logged by: eric melbardis
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: windows xp sp 2
Description:problem creating function with domain argument
Details:
hi when i
The following bug has been logged online:
Bug reference: 3668
Logged by: Eric Weimer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Linux
Description:type error in serial
Details:
Creating a table with a column of type serial causes the
Tom Lane wrote:
"Eric Haszlakiewicz" <[EMAIL PROTECTED]> writes:
I would expect this to return false:
template1=# select 'xyz' ~ E'^(.)\\1*$';
?column?
--
t
(1 row)
Seems to be a bug in the Tcl regexp library we use. It's already
r
The following bug has been logged online:
Bug reference: 3645
Logged by: Eric Haszlakiewicz
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: NetBSD
Description:regular expression back references seem broken
Details:
I was attempting to
The following bug has been logged online:
Bug reference: 2391
Logged by: Eric Noriega
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.0.5
Operating system: Linux Fedora core 4
Description:"Similar to" pattern matching does not operate as
document
The following bug has been logged online:
Bug reference: 1848
Logged by: Eric Boutin
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8
Operating system: Solaris 10 amd64
Description:Segfault with pg_dump when database name omitted
Details:
Short example that
hough the statement
is:
SELECT t0."pname", t0."person_id"
FROM "person" t0 WHERE t0."pname" = Elim
rather than:
SELECT t0."pname", t0."person_id"
FROM "person" t0 WHERE t0."pname" = 'Elim'
"YL&
I made a mistake.
Postgres does put a NULL in the field (albiet I would still like to see
postgres/COPY change the NULL to TRUE if DEFAULT is set to true), it
appears pgAdmin III version 1.2.0 is the one displaying a boolean NULL
as FALSE (as opposed to NULL).
Sorry for not testing a little bit m
The following bug has been logged online:
Bug reference: 1582
Logged by: Eric McGough
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Solaris 8
Description:boolean DEFAULT TRUE results in FALSE for NULL values
Details:
-- This table and
y by configure. i've put the right path in the command line...doesn't work).
- zlib library (same problem)
- configure is looking for an "util.h" library, not installed on my system..
maye you could give me some advice
best regards
Eric Avrillon
service informatique/IT s
n how to solve this problem. We are looking forward for your reply. Thank you very much!
Eric TanFrom Hong Kong
[EMAIL PROTECTED]
全港最大手機下載中心
http://mobile.yahoo.com.hk/
POSTGRESQL BUG REPORT TEMPLATE
Your name : Eric Jain
Your email address : [EMAIL PROTECTED]
System Configuration
ql session:
psql:bug.sql:66: ERROR: pg_class_aclcheck: relation 125816 not found
psql:bug.sql:67: ERROR: pg_class_aclcheck: relation 125816 not found
psql:bug.sql:68: ERROR: pg_class_aclcheck: relation 125816 not found
That's happening on the INSERT INTO table1 ...table2 ... and table3
sta
That's exactly what I meant. I'm getting 0 rows in tb_c_ingredient_fti.
Thank you for looking into this, I'll keep poking around as to what could be
the problem on my end (not really sure, it's a vanilla install).
Thanks again,
Eric
- Original Message -
From
ndex is created
just fine.
I've tried breaking it into two scripts (one for db structure and one for
test data) but it still doesn't do the indexing on c.
Any Ideas?
I apologize for the length,
Eric
DROP TRIGGER recipe_fti_trigger on tb_c_recipe;
DROP TRIGGER step_fti_trigger on
e informed
should you be able to find the cause of this.
Kind regards,
Eric van Lent
note: I also included the code as attachment
*/ CODE START */
#include
#include
#include "libpq-fe.h"
#include
int DBinsertCmd(char *, char *, PGconn *, PGresult *);
int DBcontrol();
s
GCC 2.96
(1 row)
Accordingly, features such as "WITHOUT OIDS" don't work. So where do I get
7.2.1?
--
Eric Jain
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
testdb=> update mytest
set masterid=1 where id=2;UPDATE 1testdb=> end;ERROR:
fk_mytest_constr1 referential integrity violation - key referenced from mytest
not found in
mytesttestdb=>----
The version of Postgresql
is 7.1.3-2
-Original Message-
From: Blossom, Eric
Sent: Monday, February 11, 2002
4:01 PM
To: 'Report bugs to'
Subject: Initdb Hangs
I can't seem to get Postgres
initialized. When I run initdb it seems to hang. If I run it in the
I can't seem to get Postgres
initialized. When I run initdb it seems to hang. If I
run it in the background and then try to run postmaster, postmaster complains
that it cannot find template1. Looking in the directories, I see no files.
Below is the result of running initdb with the debug
op
i am seeing postgre 6.4 return the following error message when performing
a JDBC update with executeUpdate(). any ideas what it means?
ava.sql.SQLException: results returned
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLExce
f this is not a bug and I am not getting something
but I couldn't find any other advise.
Eric
Pozicom Tech.
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Here is a short example where this touchy bug
occurs :
create database mydb;
\c mydb
create table temp ( name varchar(12));
insert into temp values ('eric');
insert into temp values ('daniel');
insert into temp values ('ernst');
insert into temp values ('
49 matches
Mail list logo
