All tests pass on FreeBSD/Alpha.
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Magnus
> Naeslund(f)
> Sent: Thursday, 30 January 2003 2:13 PM
> To: Marc G. Fournier; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] v7.2.4 bundled ...
>
>
> Redh
Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > Updated to tag REL7_2_4 on FreeBSD 4.7 and cannot compile it. gram.y
> > errors complaining: invalid character: ','.
>
> > bash-2.05b$ bison --version
> > bison (GNU Bison) 1.75
>
> We just had that discussion on pgcore. The 7.2 gramm
Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > Updated to tag REL7_2_4 on FreeBSD 4.7 and cannot compile it. gram.y
> > errors complaining: invalid character: ','.
>
> > bash-2.05b$ bison --version
> > bison (GNU Bison) 1.75
>
> We just had that discussion on pgcore. The 7.2 gramm
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Where do I get it from?
> I can't see it on any of the FTP sites...
Not all the mirrors have updated yet, but I see it at
ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/source/v7.2.4/
for one ...
regards, tom lan
Redhat 6.2
Linux gserver1 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002 alpha
unknown
All 79 tests passed.
Magnus
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Maybe we should create a new type 'inet6'???
I'd lean towards allowing the existing inet and cidr types to store both
v4 and v6 addresses, if at all possible. Is there a good motivation for
doing otherwise?
regards,
> Yeah. This is a pretty self-contained problem, it just needs someone
> who's motivated to work on it. Mostly what we need is to understand how
> we want to extend the previously-agreed-to I/O behaviors for IPv4 inet
> and cidr types into the v6 domain. (Or should we back up and ask if the
> in
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Linux.conf.au Report
> [ much snipped ]
> * IPV6 data types
> - Apparently there are some ISPs in some countries that have started to bill
> people for IPV6 bandwidth, and the lack of IPV6 address types is hurting
> them.
Yeah. This is a pr
Tom Lane wrote:
> "Curtis Faith" <[EMAIL PROTECTED]> writes:
> > If a developer can simply download the source, click on the Visual C++
> > project in the win32 directory and then build PostgreSQL, and they can
> > see that Windows is not the "poor stepchild" because the VC project is
> > well laid
Where do I get it from?
I can't see it on any of the FTP sites...
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Marc G. Fournier
> Sent: Thursday, 30 January 2003 10:00 AM
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] v7.2.4 bundled ...
>
>
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> I jsut bundled up v7.2.4 with all the recent security fixes ... can a
> few ppl do some regression tests and report back before I announce in the
> morning? I did a configure and build here and all looks fine, but some
> confirmations is always ni
Rod Taylor <[EMAIL PROTECTED]> writes:
> Updated to tag REL7_2_4 on FreeBSD 4.7 and cannot compile it. gram.y
> errors complaining: invalid character: ','.
> bash-2.05b$ bison --version
> bison (GNU Bison) 1.75
We just had that discussion on pgcore. The 7.2 grammar was developed
against bison 1
Cool irony in the automated .sig on the mailinglist software...
On Wed, 29 Jan 2003, Vince Vielhaber wrote:
> ...
> hammering the betas is a far cry from an "industrial-strength solution".
> ...
> TIP 4: Don't 'kill -9' the postmaster
Sounds like you're basically saying is
_do_ 'kill -9' t
Christopher Kings-Lynne wrote:
We found out all sorts of interesting places that PostgreSQL is being used:
a large Australian Telco, several restaurants in the Perth area, the Debian
inventory system and the Katie revision control system. It is also being
evaluated for process control analysis a
> I jsut bundled up v7.2.4 with all the recent security fixes ... can a
> few ppl do some regression tests and report back before I announce in the
> morning? I did a configure and build here and all looks fine, but some
> confirmations is always nice ;)
Updated to tag REL7_2_4 on FreeBSD 4.7 a
On Wed, 2003-01-29 at 21:49, Christopher Kings-Lynne wrote:
> * IPV6 data types
Looks like this will be in 7.4, in one form or another.
> - The standard table modification tactic (that I also use) or renaming table
> to *_old and creating new one breaks because the primary key of the new
> table
Linux.conf.au Report
The Linux.conf.au is an international Linux/Open Source event that attracts
lots of international speakers. Total conf attendance was around 360, maybe
even 400 I think.
Gavin Sherry was speaking at this particular conf, and I attended as a
hobbyist.
Po
Morning all ...
I jsut bundled up v7.2.4 with all the recent security fixes ... can a
few ppl do some regression tests and report back before I announce in the
morning? I did a configure and build here and all looks fine, but some
confirmations is always nice ;)
---(
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > + /* Flag to we need to initialize client encoding info */
> > + static bool need_to_init_client_encoding = -1;
>
> Surely that should be int, not bool.
Oops. Will fix.
> > ! if (!PQsendQuery(conn, "begin; select
>
Justin Clift wrote:
> For another perspective, we've been getting a few requests per day
> through the PostgreSQL Advocacy and Marketing site's request form along
> the lines of:
>
> "Is there a license fee for using PostgreSQL? We'd like to distribute
> it with our XYZ product that needs a da
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Tom Lane kirjutas K, 29.01.2003 kell 17:58:
>> It'll be looked at; whether it will be done in time for 7.4 is anyone's guess.
> Is anyone actually working on it ?
I don't think any significant work has been done yet. If you wanted to
update your existi
Tom Lane kirjutas K, 29.01.2003 kell 17:58:
> "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> > What was the result of the recursive unions thread? I remember Tom maybe
> > saying that the Redhat guys like the DB2 (SQL99) syntax the best, however
> > was it said that that was going to be d
> -Original Message-
> From: Jan Wieck [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 11:47 AM
> To: Peter Eisentraut
> Cc: Justin Clift; Hannu Krosing; Bruce Momjian; Tom Lane;
> Postgres development
> Subject: Re: [HACKERS] Win32 port patches submitted
>
>
> Peter Eise
Peter Eisentraut wrote:
>
> Justin Clift writes:
>
> > The advantages to having the Win32 port be natively compatible with
> > Visual Studio is that it already is (no toolset-porting work needed
> > there),
>
> You're missing a couple of points here. First, the MS Visual whatever
> compiler can
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Bruce Momjian writes:
>> I now realize panic isn't really off, but I don't expect panic to happen
>> too often. :-)
> Just add a level past panic that actually says "off" and really is off.
Would anyone actually use it? *Should* anyone actually use
Actually, I originally sent that message a week ago, and it got posted then
and again now. Not sure exactly why it was repeated... in any case, the
work I was planning on doing is pretty much done; I want to do some more
testing and refinement to handle performance issues, and I can post a patch.
Vince Vielhaber wrote:
So you've been running these unscientific tests you're telling us
about being so successful for "some months"?
Vince.
I open my mouth and insert foot: Where do I get any of these scientific
tests to determine if the latest and greatest 7.3.x will not fall down on my
fa
Bruce Momjian writes:
> I now realize panic isn't really off, but I don't expect panic to happen
> too often. :-)
Just add a level past panic that actually says "off" and really is off.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)-
James Hubbard wrote:
I open my mouth and insert foot: Where do I get any of these scientific
tests to determine if the latest and greatest 7.3.x will not fall down
on my favorite Unix?
For Open Source benchmarks, there is:
Open Source Database Benchmark:
http://osdb.sf.net
With this, you *w
On Wed, 29 Jan 2003, James Hubbard wrote:
> Vince Vielhaber wrote:
> > On Wed, 29 Jan 2003, Dave Page wrote:
> >
> >
> >>>The code's been available for what a week or two? Do you
> >>>actually think that can be considered conclusive by any standard?
> >>
> >>Public beta testing (but closed source
*sigh*
Often there isn't a choice of OS. If I am selling to a large enterprise
whose corporate standards say they will only run Windows in their data
center, my chances of getting them to make an exception are none. But my
chances of getting them to install Pg just for my application are far
great
Dave Cramer writes:
> The method in question is
> ResultSetMetaDate.getTableName(int column)
> and while were at it
> ResultSetMetaData.getSchemaName(int column)
> and FWIW, the return value if not applicable is ""
Not applicable sounds fine to me. It's like taking a file descriptor and
asking w
Tom Lane writes:
> I think a reasonable choice in cross-compiling situations would be to
> assume int64 works if we have a long long int datatype, but to force use
> of our own snprintf rather than trusting to luck with the platform's.
That's approximately what's happening. Formerly it insisted
Katie Ward wrote:
The latest build is still: ftp://209.61.187.152/postgres/postgres_beta4.zip
This is not exactly what Jan submitted, and the catalog number is slightly
different, but it should do for testing.
In case anyone's interested, there are step by step installation
instructions for it
Vince Vielhaber wrote:
On Wed, 29 Jan 2003, Dave Page wrote:
The code's been available for what a week or two? Do you
actually think that can be considered conclusive by any standard?
Public beta testing (but closed source) has been going on for some
months.
So you've been running these u
Curtis Faith wrote:
> If people are deciding what open-source database server they want to
use, Linux or FreeBSD is the obvious choice for the server OS. The kind
of people who are inclined to use PostgreSQL or MySQL will mostly NOT be
considering Windows servers.
For another perspective, we've
The latest build is still: ftp://209.61.187.152/postgres/postgres_beta4.zip
This is not exactly what Jan submitted, and the catalog number is slightly
different, but it should do for testing.
Katie
> -Original Message-
> From: Dave Page [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, Janu
On Wed, 29 Jan 2003, Dave Page wrote:
>
>
> > -Original Message-
> > From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
> > Sent: 29 January 2003 17:10
> > To: Dave Page
> > Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED]
> > Subject: RE: [mail] Re: [HACKERS] Windows Build System
>
On Wed, 29 Jan 2003, Katie Ward wrote:
> > On Wed, 29 Jan 2003, Katie Ward wrote:
> >
> > > > On Wed, 29 Jan 2003, Dave Page wrote:
> > > >
> > > > > > hammering the betas is a far cry from an "industrial-strength
> > > > > > solution".
> > > > >
> > > > > Have you a better suggestion? Seems a bit
> -Original Message-
> From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 17:13
> To: Dave Page
> Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED]
> Subject: RE: [mail] Re: [HACKERS] Windows Build System
>
>
> On Wed, 29 Jan 2003, Dave Page wrote:
>
> >
> -Original Message-
> From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 17:10
> To: Dave Page
> Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED]
> Subject: RE: [mail] Re: [HACKERS] Windows Build System
>
>
> On Wed, 29 Jan 2003, Dave Page wrote:
>
> >
On Wed, 29 Jan 2003, Dave Page wrote:
> > The code's been available for what a week or two? Do you
> > actually think that can be considered conclusive by any standard?
>
> Public beta testing (but closed source) has been going on for some
> months.
So you've been running these unscientific test
"Dave Page" <[EMAIL PROTECTED]> writes:
>> Aside from load testing as suggested by Vince, I'd be
>> interested to hear what happens when you pull the power cord
>> under load (repeatedly). This would give some evidence about
>> the robustness of the Windows filesystem and its ability to
>> emu
On Wed, 29 Jan 2003, Dave Page wrote:
> I would be interested to know how many windows servers those that are
> against a windows port of PostgreSQL have or do manage, and how
> experienced they are with that platform...
At this point I'm not for or against. But you're going to have to do
more t
Chris,
It's already being done, you should post this to the jdbc list.
Dave
On Fri, 2003-01-24 at 11:07, Chris Smith wrote:
> I'm about to start implemention streaming of queries to the server in the
> pgsql jdbc drivers when PreparedStatement is used with setBinaryStream...
> but before I get st
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 16:57
> To: Dave Page
> Cc: Vince Vielhaber; Katie Ward; Curtis Faith;
> [EMAIL PROTECTED]
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
>
> "Dave Page" <[EMAIL PROTECTED]> writes:
>
> -Original Message-
> From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 16:57
> To: Katie Ward
> Cc: Dave Page; Tom Lane; Curtis Faith; [EMAIL PROTECTED]
> Subject: RE: [mail] Re: [HACKERS] Windows Build System
>
>
> The code's been available for what a week or
> -Original Message-
> From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 16:45
> To: Dave Page
> Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED]
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
>
> On Wed, 29 Jan 2003, Dave Page wrote:
>
> >
"Dave Page" <[EMAIL PROTECTED]> writes:
> I'll admit my methods were not particularly scientific, but over the
> last few weeks I've had far more grief from DB2 and SQL Server than I
> did from the PostgreSQL native betas.
My gripe had to do with questioning the reliability of the platform, not
of
On Wed, 29 Jan 2003, Katie Ward wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Vince Vielhaber
> > Sent: Wednesday, January 29, 2003 11:45 AM
> > To: Dave Page
> > Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED]
> > Subject: R
tom lane wrote:
>
> In all honesty, I do not *want* Windows people to think that
> they're not running on the "poor stepchild" platform.
We should distinguish between "poor stepchild" from a client support
perspective and a production environment perspective.
What is the downside to supporting d
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Wed, 29 Jan 2003, Curt Sampson wrote:
>> ...produces rows with nulls in them.
> That's a bug in pl/pgsql I believe.
Or a bug in the domain-constraints implementation. plpgsql just
executes the input function for the datatype --- which is the same as
On Wed, 29 Jan 2003, Dave Page wrote:
> > hammering the betas is a far cry from an "industrial-strength
> > solution".
>
> Have you a better suggestion? Seems a bit catch 22 if testing won't
> prove it's good and we can't use it until we know it's good... Still,
> industrial strength testing or no
> -Original Message-
> From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 16:36
> To: Dave Page
> Cc: Katie Ward; Tom Lane; Curtis Faith; [EMAIL PROTECTED]
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
>
> On Wed, 29 Jan 2003, Dave Page wrote:
>
> >
On Wed, 29 Jan 2003, Dave Page wrote:
>
>
> > -Original Message-
> > From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
> > Sent: 29 January 2003 16:27
> > To: Katie Ward
> > Cc: Tom Lane; Curtis Faith; [EMAIL PROTECTED]
> > Subject: Re: [mail] Re: [HACKERS] Windows Build System
> >
> >
> >
> -Original Message-
> From: Vince Vielhaber [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 16:27
> To: Katie Ward
> Cc: Tom Lane; Curtis Faith; [EMAIL PROTECTED]
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
>
> The only assumption I see being made here is this:
>
>
On Wed, 29 Jan 2003, Katie Ward wrote:
> >
> > In all honesty, I do not *want* Windows people to think that they're not
> > running on the "poor stepchild" platform.If we go down that path,
> > they'll start trying to run production databases on Windows, and then
> > we'll get blamed for the
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> + /* Flag to we need to initialize client encoding info */
> + static bool need_to_init_client_encoding = -1;
Surely that should be int, not bool.
> ! if (!PQsendQuery(conn, "begin; select
>pg_client_encoding(); commi
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane
> Sent: Wednesday, January 29, 2003 3:37 AM
> To: Curtis Faith
> Cc: 'Al Sutton'; 'Bruce Momjian'; [EMAIL PROTECTED]
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
>
> "Curtis Fait
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> This came to -general, it seems like a serious problem...
By and large, there's no support for dropped columns in function result
types. Feel free to fix it ...
regards, tom lane
---(end of b
On Wed, 29 Jan 2003, Curt Sampson wrote:
> On Tue, 28 Jan 2003, Stephan Szabo wrote:
> > I believe only the column names and types are considered for purposes of
> > this. Check constraints and the like defined on the column aren't applied
> > either. I can see arguments for both ways since thin
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> What was the result of the recursive unions thread? I remember Tom maybe
> saying that the Redhat guys like the DB2 (SQL99) syntax the best, however
> was it said that that was going to be done by Redhat for 7.4?
It'll be looked at; whether
I'm certainly not trying to be difficult, I just don't know a lot about
the internals of PostgreSQL. I'm developing some interfaces to various
databases and certainly wanted to include PostgreSQL.
>From my less-than-qualified viewpoint, I would have thought including
the base table name and bit p
There is a nasty bug with the client_encoding directive in
postgresql.conf. It is simply ignored. This bug exists in both 7.3 or
later and in current. Interesting thing is "show client_encoding"
command shows expected encoding but this only shows the GUC internal
variable and the actual internal en
> I get
>
> ERROR: Function pg_catalog.pg_name_pattern(text) does not exist
>
> It could be the error is inside your custom function?
I forgot that is a new function :)
Try this one:
PREPARE "pg_psql_dd2"(text,text) AS
SELECT true
FROM (
SELECT true
FROM pg_catalog.pg_proc p,
(SE
hi all:
is there any unused signal on
postgres?
TIA and regards
On Tue, 28 Jan 2003, Stephan Szabo wrote:
> You can also return records at which point you have to give a definition
> at select time.
>
> create function aa1() returns record as 'select 1,2;' language 'sql';
> select * from aa1() as aa1(a int, b int);
Yeah, I tried that approach too, but it got
Curt Sampson <[EMAIL PROTECTED]> writes:
> So currently the only way to specify a row type is by using a table,
No, as of 7.3 there's CREATE TYPE foo AS (column list). But ...
> This is returning a row that (to my mind) doesn't match the type of the
> table above, because it's returning null for
On 28 Jan 2003, [EMAIL PROTECTED] wrote:
> Hi,
>
> I guess what we're looking for is something on the order (as much as I
> hate using it as a reference) of MySQL's full text search which does
> offer some ranking.
>
> Just putting ranking alone in tsearch would be a huge benefit. Users can
> then
"Curtis Faith" <[EMAIL PROTECTED]> writes:
> If a developer can simply download the source, click on the Visual C++
> project in the win32 directory and then build PostgreSQL, and they can
> see that Windows is not the "poor stepchild" because the VC project is
> well laid out, they will be more li
No, in 7.3 you can create anonymous composite types using the CREATE TYPE
command.
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Curt Sampson
> Sent: Wednesday, 29 January 2003 1:45 PM
> To: PostgreSQL Development
> Subject: [HACKERS] Specif
This came to -general, it seems like a serious problem...
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Damjan Pipan
> Sent: Tuesday, 28 January 2003 9:36 PM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] problems with dropped columns
>
>
"John Liu" <[EMAIL PROTECTED]> writes:
> why psql subquery is not smarter enough to use
> indexes if obviously?
IN is smarter as of CVS tip.
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Wed, 29 Jan 2003, Curt Sampson wrote:
>
> So currently the only way to specify a row type is by using a table,
> right? E.g.:
>
> CREATE TABLE t2_retval (
> value1 int NOT NULL DEFAULT -1,
> value2 int NOT NULL,
> value3 int
> );
>
> Are there plans to add another way
Rod Taylor <[EMAIL PROTECTED]> writes:
> PREPARE "pg_psql_dd2"(text,text) AS=20
> SELECT true
> FROM (
> SELECT true
> FROM pg_catalog.pg_proc p,
>pg_catalog.pg_name_pattern( $2 ) AS (schpat text, propat text)
> WHERE p.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype
> ) AS tt,
Hi guys,
What was the result of the recursive unions thread? I remember Tom maybe
saying that the Redhat guys like the DB2 (SQL99) syntax the best, however
was it said that that was going to be done by Redhat for 7.4?
Chris
---(end of broadcast)-
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> On Sat, Jan 25, 2003 at 09:55:25PM -0500, Bruce Momjian wrote:
>> If we can get them all, it is a big win. If we can't, I don't think it
>> is a win.
> In the context of backporting, this is true, but in general, if you
> don't worry about putting
77 matches
Mail list logo
