the extensions only in the databases where she/he wants to.
(C) It would be nice to have a table containing information about the extensions
currently installed .
Cheers,
Adrian Maier
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
rk quite well.
Oh, you are right Michael. I've missed the second interpretation of Pedro's
words. My apologises if I got it wrong ...
--
Adrian Maier
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
tself.
Cheers,
Adrian Maier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 8/10/07, Decibel! <[EMAIL PROTECTED]> wrote:
> On Fri, Aug 10, 2007 at 08:08:55AM +0300, Adrian Maier wrote:
> > So it looks like this is simply a known issue that hasn't been backpatched.
> > I'll simply use 8.2 .
>
> Ok, I'll bite... if you can use 8
On 8/10/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Decibel! <[EMAIL PROTECTED]> writes:
> > On Thu, Aug 09, 2007 at 11:46:47AM -0400, Tom Lane wrote:
> >> "Adrian Maier" <[EMAIL PROTECTED]> writes:
> >>> I have just tried to compile postgre
an/postgresql-7.4.17/src'
make: *** [all] Error 2
This doesn't happen in HEAD.
$ uname -a
HP-UX hpdev B.11.11 U 9000/800 822196241 unlimited-user license
$ gcc --version
gcc (GCC) 3.3.3
Cheers,
Adrian Maier
---(end of broadcast)---
get the sources from my machine.
But I am not sure whether the results could be reported back to the buildfarm.
Cheers,
Adrian Maier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
some writeln's right before the PQexec calls .
It would have been much more convenient to see the bad queries in
the logs ...
--
Adrian Maier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
oblem.
The FAQ_CYGWIN suggests that modifying the cygserver config may be
neccessary, but it doesn't provide more details.
Does anyone have any advice ?
Cheers,
Adrian Maier
$ gdb bin/initdb.exe
(gdb) break main
Breakpoint 1 at 0x403200: file initdb.c, line 2358.
(gdb) run
Starti
On 9/11/06, Jeremy Drake <[EMAIL PROTECTED]> wrote:
On Mon, 11 Sep 2006, Adrian Maier wrote:
> It's not clear to me where does that date-in-the-future come from.
> The machine's
> date is set correctly:
> $ date
> Mon Sep 11 11:00:30 PST 2006
Um, no. I am curr
tly:
$ date
Mon Sep 11 11:00:30 PST 2006
Any ideas about what might cause this?
--
Adrian Maier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
eatures that
MySQL had for a long time" a MySql guy would say.
I have the same feeling about the term "usability". It could
be interpreted like : PostgreSQL was not usable until now.
Best wishes,
Adrian Maier
---(end of broadcast)---
TIP 6: explain analyze is your friend
reasonable.
You're right. I had forgotten to do a cvs update. Fixed and committed.
The cassowary farm member went green, for the first time in history :)
Thanks guys,
Adrian Maier
---(end of broadcast)---
TIP 9: In versions below 8.0,
t underflow after version so-and-so". Do they
publish a detailed change log?
There are links to the last few releases on their home page
http://www.cygwin.com , in the News section.
--
Adrian Maier
---(end of broadcast)---
TIP 1: if posting/readi
On 01/08/06, Andrew Dunstan <[EMAIL PROTECTED]> wrote:
Adrian Maier wrote:
> On 20/07/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> Apparently the regression test is comparing the results/float8.out
> with expected/float8-small-is-zero.out because of the following line
&g
the modification ok?
I've attached the patch, and cc'ed to pgsql-patches.
Cheers,
Adrian Maier
patch_float8.diff
Description: Binary data
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
cygwin and netbsd 3.0rc5):
$ ./test-strtod.exe
double: -inf, errno: 34, tail: '', isinf: 1, fabs: inf,inf>max: 1
Cheers,
Adrian Maier
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
l-behaved ones
DELETE FROM FLOAT8_TBL;
=
This happening on cygwin 1.5.20 (running on top of winXP), gcc 3.4.4.
The entire check.log can be found here :
http://www.newsoftcontrol.ro/~am/pgfarm/check.log
The other logs generated by the buildfarm can be found here:
http://www.newsoftcontrol.ro/~am/pgfarm/
Cheers,
Adrian Maier
---(end of broadcast)---
TIP 6: explain analyze is your friend
lent.
Hello,
I'll try to set up a buildfarm installation for Cygwin on my computer at work.
But I'm taking the next week off, so this will have to wait until my return.
Cheers,
Adrian Maier
---(end of broadcast)---
TIP 6: explain analyze is your friend
ions - but these
names seem to be just labels ) - is this true ?
Best wishes,
Adrian Maier
-- Forwarded message --
From: Michael Van Canneyt <[EMAIL PROTECTED]>
Subject: Re: [lazarus] FPC question
To: lazarus@miraclec.com
On Wed, 19 Apr 2006, Adrian Maier wrote:
> On 4/1
t to_timestamp(' 0300','mmdd hh24mi') from dual;
select to_timestamp(' 0300','mmdd hh24mi') from dual
*
ERROR at line 1:
ORA-01843: not a valid month
Cheers,
Adrian Maier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
gt; me? So if there is auto-created password for this auto-created postgres
> user, please anyone tell me what it is??
You could try to change the ident method to trust (in pg_hba.conf). This
should allow you to login.
Then, set the password of the postgres user (alter user postgres with pas
the following details..
>
> 1) Test suits that i could get to test my code..
> 2) How can I put back my fix into postgres src code.. (or) What is the
> procedure that I should follow at this stage??
You might find the following document useful:
http://www.postgresql.org/docs/faqs.FA
oaded only 2 files (bundles)
MinGW-?.?.?.exe and MSYS-?.?.?.exe.
Adrian Maier
Thanx,
Gevik.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hi,
PostgreSql 8.1 RC1 ( --with-perl --with-python) passed all tests on
Slackware Linux 10.2 (kernel 2.4.31, x86)
Regards,
Adrian Maier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
in year 100.
There was no year 0 ...
Also, the 2nd millenium started in 2001, not in 2000 :
http://staff-www.uni-marburg.de/~schittek/millenni.htm )
Best wishes,
Adrian Maier
Best regards
Pavel Stehule
_
Chcete sdilet sve
installation time, it would be less
important which is the default value because i think that the users
who install PostgreSQL from sources on Win32 are fewer.
And we can expect that, after bothering to install mingw and compile
PostgreSQL, they will also bother to configure it according to
their
-- Forwarded message --
From: Adrian Maier <[EMAIL PROTECTED]>
Date: May 10, 2005 12:01 PM
Subject: Re: [HACKERS] Oracle Style packages on postgres
To: "Jim C. Nasby" <[EMAIL PROTECTED]>
On 5/9/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> On Sun, M
ting contrib
directory to a system similar to the BSD ports collection ?
One would type:
cd postgresql-8.1.0/contrib/pls/pljava
make install
( which would download the pljava sources from pgfoundry,
build it and install )
With such a system in place, various modules could be installed
in a u
with: rpm -e
Regards,
Adrian Maier
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
oring the database files.
1. Mount your filesystem to a directory, e.g /mnt/mem_drive
(possibly : mount -t mmfs /dev/mmfs /mnt/mem_drive)
2. export PG_DATA=/mnt/mem_drive
3. initdb
4. pg_ctl start
I hope this helps.
Adrian Maier
> I want to know, how to plug it with Pos
pcoming press
release, too. I don't plan to translate the po files, so
you are certainly welcome to work on them.
If you happen to be unsure about translating some of the
phrases and you want someone else's opinion, please
do not hesitate to contact me.
Cheers,
Adrian Maie
Hello,
On the production server I have PostgreSql 7.4.3 , on Mandrake Linux 9.2.
In the message log on 29 july I have received several "shared buffer
hash table
corrupted" errors .
What could cause this error ? (bad RAM maybe?)
Best wishes,
Adrian Maier
nc enabled), and a second one that contains the less
important data (configured with fsync=off for speed reasons).
Cheers,
Adrian Maier
([EMAIL PROTECTED])
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an approp
34 matches
Mail list logo
