[HACKERS] timestamp.c

2005-08-28 Thread ohp
Hi, It seems the timestamp.c patch to getg around the SCO optimizer bug did'nt get in beta1 Is it normal? Regards -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 15, Chemin des Monges+33-5-61-50-97-01 (Fax) 31190 AUTERIVE

Re: [HACKERS] Typmod for user-defined types

2005-08-28 Thread Martijn van Oosterhout
AIUI, the issue is statements like: # select numeric(6,3) '5.6'; Bison can't look far enough ahead to determine whether the numeric is a type or a function. However, the desired grammer itself is not ambgiuous, it's just that Bison is not smart enough to make it work. It works now only because

[HACKERS] small pg_dumpall bug/warning in 8.1beta1

2005-08-28 Thread Stefan Kaltenbrunner
Hi! During testing of 8.1 I found that using pg_dumpall (-g) against a live 8.0 install that has at least one GROUP defined results in the following warning while it creates the CREATE ROLE statements in the dump: row number 0 is out of range 0..-1 To reproduce the problem it is enough to

Re: [HACKERS] 8.1beta1: pg_dumpall -c does delete from pg_shadow?

2005-08-28 Thread Tom Lane
[EMAIL PROTECTED] writes: Our friendly psql complains that pg_shadow is a view: psql:filename:11: ERROR: cannot delete from a view HINT: You need an unconditional ON DELETE DO INSTEAD rule. Yeah, this is on the open-items list; the DELETE FROM is broken (and was always a pretty bogus

Re: [HACKERS] small pg_dumpall bug/warning in 8.1beta1

2005-08-28 Thread Tom Lane
Stefan Kaltenbrunner [EMAIL PROTECTED] writes: During testing of 8.1 I found that using pg_dumpall (-g) against a live 8.0 install that has at least one GROUP defined results in the following warning while it creates the CREATE ROLE statements in the dump: row number 0 is out of range 0..-1

Re: [HACKERS] Win32 Thread safetyness

2005-08-28 Thread Bruce Momjian
I poked around this one. The SSL locking documentation is at: http://www.die.net/doc/linux/man/man3/crypto_set_id_callback.3.html The description isn't clear. When they talk about locking_function() and id_function(void), they are talking about arguments to the SSL functions listed above,

Re: [HACKERS] small pg_dumpall bug/warning in 8.1beta1

2005-08-28 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Kaltenbrunner [EMAIL PROTECTED] writes: During testing of 8.1 I found that using pg_dumpall (-g) against a live 8.0 install that has at least one GROUP defined results in the following warning while it creates the CREATE ROLE statements in the dump: row number 0 is out

Re: [HACKERS] Segfault Exiting psql

2005-08-28 Thread Tom Lane
Awhile back I wrote: Hmm, I don't see that symptom, but I do see some strange stuff building PG CVS tip on a fully-up-to-date (10.4.2) OS X machine. ... Second, at exit from an interactive psql session, regression=# \q could not save history to file /Users/tgl/.psql_history: Invalid

Re: [HACKERS] Win32 Thread safetyness

2005-08-28 Thread Magnus Hagander
The basic issue with SSL is that it wants some unique identifier for threads. They really should have defined the function to take pthread_t rather than unsigned long because pthreads doesn't really give us a useful way to get an They absolutely should not have done that. That would've

Re: [HACKERS] Win32 Thread safetyness

2005-08-28 Thread Bruce Momjian
Magnus Hagander wrote: The basic issue with SSL is that it wants some unique identifier for threads. They really should have defined the function to take pthread_t rather than unsigned long because pthreads doesn't really give us a useful way to get an They absolutely should not

Re: [HACKERS] Win32 Thread safetyness

2005-08-28 Thread Dave Page
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 28 August 2005 18:19 To: Dave Page Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Win32 Thread safetyness I poked around this one. The SSL locking documentation is at:

Re: [HACKERS] Win32 Thread safetyness

2005-08-28 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: Magnus Hagander wrote: Also, there doesn't seem to be a good way for users to know if libpq or ecpg was compiled to be thread-safe. Right. A runtime function for this might be a good thing? Like bool PQisThreadSafe() or such? Yes, and a flag

[HACKERS] dangling lock information?

2005-08-28 Thread Andreas Pflug
I'm currently testing pgAdmin support for slony, on pgsql CVS HEAD, and encounter strange problems from time to time. After dropping and recreating the slony schema, all changes committed and all backends in IDLE state, I'm getting relation with OID xxx does not exist when I'm trying to add a

Re: [HACKERS] Win32 Thread safetyness

2005-08-28 Thread Bruce Momjian
Dave Page wrote: So, we might be able to get away without this on Win32, or perhaps the pthread_self().p is a valid unique identifier for Win32 threads and pthreads. Right. How is this pthread_self() call working on Win32 now? Is pthreads a requirement for libpq threading on Win32?

Re: [HACKERS] Win32 Thread safetyness

2005-08-28 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Magnus Hagander wrote: Also, there doesn't seem to be a good way for users to know if libpq or ecpg was compiled to be thread-safe. Right. A runtime function for this might be a good thing? Like bool PQisThreadSafe() or

[HACKERS] Upcoming conferences for me

2005-08-28 Thread Bruce Momjian
I have the following conferences scheduled: Sept 7-10, Sri Lanka Sept 17, New York City October 17-20, Amsterdam Information is on the PostgreSQL Events list and my home page. I also have a possible Armenia trip for early October, and Mexico for mid-November. --

Re: [HACKERS] Win32 Thread safetyness

2005-08-28 Thread Dave Page
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 28 August 2005 22:56 To: Dave Page Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Win32 Thread safetyness Well, actually I tried to run configure --enable-thread-safety on a MinGW platform and

Re: [HACKERS] Win32 Thread safetyness

2005-08-28 Thread Bruce Momjian
Patch applied. Autoconf run. Thanks. --- Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 28 August 2005 22:56 To: Dave Page Cc: pgsql-hackers@postgresql.org

Re: [HACKERS] timestamp.c

2005-08-28 Thread Larry Rosenman
Yeah, I think it's a timing thing on when the fix was committed and when Beta1 was pulled. It will be in the next beta/release based on the commit I saw. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US

Re: [HACKERS] Call for 7.5 feature completion

2005-08-28 Thread Christopher Kings-Lynne
* optional interface which sends a row typeoid along with each row in a result set Oh, and 'select rowid, * from table' which returns special rowid column that just incrementally numbers each row. Chris ---(end of broadcast)--- TIP 6:

[HACKERS] Improved \df(+) in psql + backward-compatibility

2005-08-28 Thread David Fetter
Folks, I've noticed that \df doesn't do quite what it might when a function is created with named input parameters. Please find enclosed a patch against CVS TIP that does this better. On a slightly related note, I've noticed that psql isn't backward compatible. I know that it's *very* late to

Re: [HACKERS] Improved \df(+) in psql + backward-compatibility

2005-08-28 Thread Tom Lane
David Fetter [EMAIL PROTECTED] writes: On a slightly related note, I've noticed that psql isn't backward compatible. We have never expected psql's \d commands to work against older server versions, and two months after feature freeze isn't the time to start making that happen.