[HACKERS] I want tips for debugging deadlocks

2000-10-03 Thread Hannu Krosing
Hi, I'm in a situation where I urgently need to debug PostgreSQL 7.0.2 for deadlocks that it does not notice/timeout Where can I find info about running several concurrent backends under a debugger ? --- Hannu

Re: [HACKERS] AIX compile ?? libcrypt HELP !!

2000-10-03 Thread nathan
Tom Lane wrote: > Nathan Boeger <[EMAIL PROTECTED]> writes: > > I am trying to compile an app (compiles on *BSD, Linux) but for some > > reason I cant get it to compile on AIX 4.3.3.3. It seems not to like the > > libcrypt ?? > > > ld: 0711-317 ERROR: Undefined symbol: __crypt_r > > ld: 0711-317

[HACKERS] Re: [INTERFACES] C++ client libs

2000-10-03 Thread Tom Lane
Tim Allen <[EMAIL PROTECTED]> writes: > BTW, I'd urge you to keep the discussion public. The interfaces list might > be a good place, rather than hackers, but don't go hiding away in private > email or some other obscure place. 100% agreement here. pgsql-interfaces seems like the appropriate dis

[HACKERS] Re: Delimited identifier length

2000-10-03 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> Next question is do we want to change it? I can't imagine any real good >> use for a null-string name, but is there any risk of breaking existing >> applications? > I think the larger risk is breaking applications if we leave it

Re: [HACKERS] C++ client libs

2000-10-03 Thread Adam Haberlach
On Wed, Oct 04, 2000 at 12:38:35PM +1100, Tim Allen wrote: > >3) Implement asynchronous calls to the back-end permitting multiple > > queries to be executed concurrently > > Implement async calls, yes, definitely a good thing to do. But this by > itself doesn't buy you multiple queries concurr

[HACKERS] C++ client libs

2000-10-03 Thread Tim Allen
>I was wondering if anyone could offer me some pointers in extending the >C++ classes used for client applications? I'm interested in developing a >set of C++ classes which will interact directly with the postgres >back-end with the following enhancements to the current implementation: >These ar

[HACKERS] Version data type.

2000-10-03 Thread Ashley Cambrell
Hi all, Just wondering if anyone has already created a version data type where 1.100 > 1.10 > 1.9 > 1.01 etc... I don't want to reinvent the wheel... I was thinking that an array with a '.' as the delimeter would work best, but I don't know how ORDER BY 's work on arrays Thank You Ashley

[HACKERS] Re: Delimited identifier length

2000-10-03 Thread Peter Eisentraut
Tom Lane writes: > Next question is do we want to change it? I can't imagine any real good > use for a null-string name, but is there any risk of breaking existing > applications? I think the larger risk is breaking applications if we leave it this way. One such broken application is the form

[HACKERS] FW: oracle ate

2000-10-03 Thread elein
Hmm, no response on pgsql-general. Anyone up on oracle's implementation? elein == Elein Mustain [EMAIL PROTECTED] (510)420-3120 -Original Message- From: elein [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 6:41 PM To: [EMAIL PROTECTED] Cc: elein Subject

Re: [HACKERS] AIX compile ?? libcrypt HELP !!

2000-10-03 Thread Tom Lane
Nathan Boeger <[EMAIL PROTECTED]> writes: > I am trying to compile an app (compiles on *BSD, Linux) but for some > reason I cant get it to compile on AIX 4.3.3.3. It seems not to like the > libcrypt ?? > ld: 0711-317 ERROR: Undefined symbol: __crypt_r > ld: 0711-317 ERROR: Undefined symbol: __set

RE: [HACKERS] C++ client libs

2000-10-03 Thread Clark, Joel
>> If anyone has suggestions/additions to this list it would be greatly >> appreciated! > I'm very interested in helping with this (it is on my list of projects > and I've managed to stop adding new ones to the list for now). Should > we take this off-list, or keep it here? We

Re: [HACKERS] C++ client libs

2000-10-03 Thread Randy Jonasz
Thanks for responding so quickly. Your help would be most welcome. I need to do some further research as well before laying down an API. The company I work for has offered to set up a CVS box open to the public for developing this API. There's another person who has expressed interest in this p

[HACKERS] AIX compile ?? libcrypt HELP !!

