The following bug has been logged online:
Bug reference: 1327
Logged by: yychen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system: Fedora 3
Description:Compare column of varchar FAILURE!
Details:
Client Charset zh_TW Big5
Server DataB
On Mon, 22 Nov 2004, David Schweikert wrote:
> On Sun, Nov 21, 2004 at 20:10:08 -0500, Tom Lane wrote:
> > I'm not entirely convinced this is a bug. I get the right answer from
> >
> > regression=# select to_number('001,000', '999,999') ;
> > to_number
> > ---
> > 1000
> > (1 row)
On Mon, 22 Nov 2004, Stephan Szabo wrote:
> On Mon, 22 Nov 2004, David Schweikert wrote:
>
> > On Sun, Nov 21, 2004 at 20:10:08 -0500, Tom Lane wrote:
> > > I'm not entirely convinced this is a bug. I get the right answer from
> > >
> > > regression=# select to_number('001,000', '999,999') ;
> >
On Mon, Nov 22, 2004 at 05:47:19 -0800, Stephan Szabo wrote:
>No, but I think you're supposed to use FM in such cases.
>
>select to_number(1000, 'FM999,999');
Indeed, it works with 'FM'.
Thanks!
David
--
David Schweikert| phone: +41 44 632 7019
System manager ISG.EE | walk: ETH Zentru
Stephan Szabo <[EMAIL PROTECTED]> writes:
> No, but I think you're supposed to use FM in such cases.
>
> select to_number(1000, 'FM999,999');
Good point --- I had forgot about FM. In that case there *is* a bug
here, but I'm not sure if it's with to_char or to_number:
regression=# select to_numbe
This is my third attempt at posting to the list ... hopefully it will make
it this time
-- Forwarded message --
Date: Mon, 22 Nov 2004 04:34:22 + (GMT)
From: Nicola Pero <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Data corruption/loss when altering tables
I've been expe
Hello Nicola,
Monday, November 22, 2004, 9:00:30 PM, you wrote:
NP> I've been experiencing data corruption/loss in Postgresql 7.4.2.
Try to recompile (create or replace) your stored procedure
after you alter the table
Hope this help...
--
Best regards,
Ivanmai
Nicola Pero <[EMAIL PROTECTED]> writes:
> I've been experiencing data corruption/loss in Postgresql 7.4.2.
> I tracked this down to altering tables. After I alter a table, I get data
> loss
> (fields becoming NULL with no reason!) unless I restart immediately the
> database server.
The proble
I've been experiencing data corruption/loss in Postgresql 7.4.2.
I tracked this down to altering tables. After I alter a table, I get data loss
(fields becoming NULL with no reason!) unless I restart immediately the
database server.
The problem shown in your example is simply that the UPDATE in
On Mon, Nov 22, 2004 at 12:14:30PM -0500, Tom Lane wrote:
> The problem shown in your example is simply that the UPDATE in the
> plpgsql function has cached a plan that applies to the original format
> of the table. You don't need to restart the server, but you do need to
> start a fresh session
On Mon, Nov 22, 2004 at 06:26:09PM +, Nicola Pero wrote:
> Is there a way to explictly flush cached plans ? Is there a way to
> prevent the caching of the plan in the stored procedure ?
You can prevent plan caching in PL/pgSQL by using EXECUTE. See the
"Executing Dynamic Commands" section
Your name : Aaron Hillegass
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : PPC
Operating System (example: Linux 2.4.18) : Mac OS X 10.3.5
PostgreSQL version (example: PostgreSQL-8
On occasion, it seems the psql history file gets truncated.
Unable to replicate, it just seems to happen every now and then.
... John
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregiste
Hi
I wanted to involve in Postgres beta testing. I want to the test the Windows
Beta version.
I have downloaded the below
ftp://ftp4.ar.postgresql.org/pub/mirrors/postgresql/win32/postgresql-8.0.0-beta4.zip
Is this the right version for Beta testing? I am consfused
Regards
Siva Ganesh
___
I've been experiencing data corruption/loss in Postgresql 7.4.2.
I tracked this down to altering tables. After I alter a table, I get data
loss (fields becoming NULL with no reason!) unless I restart immediately
the database server. After the restart all seems OK (but the data which
was lost,
Is there a way to explictly flush cached plans ? Is there a way to
prevent the caching of the plan in the stored procedure ?
You can prevent plan caching in PL/pgSQL by using EXECUTE. See the
"Executing Dynamic Commands" section in the PL/pgSQL chapter of the
documentation.
Thanks! I suppose th
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Would LOAD 'plpgsql' work? Would that cause a fresh compile of the
> function the next time it's called, resulting in a new cached plan?
I think that would cause plpgsql to lose track of its entire function
table, which is a brute force way of doing that
Aaron Hillegass <[EMAIL PROTECTED]> writes:
> I have a script that must start the postmaster before continuing, so I
> do this:
> sudo -u postgres /Library/PostgreSQL/bin/pg_ctl -w start
This is not going to work very well because sudo doesn't update the
environment --- for example if PGUSER is
On Mon, Nov 22, 2004 at 03:44:25PM -0500, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > Would LOAD 'plpgsql' work? Would that cause a fresh compile of the
> > function the next time it's called, resulting in a new cached plan?
>
> I think that would cause plpgsql to lose track of
John Hansen wrote:
> On occasion, it seems the psql history file gets truncated.
Truncated to 500 lines by any chance?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: don't forget to increase your free
On Tue, 2004-11-16 at 21:45, Simon Riggs wrote:
> On Tue, 2004-11-16 at 12:34, Devrim GUNDUZ wrote:
> > > Description:7.3.8 server RPM has file error
> > >
> > > Details:
> > >
> > > Installing postgresql-server-7.3.8-2PGDG.i686.rpm,
> > > I get the following error:
> > > error: unpacking o
Folks,
Two possible bugs.
#1 Loading unicode data.
#2 Doing count of data based on substring(1,1) of a col.
--
#1 Loading unicode data
--
I've loaded freedb database (freedb.org) into a 8.0.0 beta 4 database I
created on my PC.
PC is Windows XP P
22 matches
Mail list logo
