On Mon, Dec 02, 2002 at 08:56:41AM -0800, Joe Conway wrote:
Karel Zak wrote:
On Sat, Nov 30, 2002 at 01:11:20PM -0800, Joe Conway wrote:
As I said, this is all very preliminary; comments, suggestions, requests
are all welcome.
Only idea/dream: what implement dblink as virtual schema.
I'm certainly interested! I am working here on Geographical Information
Systems with PostgreSQL/PostGIS with the Minnesota MapServer, with a lot
of regular database work thrown in. PostgreSQL has great potential for
teaching databases and SQL, and when the native Windows port is ready,
it
-Original Message-
From: mlw [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 06:17
To: psqlodbc; [EMAIL PROTECTED]
Subject: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?
I am working on getting a shrink-wrapped version of
PostgreSQL for Windows
Currently it
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
Now convert this query so that it only evaluates the date_part thing
ONCE:
select t.id, date_part('days',now()-t.stamp) from table_name t where
date_part('days',now()-t.stamp) 20;
Something like this could work:
select *
from (select t.id,
On Mon, Dec 02, 2002 at 12:48:38PM -0800, Christopher Kings-Lynne wrote:
But if there is, then the sum/count(*) is nonsensical anyway.
You must to use it in SERIALIZABLE transaction isolation.
Karel
--
Karel Zak [EMAIL PROTECTED]
http://home.zf.jcu.cz/~zakkr/
I've looked long and hard and can't find any license issues. Does anyone
know of any that I may have missed? As far as I can see, as long as I
maintain GPL restrictions, I should be fine.
PostgreSQL isn't licensed under the GPL, so it sounds to me as though you're
confused about the
[EMAIL PROTECTED] wrote:
I've looked long and hard and can't find any license issues. Does anyone
know of any that I may have missed? As far as I can see, as long as I
maintain GPL restrictions, I should be fine.
PostgreSQL isn't licensed under the GPL, so it sounds to me as though
On Tue, 2002-12-03 at 09:20, Dennis Björklund wrote:
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
Now convert this query so that it only evaluates the date_part thing
ONCE:
select t.id, date_part('days',now()-t.stamp) from table_name t where
date_part('days',now()-t.stamp) 20;
On 3 Dec 2002, Hannu Krosing wrote:
the standard way of doing it would be SQL99's WITH :
Great! I havn't looked too much at sql99 yet so I've missed this. It's
exactly what I want. Now I know what I will use in the future (when it's
all implemented).
--
/Dennis
Was it necessary? No idea, you're welcome to search through the
pgsql-hackers archives to determine the reasoning behind the change. I
believe the change was made by Bruce Momjian (going by the release
notes). I only remember reading the discussion in passing.
This is also one of the reasons for
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 12:16
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] Shrinkwrap Windows Product, any
issues? Anyone?
I've looked long and hard and can't find any license issues. Does
anyone
Dave Page wrote:
-Original Message-
From: mlw [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 06:17
To: psqlodbc; [EMAIL PROTECTED]
Subject: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?
I am working on getting a shrink-wrapped version of
PostgreSQL for Windows
-Original Message-
From: mlw [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 12:44
To: Dave Page
Cc: psqlodbc; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?
Dave Page wrote:
No problems with pgAdmin, though I do have to wonder
I'm evaluating tsearch contrib module, and i get a backend crash when
i'm about to use a tsearch function.
When i issue
update things set nidx=txt2txtidx(productname),
didx=txt2txtidx(longdescription);
The backend dies in a segfault.
The system is redhat 7.3 dual athlon w/ 1GB memory.
Postgresql
I am thinking of tweaking EXPLAIN so that it performs ExecutorStart()
and ExecutorEnd() even when you just do plain EXPLAIN (and not EXPLAIN
ANALYZE). The immediate reason for this is an internal change (details
below) but it would have a couple of user-visible side effects:
1. Permissions
Magnus Naeslund(f) [EMAIL PROTECTED] writes:
The backend dies in a segfault.
Backtrace:
#0 0x02d1 in ?? ()
#1 0x401faf48 in ?? ()
#2 0x401fb5e6 in ?? ()
#3 0x080d8f5c in ExecMakeFunctionResult (fcache=0x82d3710,
arguments=0x82ce170, econtext=0x82d3580, isNull=0xbfffec8f ,
Tom Lane [EMAIL PROTECTED] wrote:
Magnus Naeslund(f) [EMAIL PROTECTED] writes:
The backend dies in a segfault.
Backtrace:
#0 0x02d1 in ?? ()
#1 0x401faf48 in ?? ()
#2 0x401fb5e6 in ?? ()
#3 0x080d8f5c in ExecMakeFunctionResult (fcache=0x82d3710,
arguments=0x82ce170,
Magnus Naeslund\(f\) [EMAIL PROTECTED] writes:
It's either that it can't load the lib (shouldn't it complain?) or it's
a bad pointer.
Be sure to eliminate the possibility that you're loading the wrong
version of the .so (ie, loading a 7.2 tsearch.so into 7.3). People
get bit by that quite
More info, the gdb sharedlibrary loaded some more symbols:
(gdb) bt
#0 0x02d1 in ?? ()
#1 0x401faf48 in parsetext (prs=0xbfffea60, buf=0x4277eb3c Can - Live
1971-77, buflen=18) at txtidx.c:366
#2 0x401fb5e6 in txt2txtidx (fcinfo=0xbfffeaf0) at txtidx.c:487
#3 0x080ec45c in
Rod Taylor wrote:
Why just restrict them to moving tables? What if someone wants to move a
function or an aggregate to another schema?
What if they want to copy it?
Copying might be tricky, but I'd be happy to help with moving everything
else around. Though I don't think sequences can move
Does it crashed?
# select txt2txtidx('Can - Live 1971-77');
Line txtidx.c:366 :
lemm = lemmatize(token, lenlemm, type);
lemmatize() is defined in morph.c. Did you use another modules for postgresql?
It seems to me that we see a name conflict. Function lemmatize is defined in
somewhere also.
Teodor Sigaev wrote:
Does it crashed?
# select txt2txtidx('Can - Live 1971-77');
Line txtidx.c:366 :
lemm = lemmatize(token, lenlemm, type);
lemmatize() is defined in morph.c. Did you use another modules for
postgresql?
It seems to me that we see a name conflict. Function lemmatize is
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
I'm evaluating tsearch contrib module, and i get a backend crash when
i'm about to use a tsearch function.
When i issue
update things set nidx=txt2txtidx(productname),
didx=txt2txtidx(longdescription);
The backend dies in a segfault.
The
Copy is another story all together. But I'd like a
CREATE SCHEMA ... AS COPY schemaname;
Wouldn't it be better to use pg_dump/pg_restore for that?
Perhaps.. But I'd really like to see some of these types of abilities
added to pg_admin.
--
Rod Taylor [EMAIL PROTECTED]
PGP Key:
On Fri, 29 Nov 2002, Prasanna Phadke wrote:
Can anybody explain me, how to compile postgres source code in VC++.
Catch all the cricket action. Download Yahoo! Score tracker
Step 1: Get VC++ to run under unix...
Just kidding. :-) Right now you can't.
pgsql 7.4 should support native
Some more (useless) info.
objdump -x /lib/*.so /usr/lib/*.so /lib/i686/*.so /usr/kerberos/lib/*.so
/usr/local/pgsql/bin/* /usr/local/pgsql/lib/*.so | grep lemmatize
reviels only one lemmatize symbol.
The offending address 0x02d1 is not mapped anywhere in the address
space according to
On Tue, 3 Dec 2002, Justin Clift wrote:
Excellent. Are there any other people involved in PostgreSQL and
universities or educational institutions? If so we could put something
together about experiences for the advocacy Web site.
Is this the kind of thing that the Techdocs Guides area
On Tue, 2002-12-03 at 17:59, scott.marlowe wrote:
On Fri, 29 Nov 2002, Prasanna Phadke wrote:
Catch all the cricket action. Download Yahoo! Score tracker
Step 1: Get VC++ to run under unix...
Virtual Cricket++? I don't exactly see how this applies here.
(sorry)
-- vbi
--
this email is
Oleg Bartunov [EMAIL PROTECTED] wrote:
Please, tell us postgresql version. Did you reinstall tsearch after
upgrading ? Test-suite (data, sql) demonstrated the problem would be
nice.
pgsql 7.3, about 700mb text database with product descriptions.
I'm working on isolation the behavior, the
I don't see any 7.3 tag created when we did the 7.3 release. (I do see
the 7.3 branch.)
Marc, can a tag be added to match the 7.3 release tree?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard
On Mon, 2 Dec 2002, Joel Burton wrote:
joel@joel=# select round('2.000'::numeric);
round
---
2
(1 row)
joel@joel=# select round('2.000'::numeric,2);
round
---
2.00
(1 row)
OK, but:
template1=# select round('2.001'::numeric);
round
---
2
(1 row)
On Mon, 2 Dec 2002, Rod Taylor wrote:
double precision | pg_catalog | round | double precision
numeric | pg_catalog | round | numeric
numeric | pg_catalog | round | numeric, integer
Looks like round still exists to me.
Rod, you don't
I'll reinstall tsearch and try again soon.
Is it necesary to install OpenFTS contrib aswell, or do i get away with
only installing tsearch?
Now i do both...
Can you give us the compressed text? I can try it on my installation and
see if there's the same problem?
Chris
On Tue, 3 Dec 2002, Marc G. Fournier wrote:
On Tue, 3 Dec 2002, Justin Clift wrote:
Excellent. Are there any other people involved in PostgreSQL and
universities or educational institutions? If so we could put something
together about experiences for the advocacy Web site.
Is this
Christopher Kings-Lynne [EMAIL PROTECTED] wrote:
I'll reinstall tsearch and try again soon.
Is it necesary to install OpenFTS contrib aswell, or do i get away
with only installing tsearch?
Now i do both...
Can you give us the compressed text? I can try it on my installation
and see if
No i can't, it's not my data to give :(
OK
But it doesn't matter since if you run gmake installcheck in
contrib/tsearch it will explode.
A funny thing is that i installed pg7.3 on an linux intel celeron system
(rh8.0) w/128 mb memory, and THERE it works!
Works on FreeBSD/Alpha for me.
Christopher Kings-Lynne [EMAIL PROTECTED] wrote:
Works on FreeBSD/Alpha for me. Maybe you've got some weirdness with
bad RAM chips or something?
Chris
Could be, but it only shows when i do this, and the server has been up
for several months.
If everything else failes, i'll run memtest86 on
On Tue, 3 Dec 2002, Vince Vielhaber wrote:
On Tue, 3 Dec 2002, Marc G. Fournier wrote:
On Tue, 3 Dec 2002, Justin Clift wrote:
Excellent. Are there any other people involved in PostgreSQL and
universities or educational institutions? If so we could put something
together about
Al Sutton wrote:
Point to Point and Broadcast replication
With point to point you specify multiple endpoints, with broadcast you can
specify a subnet address and the updates are broadcast over that subnet.
The difference being that point to point
On 3 Dec 2002 at 15:08, Vince Vielhaber wrote:
Where have you been? The lines of distinction between all of the
lists have gotten so blurred it hardly makes a difference.
So consider this a wake up call.
--
Dan Langille : http://www.langille.org/
---(end of
Is WITH a TODO item?
---
Hannu Krosing wrote:
On Tue, 2002-12-03 at 09:20, Dennis Bj?rklund wrote:
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
Now convert this query so that it only evaluates the date_part thing
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
Oleg Bartunov [EMAIL PROTECTED] wrote:
Please, tell us postgresql version. Did you reinstall tsearch after
upgrading ? Test-suite (data, sql) demonstrated the problem would be
nice.
pgsql 7.3, about 700mb text database with product
Tom Lane [EMAIL PROTECTED] writes:
Greg Stark [EMAIL PROTECTED] writes:
Ok, someone else posted their data warehousing wishlist, I want to post my
single item OLP wishlist: Plan stability.
That seems to me to translate to I want the system to fail to react to
changes in data statistics
Marc G. Fournier wrote:
On Tue, 3 Dec 2002, Justin Clift wrote:
Excellent. Are there any other people involved in PostgreSQL and
universities or educational institutions? If so we could put something
together about experiences for the advocacy Web site.
Is this the kind of thing that the
Marc G. Fournier wrote:
snip
Actually, there are lines, Justin just occasionally appears to 'blur' them
until I get a chance to refresh them ... eh Justin?:)
[innocent whistle]
+ Justin
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
Ok, I nailed the bug, but i'm not sure what the correct fix is.
Attached tsearch_morph.diff that remedies this problem by avoiding it.
Also there's a debug aid patch if someone would like to know how i
finally found it out :)
There problem in the lemmatize() function is that GETDICT(...) returned
The change was made to tighten up the code to catch errors sooner.
There isn't much logic to making '' be 0, and no one could make a case
for keeping such a mapping.
---
Lee Kindness wrote:
Was it necessary? No idea,
Hi,
| What is the solution of other dbs ( oracle, db2 .. ) to:
| insert into table (num) value (''); ? |
| I assume they would fail too.
The Oracle behaviour is:
---
oracle create table foonum (x number(5));
oracle insert into foonum values ('');
oracle select * from foonum;
+
X
On Tue, 2002-12-03 at 16:00, Bruce Momjian wrote:
Is WITH a TODO item?
It is disguised as
Exotic Features
===
* Add sql3 recursive unions
Which was added at my request in dark times, possibly when PostgreSQL
was called postgres95 ;)
This should be changed to two items
* Add
If we had received more complaints about the change during beta, we
would have added a mention that the change would be in 7.4. As we got
few complaints, the change went into 7.3, and it is mentioned in the
porting section of the release notes (last item):
* An empty string ('') is no
TODO updated. Thanks for the clarification.
---
Hannu Krosing wrote:
On Tue, 2002-12-03 at 16:00, Bruce Momjian wrote:
Is WITH a TODO item?
It is disguised as
Exotic Features
===
* Add sql3
As you wish...
This is a bt taken from a core file this time (the other ones were from
attached processes).
The whole thing has been recompiled with no additional compiler flags
(i.e. removed -march=athlon -O3), but still with --enable-debug
and --enable-cassert.
Sorry, I have no any idea.
Teodor Sigaev [EMAIL PROTECTED] wrote:
Sorry, I have no any idea. Just only full reinstall (with initdb
and rm -rf /usr/local/pgsql) postgresql...
Can you give me login on you computer for a several hours?
The thing is that when i ran the thing breakpointing on parsetext() at
the line
On Thu, 28 Nov 2002, Bruce Momjian wrote:
Wow, this sounds great.
Where can I get a copy? Why would anyone use anything else? ;-)
Well, if you read the announcement in its entirety, you would have
noticed:
Source for this release is available at:
Marc G. Fournier wrote:
On Thu, 28 Nov 2002, Bruce Momjian wrote:
Wow, this sounds great.
Where can I get a copy? Why would anyone use anything else? ;-)
Well, if you read the announcement in its entirety, you would have
noticed:
Source for this release is available at:
Hi:
We at the Department of Information Technology of the Mindanao State
University-Iligan Institute of Technology (MSU-IIT) in Iligan City,
Philippines had been using PostgreSQL since 1998 in teaching courses in
Databases, SQL, and as a support tool in teaching Software Engineering and
Web
Brute force, of course!
Seriously, I have hidden the cygwin environment and simply called it
PostgreSQL. I am managing all he environment variables in my installer,
and I am using Windows batch files to start bash which executes the
PostgreSQL comands.
I am using PGAdmin as the
-Original Message-
From: Marc G. Fournier [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 19:12
To: Bruce Momjian
Cc: PostgreSQL-development
Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global
Development Group Announces
On Thu, 28 Nov 2002, Bruce Momjian wrote:
Wow,
On Tue, 3 Dec 2002, Dave Page wrote:
-Original Message-
From: Marc G. Fournier [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 19:12
To: Bruce Momjian
Cc: PostgreSQL-development
Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global
Development Group Announces
On Thu,
On Tue, 3 Dec 2002, Dave Page wrote:
I could have sworn we used to have a bunch of ftp mirrors for downloads.
Come to think of it I rewrote/stole a load of Vince's PHP code to allow
you to select one from the portal recently. Are we not using them
anymore?
Yup, as with doing anything for the
On Tue, 3 Dec 2002, Vince Vielhaber wrote:
Haven't you been paying attention? There's this new advocacy and suit
marketing thing going on that makes all of that irrelevant. It's just
there for show now.
---(end of broadcast)---
TIP 3: if
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
Christopher Kings-Lynne [EMAIL PROTECTED] wrote:
I'll reinstall tsearch and try again soon.
Is it necesary to install OpenFTS contrib aswell, or do i get away
with only installing tsearch?
Now i do both...
Can you give us the compressed
Oleg Bartunov [EMAIL PROTECTED] wrote:
So, the problem may be in rh 7.3 ?
Might be, i'm debugging it now, and i can see that the dicts[] array in
morph.c is beeing overwritten with junk.
I can trigger it with this query:
select txt2txtidx('Can - Live 1971-77');
Is there any good way of
On Tue, 3 Dec 2002, Marc G. Fournier wrote:
On Tue, 3 Dec 2002, Dave Page wrote:
I could have sworn we used to have a bunch of ftp mirrors for downloads.
Come to think of it I rewrote/stole a load of Vince's PHP code to allow
you to select one from the portal recently. Are we not using
Joe Conway writes:
That is one thing I'd like to take a look at. I think the problem is that
certain byte-sequence/multibyte-encoding combinations are illegal, so it's not
as simple an issue as it might first appear.
The bytea type really shouldn't come even close to having to care about
Hi,
I thought MySQL is marked as obsolete since PostgreSQL 7.3 ;-)
Tommi
Am Mittwoch, 4. Dezember 2002 03:55 schrieb Christopher Kings-Lynne:
Not that anyone cares, but I notice in the commit logs for MySQL 4.1, it
now has subselects.
Chris
---(end of
On 4 Dec 2002 at 8:13, Tommi Maekitalo wrote:
I thought MySQL is marked as obsolete since PostgreSQL 7.3 ;-)
If you ask me, one should never under-estimate the compitition..No matter how
big upper hand you have..
If you want to compete in the first place, that is..
Bye
Shridhar
--
Ogden's
Dave Page wrote:
snip
I could have sworn we used to have a bunch of ftp mirrors for downloads.
Come to think of it I rewrote/stole a load of Vince's PHP code to allow
you to select one from the portal recently. Are we not using them
anymore?
Of course we are, it's just that we're also trying to
Marc G. Fournier writes:
Yup, as with doing anything for the firs ttime, the press release itself
had its 'bugs' ... considering how many times Josh asked for comments on
it, I'm surprised that nobody picked up on it *shrug*
And how should we have guessed that release management is now done
Justin Clift writes:
Of course we are, it's just that we're also trying to direct people to
the Advocacy site where there is a lot more info, in a lot more languages.
Why don't we just shut down the regular web site. Clearly it's not
considered adequate anymore.
--
Peter Eisentraut [EMAIL
Peter Eisentraut wrote:
Marc G. Fournier writes:
Yup, as with doing anything for the firs ttime, the press release itself
had its 'bugs' ... considering how many times Josh asked for comments on
it, I'm surprised that nobody picked up on it *shrug*
And how should we have guessed that
Peter Eisentraut wrote:
Justin Clift writes:
Of course we are, it's just that we're also trying to direct people to
the Advocacy site where there is a lot more info, in a lot more languages.
Why don't we just shut down the regular web site. Clearly it's not
considered adequate anymore.
72 matches
Mail list logo