Hi,
I just installed 7.3b3 on my server (SuSE linux 8.1 on x86 with gcc 3.2) and
discovered a problem with tabcompletition in pgsql. It doesn't work with
schema. I created a schema 's' and a table 'tab' in this schema. When typing
'select * from s.' followed by tab nothing happens. A second
People,
I posted this to the general list with no response so this is the next
step . .
I have a client that I have just changed over to PG 7.2.3 and despite
the early teething problems things are going pretty well. There are,
however, a few more difficult problems to do with reporting via
Hello,
OK
select 1 as ccc where 1=1
ERROR
select 1 as ccc where ccc=1
PostgreSQL said: ERROR: Attribute 'ccc' not found
Is there any way to set conditions on calculated fields values?
Best regards,
Yar
---(end of broadcast)---
TIP 3: if
Hi,
I am not subscribed (and I would prefer to continue read
the list through web interface only).
Does the developers team follow the
http://developer.postgresql.org/regress/report.php ?
May be it's worthless to report there?
Best regards,
Vladimir Chukharev
---(end of
Hi,
Can anybody explain the following results when using EXPLAIN,
one time with enable_seqscan=on and one time with enable_seqscan=off.
What I don't understand is that the nodes created are the same
(index scan, seq scan), but the costs differ.
set enable_seqscan=on;
explain (SELECT
On 29/10/02 6:02 pm, Tom Lane [EMAIL PROTECTED] wrote:
Adam Witney [EMAIL PROTECTED] writes:
Just to update the list of supported platforms, 7.3b3 compiles and passes
all the regression tests on MacOSX 10.2.1
Although don't know if this is relevant but this appears when running the
tests:
On 29 Oct 2002, Ives Landrieu wrote:
Hi,
Can anybody explain the following results when using EXPLAIN,
one time with enable_seqscan=on and one time with enable_seqscan=off.
What I don't understand is that the nodes created are the same
(index scan, seq scan), but the costs differ.
Enable
On Wed, 30 Oct 2002, Stephan Szabo wrote:
On 29 Oct 2002, Ives Landrieu wrote:
Hi,
Can anybody explain the following results when using EXPLAIN,
one time with enable_seqscan=on and one time with enable_seqscan=off.
What I don't understand is that the nodes created are the same
There's a nice simple book from 1999 by Stonebreaker and a technologist
form Informix about object-relational features. PostgreSQL has
definately started to lag on that front, while shoring up other aspects
of the RDBMS. A simple (simple?) start might just be supporting dot
notation and other
Adam Witney [EMAIL PROTECTED] writes:
It appears that my ignorance got the better of me It was the first time
I had run the regression tests on any PostgreSQL installation. But I think I
am getting the same problems as others. below is the last part of the
regression tests (I had taken the
Peter Bierman [EMAIL PROTECTED] writes:
Ok. After upgrading to bison-1.75, all regression tests pass except:
*** ./expected/geometry-powerpc-darwin.out Mon Dec 11 08:45:16 2000
Perhaps the change from gcc2.x to 3.x changed floats a bit?
Could be. We had previous reports of the same diff
On Wed, 2002-10-30 at 12:16, Olivier PRENANT wrote:
On 30 Oct 2002, Larry Rosenman wrote:
Date: 30 Oct 2002 12:14:01 -0600
From: Larry Rosenman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] 7.3b3 ok on unixware 71[12] here
I've got it
Bruce Momjian writes:
So, that is why MOVE 0 goes to the end of the cursor. One idea would be
for MOVE 0 to actually move nothing, but jdbc and others need the
ability to move the end of the cursor, perhaps to then back up a certain
amount and read from there. Seems MOVE 0 is the logical
Dave Page writes:
Hackers: As the Cygwin release that is actively supported is the binary
distribution that Jason builds, I would think this is OK to be listed as
supported if no-one disagrees...
I disagree. We document as supported those platforms that build out of
the box, not those that
On Wed, 30 Oct 2002, Pedro Miguel Frazao Fernandes Ferreira wrote:
In C this is possible:
#include stdio.h
#include stdlib.h
int main(void)
{
double v;
char a[30];
v=1.79769313486231571e+308;
printf( Stored double number: %25.18g\n,v);
sprintf(a,%25.18g,v);
On Wed, Oct 30, 2002 at 19:27:57 +0100,
Peter Eisentraut [EMAIL PROTECTED] wrote:
The printf(%A) output is not system-specific.
Just out of curiosity, can you tell me a web page or keywords to use
in a search to see what that format does? I tried using google, but
searching for printf with
Well, I think I just found it!!
I adeed -Kpic in Dynaloader's Makefile. I haven't test plperl itself, but
at least it compiles.
Regards,
On 30 Oct 2002, Larry Rosenman wrote:
Date: 30 Oct 2002 12:23:06 -0600
From: Larry Rosenman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Tom Lane writes:
No, there should be ~80 tests in all. I'm not sure why the pg_regress
script is failing to process the remaining tests when this happens; any
ideas out there?
It appears that the shell simply aborts on fork failure. Example:
peter ~$ cat test.sh
ulimit -u 30
for i in
I had an interesting conversation today with Tom Tromey and Andrew Haley
of Red Hat about how to implement pljava for Postgres. Rather than
futzing with an external JVM, their thought is to use gcj (gcc compiling
Java). It sounds like this approach would mostly just work, modulo
needing to use a
I've been trying to do some code review of the recent statement-timeout
feature addition, and I've got some fairly serious concerns about it.
One problem that needs discussion is that the enable_sig_alarm and
disable_sig_alarm calls were dropped into postgres.c at rather randomly
chosen places.
ERROR: RelationClearRelation: relation 11584078 deleted while still in
use
I've been unable to come up with a test case that will cause the
problem, seems to be timing related. The queries that are currently
running when these errors occur do a lot or work with temp tables that
are frequently
On Wed, Oct 30, 2002 at 14:03:21 -0600,
While I am not sure about triggers, it certainly is possible to get
a similar effect be having the referenced function run with the security
of the definer.
I read some more on triggers and found that according to the documentation,
they appear to run
Rod Taylor [EMAIL PROTECTED] writes:
ERROR: RelationClearRelation: relation 11584078 deleted while still in
use
I was going to report a similar error that arises in a different
situation:
client 1:
CREATE TABLE a (b int);
BEGIN;
DROP TABLE a;
-- wait
client 2:
SELECT * FROM a;
client 1:
On Wed, 2002-10-30 at 15:38, Neil Conway wrote:
Rod Taylor [EMAIL PROTECTED] writes:
ERROR: RelationClearRelation: relation 11584078 deleted while still in
use
I was going to report a similar error that arises in a different
situation:
Probably a different look at the same problem.
--
Hi everyone,
Thanks to Henrik Edlund [EMAIL PROTECTED], the Swedish translation of
the PostgreSQL Advocacy and Marketing site is now completed and ready
for public use:
http://advocacy.postgresql.org/?lang=sv
:-)
Spanish should available pretty soon too (next few days at least).
Regards and
Stephan Szabo wrote:
On Wed, 30 Oct 2002, Pedro Miguel Frazao Fernandes Ferreira wrote:
I understand that if people insert a value of 1.1 in a double, they want
to get 1.1 without knowing that in fact the stored number is
1.10009. But do you understand that if some people insert,
Since you're using wxWindows, I *HIGHLY* recommend obtaining a license
to wxDesigner from http://www.roebling.de/. It allows for very rapid
GUI design. It also understands various sizers and makes it SOOO much
easier to make use of them. Once you understand sizers, you'll love
them but they
I am not sure I follow. Are you suggesting:
1) create function takes java source and then calls gcj to compile it
to native and build a .so from it that would get called at runtime?
or
2) create function takes java source and just compiles to java .class
files and the runtime invokes the
Barry Lind [EMAIL PROTECTED] writes:
I am not sure I follow. Are you suggesting:
1) create function takes java source and then calls gcj to compile it
to native and build a .so from it that would get called at runtime?
or
2) create function takes java source and just compiles to java
Neil Conway [EMAIL PROTECTED] writes:
client 1:
CREATE TABLE a (b int);
BEGIN;
DROP TABLE a;
-- wait
client 2:
SELECT * FROM a;
client 1:
COMMIT;
Now, client 2 will receive RelationClearRelation: relation 25172
deleted while still in use, rather than Relation a does not
exist, as
Tom Lane [EMAIL PROTECTED] writes:
But relation a *does* exist at the start of client 2's operation.
While I'm not here to defend the exact phrasing of this error message,
it does seem to me that it's appropriate to give a different error
message than what appears when the table wasn't found
Rod Taylor [EMAIL PROTECTED] writes:
ERROR: RelationClearRelation: relation 11584078 deleted while still in
use
I've been unable to come up with a test case that will cause the
problem, seems to be timing related. The queries that are currently
running when these errors occur do a lot or
Neil Conway [EMAIL PROTECTED] writes:
Ok, fair enough -- I agree that we should treat the two cases
differently. But one thing I think we should do in any case is improve
the wording of the error message.
Got a suggestion?
regards, tom lane
Hi,
I read a presentation about Object-Oriented features in relation DBs.
The nice are UDT (user defined type):
CREATE TABLE person (
name varchar(32),
address ROW( street varchar(32),
town varchar(32)),
age int
);
INSERT INTO person VALUES ('Bill',
-Original Message-
From: Greg Copeland [mailto:greg;copelandconsulting.net]
Sent: 30 October 2002 01:08
To: Dave Page
Subject: Re: [HACKERS] Request for supported platforms
C++? Really? What GUI toolkit is being used?
Just curious.
wxWindows. The CVS is online if anyone
Karel Zak kirjutas K, 30.10.2002 kell 10:08:
Hi,
I read a presentation about Object-Oriented features in relation DBs.
The nice are UDT (user defined type):
CREATE TABLE person (
name varchar(32),
address ROW( street varchar(32),
town varchar(32)),
On Wed, Oct 30, 2002 at 08:35:09AM +0200, Hannu Krosing wrote:
Comments? I nothinig found about OO in the current TODO.
I'm writing a small proposal for evoving inheritance and other OO
features in 7.4 and beyond. Will post once 7.3 is out.
Good! I look forward.
BTW, my
examples are
Peter Eisentraut wrote:
Matlab has a toolbox fucntion, claiming maximum precision, to convert
from its double type (PostgreSQL float8) to string which does a
sprintf('%25.18g',number).
Do we have some mathematical guarantee that this is sufficient and
necessary? If so, then it might do.
Stephan Szabo wrote:
On Tue, 29 Oct 2002, Peter Eisentraut wrote:
Pedro Miguel Frazao Fernandes Ferreira writes:
Is there a way to set query output precision to maximum precision ?
For the type of application I mentioned this is crucial. People want to
get the 'same' numbers, from querys or
Bruno Wolff III wrote:
On Tue, Oct 29, 2002 at 23:19:05 +0100,
Peter Eisentraut [EMAIL PROTECTED] wrote:
There isn't a way right now, but it's planned to be able to dump
floating-point numbers in some binary form (like printf(%A)) to be able
to restore them exactly. Not sure how that would
Tom Lane wrote:
static inline int32
StaticApplySortFunction(FmgrInfo *sortFunction, SortFunctionKind kind,
Datum datum1, bool isNull1,
Datum datum2, bool isNull2)
{
//etc.
}
int32
ApplySortFunction(FmgrInfo *sortFunction, SortFunctionKind kind,
Datum datum1, bool isNull1,
Bruce,
Not sure. I know Tom Lane ran a check on 10.1.x and didn't have any
errors, so I figured the differences I saw reflected changes made by
Apple between 10.1.x and 10.2.x. Then, I was surprised when I saw Adam's
report, so I thought perhaps he was running on a PPC G3 and there were
On 29/10/02 1:50 pm, Tom Lane [EMAIL PROTECTED] wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Strange. I just got report from another OSX 10.2.1 user saying
regression tests passed:
10.2.1, Adam Witney ([EMAIL PROTECTED]
The proper value seems to be:
15.3864610140472
or
I have a client that I am developing a web-based business application for
using Perl / PHP, DHTML, and postgreSQL on a FreeBSD server with Apache...
The client realized (or hopes) that this application may become mission
critical (to his clients / end-users) and was asking about the possibility
Yaroslav Dmitriev kirjutas K, 30.10.2002 kell 13:48:
Hello,
OK
select 1 as ccc where 1=1
ERROR
select 1 as ccc where ccc=1
PostgreSQL said: ERROR: Attribute 'ccc' not found
Is there any way to set conditions on calculated fields values?
You could try using a subquery
select *
from
You might want to check out
http://gborg.postgresql.org/genpage?replication_research which has
information and links to several replication solutions for postgresql.
the techdocs.postgresql.org website also has a good number of papers
regarding replication, as well as a high availability how-to
On Tue, Oct 29, 2002 at 03:56:46PM -0800, Greg Patnude wrote:
I have read through all 7 chapters of the PG documentation and didn't see
anything about replicating a postgreSQL database on a secondary database
server and having the primary server push all data manipulations on through
to the
On Wed, Oct 30, 2002 at 10:18:47AM -0500, Robert Treat wrote:
regarding replication, as well as a high availability how-to that
would probably be worth reading.
The high availability howto suggests using rsync to synchronise the
data areas of two data servers. That is an _extremely bad_ idea.
On Wed, 30 Oct 2002, Pedro Miguel Frazao Fernandes Ferreira wrote:
Stephan Szabo wrote:
On Tue, 29 Oct 2002, Peter Eisentraut wrote:
Pedro Miguel Frazao Fernandes Ferreira writes:
Is there a way to set query output precision to maximum precision ?
For the type of application I
Stephan Szabo wrote:
On Wed, 30 Oct 2002, Pedro Miguel Frazao Fernandes Ferreira wrote:
Stephan Szabo wrote:
On Tue, 29 Oct 2002, Peter Eisentraut wrote:
Pedro Miguel Frazao Fernandes Ferreira writes:
Is there a way to set query output precision to maximum precision ?
For the type of
Paul Ramsey [EMAIL PROTECTED] writes:
Now, if we changed the geometry type so that when one defined a geometry
column, one had to include info about what SRID and what dimension it
was, (ala varchar(243)) maybe the whole schmeer could reside in pg_class
and geometry_columns would be a
I'm glad to tell that I compiled and run regression tests ok on unixware
711 and 712 (Openunix 800) as well as on mac OS X 10.2.1 (execpt for
float8)
However, I'm still struggling to make plperl work on perl 561 and
Unixware.
I've scanned te Web and every thing without comming to a clue of what
On Wed, 2002-10-30 at 12:08, Olivier PRENANT wrote:
I'm glad to tell that I compiled and run regression tests ok on unixware
711 and 712 (Openunix 800) as well as on mac OS X 10.2.1 (execpt for
float8)
However, I'm still struggling to make plperl work on perl 561 and
Unixware.
I've
On 30 Oct 2002, Larry Rosenman wrote:
Date: 30 Oct 2002 12:14:01 -0600
From: Larry Rosenman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] 7.3b3 ok on unixware 71[12] here
On Wed, 2002-10-30 at 12:08, Olivier PRENANT wrote:
I'm glad to tell that I
Bruce Momjian [EMAIL PROTECTED] writes:
I did some research on this. It turns out the parser uses 0 for ALL, so
when you do a FETCH ALL it is passing zero. Now, when you do MOVE 0,
you are really asking for FETCH ALL and all the tuples are thrown away
because of the MOVE.
Yeah. I think
Bruno Wolff III writes:
On Tue, Oct 29, 2002 at 23:19:05 +0100,
Peter Eisentraut [EMAIL PROTECTED] wrote:
There isn't a way right now, but it's planned to be able to dump
floating-point numbers in some binary form (like printf(%A)) to be able
to restore them exactly. Not sure how
On Wed, Oct 30, 2002 at 08:27:37 -0600,
Bruno Wolff III [EMAIL PROTECTED] wrote:
Do default expressions execute with access of the user doing the insert
or the owner of the table?
What I was thinking was that the owner of a table may want to allow people
to do inserts into a table and update
On Wed, 30 Oct 2002, Pedro M. Ferreira wrote:
Stephan Szabo wrote:
On Wed, 30 Oct 2002, Pedro Miguel Frazao Fernandes Ferreira wrote:
I understand that if people insert a value of 1.1 in a double, they want
to get 1.1 without knowing that in fact the stored number is
1.10009.
Debian GNU/Linux unstable version, build from source on i386 SMP (dual
Athlon MP): all regression tests passed.
Change to source required: add CFLAGS += -D_GNU_SOURCE in
src/pl/plperl/GNUMakefile.
./configure --enable-recode --with-pgport=5678 --with-tcl
--with-perl --with-python
I have reviewed your diff and found that it was either timezone changes
or join.sql which I have recently fixed. Can you grab current CVS
snapshot and try again?
---
Ian Barwick wrote:
On Tuesday 29 October 2002 01:56,
Ah, so Ben finally got around to posting here. Ben's a CS Grad student
here at Rice. His (current) project involves taking some interesting
results from constraint satisfaction and implementing them on a database:
one of the CS faculty has demonstrated that one class of highly joined
DB queries
Stephan Szabo [EMAIL PROTECTED] writes:
On Wed, 30 Oct 2002, Pedro M. Ferreira wrote:
I looked at some of these emails and it seemed to me that the problem
was that Tom did'nt want a parameter that would force people to know
about printf number formatting. I think the first solution above (the
Ross J. Reedstrom [EMAIL PROTECTED] writes:
So, in the interim, Ben's trying to do it by hand: preorder the joins
and demonstrate that the 'best' order is in fact the best. Then move on
to looking into integrating this, if possible: part of the problem is
recognizing the structure of the
Peter Eisentraut wrote:
Bruce Momjian writes:
So, that is why MOVE 0 goes to the end of the cursor. One idea would be
for MOVE 0 to actually move nothing, but jdbc and others need the
ability to move the end of the cursor, perhaps to then back up a certain
amount and read from there.
Bruce Momjian [EMAIL PROTECTED] writes:
The following patch makes FETCH/MOVE 0 do nothing, and FETCH LAST move
to the end.
Do not hack up PerformPortalFetch; put the special case for INT_MAX in
utility.c's FetchStmt code, instead. As-is, you probably broke other
callers of PerformPortalFetch.
Dear Sir,
I use SCO Open Server 5.0.5 on an intel box. Although I have installed and
used PostgreSQL on Linux, setting it on SCO has not been smooth :)
I have downloaded the latest version ie Postgresql-7.2.3.
I also installed ant package for using java. I have tcl8.0, tk8.0,
itclsh3.0 and
66 matches
Mail list logo