On Wednesday 27 November 2002 06:23, Tom Lane wrote:
(B> Ian Barwick <[EMAIL PROTECTED]> writes:
(B> > in 7.3 the following no longer works:
(B> > template1=> select 0::bool;
(B> > ERROR: Cannot cast type integer to boolean
(B>
(B> Note that both old and new versions reject
(B> se
On 26 Nov 2002 at 21:54, Matthew T. O'Connor wrote:
> First: Do we want AVD integrated into the main source tree, or should it
> remain a "tool" that can be downloaded from gborg. I would think it
> should be controlled by the postmaster, and configured from GUC (at
> least basic on off settings)
On Tue, 26 Nov 2002, Stephan Szabo wrote:
> Well, it depends. SQL updatable views are fairly limited from what I
> remember and the general write your own update rules is much broader, so I
> doubt anyone got terribly excited by doing the limited version. It would
> take some work to define what
Ian Barwick <[EMAIL PROTECTED]> writes:
> in 7.3 the following no longer works:
> template1=> select 0::bool;
> ERROR: Cannot cast type integer to boolean
Note that both old and new versions reject
select 0::int4::bool;
I believe the behavioral change is a consequence of Rod Taylor's
I have worked on several gborg projects migrated from our CVS tree, and
all but one have new packaged releases, ready for 7.3:
libpq++
pgeasy
pgperl
I am working with David Wheeler on DBD:pg and hope to have a release
packaged up tomorrow.
--
Bruce Momjian
"Curtis Faith" <[EMAIL PROTECTED]> writes:
> tom lane wrote:
>> Sure, it's just shuffling the housekeeping work from one place to
>> another. The thing that I like about Postgres' approach is that we
>> put the housekeeping in a background task (VACUUM) rather than in the
>> critical path of foreg
Several months ago tried to implement a special postgres backend as an
Auto Vacuum Daemon (AVD), somewhat like the stats collector. I failed
due to my lack of experience with the postgres source.
On Sep 23, Shridhar Daithankar released an AVD written in C++ that acted
as a client program rather
I am the maintainer and lead developer for Bricolage, an
enterprise-class open-source content management system built on a
PostgreSQL database. The Bricolage developers really look forward to
7.3's new features, which, like every release of PostgreSQL, set a new
standard against which other dat
On Wed, 27 Nov 2002, XiaojingLi wrote:
> I'd like to bother you with something about updating views. At
> present, postgresql7.3¡¡doesn't support update on views.When I look up
It does if you provide the rules for what it means to do the update (and
there are some wierd issues with delete,
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> I am thinking it would be useful for debugging if elog(PANIC) were to
>> exit by calling abort() so that a core dump would be produced.
> But is this appropriate?
> PANIC: The database cluster was initialized with CATALOG_VERSION
Hi!
I'd like to bother you with something about updating views. At present,
postgresql7.3¡¡doesn't support update on views.When I look up the source code, I see
that view is implemented with rules. That is when a view is created, a corresponding
¡®select'¡¡rule is created too. A
On Tuesday 26 November 2002 09:05 pm, Hannu Krosing wrote:
> Reinoud van Leeuwen kirjutas K, 20.11.2002 kell 17:03:
> > Hi,
> >
> > Is there any reason why the grolist field in the table pg_group is
> > implemented as an array and not as a separate table?
>
> most likely for performance reasons.
>
I have been looking at contrib/ltree in the PostgreSQL repository. I've
modified the code to allow / as a node delimiter instead of . which is the
default.
Below are the patches to make this change. I have also moved the
delimiter to a DEFINE so that other customizations are easily done. This
i
Hi Lisa,
I'm the Lead Programmer for a company that specialises in online weight loss
programs in Australia and the USA.
We started off using MySQL but turned to PostgreSQL when it became obvious
that MySQL lacked many necessary features required for a maximum power and
data integrity.
We have f
A quick question:
in 7.3 the following no longer works:
template1=> select 0::bool;
ERROR: Cannot cast type integer to boolean
The statement must be rewritten as this:
template1=> select '0'::bool;
bool
--
f
(1 row)
Is there a reason for this?
I ask because the former qu
Insisting on Andreas suggestion, why can't we just prefix all error message
strings with the SQLState code? So all error messages would have the format
CCSSS -
Where CCSSS is the standard SQLState code and the message text is a more
spe
I just spoke with Lisa Vaas from eWeek. She is writing an article on
the upcoming PostgreSQL 7.3 release. (The release of 7.3 is scheduled
for tomorrow.)
She would like comments from users about the upcoming 7.3 features,
listed at:
http://developer.postgresql.org/docs/postgres/release.
> > Merlin Moncure kirjutas T, 26.11.2002 kell 08:00:
> > > I was playing with the Japanese win32 7.2.1 port and I noticed that
"select
> > > 0 / 0" caused the server to crash and restart. I understand that it
is a
> > > totally unsupported version, but it should be easy enough to check vs.
the
>
> Merlin Moncure kirjutas T, 26.11.2002 kell 08:00:
> > I was playing with the Japanese win32 7.2.1 port and I noticed that
"select
> > 0 / 0" caused the server to crash and restart. I understand that it is
a
> > totally unsupported version, but it should be easy enough to check vs.
the
> > curre
On 27 Nov 2002, Hannu Krosing wrote:
> scott.marlowe kirjutas K, 27.11.2002 kell 01:40:
> > On 27 Nov 2002, Hannu Krosing wrote:
> >
> > > You could try out VMWare and run a linux virtual machine under Windows,
> > > You could set it up once with all necessary servers and then copy the
> > > files
On 27 Nov 2002, Hannu Krosing wrote:
> Merlin Moncure kirjutas T, 26.11.2002 kell 08:00:
> > I was playing with the Japanese win32 7.2.1 port and I noticed that "select
> > 0 / 0" caused the server to crash and restart. I understand that it is a
> > totally unsupported version, but it should be e
I have rebuild HISTORY to add recent release.sgml changes, and have
stamped configure/configure.in for 7.3.
Marc, if you can, please create the 7.3 tarball tonight so the mirrors
will be ready tomorrow. Thanks.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTEC
Merlin Moncure kirjutas T, 26.11.2002 kell 08:00:
> I was playing with the Japanese win32 7.2.1 port and I noticed that "select
> 0 / 0" caused the server to crash and restart. I understand that it is a
> totally unsupported version, but it should be easy enough to check vs. the
> current version.
On Tue, 26 Nov 2002, bpalmer wrote:
> > > D'Arcy,
> > >
> > > In production the database servers are seperate multi-processor machines
> > > with mirrored disks linked via Gigabit ethernet to the app server.
> > >
> > > In development I have people extremely familiar with MS, but not very hot
> >
scott.marlowe kirjutas K, 27.11.2002 kell 01:40:
> On 27 Nov 2002, Hannu Krosing wrote:
>
> > You could try out VMWare and run a linux virtual machine under Windows,
> > You could set it up once with all necessary servers and then copy the
> > files to each new developers machine.
> >
> > VMWare i
Reinoud van Leeuwen kirjutas K, 20.11.2002 kell 17:03:
> Hi,
>
> Is there any reason why the grolist field in the table pg_group is
> implemented as an array and not as a separate table?
most likely for performance reasons.
> According to the documentation:
>
>
> Arrays are not sets; using ar
Evgen Potemkin kirjutas R, 22.11.2002 kell 15:57:
> Hi there!
>
> Patch is posted to pgsql-patches. docs inside.
It would of course be nice to support both Oracle and ISO/ANSI syntaxes,
but I'm afraid that the (+) may clash with our overloadable operators
feature.
> SQL 99 version will be later.
On 27 Nov 2002, Hannu Krosing wrote:
> Al Sutton kirjutas T, 26.11.2002 kell 20:37:
> > D'Arcy,
> >
> > In production the database servers are seperate multi-processor machines
> > with mirrored disks linked via Gigabit ethernet to the app server.
> >
> > In development I have people extremely f
> > D'Arcy,
> >
> > In production the database servers are seperate multi-processor machines
> > with mirrored disks linked via Gigabit ethernet to the app server.
> >
> > In development I have people extremely familiar with MS, but not very hot
> > with Unix in any flavour, who are developing Java
Al Sutton kirjutas T, 26.11.2002 kell 20:37:
> D'Arcy,
>
> In production the database servers are seperate multi-processor machines
> with mirrored disks linked via Gigabit ethernet to the app server.
>
> In development I have people extremely familiar with MS, but not very hot
> with Unix in any
On Tuesday 26 November 2002 18:42, Peter Eisentraut wrote:
> Zdravo,
>
> Darko Prenosil writes:
> > When I install, .mo file is copied to:
> > /usr/local/pgsql/share/locale/hr_HR/LC_MESSAGES/postgres.mo (RedHat).
> > In postgresql.conf is already line that looks like this:
> > LC_MESSAGES = 'hr
Good ideas. I think the master solution is to hook the statistics
daemon information into an automatic vacuum that could _know_ which
tables need attention.
---
Curtis Faith wrote:
> tom lane wrote:
> > Sure, it's just shuf
I am told by PeerDirect that they will release the Win32 source as a
patch against current CVS by the end of December. At that point, we
will make adjustments then apply the patch and start making any other
changes required.
I don't think there is much we can do until they supply that patch. I
> Site note: good strategic positioning in this regard would be an XML shell
> for postgres (pgxml) and a data provider for .net.
Just so you know, there is already a .NET provider for PostgreSQL. You can
find it on:
http://gborg.postgresql.org/
Chris
---(end of broadca
SuSE 7..3 (2.4.10-4GB)
Compiles and passes regression fine:
All 89 tests passed.
Installing to dev server next.
Cheers,
Steve
On Monday 25 November 2002 8:19 am, you wrote:
> Morning all ...
>
>On Sunday this weekend, we packaged up PostgreSQL v7.3rc2 for testing
> ... this release, if a
[EMAIL PROTECTED] ("scott.marlowe") wrote in message
news:<[EMAIL PROTECTED]>...
> On 21 Nov 2002, Rod Taylor wrote:
>
> > On Thu, 2002-11-21 at 15:09, scott.marlowe wrote:
> > > On 21 Nov 2002, Rod Taylor wrote:
> > >
> > > > On Thu, 2002-11-21 at 14:11, Bruce Momjian wrote:
> > > > > Of course
Al Sutton wrote:
> Lee,
>
> I wouldn't go for 7.4 in production until after it's gone gold, but being
> able to cut the number of boxes per developer by giving them a Win32 native
> version would save on everything from the overhead of getting the developers
> familiar enough with Linux to be able
Tom Lane writes:
> I am thinking it would be useful for debugging if elog(PANIC) were to
> exit by calling abort() so that a core dump would be produced.
>
> Going out via proc_exit(), as it now does, seems like a bad idea in any
> case, since that will try to do a bunch of cleanup activity that's
Zdravo,
Darko Prenosil writes:
> When I install, .mo file is copied to:
> /usr/local/pgsql/share/locale/hr_HR/LC_MESSAGES/postgres.mo (RedHat).
> In postgresql.conf is already line that looks like this:
> LC_MESSAGES = 'hr_HR'.
>
> So why I do not see the translated messages ?
Hard to tell
Dave Page wrote:
>
>
> > -Original Message-
> > From: Merlin Moncure [mailto:[EMAIL PROTECTED]]
> > Sent: 22 November 2002 21:25
> > To: [EMAIL PROTECTED]
> > Subject: [HACKERS] PostGres and WIN32, a plea!
> >
> >
> > I had read on one of the newsgroups that there is a planned
> > nat
Here is a good article on linking/loading:
http://www.linuxjournal.com/article.php?sid=6463
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can b
On Tue, 26 Nov 2002, Al Sutton wrote:
> D'Arcy,
>
> In production the database servers are seperate multi-processor machines
> with mirrored disks linked via Gigabit ethernet to the app server.
>
> In development I have people extremely familiar with MS, but not very hot
> with Unix in any flavo
On Tue, 26 Nov 2002, Justin Clift wrote:
> Dear Clift,
>
> > As a side thought, would you please be able to correct the spelling of
> PostgreSQL on the same page. Presently it's spelt "PostGreSQL", which
> is
> incorrect.
>
> Better way, i'v remove postgresql name in the site, as i think you wa
> -Original Message-
> From: Merlin Moncure [mailto:[EMAIL PROTECTED]]
> Sent: 22 November 2002 21:25
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] PostGres and WIN32, a plea!
>
>
> I had read on one of the newsgroups that there is a planned
> native port to the win32 platform, is this
D'Arcy,
In production the database servers are seperate multi-processor machines
with mirrored disks linked via Gigabit ethernet to the app server.
In development I have people extremely familiar with MS, but not very hot
with Unix in any flavour, who are developing Java and PHP code which is the
tom lane wrote:
> Sure, it's just shuffling the housekeeping work from one place to
> another. The thing that I like about Postgres' approach is that we
> put the housekeeping in a background task (VACUUM) rather than in the
> critical path of foreground transaction commit.
Thinking with my marke
On Tuesday, November 26, 2002, at 07:12 AM, Neil Conway wrote:
Looks like a problem on your end...
Oh, the message finally got through, did it? I chatted with Bruce
yesterday and ran the tests again and they all passed.
Thanks,
David
--
David Wheeler AIM
David Wheeler <[EMAIL PROTECTED]> writes:
> COPY onek FROM
>'/usr/local/src/postgresql-7.3rc2/src/test/regress/results/onek.data';
> + ERROR: COPY command, running in backend with effective uid 77, could not open
>file '/usr/local/src/postgresql-7.3rc2/src/test/regress/results/onek.data' for
> > I think it's great - but don't quote me on that. :)
> >
>
> PostgreSQL. Because life's too short to learn Oracle.
PostgreSQL. For those with more to do than babysit a database.
--
Rod Taylor <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP
>I was playing with the Japanese win32 7.2.1 port and I noticed that "select
>0 / 0" caused the server to crash and restart. I understand that it is a
>totally unsupported version, but it should be easy enough to check vs. the
>current version. Note that select 0.0/0.0 worked fine!
Seems to work
At 1:51 PM -0500 11/20/02, Tom Lane wrote:
Patrick Welche <[EMAIL PROTECTED]> writes:
On Wed, Nov 20, 2002 at 01:21:47PM -0500, Tom Lane wrote:
Ah-hah, so it is a version issue --- we could make the resultmap line
something like
geometry/.*-netbsd1.[0-5]=geometry-positive-zeros
NetBSD/i3
Hi,
Is there any reason why the grolist field in the table pg_group is
implemented as an array and not as a separate table?
According to the documentation:
Arrays are not sets; using arrays in the manner described in the previous
paragraph is often a sign of database misdesign.
I have troub
system = powerpc-ibm-aix4.2.1.0
configure command
env CC=gcc ./configure --with-maxbackends=1024 --with-openssl=/usr/local/ssl
--enable-syslog --enable-odbc --disable-nls
gmake check output file
regression.out
--
parallel group (13 tests): text varchar oid int2 char boolean
regression.diffs
Description: Binary data
regression.out
Description: Binary data
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
I had read on one of the newsgroups that there is a planned native port to
the win32 platform, is this true? I read most of the win32 thread off of
the dev site and it was not clear if this was true.
In either case, I would like to advocate such a port to be done, and soon,
not for any altruistic
[EMAIL PROTECTED] ("Nigel J. Andrews") writes:
> On Tue, 19 Nov 2002, Josh Berkus wrote:
>
> > Folks,
> >
> > We need a quote from a major code contributor to PostgreSQL about the
> > upcoming 7.3 release -- something about how great the new release is,
> > or some of the features in the release
I was playing with the Japanese win32 7.2.1 port and I noticed that "select
0 / 0" caused the server to crash and restart. I understand that it is a
totally unsupported version, but it should be easy enough to check vs. the
current version. Note that select 0.0/0.0 worked fine!
Merlin
--
At 1:15 AM -0500 11/20/02, Tom Lane wrote:
Bruce Momjian <[EMAIL PROTECTED]> writes:
Tom, can you clarify why -0 is valid.
The IEEE spec absolutely thinks that -0 and +0 are distinct entities.
I don't remember why, at one in the morning ... but if you insist I'm
sure that plenty sufficient num
I’m a new comer of PostgreSQL, could anyone tell
me can I view the content of logs( updating a tuple, etc.) ? And if I can, how
to do it?
Thx!
Hi there!
Patch is posted to pgsql-patches. docs inside.
SQL 99 version will be later.
regards,
---
.evgen
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Problem still exists in RC2
[EMAIL PROTECTED] (Samuel A Horwitz)
-- Forwarded message --
Date: Mon, 25 Nov 2002 09:12:55 -0500 (EST)
From: Samuel A Horwitz <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] RC1? AIX 4.2.1.0 (fwd)
Sorry forgot to include that I had
On November 26, 2002 06:33 am, Al Sutton wrote:
> I wouldn't go for 7.4 in production until after it's gone gold, but being
> able to cut the number of boxes per developer by giving them a Win32 native
> version would save on everything from the overhead of getting the
> developers familiar enough
Lee,
I wouldn't go for 7.4 in production until after it's gone gold, but being
able to cut the number of boxes per developer by giving them a Win32 native
version would save on everything from the overhead of getting the developers
familiar enough with Linux to be able to admin their own systems,
FWIW, a search on Google gives some hits for the name on the lists this
year.
First impressions are that it's not Sir Mondred (or whatever the spelling was).
On Tue, 26 Nov 2002, Justin Clift wrote:
> Hi Chris,
>
> Just received this from them. Look like he was trying to claim stuff
> that
Hi Chris,
Just received this from them. Look like he was trying to claim stuff
that wasn't true.
:-/
Thanks for pointing this out Chris. :)
Regards and best wishes,
Justin Clift
***
Original Message
Subject: Re: Demande de renseignements Defi SYSDOOR
Date: Tue, 2
Bruce,
you're right, i'm asking about the sources because I want to help.
Is it possible to help in this case or not?
Ulrich
>>> Bruce Momjian <[EMAIL PROTECTED]> 25.11.2002 18:51:39 >>>
Ulrich Neumann wrote:
> Hello,
>
> i've read that there are 2 different native ports for Windows
> somewher
Al, to be honest I don't think the Windows native would save hassle,
rather it'd probably cause more! No disrespect to those doing the
version, read on for reasoning...
Yes, you get a beta of a Windows native version just now, yes it
probably will not be that long till the source is a available...
Is there a rough date for when they'll be available?
I have a development team at work who currently have an M$-Windows box and a
Linux box each in order to allow them to read M$-Office documents sent to us
and develop against PostgreSQL (which we use in production).
I know I could have a shared
68 matches
Mail list logo
