On Sat, 3 Feb 2001, Dave Mertens wrote:
On Sat, Feb 03, 2001 at 11:39:29AM -0500, Mitch Vincent wrote:
What's the standard on Money type (if there is one) and if it doesn't
include the $ (of course that would change based on what currency you were
using) then is it any different than
Has anyone got PostgreSQL 7.0.3 working on m68k architecture?
Russell is trying to install it on m68k and is consistently getting a
stuck spinlock in initdb. He used to have 6.3.2 working. Both 6.5.3
and 7.0.3 fail.
His message shows that the first attempt to set a lock fails.
---
scan.c:2145: warning: `yy_fatal_error' defined but not used
I have a sneakier idea to avoid the warning. [...]
#define fprintf(file,fmt,msg) elog(FATAL, "%s", (msg))
Meaning no disrespect : yuck... IMHO this is asking for trouble
whenever someone decides to use another yacc. One
I just do a select on a user table with the username and password
pretty upfront and normal query
you would like me to use PQtrace???
it doesnt say much
if I do bt on gdb it says: 0x4b3003d in ?? ()
On Mon, 05 Feb 2001, you wrote:
Mathieu Dube [EMAIL PROTECTED] writes:
If I remove the
Mathieu Dube [EMAIL PROTECTED] writes:
If I remove the function where I authenticate my server can handle as
much clients as I want.
Which authentication method do you use?
If I authenticate every clients with connections to the database it
crashes on PQconnectdb at th 1024th
Im currently using rpms
is there a way to just remove an rpm(the API one) and compile only that??
where can I find libpq sources?
my app is already compiled with -g
On Mon, 05 Feb 2001, you wrote:
Mathieu Dube [EMAIL PROTECTED] writes:
if I do bt on gdb it says: 0x4b3003d in ?? ()
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.
Comments? Would a pg_dump guru be willing to take this on? Should be
Tom Lane writes:
"fast" shutdown should be the default, otherwise you may get surprises on
system shutdown when users are still connected.
No, I don't think so. During a system shutdown, init will deliver
SIGTERM to all the backends as well as the postmaster, so the backends
will die
To build the PostgreSQL ODBC driver from CVS (or a recent
snapshot/beta, I presume): the following steps worked for me:
+ Make sure that the psqlodbc.def file in interfaces/odbc is exactly
as distributed or obtained from CVS, not the result of some prior build.
+ Run 'configure' _without_
A command-line option for specifying the logfile would be very helpful
on WIN32.
When setting up PostgreSQL to run as an NT service, the only way I can
see to redirect stdout/stderr to a file is to invoke postmaster via a
wrapper sh/bash process. I suspect that this wrapper process would
have
cc -o therver therver.c -g -lflipr -lpq -L. -lpthread -D_REENTRANT
./libpq.a(fe-auth.o): In function `pg_password_sendauth':
/usr/local/postgresql-7.0.3/src/interfaces/libpq/fe-auth.c:465: undefined reference to
`crypt'
collect2: ld returned 1 exit status
make: *** [therver] Error 1
this is
On Mon, 5 Feb 2001, Philip Warner wrote:
PGSQL implements PK/FK Unique constraints by using indexes (and rules) at
the moment. There is no guarantee that this will always be the case - in
fact, one path to rationalizing the constraints system is to implement most
features as SQL CHECK
Peter Eisentraut wrote:
Tom Lane writes:
"fast" shutdown should be the default, otherwise you may get surprises on
system shutdown when users are still connected.
No, I don't think so. During a system shutdown, init will deliver
SIGTERM to all the backends as well as the postmaster,
Thomas Lockhart writes:
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.
Comments? Would a pg_dump guru be willing to
I suppose the below reference isn't intended to be done. But, I'd
like to extend the pg_shadow table to store information about the
database users and some of their actions (a history of changes).
Is it safe to add a UNIQUE constraint to the usesysid or usename
columns?
temp=# \d pg_shadow
Hi there,
I am compiling postgresql 7.1beta4. How would i change the default 8k
row limit?
--
Manny C. Cabido
e-mail:[EMAIL PROTECTED]
This is very odd. I have a database app failing sometimes with an error
when I try to get back my inserted row. I do this to get all the fields
that were adjusted for defaults, triggers and rules. On an insert query
I expect to get the OID of the just inserted tuple. Once in a while I
get the
This is the debug output for the last query that seems to be throwing PHP
into a fit (a fit that somehow closes the backend connection - note, it
doesn't crash, it just closes)..
I don't think anything is going on here that shouldn't be, it looks the same
as any other query that succeeds.. I
Hi,
Im building a server that uses libpq to connect to a database and
authenticate the users that connect.
I do PQfinish for the conn and PQclear for the result so there cant be
a memory leak there.
If I remove the function where I authenticate my server can handle as
much
Title: Parallel queries
All,
How hard would it be to get a back end to hand off parts of a query tree to other back ends (which it created), and then collate the results, and take it from there? Obviously, it would only do this under certain conditions, specifically, if it was compiled in
Hi,
Im building a server that uses libpq to connect to a database and
authenticate the users that connect.
I do PQfinish for the conn and PQclear for the result so there cant be
a memory leak there.
If I remove the function where I authenticate my server can handle as
much
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 problem.
After the upgrade, applications like Crystal Reports, MS Query, Brio, etc.
now do not see the catalog of tables and fields in the database, login is
There isn't any row or query size limit in 7.1 thanks to TOAST!
-Mitch
- Original Message -
From: "Manuel Cabido" [EMAIL PROTECTED]
To: "m w" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, January 29, 2001 10:18 PM
Subject: Re: Like vs '='
Hi there,
I am compiling
From which file should I load the symbol for gdb??
Thanks
-Mat
On Mon, 05 Feb 2001, you wrote:
"Mitch Vincent" [EMAIL PROTECTED] writes:
You need to compile PostgreSQL from source with -g ..
ftp.postgresql.org
Bruce Momjian [EMAIL PROTECTED] 04-Feb-01 10:07:40 PM
The bottom line is that, IMHO, writing a portable
init.d style (or any other such concept) startup file
that is ready for blind use is beyond practicality.
It might be better to collect a few of the ones that are
being used now
In the PHP bugs I see...
===[PostgreSQL
related]===
5862 Open Consecutive pg_open statements cause second statement to
fail
6525 Open Connection problem
7007 Open The pg_close function doesn't close the connection.
Michal Maruka writes:
I have started trying to make the emacs' psql experience more comfortable.
I transformed (with sed(1) manually) the C-source to elisp program.
Now I want to improve it.
Interesting. Is the reason that you need this the fact that psql doesn't
use readline when run in
Fred Yankowski writes:
To build the PostgreSQL ODBC driver from CVS (or a recent
snapshot/beta, I presume): the following steps worked for me:
[snip]
+ Run 'configure' _without_ '--with-odbc' to build PostgreSQL.
I doubt you need that, since you don't use the makefiles.
[snip]
Building
On Sun, 4 Feb 2001, Kajetan Hofman wrote:
Hi Guys,
please tell me how to get software from you.
I found no way to download any software.
Did you try the "Software" link on the website?
Vince.
--
==
Vince Vielhaber --
We are currently developing a java RMI Server to manage database backup on
FreeBSD 4.1 running Postgres 7.0.2 (we plan to upgrade to 7.1 when it is
released). The server will pg_dump individual tables and entire databases
at specified intervals and manage backup verification and backup file
On Mon, Feb 05, 2001 at 08:06:28PM +0100, Peter Eisentraut wrote:
+ Run 'configure' _without_ '--with-odbc' to build PostgreSQL.
I doubt you need that, since you don't use the makefiles.
I stated that point for the benefit of those, like me, who are
building all of PG from source, not just
Hello
A few weeks ago I was interested in this question. My results were:
- Yes, this is a sorrowful but true fact that if you enable access to
someone to a database, she is automatically enabled to create
objects in it.
- Yes, the developers know it, and they said: there is a patch
Peter Eisentraut [EMAIL PROTECTED] writes:
Can somebody explain to me what this means, from said readme.txt:
"In order to use row versioning, you must overload the int4eq function for
use with the xid type."
Apparently, there is something in either the ODBC driver itself or MS
Access that
even after compiling with -g and using the libpq.a it still outputs that on the
bt after the crash...
(gdb) bt
#0 0x40050768 in ?? ()
#1 0x4004ff25 in ?? ()
#2 0x804a3cd in main (argc=3, argv=0xb8e4) at therver.c:430
#3 0x400739ee in ?? ()
--
Mathieu Dube
Mondo-Live
If I write a function that does a 'tolower()' on each
character of a parameter passed into my function, do I
have to allocate a new text object and initialize it
and copy the data, or can I modify that object in
place and return it?
Modifying it in place will save the overhead of an
alloc call,
Tom Lane writes:
Peter Eisentraut [EMAIL PROTECTED] writes:
To alleviate the need for a start up script somewhat we could perhaps fix
up pg_ctl to serve that purpose better.
-w should be the default, as has been suggested.
Agreed.
But we need to make up a better way to wait for
* Mikheev, Vadim [EMAIL PROTECTED] [010202 10:39] wrote:
After several weeks our idicies grow very large (in one case to
4-5 gigabytes) After droppping and recreating the indecies they
shrink back to something more reasonable (500megs same case).
We are currently using Vadim's vacuum
So...
If after recompiling postgres with -g in the CFLAGS and still getting 0x40050768 in ??
()
in gdb, should I look elsewhere???
Thanks
-Mat
--
Mathieu Dube
Mondo-Live
Hi there,
I am compiling postgresql 7.1beta4. How would i change the 8k row
limit?
--
Manny C. Cabido
e-mail:[EMAIL PROTECTED]
Hrm- I'd love to know where this patch is. I don't see how that quite
breaks PG_DUMPALL though. Really if your logged in as a superuser
(postgres) you should be able to use all the databases and dump all of the
data. Am I the only one that doesn't see where the problem is? How about a
I wanted to get pgaccess working under win32 with MSVC 6. It relies on the
libpgtcl library, which didn't have a win32.mak. This turned out to be (I
think) because Tcl_CreateFileChannel function isn't portable to win32 systems.
So I grabbed the relevant files from CVS (no tags), and hacked
On Mon, 05 Feb 2001, you wrote:
You're not backtracing the same core file as before, are you?
???
I dont see what you mean
I build postgresql with -g and then put libpq.a in my project's dir
all my files are compiled with -g too
the only other thing I use is posix threads
How do I know what
post the rest of the traceback.
0x40* is the address inside some shared library, most likely libc.
full traceback will show what happened before it got to libc
-alex
On Mon, 5 Feb 2001, Mathieu Dube wrote:
So...
If after recompiling postgres with -g in the CFLAGS and still getting
Well, I'm not sure about the spec precisely, but I found
out how Oracle seems to handle the delete/insert, etc
cases for at least on delete cascade.
It seems that they do the action (other than no action
obviously) immediately upon the statement, but still
defer the check for validity until
At 11:09 5/02/01 -0800, Peter Schmidt wrote:
If I pg_dump a single table which has a foreign key constraint, and
subsequently backup the constraint table, won't the data be out of sync?
Each pg_dump will run in it's own transaction, right?
Yes.
Is there a way to dump multiple tables within a
"Oliver Elphick" [EMAIL PROTECTED] writes:
"Nic Ferrier" wrote:
- the postmaster was being started without nohup
If postmaster is being started by init, it should not need nohup, because
init never exits and postmaster is not going to get shutdown unexpectedly.
On the other hand, when
m w [EMAIL PROTECTED] writes:
If I write a function that does a 'tolower()' on each
character of a parameter passed into my function, do I
have to allocate a new text object and initialize it
and copy the data, or can I modify that object in
place and return it?
You must NEVER alter a
Philip Warner [EMAIL PROTECTED] writes:
If it is dumped as inserts you will get RI errors. If done via copy then
some but not all constraints will be evaluated - I think that COPY does not
fire triggers.
Say what? COPY certainly does fire triggers ...
regards, tom
At 20:16 5/02/01 -0500, Tom Lane wrote:
Philip Warner [EMAIL PROTECTED] writes:
If it is dumped as inserts you will get RI errors. If done via copy then
some but not all constraints will be evaluated - I think that COPY does not
fire triggers.
Say what? COPY certainly does fire triggers ...
Philip Warner [EMAIL PROTECTED] writes:
Say what? COPY certainly does fire triggers ...
Is there any difference between COPY and INSERT other than speed?
COPY does not fire ON INSERT rules. Other than that, AFAIR they're
the same from an integrity point of view.
--- Tom Lane [EMAIL PROTECTED] wrote:
m w [EMAIL PROTECTED] writes:
If I write a function that does a 'tolower()' on
each
character of a parameter passed into my function,
do I
have to allocate a new text object and initialize
it
and copy the data, or can I modify that object in
I tell you what I'd like to see in PHP. If you're using a Postgres
persistent connection, and it detects a 'BEGIN TRANSACTION' going thru, once
that script has finished, the connection should not be returned to the
connection pool.
Chris
-Original Message-
From: [EMAIL PROTECTED]
Bruce said he and Rasmus (from PHP devel) were fixing this. That'll be
great!
-Mitch
- Original Message -
From: "Christopher Kings-Lynne" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 8:55 PM
Subject: RE: Re: PostgreSQL - PHP problem
I tell you what I'd like
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes:
Get: 31930584, should be 3193058
Get: 31943386, should be 3194338
As you can see, there is an extra digit added. I am using PQoidStatus()
to get the OID. Is this the right way? Is it possible that there is
a buffer/terminating problem in the
Mathieu Dube [EMAIL PROTECTED] writes:
even after compiling with -g and using the libpq.a it still outputs that on the
bt after the crash...
(gdb) bt
#0 0x40050768 in ?? ()
#1 0x4004ff25 in ?? ()
#2 0x804a3cd in main (argc=3, argv=0xb8e4) at therver.c:430
#3 0x400739ee in ?? ()
"Rod Taylor" [EMAIL PROTECTED] writes:
I suppose the below reference isn't intended to be done. But, I'd
like to extend the pg_shadow table to store information about the
database users and some of their actions (a history of changes).
Is it safe to add a UNIQUE constraint to the usesysid or
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 per
connection model. I haven't added the java
"Maurizio" [EMAIL PROTECTED] writes:
ECHO is defined in the following QNX gcc include files :
termio.h
termios.h
If ECHO was not redefined in pgc.l you can't compile in embedded SQL C.
Well, my question still stands: why aren't the other four flex outputs
also broken? They all use ECHO.
In
If postmaster is being started by init, it should not need nohup, because
init never exits and postmaster is not going to get shutdown unexpectedly.
On the other hand, when pg_ctl is invoked by hand, it probably is a bug
that it fails to use nohup. Perhaps this is a reason why pg_ctl
"Rod Taylor" [EMAIL PROTECTED] writes:
I suppose the below reference isn't intended to be done. But, I'd
like to extend the pg_shadow table to store information about the
database users and some of their actions (a history of changes).
Is it safe to add a UNIQUE constraint to the
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.
Did that.
Great!
But given that 'timestamp' is really
i would like to alter the column type which has exist in
the table, i can't find anything about that, can anybody help me?
To effectively alter the type of a column, you must do a "create
table"/"insert into"/"create table as" combination to make an
intermediate temporary table with the
How hard would it be to get a back end to hand off parts of a query
tree to other back ends (which it created), and then collate the
results, and take it from there? Obviously, it would only do this
under certain conditions, specifically, if it was compiled in to the
server, and the query
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
during the nightly vacuum pgsql closed and do not start any more.
Attached the log.
Seems the problem was rebuilding an Index,
There is a way to force wal to ignore indexes ?
The problem was in redoing tuple movement in *table*.
Can I delete it ?
...
DEBUG: redo starts at (6,
65 matches
Mail list logo