2000-10-03 Thread Nathan Boeger
I am trying to compile an app (compiles on *BSD, Linux) but for some reason I cant get it to compile on AIX 4.3.3.3. It seems not to like the libcrypt ?? using: gcc version 2.95.2 19991024 (release) PostgreSQL 7.02 GNU Make version 3.79.1 ld ?? Flags: -I/usr/include/pgsql/ -lrts -lcrypt -L/usr/

Re: [HACKERS] C++ client libs

2000-10-03 Thread Adam Haberlach
On Tue, Oct 03, 2000 at 02:47:45PM -0400, Randy Jonasz wrote: > I was wondering if anyone could offer me some pointers in extending the > C++ classes used for client applications? I'm interested in developing a > set of C++ classes which will interact directly with the postgres back-end > with t

[HACKERS] C++ client libs

2000-10-03 Thread Randy Jonasz
Hi, I was wondering if anyone could offer me some pointers in extending the C++ classes used for client applications? I'm interested in developing a set of C++ classes which will interact directly with the postgres back-end with the following enhancements to the current implementation: These a

[HACKERS] pg_dump and quoting

2000-10-03 Thread Peter Eisentraut
I think that pg_dump should not quote identifiers that only contain lower-case letters and underscores. That will make it easier to move dumps to other database products, because PostgreSQL is off the spec in matters case folding in identifiers. But it's just an idea; if the performance hit woul

Re: [HACKERS] Syslog and pg_options (for RPMs)

2000-10-03 Thread Lamar Owen
Bruce Momjian wrote: > > Can someone comment on this? You can tell we're getting close to beta when Bruce combs through the archives :-) The situation has not changed much. There is still code printing to stderr and stdout that quite possibly should be using the standard logging system tha

Re: [HACKERS] Autoconf version discrepancies

2000-10-03 Thread Bruce Momjian
> Bruce Momjian writes: > > > I always telnet into hub to run autoconf. I have a little script in my > > ~momjian/bin directory called pgautoconf that does that, and cvs commits > > the changes. > > That's exactly the problem, the version on hub.org is custom-patched for > FreeBSD and has signi

[HACKERS] Delimited identifier length

2000-10-03 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> I don't see any clear statement in SQL92 that >> can't have zero length, so I'm not convinced there's anything wrong here. > Hmm, I do: > ::= > > ::= ... > ::= >

Re: [HACKERS] backup and restore

2000-10-03 Thread Martin A. Marques
On Mon, 02 Oct 2000, Hannu Krosing wrote: > "Martin A. Marques" wrote: > > Hi, > > > > I would like to know if postgres comes with some kind of backup > > application? I mean something that would do database backup and restore, > > something like informix's ontape and logical logs. >> > Take a loo

Re: [HACKERS] Autoconf version discrepancies

2000-10-03 Thread Vince Vielhaber
On Tue, 3 Oct 2000, Peter Eisentraut wrote: > Bruce Momjian writes: > > > I always telnet into hub to run autoconf. I have a little script in my > > ~momjian/bin directory called pgautoconf that does that, and cvs commits > > the changes. > > That's exactly the problem, the version on hub.org

Re: [HACKERS] libpq PGHOST

2000-10-03 Thread Peter Eisentraut
Tom Lane writes: > I don't see any clear statement in SQL92 that > can't have zero length, so I'm not convinced there's anything wrong here. Hmm, I do: ::= ::= ... ::= | As opposed to, say, an empty character s

Re: [HACKERS] Autoconf version discrepancies

2000-10-03 Thread Peter Eisentraut
Bruce Momjian writes: > I always telnet into hub to run autoconf. I have a little script in my > ~momjian/bin directory called pgautoconf that does that, and cvs commits > the changes. That's exactly the problem, the version on hub.org is custom-patched for FreeBSD and has significant loser pot

Re: [HACKERS] off-topic: (sorta) freebsd -> oracle, lightweight

2000-10-03 Thread Rod Taylor
The linux version of Oracle works pretty good on FreeBSD (not suggested if it's going to be a heavy hit database box), then again, I don't suggest the Linux version of Oracle for that anyway. Linux compat from -stable is required. Send your emails off to Oracle requesting the FreeBSD native vers

Re: [HACKERS] off-topic: (sorta) freebsd -> oracle, lightweight

2000-10-03 Thread Fabrice Scemama
He can use DBD::Proxy over DBI as he can use ODBC through network; but at the end, he still has to have a box where he can install oracle drivers (which are binaries, and requier you to launch oracle java installer, as if you were going to install the whole beast, then to choose to only install a