Hello!
Can anybody tell me the website from which I can download PostgreSQL for
Windows95.
With regards,
Sourabh
On Mon, 5 Feb 2001, Myron Scott wrote:
I have put a new version of my multi-threaded
postgresql experiment at
http://www.sacadia.com/mtpg.html
This one actually works. I have added a server
based on omniORB, a CORBA 2.3 ORB from ATT. It
is much smaller than TAO and uses the thread
"Tom Lane" [EMAIL PROTECTED] writes:
Well, my question still stands: why aren't the other four flex outputs
also broken? They all use ECHO.
I don't know why, but probably you are right. I only know that if ECHO was
not redefined, when I compile with ecpg the output c file has all the
Quoting sourabh dixit [EMAIL PROTECTED]:
Hello!
Can anybody tell me the website from which I can download PostgreSQL
for Windows95.
I'm not sure if it will run under Win95, but I have it running fine under NT
using Cygwin and WinIPC.
While my linux box was down, I had to use it under NT
I'd like to have pg_dump for 7.1 produce "timestamp with time zone" when
dealing with timestamp type(s). That will prepare us for introducing a
timestamp type without time zones, while allowing reasonable upgrades to
7.2.
But the current timestamp does not store a timezone. timestamp with
Hello,
probably you remember my crazy idea involving using indexes
directly in scans (and resulting speedup).
The idea was given to me by experiences with M$SQL (it is
yes another M$ soft but its planner is probably better
than pg's - no flames please).
Because I studied M$ again I've got
Hi,
after make clean, make failed with message:
make[2]: Entering directory /home/postgres/cvs/pgsql/src/backend'
prereqdir=`cd parser/ pwd` \
cd ../../src/include/parser/ rm -f parse.h \
ln -s $prereqdir/parse.h .
ln: ./parser: File exists
make[2]: ***
Am Sonntag, 4. Februar 2001 20:12 schrieben Sie:
Mario Weilguni [EMAIL PROTECTED] writes:
float8 num3 = numeric_float8(num1);
That won't work in the brave new world of 7.1 :-(. You need to do
something like
float8 num3 = DatumGetFloat8(DirectFunctionCall1(numeric_float8,
On Sun, 4 Feb 2001, Peter Eisentraut wrote:
Ryan Kirkpatrick writes:
postgresql - This is a Linux distribution independent (or so I
hope) init.d/rc.d script that makes use of pg_ctl. There is currently a
few in ./contrib/linux of the pgsql source tree, but they are RedHat
Yes, I have the same problem...
pgaccess also can't see any Views...
"Steve Shaffer" [EMAIL PROTECTED] escreveu nas notícias de
mensagem:[EMAIL PROTECTED]
Developers,
Pgsql v7.1 beta4
ODBC v6.50.00.00
RedHat v6.2
I upgraded from 7.03 to 7.1 beta4 yesterday see the following
For a project we are working on, I have created a custom postgresql data
type which is similar to MS SQL Server's uniqueidentifier data type. It uses
dynamic link library extension that calls the FreeDCE library to generate
GUIDs. Support for the data type and support functions is added to a
PHP can run java code. It would be easiest, because php doesn't parse php
pages, the Zend engine is linked to php to actually parse. Which would
make Zend easy to add into Postgresql, (which already runs under apache,
which is non-threaded).
The only issue is the Zend license..
Of course, this
Hello,
probably you remember my crazy idea involving using indexes
directly in scans (and resulting speedup).
The idea was given to me by experiences with M$SQL (it is
yes another M$ soft but its planner is probably better
than pg's - no flames please).
Because I studied M$ again I've got
On Tue, 6 Feb 2001, Tom Lane wrote:
Oleg Bartunov [EMAIL PROTECTED] writes:
make[2]: Entering directory /home/postgres/cvs/pgsql/src/backend'
prereqdir=`cd parser/ pwd` \
cd ../../src/include/parser/ rm -f parse.h \
ln -s $prereqdir/parse.h .
ln: ./parser: File exists
Oleg Bartunov writes:
after make clean, make failed with message:
make[2]: Entering directory /home/postgres/cvs/pgsql/src/backend'
prereqdir=`cd parser/ pwd` \
cd ../../src/include/parser/ rm -f parse.h \
ln -s $prereqdir/parse.h .
ln: ./parser: File exists
make[2]: ***
On Tue, 6 Feb 2001, Myron Scott wrote:
There are many many globals I had to work around including all the memory
management stuff. I basically threw everything into and "environment"
variable which I stored in a thread specific using thr_setspecific.
Yes, it's good. I working on
On Sun, 4 Feb 2001, Peter Eisentraut wrote:
Ryan Kirkpatrick writes:
postgresql - This is a Linux distribution independent (or so I
hope) init.d/rc.d script that makes use of pg_ctl. There is currently a
few in ./contrib/linux of the pgsql source tree, but they are RedHat
Certain include files are installed by src/include/Makefile and by
interfaces/libpq++/Makefile. However, they in turn include others that
are not installed, thus obviating the usefulness of the ones that are.
The missing files are these:
access/heapam.h
access/htup.h
access/relscan.h
On Mon, Feb 05, 2001 at 09:17:45PM -0500, Tom Lane wrote:
Yes, on looking at it I see that someone broke PQoidStatus() in 7.0.
If you want to fix your copy, the patch (line numbers are for current
CVS) is
Index: fe-exec.c
Rick Robino writes:
psql starts up with readline support turned on by default. If readline/curses
is broken, this may show up at runtime as a pq_recvbuf error and a core dump.
psql isn't obvious about the relationship to readline, creating a mystery for
first-timers.
Since it is readline,
*** fe-exec.c 2001/01/24 19:43:30 1.98
--- fe-exec.c 2001/02/06 02:02:27 1.100
***
*** 2035,2041
if (len 23)
len = 23;
strncpy(buf, res-cmdStatus + 7, len);
! buf[23] = '\0';
return buf;
}
--- 2035,2041
On Tue, Feb 06, 2001 at 01:21:00PM -0500, Bruce Momjian wrote:
What if len 23?
mea culpa. Must go eat lunch. No sugar to brain. (and no, I didn't put
the original error in :-)
Ross
On Tue, Feb 06, 2001 at 01:21:00PM -0500, Bruce Momjian wrote:
*** fe-exec.c 2001/01/24 19:43:30 1.98
--- fe-exec.c 2001/02/06 02:02:27 1.100
***
*** 2035,2041
if (len 23)
len = 23;
strncpy(buf,
On Tue, 6 Feb 2001, Guest User wrote:
Apologies if this is the wrong place to send a question
Please use, hackers (or other PG) list. More heads more know, more
eyes more view :-)
Do you know if there is a patch for this bug and if so where I might be
able to find it? I think I'm using
On Tue, Feb 06, 2001 at 11:08:49AM -0500, Mathieu Dube wrote:
Hi y'all,
Is it a bad idea for an app to keep just a couple of connections to a
database, put semaphore/mutex on them and reuse them all through the program?
Of course I would check if their PQstatus isnt at
Well actually this particular connection is just for selects...
On Tue, 06 Feb 2001, you wrote:
On Tue, Feb 06, 2001 at 11:08:49AM -0500, Mathieu Dube wrote:
Hi y'all,
Is it a bad idea for an app to keep just a couple of connections to a
database, put semaphore/mutex on them and reuse
Oliver Elphick wrote:
Certain include files are installed by src/include/Makefile and by
interfaces/libpq++/Makefile. However, they in turn include others that
are not installed, thus obviating the usefulness of the ones that are.
The missing files are these:
[snip]
The list can be
Karel Zak wrote:
On Tue, 6 Feb 2001, Oliver Elphick wrote:
Certain include files are installed by src/include/Makefile and by
interfaces/libpq++/Makefile. However, they in turn include others that
are not installed, thus obviating the usefulness of the ones that are.
In your module
su - postgres sh -c "$DAEMON stop /dev/null"
Hmm... What is wrong here, besides the ''? The '' can be
replaced with '21 ' if that is more standard.
It won't do what you want. You want '/dev/null 21'.
Change made.
Hmmm, I don't see this change in cvsweb.
Florent
--
[EMAIL
su - postgres sh -c "$DAEMON stop /dev/null"
Hmm... What is wrong here, besides the ''? The '' can be
replaced with '21 ' if that is more standard.
It won't do what you want. You want '/dev/null 21'.
Yes, I knew he wanted /dev/null 21. I just fixed it.
Change made.
(In psql:)
I need to modify the 2nd prompt. So i looked at the sources:
I leave the validity test (of the name of the option/param) to SetVariable !!
Here is the patch:
diff -c /internet/cvs/pgsql/src/bin/psql/command.c.~1~
/internet/cvs/pgsql/src/bin/psql/command.c
***
Because pset sets parameters of the table output. Prompts have nothing to
do with table output.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Hi,
I've written a small function that should go into contrib for 7.1
As locale issues are quite tricky, being able to find out what locale
backend thinks it is in is a good thing ;)
from my README.getlocale:
getlocale('category')
-
return the locale setting of the
[EMAIL PROTECTED] (Nathan Myers) writes:
Thus, the original code is OK, except probably the literal "23"
in place of what should be a meaningful symbolic constant, or
(at least!) sizeof(buf) - 1.
No, the original code is NOT ok. Read the man page again. As the
code stood, the only null that
On Tue, Feb 06, 2001 at 07:08:20PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (Nathan Myers) writes:
Thus, the original code is OK, except probably the literal "23"
in place of what should be a meaningful symbolic constant, or
(at least!) sizeof(buf) - 1.
No, the original code is NOT ok.
Tom Lane wrote:
I agree with Karel on this --- it's difficult to visualize doing useful
SPI work without a source tree at hand, and it also seems unlikely that
SPI authors would get along for long with *only* those header files
needed to pull in spi.h. So I think it's pretty pointless to add
On Tue, Feb 06, 2001 at 06:17:46PM -0600, Ross J. Reedstrom wrote:
Seems it's a non-portable behavior:
The strncpy() function is similar, except that not more
than n bytes of src are copied. Thus, if there is no null
byte among the first n bytes of src, the result
Joe Mitchell [EMAIL PROTECTED] writes:
I noticed that pg_attribute has rows with the same OID!
Joe previously asked me about this off-list, and I replied thus:
This appears to be due to the incredibly grotty coding used in
AppendAttributeTuples in src/backend/catalog/index.c --- rather than
I agree with Karel on this --- it's difficult to visualize doing useful
SPI work without a source tree at hand, and it also seems unlikely that
SPI authors would get along for long with *only* those header files
needed to pull in spi.h. So I think it's pretty pointless to add just
those
"Ross J. Reedstrom" [EMAIL PROTECTED] writes:
Seems it's a non-portable behavior:
Not at all. The code is asking strncpy to copy n bytes, where n is
known to be = strlen of the source string. Every spec-conforming
implementation of strncpy will copy n bytes, no more, no less, and
will *not*
Good catch, Joe! This bug has probably been there since the beginning
of time. It's evidently got no serious consequences (since in reality,
OID uniqueness is not assumed for this table), but it ought to be fixed.
A quick-hack solution would be to zero out the tuple's OID before each
Lamar Owen [EMAIL PROTECTED] writes:
Tom Lane wrote:
What would make more sense is for the standard install to install only
those headers needed for *client side* programming, and then to have
an optional install target that installs the whole darn src/include
tree.
I can go for that.
The man page suggests that nohup is required to init postmaster, I
know this isn't true but to implement an example init file and not
match up with the man page seemed foolish.
I guess nohup would stop postmaster doing something awfull if it
doesn't handle HUP properly but I very much
Is it a feasible idea that PostgreSQL could detect when an index would be
handy, and create it itself, or at least log that a table is being queried
but the indices are not appropriate?
I suggest this as it's a feature of most windows databases, and MySQL does
it. I think it would be a great
* Christopher Kings-Lynne [EMAIL PROTECTED] [010206 18:29] wrote:
Is it a feasible idea that PostgreSQL could detect when an index would be
handy, and create it itself, or at least log that a table is being queried
but the indices are not appropriate?
I suggest this as it's a feature of
Reliable rumor has it that Deja.com (formerly Dejanews) is going out of
business, possibly as early as this week, and pulling the plug completely
(I worked there '97-'99). They've already laid off all but a small
handful of the peak of ~125 employees. That was the premier source for
technical
46 matches
Mail list logo
