Hi,
I have encountered a problem with plpgsql and I would appreciated it
if anyone could help me with this.
If I have a relation say:
emp_id | salary
---
1 | 4.00
---
2 | 45600.00
---
3 | 4.00
--
On Fri, 5 Oct 2001, Marc G. Fournier wrote:
> On Fri, 5 Oct 2001, John Summerfield wrote:
>
> > I don't think I was being rude. It's true I'm no diplomat. I've
> > criticised actions (and, I think, with considerable justice), but I've
> > not actually criticised people.
>
> How can your criticis
On Fri, 5 Oct 2001, Lamar Owen wrote:
> On Thursday 04 October 2001 09:40 pm, John Summerfield wrote:
> > Well, remember I only arrived here in the past two weeks. What I've seen
> > has not been reassuring.
>
> May I be so bold as to suggest your taking a few hours of your time and
> reading th
Tom Lane writes:
> regression=# select '2001-10-04 13:52:42.845985-04'::timestamp;
> timestamptz
>
> 2001-10-04 13:52:43-04
> (1 row)
>
> Throwing away the clearly stated precision of the literal doesn't
> seem like the right behavior to me.
That depends on the ex
Alex Avriette writes:
> /usr/bin/ld: -undefined error must be used when -twolevel_namespace is in effect
In src/makefiles/Makefile.darwin, add -flat_namespace to CFLAGS_SL.
I'm checking in a patch to fix this in 7.2.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
I have found some kind of problems with a rule I have on one of my databases,
and after some mailling with Tom, and re-checking my logs I find out that the
inserts look like the are getting (if I look at the logs) but the data is not
there!
This is the RULE:
CREATE RULE admin_insert AS ON
IN
> So far, as compared to many other databases, PostgreSQL, remains
> pretty close to the standard (at least for our projects). The only
> areas that we have had issues with is the default inclusion of the
> timezone information when retriving the timestamp information and the
> slightly non-stand
Laurette Cisneros <[EMAIL PROTECTED]> writes:
> Should I file a bug or is this known (or fixed)?
The problem appears to be gone in current development sources:
regression=# select interval( 301.00 );
interval
--
00:05:01
(1 row)
The particular code you mentioned seems unchanged, so t
"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
>> Of course the working source is 3rd October.
> Tom, do you have an idea what you might have fixed to that effect ?
No idea. I've been fixing some portability issues in dynahash.c,
but AFAIK they only affected the pgstats collector proce
Howdy hackers,
Should I file a bug or is this known (or fixed)?
Thanks!
Laurette ([EMAIL PROTECTED])
Here's the psql ready test and description:
--
-- BUG Description:
-- A float with zeros on the right of the decimal
-- fails conversion to an interval.
-- interval ( int ) works
-- interval (
>
> > > I am quite sure that all AIX Versions accept the CLOBBER method,
> > > thus I ask you to apply the following patch, to make it work.
> >
> > CLOBBER does not work with AIX5L, nor CHANGE_ARGV. (SETPROCTITLE,
> > PSTAT and PS_STRINGS can not be used since AIX5L does not have
> > appropreat
> > > BTW, still I'm getting the stucking backends. New info: a snapshot
> > > dated on 10/3 works fine.
> >
> > I allways have trouble with those different date formats. Do you
> > mean, that the problem is fixed as of 3. October, or that an old
> > snapshot from 10. March still worked ?
>
> O
On Thursday 04 October 2001 09:40 pm, John Summerfield wrote:
> Well, remember I only arrived here in the past two weeks. What I've seen
> has not been reassuring.
May I be so bold as to suggest your taking a few hours of your time and
reading the last six months to a year of the list's archives
At 9:41 AM -0400 10/5/01, Alex Avriette wrote:
>I had a catastrophic crash on one of our webservers here and took the
>opportunity to upgrade it. Unfortunately, after the upgrade, I am unable to
>compile either 7.1.3 or the current snapshot of postgres.
>
>The error I get is rather opaque:
>
>/usr
At 9:41 AM -0400 10/5/01, Alex Avriette wrote:
>I had a catastrophic crash on one of our webservers here and took the
>opportunity to upgrade it. Unfortunately, after the upgrade, I am unable to
>compile either 7.1.3 or the current snapshot of postgres.
>
>The error I get is rather opaque:
>
>/usr
Hi All,
I am having troubles compiling Postgresql 7.1.3 on OSX 10.1
I have the following error:
cut
cc -no-cpp-precomp -g -O2 -Wall -Wmissing-prototypes
-Wmissing-declarations -bundle -undefined suppress -bundle -undefined
suppress fe-auth.o fe-connect.o fe-exec.o fe-misc.o fe-print.o
On 05 Oct 2001 at 09:46 (-0400), Tom Lane wrote:
| Brent Verner <[EMAIL PROTECTED]> writes:
| > 'ALTER TABLE tbl RENAME col1 TO col2' does not update any indices that
| > reference the old column name.
|
| It doesn't need to; the indexes link to column numbers, not column
| names.
Forgive my inc
> > BTW, still I'm getting the stucking backends. New info: a snapshot
> > dated on 10/3 works fine.
>
> I allways have trouble with those different date formats. Do you
> mean, that the problem is fixed as of 3. October, or that an old
> snapshot from 10. March still worked ?
Of course the work
Alex Avriette <[EMAIL PROTECTED]> writes:
> /usr/bin/ld: -undefined error must be used when -twolevel_namespace is in
> effect
All we know at this point is that Apple changed something between 10.0.4
and 10.1. If you want to look into it and figure out how to fix it,
that'd be great.
Attached i
Brent Verner <[EMAIL PROTECTED]> writes:
> 'ALTER TABLE tbl RENAME col1 TO col2' does not update any indices that
> reference the old column name.
It doesn't need to; the indexes link to column numbers, not column
names.
regards, tom lane
---(end
I had a catastrophic crash on one of our webservers here and took the
opportunity to upgrade it. Unfortunately, after the upgrade, I am unable to
compile either 7.1.3 or the current snapshot of postgres.
The error I get is rather opaque:
/usr/bin/ld: -undefined error must be used when -twolevel_
My friends,I'm brazilian and I am developing a
project that need to develop a function that returns me the amount of users
connected in the bank, and the amount of lock's in a table, and the space in
disk placed for one determined database! Can you help me with the solution ? How
can I get t
I just finished up some work bringing a Linux/FreeBSD server project to
Windows. Enough to test at least. (I have to find a version of getopt() for
Windows) What I found was surprising.
My server project is like a database cache for Web servers. It is used to keep
session information across page
On Fri, 5 Oct 2001, John Summerfield wrote:
> On Thu, 4 Oct 2001, Stephan Szabo wrote:
>
>
> > of the message this was in response to which appears to be what Lamar was
> > responding to. Besides, there's a far cry from a message of constructive
> > criticism and the message this was in response
On Fri, 5 Oct 2001, John Summerfield wrote:
> I don't think I was being rude. It's true I'm no diplomat. I've
> criticised actions (and, I think, with considerable justice), but I've
> not actually criticised people.
How can your criticisms be 'with considerable justice' (justification?)
when yo
> BTW, still I'm getting the stucking backends. New info: a snapshot
> dated on 10/3 works fine.
I allways have trouble with those different date formats. Do you
mean, that the problem is fixed as of 3. October, or that an old
snapshot from 10. March still worked ?
Snapshot of 1. Oct 2001 does
>>Tom, I want to notice that initGISTstate is called for every inserting
>>value (for each row). I think it's not good, because this function
>>called 'fmgr_info' 7 times. 'fmgr_info' call a
>>'load_external_function' with execution of sequence search on library
>>name. Any suggestion?
>>
>
> fmg
> > > I am quite sure that all AIX Versions accept the CLOBBER method,
> > > thus I ask you to apply the following patch, to make it work.
> >
> > CLOBBER does not work with AIX5L, nor CHANGE_ARGV. (SETPROCTITLE,
> > PSTAT and PS_STRINGS can not be used since AIX5L does not have
> > appropreate h
> > ... then trailing zeros are hacked out,
> > two digits at a time.
>
> I was wondering why it seemed to always want to produce an even number
> of fractional digits. Why are you doing it 2 at a time and not 1?
> I should think timestamp(1) would produce 1 fractional digit, not
> two digits o
> > I am quite sure that all AIX Versions accept the CLOBBER method,
> > thus I ask you to apply the following patch, to make it work.
>
> CLOBBER does not work with AIX5L, nor CHANGE_ARGV. (SETPROCTITLE,
> PSTAT and PS_STRINGS can not be used since AIX5L does not have
> appropreate header files
30 matches
Mail list logo
