On Wed, 30 Oct 2002, Tom Lane wrote:
> 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
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 PerformPortalFetc
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
---
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 l
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
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
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" do
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 jav
"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 th
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 gc
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 ab
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 map
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 an
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, Br
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 --with
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.1000
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 pro
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
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 r
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 t
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 u
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. T
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 are
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,
for
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
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 $(
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 PROTEC
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 w
On Wed, 30 Oct 2002, Pedro Miguel Frazao Fernandes Ferreira wrote:
> In C this is possible:
>
> #include
> #include
>
> 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)
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
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
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
> >
> >
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
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 thin
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 tel
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'v
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
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 t
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 take
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
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 applicati
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 s
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 s
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.
Ena
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 typ
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_ ide
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 th
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"
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
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
of
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
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" an
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 alias96.I
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
>>
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
differ
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
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,
> >>
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 posting
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 woul
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
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.
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 Cr
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 tab
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
> > exam
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(3
> -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
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', ('Somes
67 matches
Mail list logo