> 2009/1/10 Tom Lane :
>> Bruce Momjian writes:
>>> Uh, is this ready to be applied?
>>
>> I don't think any consensus has been reached on changing this behavior.
>
> I thing, so this is bug - RETURN QUERY has to supply FOR SELECT LOOP
> RETURN NEXT pattern.
>
> My first patch expected so RETURN
On Wed, Feb 4, 2009 at 1:32 PM, Bruce Momjian wrote:
> Robert Haas wrote:
>> > 2009/1/10 Tom Lane :
>> >> Bruce Momjian writes:
>> >>> Uh, is this ready to be applied?
>> >>
>> >> I don't think any consensus has been reached on
On Tue, Jun 9, 2009 at 12:07 PM, Tom Lane wrote:
> The technically best solution is probably similar to what Materialize
> nodes do, ie, read the query only once and be careful to stash rows
> aside into a tuplestore as they are read. This would fix both issues
> with one patch. The problem with
On Tue, Jun 9, 2009 at 1:47 PM, Tom Lane wrote:
> Robert Haas writes:
>> This seems like the only option that will produce correct answers, so
>> it gets my vote. How much is the performance penalty for
>> materializing the tuplestore? I'm inclined to think that whatev
On Wed, Jul 15, 2009 at 7:18 PM, Don Fox wrote:
> I am having installation problems with postrgesql on my mac. I'v tried
> MacPorts, your site and PostgreSQLforMac. I've tried 8.3.7 and the most
> current version. After each install I'm unable to locate any actual access
> to the DB. When installi
On Tue, Jul 21, 2009 at 2:13 AM, Pavel Stehule wrote:
> 2009/7/21 Jaime Casanova :
>> On Mon, Jul 20, 2009 at 11:34 AM, Jaime
>> Casanova wrote:
>>> On Mon, Jul 20, 2009 at 10:09 AM, Alvaro
Getting rid of the check on natts was "ungood" ... it needs to compare
the number of undropped
On Tue, Jul 28, 2009 at 1:19 PM, Jaime
Casanova wrote:
> On Tue, Jul 28, 2009 at 12:12 PM, Robert Haas wrote:
>>>>
>>>> patch attached
>>>>
>>> super, thanks
>>>
>>> Pavel
>>
>> So is this Ready for Committer?
&g
On Jul 28, 2009, at 1:16 PM, "Dan Boeriu" wrote:
I am doing a reply-all - hope that's fine.
The pg_locks shows only locks held by that Postgresql process - I am
the only one on the box.
pg_stat_activity shows 2 things:
1) the update
2) vacuum on the updated table
Now, I tried to isolate th
On Jul 28, 2009, at 9:47 AM, Tom Lane wrote:
"Ole Tange" writes:
(modulo NULLs which seem to always cause problems in NOT INs).
Because it can be rewritten, NOT IN should never be much slower
than the
rewritten solution, as PostgreSQL should simply rewrite NOT IN to the
above.
Let's se
On Tue, Jul 28, 2009 at 9:26 AM, Ramakanth wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4950
> Logged by: Ramakanth
> Email address: ramaka...@iblesoft.com
> PostgreSQL version: Advanced 8.3 R2
> Operating system: Windows xp
> Description: Prob
On Thu, Jul 16, 2009 at 12:34 PM, Steve Caligo wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4925
> Logged by: Steve Caligo
> Email address: steve.cal...@ctie.etat.lu
> PostgreSQL version: 8.3.7 and 8.4.0
> Operating system: Archlinux and Gentoo 8.3.7,
On Thu, Jul 30, 2009 at 1:40 AM, Steve Caligo wrote:
> Allowing FOR UPDATE in sub-queries has been rejected in this same thread,
> you've also mentioned it your previous reply.
> http://archives.postgresql.org/pgsql-bugs/2004-10/msg00150.php
Um, I didn't write that email. That was Tom Lane.
>> T
On Mon, Jul 27, 2009 at 8:06 PM, Fabiano wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4946
> Logged by: Fabiano
> Email address: fabiano.san...@onda.com.br
> PostgreSQL version: 8.3
> Operating system: windows
> Description: bug - libiconv-2.dl
On Wed, Aug 5, 2009 at 10:46 AM, Jeff Janes wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4965
> Logged by: Jeff Janes
> Email address: jeff.ja...@gmail.com
> PostgreSQL version: 8.4.0
> Operating system: Linux
> Description: missing tests in to
On Fri, Jul 31, 2009 at 11:00 AM, wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4959
> Logged by:
> Email address: wad...@jcom.home.ne.jp
> PostgreSQL version: 8.4.0
> Operating system: Windows
> Description: unable to install/start service
> Details:
>
On Thu, Aug 6, 2009 at 3:09 PM, Dielton Paulo wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4969
> Logged by: Dielton Paulo
> Email address: dpa...@sefaz.ba.gov.br
> PostgreSQL version: 8.4
> Operating system: Windows XP
> Description: ajuda
> D
On Fri, Aug 7, 2009 at 12:31 AM, Rob Wultsh wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4970
> Logged by: Rob Wultsh
> Email address: wult...@gmail.com
> PostgreSQL version: 8.4
> Operating system: N/A
> Description: Broken link in manual
> De
On Fri, Jul 17, 2009 at 10:21 AM, Tom Lane wrote:
> Peter Eisentraut writes:
>> ... But again, this is data type specific knowledge.
>
> Actually, now that I think about it, the planner already has
> datatype-specific knowledge about boolean equality (see
> simplify_boolean_equality). It would ta
On Mon, Aug 10, 2009 at 8:52 AM, Richard Neill wrote:
> What I think I meant was dividing a differential timestamp by an interval.
> In this case, both should be unambiguously expressed in seconds, and the
> result will be dimensionless.
And what will you get when you divide 1 month by 1 day?
...
On Mon, Aug 10, 2009 at 11:10 AM, Tom Lane wrote:
> Robert Haas writes:
>> On Fri, Jul 17, 2009 at 10:21 AM, Tom Lane wrote:
>>> Actually, now that I think about it, the planner already has
>>> datatype-specific knowledge about boolean equality (see
>>> simpli
On Fri, Aug 7, 2009 at 7:50 AM, psqluser wrote:
> I am getting the below error repeatedly in postgres 8.3
>
> 2009-08-07 15:19:35.749 ISTLOG: unexpected EOF on client connection
> 2009-08-07 15:31:47.718 ISTWARNING: worker took too long to start;
> cancelled
> 2009-08-07 15:32:22.825 ISTWARNING:
On Wed, Aug 12, 2009 at 8:00 AM, Gaurav K Srivastava wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4980
> Logged by: Gaurav K Srivastava
> Email address: gaurav...@gmail.com
> PostgreSQL version: 8.3
> Operating system: Windows xp
> Description:
On Tue, Aug 11, 2009 at 2:40 AM, Sergei Abramov wrote:
> Platform: Windows XP, 5.1 (Build 2600).Language: Russain.
> Distribution used: Binary.
> pgAdmin version: 1.10.0.
> PostgreSQL version: 8.4.0-1.
>
> Bug description: When I use pgAdmin's menu command 'Delete/drop' to drop
> database, especial
On Wed, Aug 12, 2009 at 3:28 AM, Jim Michaels wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4976
> Logged by: Jim Michaels
> Email address: jmich...@yahoo.com
> PostgreSQL version: 8.4.0
> Operating system: Windows XP Pro SP3
> Description: pgad
On Fri, Aug 14, 2009 at 1:35 AM, Saneera Gunasekara wrote:
>
> Dear Sir
>
> I have got the following error message when connecting postgres from
> postgres admin connecting form the localhost
> (only special thing in machine configuration is attached the 2 network cards
> to the installation machin
On Thu, Aug 13, 2009 at 2:32 AM, Carlos B Netto wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4984
> Logged by: Carlos B Netto
> Email address: cobbne...@hotmail.com
> PostgreSQL version: 8.4.0-1
> Operating system: Windows Server 2003
> Description:
On Wed, Aug 12, 2009 at 2:11 AM, Hans wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4975
> Logged by: Hans
> Email address: nanjangmu...@naver.com
> PostgreSQL version: 8.4.0
> Operating system: Windows Server 2003 Standard Edition KN Service Pack 2
>
On Sun, Aug 9, 2009 at 4:51 PM, Daniel Migowski wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4971
> Logged by: Daniel Migowski
> Email address: dmigow...@ikoffice.de
> PostgreSQL version: 8.3.5
> Operating system: Windows XP
> Description: Back
On Wed, Aug 19, 2009 at 5:45 AM, Gaurav K Srivastav wrote:
> HI,
>
> I have a normal user 'abcd' and grant all previliges to this user on the
> database 'pqr'.
> now i am unable to use dblink(text,text).
> while via super user 'postgre' which is the owner of database 'postgre' I
> am able to use
On Fri, Aug 21, 2009 at 10:36 AM, fabiofurlan wrote:
>
> Hi.
>
> I do not any idea.
>
> When i drop table or alter table, i need restart service postgresql 8.1,
> because is impossible new connect or
> because the changes are not visible.
>
> Gnu Linux Debian 4.0
> PostgreSQL 8.1
>
>
> Thanks a lot
On Mon, Aug 24, 2009 at 8:24 AM, Brian
Ceccarelli wrote:
> Yes. I understand. It has all to do with Unicode collating sequence. I
> need to somehow remove this bug from the list, since it is not a bug.
Heh. As far as I understand, there is no list... one thing that I
have been worrying abou
On Mon, Aug 24, 2009 at 3:10 PM, Greg Stark wrote:
> On Mon, Aug 24, 2009 at 8:03 PM, Alvaro
> Herrera wrote:
>> Personally I still think debbugs would suit us perfectly, but 1. I don't
>> have time to handle it, 2. nobody else believes this, 3. the debbugs
>> developers are not very interested in
On Thu, Aug 27, 2009 at 12:49 PM, Eduardo 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 funciona
> Det
2009/8/27 Alvaro Herrera :
> 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://li
On Wed, Aug 26, 2009 at 5:55 AM, Ishara 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 psqlodbc config
On Fri, Aug 21, 2009 at 9:35 AM, Pramod 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: setup error
>
On Tue, Sep 1, 2009 at 9:51 AM, Dmitry 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?
> Details
On Wed, Sep 2, 2009 at 11:55 AM, Sam Mason 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 || isn't define
On Wed, Sep 2, 2009 at 3:34 PM, Sam Mason wrote:
> On Wed, Sep 02, 2009 at 12:54:03PM -0500, Kevin Grittner wrote:
>> Sam Mason 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 requires that, and barri
On Sep 2, 2009, at 11:27 PM, Pavel Stehule
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
--
Sent via pgsql-bugs mail
On Fri, Sep 4, 2009 at 11:15 AM, Tom Lane 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 to decide i
On Fri, Sep 4, 2009 at 11:59 AM, Kevin
Grittner wrote:
> Tom Lane 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 act
On Thu, Sep 3, 2009 at 5:21 PM, Diego de Lima 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
> Description:
On Tue, Aug 25, 2009 at 8:15 AM, Lampa 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 iconv fun
On Sep 5, 2009, at 6:52 PM, Tom Lane wrote:
Robert Haas writes:
On Thu, Sep 3, 2009 at 5:21 PM, Diego de Lima> wrote:
Using Fedora 10 default rpm packages, all updated last month via
yum.
I can't reproduce this on a clean build of 8.3.7 or on a clean build
of CVS HEAD, both agai
On Wed, Sep 9, 2009 at 6:04 PM, Tom Lane wrote:
> Keh-Cheng Chu 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, annoying. Seems like we could do one of two
On Sun, Sep 13, 2009 at 10:28 PM, Tom Lane wrote:
> "Andrew Gierth" 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 debate about
> whether a composite null i
On Wed, Sep 9, 2009 at 5:42 AM, mahmoud badr 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 developer
>
On Mon, Sep 14, 2009 at 10:22 AM, Tom Lane wrote:
> Robert Haas 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 the not-unr
On Thu, Sep 10, 2009 at 7:17 AM, Rohan jamadagni
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
> Description:
On Fri, Sep 4, 2009 at 6:02 PM, Rob Resendez wrote:
> The following bug has been logged online:
>
> Bug reference: 5037
> Logged by: Rob Resendez
> Email address: rob.resen...@cpsinet.com
> PostgreSQL version: 8.3.7
> Operating system: Linux
> Description: jdbc bug \uff
On Mon, Sep 14, 2009 at 10:40 PM, the6campbells 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
> Description: SQLDes
On Tue, Sep 8, 2009 at 11:38 PM, vyou zhi 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 while
On Tue, Sep 15, 2009 at 4:41 PM, Simon Riggs 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 public test suites
On Tue, Sep 15, 2009 at 3:26 PM, Joseph Shraibman 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: [jdbc]
On Sun, Sep 6, 2009 at 4:48 PM, Ilian Georgiev 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
> Description: U
On Tue, Sep 15, 2009 at 11:35 PM, Kenaniah Cerny 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: Planner
On Wed, Sep 16, 2009 at 6:39 PM, Kenaniah Cerny 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
> user_anime_log.user_account_id was defi
On Thu, Sep 17, 2009 at 8:15 AM, Andre Rothe 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 varch
On Thu, Sep 17, 2009 at 10:44 AM, Andre Rothe 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 seems tha
On Fri, Sep 18, 2009 at 5:45 AM, Annita
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: MS Access crash
On Sat, Sep 19, 2009 at 3:53 PM, Tom Lane wrote:
> "Tim Bunce" 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 expect them
to be executed.
..
On Mon, Sep 21, 2009 at 12:06 PM, Alvaro Herrera
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 happens when there a
On Mon, Sep 21, 2009 at 12:31 PM, Bruce Momjian wrote:
> Sam Mason wrote:
>> On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote:
>> > Sam Mason wrote:
>> > > the deeper problem seems to be that the table was created as:
>> > >
>> > > create table test (a tstdom);
>> > >
>> > > and n
On Mon, Sep 21, 2009 at 2:17 PM, David Fetter 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
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 definition;
On Mon, Sep 21, 2009 at 7:30 PM, Tom Lane wrote:
> David Fetter 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 code?
>>>
>>> This is an int
On Tue, Sep 22, 2009 at 10:13 AM, Tom Lane wrote:
> Robert Haas 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 obvi
On Mon, Sep 21, 2009 at 3:23 PM, Christine Penner
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 through the command promp
2009/9/23 Yaming Gu
>
>
> 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\bin>createlang �CU postgres plperl
> example (example is my
On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane wrote:
> "Stefan" 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 documented to work: an ON INS
On Sun, Sep 27, 2009 at 11:36 AM, Tom Lane wrote:
> Robert Haas writes:
>> On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane 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 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 get logfile
On Wed, Sep 23, 2009 at 11:44 PM, Yaming Gu 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 suspicious
On Tue, Sep 22, 2009 at 12:54 AM, 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 with IPv6
> Detail
On Mon, Sep 21, 2009 at 1:53 AM, Bhushan Verma 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 postgres /v
2009/9/17 Paola R.
>
>
> 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 required for
> the i
On Wed, Sep 23, 2009 at 7:31 PM, Euler Taveira de Oliveira
wrote:
> Marek Lewczuk escreveu:
>> Please execute following example:
>> select * from ts_debug('english', '> align="right" style="margin: 0px 0px 5px 5px;" test_aa="26461"/>')
>>
>> As the result you will see, that is not identified as X
On Mon, Sep 28, 2009 at 10:12 AM, Jacques Caron 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 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 Perl goes well
On Tue, Sep 29, 2009 at 11:15 PM, Ian Small 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: community account no
On Wed, Sep 30, 2009 at 5:23 AM, ajay labade 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
>> SQL Error: 0,
On Wed, Sep 30, 2009 at 7:11 AM, Edinei 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: erro
> Details
On Wed, Sep 30, 2009 at 4:33 AM, Yamashkin Alex 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
> Description:
On Wed, Sep 30, 2009 at 4:33 AM, Yamashkin Alex 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
> Description:
On Sun, Sep 27, 2009 at 5:29 PM, Jesper 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 account.
> Deta
On Fri, Oct 16, 2009 at 6:39 AM, Heikki Linnakangas
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 searched the postgres
>> FAQs,
On Fri, Oct 16, 2009 at 10:33 AM, Kevin Grittner
wrote:
> Pedro Gimeno 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 grounds. We don't let nonprivileged users kno
On Fri, Oct 16, 2009 at 11:08 AM, Kevin Grittner
wrote:
> Robert Haas 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 not
On Fri, Oct 16, 2009 at 2:04 PM, Kevin Grittner
wrote:
> Robert Haas 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.
...Robert
--
Sent via pgsql
2009/10/16 malu :
>
> 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 registros
> Details:
On Wed, Oct 14, 2009 at 9:56 AM, 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
> Details:
>
>
On Tue, Oct 6, 2009 at 9:38 PM, Matthew Byrne 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 9.04)
> Descript
On Wed, Oct 21, 2009 at 11:23 PM, aihongwei 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 pgsql will
On Wed, Oct 21, 2009 at 12:51 PM, 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
> Details:
>
>
On Thu, Oct 22, 2009 at 3:23 AM, Geok Hua Yap 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
> Description: Inval
2009/9/29 Yaming Gu :
> Hi, Robert,
>
> According to your recommendations, I tried to load plperu, almost the same
> error messages have shown:
>
> D:\Program Files\Postgresql\8.3\bin>createlang -U postgres plperlu example
>
> Password:
>
> createlang: language installation failed: server closed t
On Sat, Sep 5, 2009 at 5:42 AM, Kamil Roman 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
> Description: 'i' fl
On Thu, Oct 22, 2009 at 10:47 AM, flamin dragon wrote:
>
>
> 2009/10/22 Robert Haas
>>
>> On Wed, Oct 21, 2009 at 12:51 PM, wrote:
>> >
>> > The following bug has been logged online:
>> >
>> > Bug reference: 5130
>>
On Fri, Aug 28, 2009 at 9:59 AM, Dan O'Hara 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: ts_parse doesn
1 - 100 of 787 matches
Mail list logo