On Wed, 14 Aug 2002, Tom Lane wrote:
It's nonlocal constraints that are the problem, and here foreign keys
and UNIQUE constraints are certainly the canonical examples. Both of
these would be largely solved with table-spanning indexes I think.
Note that the other obvious way to solve this
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Rod Taylor wrote:
Appears there is a problem
[ Sorry for previous message saying it was added to queue.]
Patch applied. Thanks.
---
Rod Taylor wrote:
Appears there is a problem finding the opclass when indexing a domain.
CREATE DOMAIN newint as int4;
CREATE
Patch applied. Thanks.
---
Teodor Sigaev wrote:
CHANGES:
August 13, 2002
Use parser of OpenFTS v0.33.
--
Teodor Sigaev
[EMAIL PROTECTED]
[ application/gzip is not supported, skipping... ]
Well, I tend to agree with that. Overall, I can't say that I see bad
things coming out of accepting the patch as is. It's not exactly
causing an extra join or other wise a significant waste of resources.
At worst, it appears to be ambiguous. Since Christopher has not offered
any additional
Yep - alright, just commit it I guess.
Chris
-Original Message-
From: Greg Copeland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 August 2002 11:09 AM
To: Rod Taylor
Cc: Christopher Kings-Lynne; Bruce Momjian; PostgresSQL Hackers Mailing
List
Subject: Re: [HACKERS] python patch
Patch applied. Thanks.
---
Greg Copeland wrote:
Checking application/pgp-signature: FAILURE
-- Start of PGP signed section.
Okay, I read
http://archives.postgresql.org/pgsql-bugs/2002-06/msg00086.php and never
saw a
Patch applied. Thanks.
---
Greg Copeland wrote:
Checking application/pgp-signature: FAILURE
-- Start of PGP signed section.
Well, that certainly appeared to be very straight forward. pg.py and
syscat.py scripts were
Patch applied. Thanks.
---
Greg Copeland wrote:
Checking application/pgp-signature: FAILURE
-- Start of PGP signed section.
This fixes some text as well as enforces the use of drop table cascade
since we moved from
OK, I have applied all three of Greg's python patches.
---
Christopher Kings-Lynne wrote:
Yep - alright, just commit it I guess.
Chris
-Original Message-
From: Greg Copeland [mailto:[EMAIL PROTECTED]]
Thanks.
-Greg
On Wed, 2002-08-14 at 22:34, Bruce Momjian wrote:
OK, I have applied all three of Greg's python patches.
---
Christopher Kings-Lynne wrote:
Yep - alright, just commit it I guess.
Chris
On Tue, 13 Aug 2002, scott.marlowe wrote:
My non-coding vote goes with Tom Lane on this. initdb can set pg_xlog,
and if you need to change it, use symlinks.
I've not been following this thread, and thus I suppose I missed
my opportunity to vote, but just for the record I'm with the don't
use
Here are some comments on the open 7.3 items. We have to start pairing
this down if we are going to hit beta in 2.5 weeks:
---
P O S T G R E S Q L
7 . 3 O P E N
Curt Sampson [EMAIL PROTECTED] writes:
... just for the record I'm with the don't
use an environment variable crowd here, too. It's way, way to easy
to start up with the wrong setting in your environment.
What he said ...
Oh, and yes, it does need to be changable after an initdb. Say you
Dependency - have pg_dump auto-create dependencies when loading 7.2.X
data?
Are we as far as we can go here?
The only trouble maker is foreign keys. If there was a nice way of
finding foreign keys in 7.2 and prior it probably would have been
implemented a long time ago in
I would like to know how to move this item forward.
---
Tom Lane wrote:
Curt Sampson [EMAIL PROTECTED] writes:
... just for the record I'm with the don't
use an environment variable crowd here, too. It's way, way to
Dependency - have pg_dump auto-create dependencies when
loading 7.2.X
data?
Are we as far as we can go here?
The only trouble maker is foreign keys. If there was a nice way of
finding foreign keys in 7.2 and prior it probably would have been
implemented a long time ago in
On Thu, 15 Aug 2002, Bruce Momjian wrote:
I would like to know how to move this item forward.
Right now (i.e., in 7.2), the only two options we have for moving the
log file to a different spindle are mounting it on pg_xlog and using a
symlink. I doubt many people do the the former, and if they
Bruce Momjian [EMAIL PROTECTED] writes:
remove interfaces/ssl if not improved
I am ready to yank this.
Agreed.
integrate or remove new libpqxx
integrate or add to gborg Pg:DBD
Seems like gborg is the place for these.
Yes, but I'd also like to see libpq++, perl5, and
Rod Taylor [EMAIL PROTECTED] writes:
Anyone mind if we bump the DTD version to Docbook 4.2?
Peter E. is the gatekeeper on that, I think --- he pushed us to 4.1
not long ago.
If Peter's okay with 4.2, then full speed ahead ...
regards, tom lane
PS: pgsql-docs is
On Thu, 2002-08-15 at 00:01, Christopher Kings-Lynne wrote:
Dependency - have pg_dump auto-create dependencies when
loading 7.2.X
data?
Are we as far as we can go here?
The only trouble maker is foreign keys. If there was a nice way of
finding foreign keys in 7.2 and
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
What about this.
1. Implement pg_get_foreignkey_def() or whatever
2. Adjust pg_dump to dump foreign keys using an ALTER statement
3. Back port the above to rel 7_2_2
4. Release a 7.2.2 version and ask that people upgrade to that version and
Is it possible to have two different functions in the .so that can be made
into two different postgres funtions, both referencing the same .so?
Chris
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 August 2002 6:02 AM
To: Christopher
I believe that
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
ahould give a fairly large integer --- in 7.2 I get 982373920.
But CVS tip (without the int64-timestamp option) produces
982.35592. Broken, no?
regards, tom lane
---(end
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Is it possible to have two different functions in the .so that can be made
into two different postgres funtions, both referencing the same .so?
Certainly, what's the problem there? Offhand I can't think of any
contrib modules that only define
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Is it possible to have two different functions in the .so that
can be made
into two different postgres funtions, both referencing the same .so?
Certainly, what's the problem there? Offhand I can't think of any
contrib modules that only
Christopher Kings-Lynne wrote:
create function fti() returns opaque as
'$libdir/fti'
language 'C';
So it references the fti.so, but where does it say what function to actually
run in fti.so? Or is it assumed in C functions that the function to call in
the shared object is
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
I guess my question would be that currently fulltextindex generates SQL like
this:
create function fti() returns opaque as
'$libdir/fti'
language 'C';
So it references the fti.so, but where does it say what function to
Bruce Momjian wrote:
Point-in-time recovery - ready for 7.3?
This seems very unlikely now. Status?
It would be a shame to have to wait for 7.4 for this one.
glibc and mktime() - fix?
I can do the work on this I need more info and no one seems to be
conerned.
I'm
Hi,
I noticed this behaviour:
usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 's';
id | name |
description
-+--+---
Actually, looking at this again it's possible that tsearch sees 'a' as a
skip word and so doesn't allow a search on it. This makes it _really_ hard
for me to parse and check user keywords - maybe a 'isvalidsyntax' sort of
function should be included? Hmmm...maybe I could use the cast to
Joe Conway [EMAIL PROTECTED] writes:
Bruce Momjian wrote:
Point-in-time recovery - ready for 7.3?
This seems very unlikely now. Status?
It would be a shame to have to wait for 7.4 for this one.
If a credible patch appears before the end of the month, great ---
but the discussions so far
Hannu Krosing wrote:
What about functions
1. split(text,text,int) returns text
2. split(text,text) returns text[]
and why not
3. split(text,text,text) returns text
which returns text from $1 delimited by $2 and $3
Given the time remaining before beta, I'll be happy just to get #1
101 - 133 of 133 matches
Mail list logo