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
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
Hi!
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] Specifying
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 locks on
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 likely to
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 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 ugly
hi all:
is there any unused signal on
postgres?
TIA and regards
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,
(SELECT
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
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
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 it
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
-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 Faith [EMAIL
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(); commit))
On Wed, 29 Jan 2003, Katie Ward wrote:
flame on
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
-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:
I believe
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
the
tom lane wrote:
flame on
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
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
Curtis Faith wrote:
snip
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,
*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
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) has been going on
Vince Vielhaber wrote:
snip
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
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
The only assumption
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
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 not, it's
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: Re: [mail] Re:
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 the
-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:
hammering
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 ;)
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.
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 is
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 and
-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 two? Do
Christopher Kings-Lynne wrote:
snip
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
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' the
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.28;
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 nice ;)
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 ...
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 out, they
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 pretty
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, tom
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
-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:
I'll admit
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 lane
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 grammar was
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
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
emulate Unix
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 tests
-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:
I would be
-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:
The code's
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 catch 22 if testing won't
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,
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,
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
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
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 on
James Hubbard wrote:
snip
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,
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
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 it?
I
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 also be
-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 Eisentraut
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 done by
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 existing
65 matches
Mail list logo
