On Thu, Dec 3, 2009 at 10:45 AM, aftab khan akha...@hotmail.co.uk wrote:
This is not exactly the same what I posted yesterday, What I have posted
today also include EXPLAIN ANALYZE OUTPUT .
[ adding the list back to the CC line ]
It looks like you have a problem very similar to one Laurence
On Thu, Dec 3, 2009 at 8:21 PM, Fred Wei w...@niwa.co.nz wrote:
The following bug has been logged online:
Bug reference: 5233
Logged by: Fred Wei
Email address: w...@niwa.co.nz
PostgreSQL version: 8.1.11
Operating system: SUSE Linux Enterprise Server 10 SP2 (x86_64)
On Fri, Nov 27, 2009 at 8:09 AM, Martin searepo...@aol.at wrote:
The following bug has been logged online:
Bug reference: 5217
Logged by: Martin
Email address: searepo...@aol.at
PostgreSQL version: 8.4.1
Operating system: M$ Vista (but does not matter) same on XP, ...
On Wed, Dec 2, 2009 at 11:42 AM, Craig Ringer
cr...@postnewspapers.com.au wrote:
On 2/12/2009 10:35 PM, aftab wrote:
The following bug has been logged online:
Bug reference: 5226
Logged by: aftab
Email address: akha...@hotmail.co.uk
PostgreSQL version: 8.3.8
Operating
On Thu, Nov 26, 2009 at 5:41 AM, Walter Willmertinger will...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5215
Logged by: Walter Willmertinger
Email address: will...@gmail.com
PostgreSQL version: 8.4.1
Operating system: Windows XP Prof.
On Sat, Nov 28, 2009 at 5:34 PM, Russell Wallace
russell.wall...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5218
Logged by: Russell Wallace
Email address: russell.wall...@gmail.com
PostgreSQL version: 8.4.1
Operating system: Windows
On Mon, Nov 30, 2009 at 12:28 PM, Pavel Stehule pavel.steh...@gmail.com wrote:
Rather than trying to be compatible with MySQL directly, I think we
might be better off adding a chapter to our documentation explaining
to ex-MySQL users how to accomplish the same things in PostgreSQL. We
might
On Mon, Nov 30, 2009 at 1:42 PM, Pavel Stehule pavel.steh...@gmail.com wrote:
2009/11/30 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com writes:
I thing so ex-MySQL needs exact DESCRIBE, exact SHOW statement. It is
some, what they used long time and then they missing it.
On Fri, Nov 27, 2009 at 1:42 AM, Peter Eisentraut pete...@gmx.net wrote:
On tor, 2009-11-26 at 22:59 -0500, Robert Haas wrote:
ISTM that if you run psql with -f -, you shouldn't expect to get an
interactive shell. Rather, you should expect psql to do whatever it
normally does when given -f
On Fri, Nov 27, 2009 at 3:42 AM, Denny Saviant Mohammad
konohabluefl...@gmail.com wrote:
Well, i changed nothing in my postgresql.conf before the accident.
Well, someone or something did, because stdmsg isn't ever a legal
value, and it didn't put itself into that file.
.
But, after i try
On Thu, Oct 22, 2009 at 2:42 PM, Stephen Frost sfr...@snowman.net wrote:
-1 appears to be ignored when '-f -' is set.
I've been bitten by this, too. It appears that -f - is in general
equivalent to not specifying -f at all. In startup.c we have a test
for:
options.action == ACT_FILE
On Sat, Nov 21, 2009 at 9:13 AM, denny saviant
konohabluefl...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5207
Logged by: denny saviant
Email address: konohabluefl...@gmail.com
PostgreSQL version: 8.4.1
Operating system: windows xp pro
On Tue, Nov 24, 2009 at 6:04 AM, lee brown lee_bro...@msn.com wrote:
The following bug has been logged online:
Bug reference: 5211
Logged by: lee brown
Email address: lee_bro...@msn.com
PostgreSQL version: 8.3
Operating system: vista
Description: invalid
On Mon, Nov 23, 2009 at 4:21 AM, Maithili maithili.manur...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5210
Logged by: Maithili
Email address: maithili.manur...@gmail.com
PostgreSQL version: 8.2
Operating system: Windows 2003
On Fri, Nov 20, 2009 at 6:56 PM, Alvaro Herrera alvhe...@postgresql.org wrote:
The following bug has been logged online:
Bug reference: 5206
Logged by: Alvaro Herrera
Email address: alvhe...@postgresql.org
PostgreSQL version: any
Operating system: any
Description:
On Fri, Nov 20, 2009 at 10:11 AM, Marcel Wieland
marcel.wiel...@fondsnet.de wrote:
The following bug has been logged online:
Bug reference: 5203
Logged by: Marcel Wieland
Email address: marcel.wiel...@fondsnet.de
PostgreSQL version: 8.2
Operating system: Linux
On Fri, Nov 20, 2009 at 9:58 AM, Marcel Wieland
marcel.wiel...@fondsnet.de wrote:
The following bug has been logged online:
Bug reference: 5202
Logged by: Marcel Wieland
Email address: marcel.wiel...@fondsnet.de
PostgreSQL version: 8.2
Operating system: Linux
On Fri, Nov 20, 2009 at 6:44 PM, Alain Baeckeroot
alain.baecker...@laposte.net wrote:
The following bug has been logged online:
Bug reference: 5205
Logged by: Alain Baeckeroot
Email address: alain.baecker...@laposte.net
PostgreSQL version: 8.4.1
Operating system: Linux
On Wed, Nov 18, 2009 at 11:26 PM, Joseph Shraibman j...@selectacast.net wrote:
The following bug has been logged online:
Bug reference: 5197
Logged by: Joseph Shraibman
Email address: ...@selectacast.net
PostgreSQL version: 8.2.14
Operating system: Linux
Description:
On Mon, Nov 9, 2009 at 7:21 PM, Vijaya Krishna Cherukuri
krisveejay...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5175
Logged by: Vijaya Krishna Cherukuri
Email address: krisveejay...@gmail.com
PostgreSQL version: 8.3.8
Operating system:
I see that there's been no response to bugs #5194, #5187, #5051.
Should we consider adding a message to the bug reporting page that
suggests emailing the relevant list directly for JDBC/ODBC bugs? We
seem to get a lot of those here. The other frequent one that seems to
come up is the one-click
On Mon, Nov 16, 2009 at 12:59 PM, Clark Pearson
cloink_frigg...@ntlworld.com wrote:
The following bug has been logged online:
Bug reference: 5191
Logged by: Clark Pearson
Email address: cloink_frigg...@ntlworld.com
PostgreSQL version: 8.3.7
Operating system: Windows
On Fri, Nov 13, 2009 at 1:13 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
The following command does not change the output of pg_dumpall:
alter tablespace pg_default owner to bob;
I don't think this is a bug. It's one specific aspect of a general
On Fri, Nov 13, 2009 at 10:39 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
I think it would be over the top to suggest that pg_dump has to cope
with modifications that can only occur through manual updates
On Fri, Nov 13, 2009 at 8:52 PM, obelich obel...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5186
Logged by: obelich
Email address: obel...@gmail.com
PostgreSQL version: 8.4.1
Operating system: Opensuse 11.2
Description: Not
The following bug has been logged online:
Bug reference: 5184
Logged by: Robert Haas
Email address: robertmh...@gmail.com
PostgreSQL version: CVS HEAD
Operating system: Linux
Description:default tablespace owner is not dumped
Details:
The following command does
On Tue, Oct 20, 2009 at 12:19 PM, landrevi...@deadtreepages.com wrote:
The following bug has been logged online:
Bug reference: 5128
Logged by:
Email address: landrevi...@deadtreepages.com
PostgreSQL version: 8.4
Operating system: FreeBSD
Description: Returning nested
On Sat, Nov 7, 2009 at 5:23 AM, Peter Eisentraut pete...@gmx.net wrote:
On fre, 2009-11-06 at 17:29 +, Jason wrote:
When I have a plpythonu function returning a composite type that has an
array column, the function does not work when I try to return a list for
that column.
There is a
On Wed, Nov 4, 2009 at 3:35 PM, Tom Lane t...@sss.pgh.pa.us wrote:
assaf assaf_l...@yahoo.com writes:
PostgreSQL version: 8.37
Description: Poor performance with Left-join where right side does
not exist
8.4 might be smarter about this case for you. It's hard to tell for sure
with
2009/11/2 donniehan donnie...@126.com:
Hi Tom,
I agree with Hxli. It may be a good way to add permissions check when create
the view.
I also find 2 pieces of words in the document about the owner of the object.
By default, only the owner of an object can do anything with the object.
On Tue, Oct 27, 2009 at 10:47 AM, Marcus Lundblad
marcus.lundb...@mogul.com wrote:
The following bug has been logged online:
Bug reference: 5140
Logged by: Marcus Lundblad
Email address: marcus.lundb...@mogul.com
PostgreSQL version: 8.3.8
Operating system: Solaris 10
On Thu, Oct 29, 2009 at 6:14 PM, Don Fox donf...@mac.com wrote:
The following bug has been logged online:
Bug reference: 5149
Logged by: Don Fox
Email address: donf...@mac.com
PostgreSQL version: 8.4.1
Operating system: Mac X Snowleopard
Description: Can't
On Fri, Oct 30, 2009 at 1:39 AM, Gray g...@ms-irk.ru wrote:
The following bug has been logged online:
Bug reference: 5150
Logged by: Gray
Email address: g...@ms-irk.ru
PostgreSQL version: 8.2.6
Operating system: i686-pc-linux-gnu
Description: math bug
Details:
On Wed, Oct 21, 2009 at 11:23 PM, aihongwei ufo008...@163.com wrote:
The following bug has been logged online:
Bug reference: 5131
Logged by: aihongwei
Email address: ufo008...@163.com
PostgreSQL version: 8.0.0
Operating system: linux x86_64
Description: The
On Wed, Oct 21, 2009 at 12:51 PM, flamindrag...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5130
Logged by:
Email address: flamindrag...@gmail.com
PostgreSQL version: any
Operating system: Win XP Pro SP2
Description: Failed to run initdb:1
On Thu, Oct 22, 2009 at 3:23 AM, Geok Hua Yap geokhua8...@yahoo.com.sg wrote:
The following bug has been logged online:
Bug reference: 5132
Logged by: Geok Hua Yap
Email address: geokhua8...@yahoo.com.sg
PostgreSQL version: 8.3.1
Operating system: CentOS 5.2
2009/9/29 Yaming Gu yaming...@w-oasis.com:
Hi, Robert,
According to your recommendations, I tried to load plperu, almost the same
error messages have shown:
D:\Program Files\Postgresql\8.3\bincreatelang -U postgres plperlu example
Password:
createlang: language installation failed:
On Sat, Sep 5, 2009 at 5:42 AM, Kamil Roman kamil.lech.ro...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5039
Logged by: Kamil Roman
Email address: kamil.lech.ro...@gmail.com
PostgreSQL version: 8.3.7
Operating system: Windows XP
On Thu, Oct 22, 2009 at 10:47 AM, flamin dragon flamindrag...@gmail.com wrote:
2009/10/22 Robert Haas robertmh...@gmail.com
On Wed, Oct 21, 2009 at 12:51 PM, flamindrag...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5130
Logged by:
Email address
On Fri, Aug 28, 2009 at 9:59 AM, Dan O'Hara danarasoftw...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5021
Logged by: Dan O'Hara
Email address: danarasoftw...@gmail.com
PostgreSQL version: 8.3.7
Operating system: win32
Description:
2009/10/16 malu maluulam_l...@yahoo.com.mx:
The following bug has been logged online:
Bug reference: 5124
Logged by: malu
Email address: maluulam_l...@yahoo.com.mx
PostgreSQL version: 8.3
Operating system: windows xp proffeional
Description: visualizacion de
On Wed, Oct 14, 2009 at 9:56 AM, flamindrag...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5114
Logged by:
Email address: flamindrag...@gmail.com
PostgreSQL version: any
Operating system: Win XP Pro SP2
Description: database initialization
On Tue, Oct 6, 2009 at 9:38 PM, Matthew Byrne matt...@hairybrain.co.uk wrote:
The following bug has been logged online:
Bug reference: 5098
Logged by: Matthew Byrne
Email address: matt...@hairybrain.co.uk
PostgreSQL version: 8.4.1
Operating system: Linux x86_64 (Ubuntu
On Fri, Oct 16, 2009 at 6:39 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Thom Brown wrote:
This is either a bug in vacuumdb with it not using the correct order,
or postgres shouldn't be paying attention to the order of the
keywords. In any case, it doesn't work. I've
On Fri, Oct 16, 2009 at 10:33 AM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Pedro Gimeno pgsql-...@personal.formauri.es wrote:
Tom Lane wrote:
This could be addressed by having the postmaster report its $PGDATA
value in the pg_ping response, but I would be against that on
security
On Fri, Oct 16, 2009 at 11:08 AM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Robert Haas robertmh...@gmail.com wrote:
Well, then Tom's idea of using a random number seems pretty solid no
matter how you slice it. Maybe a UUID.
A random number is looking like the best option. I'm
On Fri, Oct 16, 2009 at 2:04 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Robert Haas robertmh...@gmail.com wrote:
UUIDs throw away 6 bits?
http://en.wikipedia.org/wiki/Universally_Unique_Identifier#Version_4_.28random.29
How about that. You learn something new every day
On Sun, Sep 27, 2009 at 5:29 PM, Jesper sol...@hotmail.com wrote:
The following bug has been logged online:
Bug reference: 5083
Logged by: Jesper
Email address: sol...@hotmail.com
PostgreSQL version: 8,3
Operating system: Vista
Description: Problem create
On Wed, Sep 30, 2009 at 7:11 AM, Edinei edi...@guaporepecuaria.com.br wrote:
The following bug has been logged online:
Bug reference: 5090
Logged by: Edinei
Email address: edi...@guaporepecuaria.com.br
PostgreSQL version: 8.4
Operating system: Windows XP
Description:
On Wed, Sep 30, 2009 at 4:33 AM, Yamashkin Alex defa...@smart-soft.ru wrote:
The following bug has been logged online:
Bug reference: 5089
Logged by: Yamashkin Alex
Email address: defa...@smart-soft.ru
PostgreSQL version: 8.4.0.1
Operating system: windows XP Embeded
On Wed, Sep 30, 2009 at 4:33 AM, Yamashkin Alex defa...@smart-soft.ru wrote:
The following bug has been logged online:
Bug reference: 5089
Logged by: Yamashkin Alex
Email address: defa...@smart-soft.ru
PostgreSQL version: 8.4.0.1
Operating system: windows XP Embeded
On Tue, Sep 29, 2009 at 11:15 PM, Ian Small i...@omniconnect.com.au wrote:
The following bug has been logged online:
Bug reference: 5088
Logged by: Ian Small
Email address: i...@omniconnect.com.au
PostgreSQL version: any
Operating system: any
Description:
On Wed, Sep 30, 2009 at 5:23 AM, ajay labade ajaylab...@gmail.com wrote:
I am trying to port my application from Oracle to PostGREs. I have a
problem while doing so. In my application i need to update record if the
delete on the respective record is failed due to Constraint Violation. But
On Mon, Sep 28, 2009 at 10:12 AM, Jacques Caron j...@oxado.com wrote:
Hi,
You can use a trigger before insert and a pl/pgsql function that goes:
BEGIN
UPDATE table SET ... WHERE pk=NEW.pk
IF FOUND THEN
RETURN NULL;
ELSE
RETURN NEW;
END IF;
END;
Jacques.
That seems about right.
On Mon, Sep 28, 2009 at 2:51 AM, Yaming Gu yaming...@w-oasis.com wrote:
Thank you so much for your kind reply.
Your analysis sounds very reasonable. I checked my Perl version, it is Perl
5.8.9 Build 826 which is the latest version in the series of 5.8.*.
The whole process of installation of
On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Stefan s...@drbott.de writes:
The problem is that if it is no record in the table, it seems that first the
INSERT command is issued and after that the UPDATE command is issued, too.
Well, yeah. That's exactly how it's
On Sun, Sep 27, 2009 at 11:36 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Well, yeah. That's exactly how it's documented to work: an ON INSERT
rule is executed after the INSERT proper
On Fri, Sep 25, 2009 at 11:50 AM, smuffy vday1...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5082
Logged by: smuffy
Email address: vday1...@gmail.com
PostgreSQL version: 8.4.0
Operating system: opensuse 10.2
Description: I can't
On Wed, Sep 23, 2009 at 11:44 PM, Yaming Gu yaming...@w-oasis.com wrote:
2009-09-24 10:50:55 HKT LOG: loaded library
$libdir/plugins/plugin_debugger.dll
2009-09-24 10:50:59 HKT LOG: loaded library
$libdir/plugins/plugin_debugger.dll
Substitution pattern not terminated at line 1.
I'm very
On Tue, Sep 22, 2009 at 12:54 AM, alexander.o...@koeln.de wrote:
The following bug has been logged online:
Bug reference: 5071
Logged by:
Email address: alexander.o...@koeln.de
PostgreSQL version: 8.3.7
Operating system: Debian Lenny 64Bit
Description: abbrev() bug
On Mon, Sep 21, 2009 at 1:53 AM, Bhushan Verma verma.bhus...@gmail.com wrote:
I have tried to install postgres version 8.3.7 as follows
rm -rf /var/lib/pgsql
mkdir /var/lib/pgsql
./configure --prefix /var/lib/pgsql
gmake
su
gmake install
adduser postgres
mkdir /var/lib/pgsql/data
chown
2009/9/17 Paola R. griffindor_2...@hotmail.com
buenas tardes
estoy tratando de instalar postgresql 8.2 pero en la parte initialise
databasecluster cuando ingreso un el password al dar next me sale el
siguiente mensaje:
the secondary logon service is not running. this service is
On Wed, Sep 23, 2009 at 7:31 PM, Euler Taveira de Oliveira
eu...@timbira.com wrote:
Marek Lewczuk escreveu:
Please execute following example:
select * from ts_debug('english', 'img width=182 height=120
align=right style=margin: 0px 0px 5px 5px; test_aa=26461/')
As the result you will see,
2009/9/23 Yaming Gu yaming...@w-oasis.com
Hi, List
Because I need to use pl/perl language, then I decided to run “createlang”
to create PL/Perl language. I have checked all dependencies and all is ok.
Next I run: D:\Program Files\Postgresql\bincreatelang �CU postgres plperl
example
On Mon, Sep 21, 2009 at 7:30 PM, Tom Lane t...@sss.pgh.pa.us wrote:
David Fetter da...@fetter.org writes:
On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote:
With connection poolers, backends can last quite awhile. Is it OK
for the END block to run hours after the rest of the
On Tue, Sep 22, 2009 at 10:13 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
If the changes are simple, as Tim seems to believe, exactly what do we
lose by doing this?
It's not simple. There are any number of issues that Tim has not
addressed. The most
On Mon, Sep 21, 2009 at 3:23 PM, Christine Penner
christ...@ingenioussoftware.com wrote:
At 11:57 AM 21/09/2009, you wrote:
What error you get when you run initdb?? (Also what exact command you
run?)
The first time I just double clicked on the file initdb.exe. Just now I
tried to run it
On Mon, Sep 21, 2009 at 12:06 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
David Fetter escribió:
Taken literally, that would mean, the last action before the backend
exits, but at least to me, that sounds troubling for the same reasons
that end of transaction triggers do. What
On Mon, Sep 21, 2009 at 12:31 PM, Bruce Momjian br...@momjian.us wrote:
Sam Mason wrote:
On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote:
Sam Mason s...@samason.me.uk wrote:
the deeper problem seems to be that the table was created as:
create table test (a tstdom);
On Mon, Sep 21, 2009 at 2:17 PM, David Fetter da...@fetter.org wrote:
On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote:
David Fetter escribió:
On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote:
David Fetter escribió:
Taken literally, that would mean, the
On Mon, Sep 21, 2009 at 3:08 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
David Fetter escribió:
On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote:
The fine manual saith
You may have multiple END blocks within a file--they will
execute in reverse order of
On Sat, Sep 19, 2009 at 3:53 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Tim Bunce tim.bu...@pobox.com writes:
The plperl implementation doesn't call perl_destruct() during server
shutdown.
Who cares? The process is going away anyway.
END {} blocks can execute arbitrary code. Perl users will
On Fri, Sep 18, 2009 at 5:45 AM, Annita
annita.ven...@qs-unisolution.com wrote:
The following bug has been logged online:
Bug reference: 5063
Logged by: Annita
Email address: annita.ven...@qs-unisolution.com
PostgreSQL version: 8
Operating system: Windows
Description:
On Thu, Sep 17, 2009 at 8:15 AM, Andre Rothe pho...@gmx.de wrote:
Hi,
I have installed Postgres 8.3.8 on Fedora Linux. If I create a table,
the default values will be set by the database to
NULL::timestamp without time zone
for a timezone column and to
NULL::character varying
for a
On Thu, Sep 17, 2009 at 10:44 AM, Andre Rothe pho...@gmx.de wrote:
The problem is, that I get the default values from a metadata query
with JDBC,
so I have to parse every return value for such an annotation before I
can
use them.
That sounds annoying, but it's not a PostgreSQL bug.
So it
On Tue, Sep 15, 2009 at 11:35 PM, Kenaniah Cerny kenan...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5059
Logged by: Kenaniah Cerny
Email address: kenan...@gmail.com
PostgreSQL version: 8.4.1
Operating system: Centos5.2
Description:
On Wed, Sep 16, 2009 at 6:39 PM, Kenaniah Cerny kenan...@gmail.com wrote:
I can provide the output of statistics queries if you would like. Just let
me know which statistics you want and I'll pastebin them.
As far as selectivity goes, the selectivity estimate for the
On Tue, Sep 8, 2009 at 11:38 PM, vyou zhi vyou...@gmail.com wrote:
hi all:
i use Python and PyGreSQL to link PostgreSQL
but the Python give me the error
the error here :
...
95
93
95
97
94
96
94
message type 0x43 arrived from server
On Tue, Sep 15, 2009 at 4:41 PM, Simon Riggs si...@2ndquadrant.com wrote:
I guess if you or another committer spends some time writing a test
framework that is useful and that you can trust, I'm sure many people
will add to it. That'll be true for any of the major/complex areas not
covered by
On Tue, Sep 15, 2009 at 3:26 PM, Joseph Shraibman j...@selectacast.net wrote:
The following bug has been logged online:
Bug reference: 5058
Logged by: Joseph Shraibman
Email address: ...@selectacast.net
PostgreSQL version: 8.2.14
Operating system: Linux
Description:
On Sun, Sep 6, 2009 at 4:48 PM, Ilian Georgiev georgiev.il...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5042
Logged by: Ilian Georgiev
Email address: georgiev.il...@gmail.com
PostgreSQL version: 8.1.10
Operating system: Windows XP
On Sun, Sep 13, 2009 at 10:28 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Andrew Gierth and...@tao11.riddles.org.uk writes:
Domain NOT NULL constraints (and probably other constraints too) aren't
being enforced in some code paths. e.g.
The example you give seems to tie really closely into the
On Wed, Sep 9, 2009 at 5:42 AM, mahmoud badr alien_...@yahoo.com wrote:
The following bug has been logged online:
Bug reference: 5046
Logged by: mahmoud badr
Email address: alien_...@yahoo.com
PostgreSQL version: 8.4
Operating system: windows
Description: java
On Mon, Sep 14, 2009 at 10:22 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
It seems like regardless of this discussion you oughtn't to be able to
store a NULL into that table column. But maybe I'm just confused.
The system is relying
On Thu, Sep 10, 2009 at 7:17 AM, Rohan jamadagni
rohan.jamada...@tcs.com wrote:
The following bug has been logged online:
Bug reference: 5047
Logged by: Rohan jamadagni
Email address: rohan.jamada...@tcs.com
PostgreSQL version: 8.3.7
Operating system: Linux Rhel 5.0
On Mon, Sep 14, 2009 at 10:40 PM, the6campbells the6campbe...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5056
Logged by: the6campbells
Email address: the6campbe...@gmail.com
PostgreSQL version: 8.4.1
Operating system: windows
On Wed, Sep 9, 2009 at 6:04 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Keh-Cheng Chu kehch...@solar2.stanford.edu writes:
While 17 decimal digits are sufficient to guarantee the
complete recovery of all 64-bit double values, some 32-bit
reals actually require NINE significant figures.
Hm,
On Sep 5, 2009, at 6:52 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Thu, Sep 3, 2009 at 5:21 PM, Diego de Limadiego_de_l...@hotmail.com
wrote:
Using Fedora 10 default rpm packages, all updated last month via
yum.
I can't reproduce this on a clean
On Fri, Sep 4, 2009 at 11:15 AM, Tom Lanet...@sss.pgh.pa.us wrote:
I certainly don't want to have char emulate the misbegotten decision
to have explicit and implicit coercions behave differently. So it
looks to me like the argument to make char work like char(1) doesn't
actually help us much
On Fri, Sep 4, 2009 at 11:59 AM, Kevin
Grittnerkevin.gritt...@wicourts.gov wrote:
Tom Lane t...@sss.pgh.pa.us wrote:
I certainly don't want to have char emulate the misbegotten
decision to have explicit and implicit coercions behave differently.
So it looks to me like the argument to make
On Thu, Sep 3, 2009 at 5:21 PM, Diego de Limadiego_de_l...@hotmail.com wrote:
The following bug has been logged online:
Bug reference: 5034
Logged by: Diego de Lima
Email address: diego_de_l...@hotmail.com
PostgreSQL version: 8.3.7
Operating system: Linux Fedora 10
On Tue, Aug 25, 2009 at 8:15 AM, Lampalamp...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5010
Logged by: Lampa
Email address: lamp...@gmail.com
PostgreSQL version: 8.4.0
Operating system: Debian testing/unstable
Description: perl
On Sep 2, 2009, at 11:27 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
Hello
it's not bug - PostgreSQL doesn't support parameter placeholder on
this position. Use dynamic query instead - plpgsql statement EXECUTE.
It may not be a bug exactly, but it sure isn't a feature.
...Robert
--
On Tue, Sep 1, 2009 at 9:51 AM, Dmitrymas...@hsdesign.ru wrote:
The following bug has been logged online:
Bug reference: 5027
Logged by: Dmitry
Email address: mas...@hsdesign.ru
PostgreSQL version: 8.3.5
Operating system: ALT Linux
Description: SQL query error?
On Wed, Sep 2, 2009 at 11:55 AM, Sam Masons...@samason.me.uk wrote:
In fact it doesn't seem to want to play ball at all. Even given the
apparently unambiguous:
SELECT 1+add(1,2);
or
SELECT 'hi'||add(1,2);
It doesn't get anywhere. No need for text 'hi' in the second one
because ||
On Wed, Sep 2, 2009 at 3:34 PM, Sam Masons...@samason.me.uk wrote:
On Wed, Sep 02, 2009 at 12:54:03PM -0500, Kevin Grittner wrote:
Sam Mason s...@samason.me.uk wrote:
If we did follow Kevin's request directly, should we also be
specifying the type of NULL?
I don't *think* the SQL standard
On Wed, Aug 26, 2009 at 5:55 AM, Isharaishara...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5013
Logged by: Ishara
Email address: ishara...@gmail.com
PostgreSQL version: 8.4
Operating system: Solaris x86
Description: Error in
On Fri, Aug 21, 2009 at 9:35 AM, Pramodpramodchoudhar...@yahoo.com wrote:
The following bug has been logged online:
Bug reference: 5003
Logged by: Pramod
Email address: pramodchoudhar...@yahoo.com
PostgreSQL version: 8.4.0-1
Operating system: Windows XP
Description:
On Thu, Aug 27, 2009 at 12:49 PM, Eduardoedua...@vip10.com.br wrote:
The following bug has been logged online:
Bug reference: 5019
Logged by: Eduardo
Email address: edua...@vip10.com.br
PostgreSQL version: 8.3
Operating system: Vista 64 bits
Description: Nao
2009/8/27 Alvaro Herrera alvhe...@commandprompt.com:
Robert Haas escribió:
Para obtener ayuda en espan~ol, tal vez puede Ud. tratar
pgsql-es-ay...@postgresql.org. Creo que no tenemos una list de correo
en Portugue's.
It lives in another list server:
https://listas.postgresql.org.br/cgi
601 - 700 of 731 matches
Mail list logo