you will have to edit the file called 'rc' in the top
level etc folder..
in the terminal type
cd /etc
sudo pico rc
(you will be asked for an administrator password)
scroll down 2 to 3 pages and find the section like
this
# System tuning
sysctl -w kern.maxvnodes=$(echo $(sysctl -n
hw.physmem) '3
Michael van Elst <[EMAIL PROTECTED]> writes:
> But there is no 55th month and no 66th day of that month,
> the conversion should simply fail and abort the transaction
> with an error, shouldn't it ?
I believe this is an acknowledged bug in to_date, which Karel hasn't
yet got around to fixing.
On Mon, Dec 29, 2003 at 05:47:56AM -0800, Theodore Petrosky wrote:
>
> I don't see the problem... you are specifying the 66th
> day of the 55th month in the year . just a cursory
> glance says that 48 months is 4 years... that gives
> the year as 5559. try your example with real numbers
> (unl
I don't see the problem... you are specifying the 66th
day of the 55th month in the year . just a cursory
glance says that 48 months is 4 years... that gives
the year as 5559. try your example with real numbers
(unless these are real)
select to_date('13122003','ddmm');
to_date
--
sir,
in postgresql 7.3.2 when we are trying to query like
select to_date('66555','ddmm');
the output is
5559-09-06
it is not validating the day and month and unknown format
is the output..
any help regarding this is greatful...
thank you
---(end of b
Michael,
As you indicated, we may change some configurations
to see whether it can help.
The configuration parameters I used are as follows:
/bin/env CC=$MYCC ./configure \
--prefix=/platdb \
--with-pgport=5333 \
--without-readline \
--with-CXX \
--with-perl \
--with-java \
--with-pam \
--enable
I'm sorry, it was my problem.
Thank You
Pavel
On Tue, 23 Dec 2003, Tom Lane wrote:
> Pavel Stehule <[EMAIL PROTECTED]> writes:
> > make[2]: Entering directory `/home/src/pgsql/src/bin'
> > make[3]: Entering directory `/home/src/pgsql/src/bin/initdb'
> > make[3]: *** No rule to make target `po/de
Michael,
Yes, the enable-thread-safety is used in configure file.
Is it expected to be there?
I can try an empty database and let you know the result.
For machine login, I'm afraid it will be agains Lucent
Security policy. Maybe we can try to open a Netmeeting
session and share the desktop to s
