The following bug has been logged online:
Bug reference: 4558
Logged by: Paul
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.5
Operating system: Vista Ultimate
Description:Error 255!
Details:
Whenever I try to install postgres database I keep getting an
ction"
Output I expected:
at least some error message, but not closing of connection.
I know that my SQL sequence is wrong, but i just expected the error
message.
PostgreSQL version:
7.1.1
Platform information:
Linux Slackware 7.1, kernel 2.4.1
--
Best regards,
Paul mai
The following bug has been logged online:
Bug reference: 1608
Logged by: Paul
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.2
Operating system: Gentoo and Fedora Core 3
Description:integer negative limit in plpgsql function arguments
Details:
The script
The following bug has been logged online:
Bug reference: 5972
Logged by: Paul
Email address: paul.co...@punct.ro
PostgreSQL version: 9.0.3
Operating system: CentOS 5.5
Description:Update with subquery: erroneous results for foreign key
field
Details:
Hello.
We
The following bug has been logged on the website:
Bug reference: 8396
Logged by: Paul M.
Email address: p...@weotta.com
PostgreSQL version: 9.3rc1
Operating system: Ubuntu Linux
Description:
When I select from a view, the where clause in my select statement does not
of a palloc'd chunk are never zeroes in such a build.
>
>> regards, tom lane
>
> Tom,
>
> Thanks for the quick response on this.
>
> Paul,
> You think by chance you can test out the patch since you can make this bug
> happen consistently on yo
The following bug has been logged online:
Bug reference: 4809
Logged by: Paul Matthews
Email address: p...@netspace.net.au
PostgreSQL version: 8.3.7
Operating system: Linux OpenSuse 11.0
Description:Missing Expected Operator
Details:
Not a bug as such, but an
The following bug has been logged online:
Bug reference: 4810
Logged by: Paul Mathews
Email address: p...@netspace.net.au
PostgreSQL version: 8.3.7
Operating system: Linux SuSE 11.0
Description:Complex Contains, Bad Performace.
Details:
Consider a table
Tom Lane wrote:
"Paul Mathews" writes:
Despite the existence of the index, postgresql is determined to full table
scan when given.
SELECT
postcode
WHERE
boundary @> point 'x,y';
polygon @> point isn't an indexable operator.
The following bug has been logged online:
Bug reference: 4967
Logged by: Paul Matthews
Email address: p...@netspace.net.au
PostgreSQL version: 8.3.7
Operating system: Linux Open Suse 11.0 + 11.1
Description:polygon @> point incorrect for points close to sha
Tom Lane wrote:
"Paul Matthews" writes:
A number of points close to the common border claimed they fell into both of
the polygons.
How close is "close"? There's some pretty arbitrary fuzzy-comparisons
logic in the geometric datatypes ... see
erence < 0)
StopLow = StopMiddle + 1;
else
StopHigh = StopMiddle - 1;
}
return (false);
}
==
--
Paul McGarrymailto:[EMAIL PROTECTED]
Systems Integrator http://www.opentec.com.au
Opentec Pty Ltd
P BY targetTable.ctid.
What exactly is a ctid?
Thanks for your response Tom, it has been enlightening. I feel I'm
getting a better understanding of what's going inside pgsql by the
day from yourself and other peoples posts on the various lists.
--
Paul McGarrymailto:[EMAIL P
Here's the attachment I said I was going to attach to the last message.
TFIF!
--
Paul McGarrymailto:[EMAIL PROTECTED]
Systems Integrator http://www.opentec.com.au
Opentec Pty Ltd http://www.iebusiness.com.au
6 Lyon Park RoadPhone: (02) 9878 1744
North
s
DEBUG: line 4 at SQL statement
====
Thanks,
--
Paul McGarrymailto:[EMAIL PROTECTED]
Systems Integrator http://www.opentec.com.au
Opentec Pty Ltd http://www.iebusiness.com.au
6 Lyon Park RoadPhone: (02) 9878 1744
North Ryde NSW 2113 Fax: (02) 9878
3ba060 in ?? ()
#3 0xff0a0130 in _exithandle () from /usr/lib/libc.so.1
#4 0xff116964 in exit () from /usr/lib/libc.so.1
==
Any ideas?
--
Paul McGarrymailto:[EMAIL PROTECTED]
Systems Integrator http://www.opentec.com.au
Opentec Pty Ltd http://www.iebusiness.com.au
n and went with it :)
Upgrading to gcc 2.95.3 has fixed the problem I was having,
it's compiled and the regression tests are now whirring
away happily.
Those build instrucions look good, as does the init script.
Thanks again.
--
Paul McGarrymailto:[EMAIL PROTECTED]
Systems Inte
POSTGRESQL BUG REPORT TEMPLATE
Your name : Paul Vixie
Your email address : [EMAIL
Great! But where is the documentation on doing this
stuff? I'd like to try.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Peter <[EMAIL PROTECTED]> writes:
> > I resorted to trial and error. Initdb hangs when
> "Creating template1
> > database" so there must be a step missing.
>
> I think you forgot
The following bug has been logged online:
Bug reference: 2498
Logged by: Paul Röttgerding
Email address: [EMAIL PROTECTED]
PostgreSQL version: DBMS 8.0.3
Operating system: Windows / Linux
Description:Problem with ADO.RECORDSET.UPDATE
Details:
Hello,
we have PG
The following bug has been logged online:
Bug reference: 2611
Logged by: Paul Suckling
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4-1
Operating system: Windows XP
Description:2 instalation probs: invalid directory and user account
creation
Details:
I
pg_toast_<>Thanks,Paul
warehouse=# select count(distinct chunk_id) from pg_toast.pg_toast_635216540;count---74557(1 row)We're on version 8.0.7On 10/16/06,
Tom Lane <[EMAIL PROTECTED]> wrote:"Paul Laughlin" <
[EMAIL PROTECTED]> writes:> For the last 6 months or so we've had an int
We got it early last week and again this morning. Before these two it was about six months ago.On 10/16/06, Tom Lane <
[EMAIL PROTECTED]> wrote:"Paul Laughlin" <
[EMAIL PROTECTED]> writes:> warehouse=# select count(distinct chunk_id) from> pg_toast.pg_toast_635216540
before, so my error
might even be blindingly obvious, but I have no idea what it is. Any
help you could give me in getting postgres to do what it's supposed to
do would be marvelous.
Many thanks,
Paul Jordan
Digital Archivist
Occidental College
Sorry for the duplicate post. I forgot to mention this is with
Postgresql 7.2.2.
It seems the psql \copy command doesn't work properly when dealing
with certain non-ascii characters (which ones I don't know). At any rate
I took some binary data and escaped it like so with perl.
$text=~s/\\/
I wrote:
> It seems the psql \copy command doesn't work properly when dealing
> with certain non-ascii characters (which ones I don't know). At any rate
> I took some binary data and escaped it like so with perl.
I was wrong. I wasn't escaping things properly; in particular,
ascii 0 needed to be
It seems the psql \copy command doesn't work properly when dealing
with certain non-ascii characters (which ones I don't know). At any rate
I took some binary data and escaped it like so with perl.
$text=~s/\\//g;
$text=~s/\n/\\\n/g;
$text=~s/\t/\\\t/g;
In other words I escaped escape chara
Dear sir,
i am encounting the following problem while
initializing data cluster(i am using Mac os x 10.2).
Plez tell me solution for this
--
bash-2.05a$ initdb -D /usr/local/PostgreSQL/data
The files belonging to this database
Dear sir,
Sir last one week i am try to install PostgreSQL in
Mac os x 10.2 .I dowm loaded PostgreSQL 7.3 from net
and i installed it in 'ampleuser', my login (in
dir:Library/PostgreSQL).
After that i set the paths in follwing manner.And it
successfully starting the postmaster also.But when
I ran into the following problem building PostgreSQL 7.3.3 on Solaris
9 (sparc) using GCC 3.3 and OpenSSL 0.9.7b.
gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -fPIC -I.
-I../../../src/include -I/opt/reb/include -I/opt/sfw/include -DFRONTEND
-DSYSCONFDIR='"/opt/reb/etc/postgresql"'
POSTGRESQL BUG REPORT TEMPLATE
Your name : Paul Tillotson
Your email address : ptchristendom at
fine. Has something changed
radically in this release that could cause a binary
incompatibility?
Any suggestions?
Thanks,
Paul
Download Yahoo! Messenger now for a chance to win Live At Knebworth DVDs
http://www.yahoo.co.uk
etail to sliceFile;
counter := counter + 1;
Truncate Table curSliceDetail;
---Generate next curSliceId
curSliceId := curTrackList + counter;
END LOOP;
RETURN 1;
END;
' LANGUAGE plpgsql;
Can someone help please
Regards
Pau
into Table values(IdForEachRun, ..)
counter := counter + 1;
IdForEachRun := IdSet || counter;(PROBLEM HERE)
--Or IdForEachRun := IdSet + counter;(PROBLEM HERE)
END LOOP
END
Language 'plpgsql'
Thanks in advance.
Paul
__
Do you Yahoo!?
Protect your
into Table values(IdForEachRun, ..)
counter := counter + 1;
IdForEachRun := IdSet || counter;(PROBLEM HERE)
--Or IdForEachRun := IdSet + counter;(PROBLEM HERE)
END LOOP
END
Language 'plpgsql'
Thanks in advance.
Paul Puneet
---(end of broadcast)---
.)
Paul Tillotson
Hello.
I use PostgreSQL 7.4.2 on i386-portbld-freebsd5.2, compiled by GCC cc (GCC) 3.3.3 [FreeBSD] 20031106
Description:
It seems that renaming tables with columns of type "serial" leaves
"orphaned" implicit sequences which breaks pg_restore.
How to reproduce
I am using postgresql 8.0 beta 4 on win2000.
psql operates strangely within a cmd.exe window. It is somewhat like if
you backgrounded the command in unix. with psql in interactive mode (no
-f switch) whatever line you type is alternately processed by cmd.exe and
psql.
So you get the following (
work. Can you
advise. PostgreSQL 8.0.0 RC5-2
Regards
Paul Conroy
an Chéim Computer Services
52 Broomhill Road
Tallaght
Dublin 24
Email: [EMAIL PROTECTED]
Ph: 01 -4310708
This email, its content and any files transmitted with it are intended solely
for the addressee(s) and may be legally
a point in
Postgres’s favor.
Regards,
Paul Bramble,
Vidiom Inc.
The following bug has been logged online:
Bug reference: 1879
Logged by: Paul O'Connor
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.2
Operating system: Redhat: kernel 2.4
Description:ODBC Connection Dies
Details:
The ODBC Connection dies, displ
The following bug has been logged online:
Bug reference: 1987
Logged by: Paul Lindner
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1beta3
Operating system: Fedora Core 4 x86_64
Description:UTF8 encoding differences hamper upgrades
Details:
I've been
The following bug has been logged online:
Bug reference: 1992
Logged by: Paul Anderson
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Microsoft Windows XP Professional version 5.1.2600
Service Pack 1 Build 2600
Description:ODBC error
The following bug has been logged online:
Bug reference: 2436
Logged by: Paul Forgey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Debian stable (sarge)
Description:cannot --enable-thread-safety on -lpthread host
Details:
Linux
As given in my OS info, this isn't FC4. The configure script fails
to enable threading in Debian Sarge.
On May 15, 2006, at 6:48 AM, Tom Lane wrote:
"Paul Forgey" <[EMAIL PROTECTED]> writes:
Linux supplies -lpthread. The configure script seems to only look
for
-lp
On Wed, Dec 29, 2010 at 10:30 AM, Paul J. Davis
wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5804
> Logged by: Paul J. Davis
> Email address: paul.joseph.da...@gmail.com
> PostgreSQL version: 9.0.2
> Operating system: O
On Wed, Dec 29, 2010 at 10:58 AM, Kevin Grittner
wrote:
> "Paul J. Davis" wrote:
>
>> After running many queries (millions) a connection will report an
>> error that the server has unexpectedly closed the connection.
>
> What message are you getting? (Copy/p
On Wed, Dec 29, 2010 at 11:27 AM, Tom Lane wrote:
> Paul Davis writes:
>> And this intriguing error in the server logs from around that time:
>
>> 2010-12-28 18:40:02 EST LOG: SSL renegotiation failure
>> 2010-12-28 18:40:02 EST LOG: SSL failed to send renegotiation req
Thank you very much, i understand now :)
Paul
On Tue, Apr 12, 2011 at 4:42 PM, Kevin Grittner wrote:
> "Paul" wrote:
>
> > update cart set status = 1 where userid = (select userid from
> > users where email = 'exam...@example.com');
> >
> > A
The following bug has been logged online:
Bug reference: 5978
Logged by: Paul Deschamps
Email address: pdescha...@gmail.com
PostgreSQL version: 8.4.6
Operating system: Ubuntu 10.4
Description:Running postgress in a shell script fails
Details:
When running postgres
The following bug has been logged online:
Bug reference: 6269
Logged by: Paul Stapersma
Email address: paul.staper...@gmail.com
PostgreSQL version: 8.3.3
Operating system: Mac OS X Version 10.6.8
Description:Anomaly detection
Details:
Dear reader,
For a project at
has been logged on the website:
>>
>> Bug reference: 6379
>> Logged by: Paul Ramsey
>> Email address: pram...@cleverelephant.ca
>> PostgreSQL version: 9.1.2
>> Operating system: OSX 10.6.8
>> Description:
>>
>> CREATE OR REP
oo as select 1
as x; $f$; should be enough to break it
[12:31pm] RhodiumToad: there's no trivial fix
On Wed, Jan 4, 2012 at 11:32 AM, Paul Ramsey wrote:
> One extra detail, my PostgreSQL is compiled with --enable-cassert.
> This is required to set off the killer function.
>
>>
ng localhost to both 127.0.0.1 and my other IP. Using
`listen_addresses = '127.0.0.1'` fixes the problem.
Thank you!
Paul
--
_
Pulchritudo splendor veritatis.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subs
The following bug has been logged on the website:
Bug reference: 7795
Logged by: Paul
Email address: paul.wat...@zephyr-consulting.com
PostgreSQL version: 9.2.2
Operating system: Microsoft Windows [Version 6.0.6002] Vista 64-bit
Description:
C:\Program Files
The following bug has been logged on the website:
Bug reference: 8247
Logged by: Paul Macdonald
Email address: paul.macdon...@ssc-spc.gc.ca
PostgreSQL version: Unsupported/Unknown
Operating system: Debian Sarge
Description:
Postgres version: 7.4.7-6sarge1
Issue
original point still stands, of course ;-)
--
Paul M. Aoki / Xerox Palo Alto Research Center / Coyote Hill Road
[EMAIL PROTECTED] / Computer Science Laboratory / Palo Alto, CA 94304-1314
d haven't been getting
updated regularly.
--
Paul M. Aoki / Xerox Palo Alto Research Center / Coyote Hill Road
[EMAIL PROTECTED] / Computer Science Laboratory / Palo Alto, CA 94304-1314
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Anyone able to fix this?
here's a hack we've been using in-house (written by Jun Gabayan,
<[EMAIL PROTECTED]>).
you may not like the style but it's a stab at a solution.
--
Paul M. Aoki / Xerox Palo Alto Research
k doesn't actually add any extra buffers or copies.
--
Paul M. Aoki / Xerox Palo Alto Research Center / Coyote Hill Road
[EMAIL PROTECTED] / Computer Science Laboratory / Palo Alto, CA 94304-1314
, please let me know.
-
<>
Paul-Andre Panon
Sierra Systems
1177 West Hastings Street, Suite 2500
Vancouver, BC V6E 2K3
Main: 604.688.1371
Fax: 604.688.6482
www.SierraSystems.com
postgresql.log
---(end of broadcast)---
TIP 6:
ine an incoming
tunnel in the Windows SSH client.
My application works (quite well), but I'm worried that the incoming
data stream, which will contain sensitive data, is not encrypted.
By the way, the Van Dyke product (SecureCRT) does the exact same
thing.
Can anyone advise?
Thankyou in
> As far as Postgres is concerned, there's no deadlock here, only a slow client
that could be true if we used explicit locks. all our accesses are of the
form "learn everything you need to know to do the transaction, then open the
database, do it, and close". there are some really long SELECT's
But this still not works. So I'm a bit confused. What's wrong?
Thanks in advance and best regards.
--
Jean-Paul ARGUDO
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
t on
pg_proc)
drop the language
create the language
rebuild functions and triggers: all ok now..
Thanks Tom.
--
Jean-Paul ARGUDO
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
eady notifyied bug :-(
What am I doing wrong?...
I'll watch the source and try to guess what's wrong in bootstrap.* ...
Cheers,
--
Jean-Paul ARGUDOIDEALX S.A.S
Consultant bases de données 15-17, av. de Ségur
http:/
c/backend/bootstrap for example), is that ok?
Thanks for the right help :)
--
Jean-Paul ARGUDOIDEALX S.A.S
Consultant bases de données 15-17, av. de Ségur
http://www.idealx.com F-75007 PARIS
-
, it's greatly appreciated.
Paul Redd-LaFlamme
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 12:00 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [BUGS] Bug #726: PHP/PG ERROR: parser: parse error at or
near ","
The following bug has been logged online:
Bug reference: 5804
Logged by: Paul J. Davis
Email address: paul.joseph.da...@gmail.com
PostgreSQL version: 9.0.2
Operating system: OS X 10.6.5, Ubuntu 10.04
Description:Connection aborted after many queries.
Details:
After
The following bug has been logged online:
Bug reference: 2520
Logged by: Jean Paul Aguilar Ruiz
Email address: [EMAIL PROTECTED]
PostgreSQL version: 807,814
Operating system: Win xp
Description:security problem
Details:
Hi,
When you add a user as owner of
The following bug has been logged online:
Bug reference: 2406
Logged by: Paul van der Zwan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Solaris
Description:Not all systems support SHM_SHARE_MMU
Details:
Only systems with large
On 25-apr-2006, at 7:48, Tom Lane wrote:
"Paul van der Zwan" <[EMAIL PROTECTED]> writes:
Only systems with large pagesizes support ISM, so always defining
#define PG_SHMAT_FLAGS SHM_SHARE_MMU
in src/backend/port/sysv_shmem.c will cause all calls to shma
On 25-apr-2006, at 9:08, Tom Lane wrote:
Paul van der Zwan <[EMAIL PROTECTED]> writes:
Maybe noone ever ran Postgres on Solaris on a VIA Epia system.
Maybe. What is a "VIA Epia system"?
VIA is a hardware manufacturer who make small, low power boards with
their own X8
On 25-apr-2006, at 16:46, Tom Lane wrote:
Paul van der Zwan <[EMAIL PROTECTED]> writes:
AFAIK getpagesizes() appeared in 2001 so that probably means it is
missing in anything before Solaris 9.
We could handle this without relying on getpagesizes() by just trying
and falling back:
On 25-apr-2006, at 20:34, Tom Lane wrote:
Paul van der Zwan <[EMAIL PROTECTED]> writes:
On 25-apr-2006, at 16:46, Tom Lane wrote:
AFAICS, SHM_SHARE_MMU has no
guaranteed semantic effect anyway, it's just a performance hint; so
ignoring it on platforms that can't handle it is
75 matches
Mail list logo
