The following bug has been logged online:
Bug reference: 2511
Logged by: james
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.1
Operating system: windows xp professional sp2
Description:violation of primary key on update with 2 tables
Details:
hi,
i&#x
The following bug has been logged online:
Bug reference: 2569
Logged by: James
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Windows 200 Pro SP4
Description:statement_timeout bug on Windows
Details:
I'm using the latest versi
The following bug has been logged online:
Bug reference: 4025
Logged by: James
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.0.1
Operating system: winXP
Description:wsock32.dll not found
Details:
when installation reach initdb stage, it shows can not
The following bug has been logged online:
Bug reference: 2417
Logged by: James
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Microsoft Windows XP Professional
Description:bug for finding string in column
Details:
hi,
i've encounte
The following bug has been logged online:
Bug reference: 2418
Logged by: James
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Microsoft Windows XP Professional
Description:number & date & time
Details:
hi,
we would like
The following bug has been logged on the website:
Bug reference: 6413
Logged by: James Stevenson
Email address: ja...@stev.org
PostgreSQL version: 8.4.9
Operating system: Linux - Debian Squeeze
Description:
I suspect pg_relation_size has a tolower in it to a table
The following bug has been logged on the website:
Bug reference: 7515
Logged by: James Bellinger
Email address: ja...@illusorystudios.com
PostgreSQL version: 9.1.5
Operating system: Ubuntu Linux 12.04 Server
Description:
If the table being referenced has a schema in
Y PLAN
-
Aggregate (cost=114.03..114.04 rows=1 width=0) (actual
time=91.171..91.171 rows=1 loops=1)
-> Seq Scan on two (cost=0.00..114.02 rows=5 width=0) (actual
time=0.028..89.598 rows=3277
The following bug has been logged online:
Bug reference: 5011
Logged by: James Bardin
Email address: jbar...@bu.edu
PostgreSQL version: 8.4.0-1
Operating system: Centos 5.3
Description:Standby recovery unable to follow timeline change
Details:
This is another use
On Wed, Aug 26, 2009 at 4:40 AM, Heikki
Linnakangas wrote:
>> Is this currently possible, or do I have to send a full file-level backup to
>> sync the ex-master server with the new master?
>
> That should work. (Note that you do need to restore the ex-master from
> the old base backup; you can't ju
The following bug has been logged online:
Bug reference: 5275
Logged by: James Bellinger
Email address: j...@zer7.com
PostgreSQL version: 8.4.2
Operating system: Ubuntu 9.10
Description:validate_exec in port/exec.c only reads u/g/o, not ACLs
Details:
Howdy,
I&#
The following bug has been logged online:
Bug reference: 5276
Logged by: James Bellinger
Email address: j...@zer7.com
PostgreSQL version: 8.4.2
Operating system: Ubuntu 9.10
Description:pg_ctl reads data directory on -D instead of
postgresql.conf directoryh
Details
Platform: Linux-2.2.12-20 (RH 6.1)
PostgreSQL: 7.0RC1
Description:
Arguments to a function seem to be incorrectly validated against constraints
on the table on which it operates. For example: I have a table that defines
one column (id) as a primary key, and also specifies the NOT NULL
constraint.
Made a mistake in the bug report below. Last line should read something
like:
select createAtom( 1, 'abc', 'Fred', 'NT', 'a', null );
-Original Message-
From: James Finch [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 4:41 PM
To: '[
POSTGRESQL BUG REPORT TEMPLATE
Your name : James Troup
Your email address : [EMAIL PROTECTED
so you should state
that 'types' are excluded from the 'qouted identifier' rule. Futher
more the exception makes it sound like I'm trying to CREATE TYPE, which
i am not.
james vinett
---(end of broadcast)---
TIP 3: i
The following bug has been logged online:
Bug reference: 2895
Logged by: James Russell
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Linux (Fedora Core 5)
Description:Private Use Unicode character crashes server when using
ILIKE
Details
The following bug has been logged online:
Bug reference: 2929
Logged by: James Becerra
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows 2003 Server
Description:Error opening 5432 port
Details:
Hi,
Let me explaint my problem.
I
with my server, time ago the Postgres 8.1 had worked perfect,
and 2 days ago it leaves.
I used the command net stat a to see the ports and I can not find 5432
port.
James Humberto Becerra Ramirez
Data Manager
ICIDR - Data Management Core
[EMAIL PROTECTED
the connection is
in the default (auto-commit) mode; setting SQL_AUTOCOMMIT_OFF causes
the program to crash dereferencing a NULL pointer internal to the ODBC
driver.
Following this message are excerpts code sufficient to replicate the
problem, and some diagnostic logs.
Thanks,
Michael James
The following bug has been logged online:
Bug reference: 3429
Logged by: James White
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3
Operating system: debian etch amd64
Description:table named MULTIPOLYGON
Details:
I accidentally created a table name
TE 1634
Since users has *no* column contact_id ? One would expect the statement
to fail, and the transaction to get rolled back.
orig_sav=# select contact_id from users;
ERROR: column "contact_id" does not exist
This is on 7.4.2.
James Robinson
Socialserve.com
--
Aha. Well, you learn something new every day. Yes, the behavior is
indeed like "contact_id is not null", which was true for all rows in
users, which explains why I lost all my data in realtycompany_contacts.
Thank goodness for backups. Many thanks!
James
On Jul 1, 2004, at 3:35 P
The following bug has been logged online:
Bug reference: 1715
Logged by: James Doherty
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Solaris 8 Intel
Description:dbmirror replaces nextval, setval functions
Details:
The dbmirror contrib
The following bug has been logged online:
Bug reference: 1713
Logged by: James Doherty
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Solaris 8 Intel
Description:dbmirror replaces nextval, setval functions
Details:
The dbmirror contrib
The following bug has been logged online:
Bug reference: 1714
Logged by: James Doherty
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Solaris 8 Intel
Description:dbmirror replaces nextval, setval functions
Details:
The dbmirror contrib
c,
but I don't think I'd be confident to submit an official fix for it.
James
-Original Message- From: Achilleus
Mantzios [mailto:[EMAIL PROTECTED] Sent: Mon 6/13/2005
2:59 AM To: James Doherty Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #1715: dbmirror
The following bug has been logged online:
Bug reference: 1862
Logged by: James Gray
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Red Hat Enterprise Linux AS release 4 (Nahant Update 1),
Kernel 2.6.9-11.EL on an ia64
Description:ECPG
If I create a normal table and a normal view that queries that table I
get incorrect results when I query the view using the AS alias in the
select statement. For example, if I create the following objects:
CREATE TABLE Test1( col1 VARCHAR(200) );
CREATE VIEW Test2 AS SELECT col1 FROM Test1 ORDER
-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.0.1 20050727 (Red Hat 4.0.1-5)
On 11/23/05, Hayden James <[EMAIL PROTECTED]> wrote:
If I create a normal table and a normal view that queries that table I
get incorrect results when I query the view using the AS alias in the
select statement
The following bug has been logged online:
Bug reference: 2258
Logged by: James Gray
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: Linux/Windows
Description:debug_print_plan doesn't work for cursors
Details:
Feature request:
The following bug has been logged online:
Bug reference: 2268
Logged by: James Hughes
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Windows 2003 (Server)
Description:initdb fails to initialize database cluster with error
"Acce
That seems to work.
thanks
-Original Message-
From: Heikki Linnakangas [mailto:heikki.linnakan...@enterprisedb.com]
Sent: 28 January 2012 19:34
To: James Stevenson
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6413: pg_relation_size wont work on table with upper
case chars
On
The following bug has been logged online:
Bug reference: 2489
Logged by: James A Cole
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.13
Operating system: Red Hat Enterprise Linux 4
Description:Metadata dosen't match tables
Details:
PostgreSQL 7.4.
The following bug has been logged online:
Bug reference: 3296
Logged by: S. Robert James
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Linux
Description:CASCADING FKs dont DEFER
Details:
If a FK is set to ON DELETE CASCADE DEFERRABLE
The following bug has been logged online:
Bug reference: 3532
Logged by: James William Pye
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: FreeBSD
Description:Can't rollup array of arrays
Details:
Dunno about the spec, but I would
The following bug has been logged online:
Bug reference: 3996
Logged by: James P. Yalem
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2 or 8.3
Operating system: Windows XP
Description:Reinstalling after uninstall
Details:
When I try to reinstall 8.3 or 8.2
hat way? If yes, why?
Yes.
You specified your path as a closed path. With its "loopback", it's twice as
long.
To specify it as an open path, do path('[(0,0),(2,0)]').
SELECT length(path('[(1,0),(0,0)]')) = '1';
SELECT length(path('(1,0),(0,0)&#
The following bug has been logged online:
Bug reference: 2389
Logged by: James M Doherty
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: RH9
Description:function within function return value
Details:
reate or replace function
The following bug has been logged on the website:
Bug reference: 7611
Logged by: James
Email address: sams.james+postg...@gmail.com
PostgreSQL version: 9.1.6
Operating system: Ubuntu Linux 12.04
Description:
I have a file with several nul characters in it. The file
loops=1)
Total runtime: 77836.949 ms
Thanks and Regards,
James Skaggs
IT/FIS Longmont
SeaTel: 8 684 1048
General: +1 612 367 6224
On Tue, Feb 5, 2013 at 3:00 PM, Kevin Grittner wrote:
> "jim...@seagate.com" wrote:
>
> > INFO: analyzing "public.stream_file"
&
. So if the "bloated"
statistics are representative of the true cost, I'm all for them.
We are clustering the database as we speak, so I can't force a hash
aggregate to see if that is the right choice or not.
Thanks and Regards,
James Skaggs
IT/FIS Longmont
SeaTel: 8 684 1048
f.current_comment_line_count,
sf.current_source_md5, sf.component_id, sf.current_file_instance_id,
sf.current_file_state_id, sf.file_path_id, sf.stream_element_id"
"Total runtime: 33822.707 ms"
But later in the day, the statistics revert back to the 100M number! Any
ideas? Is there
The following bug has been logged on the website:
Bug reference: 8238
Logged by: Jim Hughes
Email address: james.e.hug...@boeing.com
PostgreSQL version: 9.1.4
Operating system: SLES 11
Description:
Upon creating a database on a panfs (Panasas proprietary fs) directory
44 matches
Mail list logo
