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 th
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.
I am also checking for another problem.
I have some errors if I compile pgsql without change the typedef Size in
c.h.
To succesfully compile pgsql I
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.
--- Forward
>
> > 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. O
> IMHO use numeric and some formatting routine is good idea (better than
> current money datetype..)
The "money" type implementation was a workaround/hack to make up for the
lack of a "numeric" type. I've always assumed that it would be removed
as soon as numeric was available and fast enough to
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
"Oliver Elphick" <[EMAIL PROTECTED]> writes:
> 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 th
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
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 1024
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 ?? ()
>
>
You need to compile PostgreSQL from source with -g ..
ftp.postgresql.org is the main FTP, there are many mirrors. Look for the
source tarball there..
-Mitch
- Original Message -
From: "Mathieu Dube" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Mon
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> You need to compile PostgreSQL from source with -g ..
> ftp.postgresql.org is the main FTP, there are many mirrors. Look for the
> source tarball there..
>> Im currently using rpms
>> is there a way to just remove an rpm(the API one) and compile only
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
"easy"
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
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_ '--w
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 to
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 what
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 c
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 po
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 willi
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
T
> Subject: like vs '='
>
> I have a function to transform text into a
> pseudo-metaphone variable, take this
> example:
>
> cddbsql=# select song, metatext(song) from cdsongs
> where metatext(song) like
> metatext('born to run') limit 3 ;
> song | metatext
> -+--
> B
Thus spake Bruce Momjian
> It is 3.1 already. The problem is that Announce says 3.1, while the
> README says 2.5. I am CC'ing the author to update it.
>
> > I got a bug report on the PyGreSQL version included with PostgreSQL 7.0.3:
> >
> > "version 3.1 pygresql is available and there's also a
* Mathieu Dube <[EMAIL PROTECTED]> [010205 09:32] wrote:
> 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: l
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
Hello,
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?
--
Best regards,
anson mailto:[EMAIL PROTECTED]
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.
My question: What is the licence of this file. Can I distribute is under GPL?
the file is at:
http://maruska.dyn
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 just
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
Hi Guys,
please tell me how to get software from
you.
I found no way to download any
software.
Best Regards
Kai
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
throu
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 compi
Which file should I read the symbol from??
On Mon, 05 Feb 2001, Mitch Vincent wrote:
> You need to compile PostgreSQL from source with -g ..
>
> ftp.postgresql.org is the main FTP, there are many mirrors. Look for the
> source tarball there..
>
> -Mitch
>
> - Original Message -
> From:
>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.postgresq
>>> 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
>> b
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 conne
Michal Maru¹ka 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
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 Vielhabe
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
maint
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 ju
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 existing
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 tha
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, a
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
* 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
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
www
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
patc
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 abo
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 0x400
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 commi
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 withi
"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.
nohup has a performance cost, in that (at least on Linux) it automaticall
"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, w
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, to
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 tri
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
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
[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 t
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 usesys
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
> > 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_c
> "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
> > 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 corre
> 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 que
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,
79 matches
Mail list logo
