Re: [BUGS] Joins on over 10 tables returns unreliable results

2000-10-31 Thread Peter Eisentraut
'd really need to get sample data and queries to reproduce this. For now you can SET geqo TO 'off'; to disable this. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] RPMS don't work for 2.2.17

2000-10-31 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > IpcMemoryCreate: memKey=155356396 , size=760632 , > permission=384IpcMemoryCreate: shmget(..., create, ...) > failed: Invalid argument This means that you don't have enough shared memory. See FAQ. -- Peter Eisentraut [E

Re: [BUGS] installation Pb

2000-11-24 Thread Peter Eisentraut
RAMI ZALLOUM writes: > I've tried to install your database and I can't run the initdb (see logfile > below)> I've installed it on a compact deskpro (DPENS P5000/10.0/N4 EUROA4) > platform with Red Hat Linux 6.2. > Could you please help me. Read the FAQ. --

Re: [BUGS] Docs should clearly say that geometric types must beinserted as strings.

2000-11-25 Thread Peter Eisentraut
> Docs should clearly say that geometric types must be inserted as strings. http://www.postgresql.org/users-lounge/docs/7.0/user/syntax539.htm#AEN579 -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] Solaris ODBC - linker flag needs to be set when buildingshared objects

2000-12-13 Thread Peter Eisentraut
eing resolved by > # the driver manager versions rather than the pgsql > # versions Can you explain why this flag is needed? What call is getting resolved how and how should it have been resolved? Since this flag is only portable to ELF systems the problem s

Re: [BUGS] pg_dumpall -h looks up database names locally.

2000-12-21 Thread Peter Eisentraut
> pg_dumpall -h looks up database names locally. True. You will find this fixed in 7.1. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] /bin/sh: !: not found

2000-12-29 Thread Peter Eisentraut
n \ >^^^ in the Makefile > > To fix it should be changed to > @if [ ! -f GNUmakefile ] ; then \ > > This problem exists in Makefile and src/Makefile, maybe somethere else Fixed. Thanks. (Btw., it's normal that GNUmakefile is removed during 'make distc

Re: [BUGS] Re: NetBSD/Alpha and rkirkpat's patch [was Re: regressfailed tests.. SERIOUS?]

2000-12-31 Thread Peter Eisentraut
of a Tru64 symbol, rather than the absence of a bunch of > other OSes. Anyone know what would be suitable? __osf__ -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] AIX 4.3.1, 7.0.3 build annoyances: C++ comments, makeall, macro problem

2001-01-02 Thread Peter Eisentraut
/postgres.imp to TCL_SHLIB_LD > in src/pl/tcl/Makefile.tcldefs: The -Wl,-berok will lose on AIX 3*, so if anyone cares run run PG with Tcl on that platform we'll have to think harder. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] Query Problem!!

2001-01-12 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > I have problem with the GROUP BY But which is it??? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] JDBC Driver Authentication Bug

2001-01-13 Thread Peter Mount
Sorry for the delay. What is the setting in pg_hba.conf? It sounds like this is set to trust which would produce this affect. Peter - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 16, 2000 4:04 AM Subject: [BUGS]

Re: [BUGS] installation fails

2001-01-20 Thread Peter Eisentraut
hen I enter the last command, the following error message appears > initdb: pg_encoding failed Do step 8 before step 9. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [DOCS] Re: [BUGS] 7.1 released on 2000-09-01?

2001-01-24 Thread Peter Eisentraut
eases. Lots of these have changed for 7.1, but that doesn't help those using 7.0 right now. FAQ is a stupid name anyway. Additional installation hints is better. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] Python interface with CFLAGS

2001-01-24 Thread Peter Eisentraut
on --with-openssl --with-CXX make all (-O2 should be the default anyway.) -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [JDBC] [BUGS] no way in LargeObject API to detect short read?

2001-01-30 Thread Peter Mount
or (e.g.) -1 on EOF. > >Sample Code > > >No file was uploaded with this report This method now returns the number of bytes read. It will be in CVS by 0900GMT tomorrow. Peter

Re: [BUGS] JDBC ResultSet.getObject() fails for type INTERVAL

2001-02-03 Thread Peter Mount
l. >No class found for interval. This is caused because getObject() can't find the class handling Interval. Probably because there currently isn't one. When I last checked there was 45 types in 7.1 and I think the JDBC driver has about 1/2 of them mapped to either SQL or a custom class. Shouldn't take too long to implement. Peter

Re: [BUGS] syslog logging setup broken?

2001-02-04 Thread Peter Eisentraut
> Nic Ferrier ([EMAIL PROTECTED]) reports a bug with a severity of 3 > The relevant part of the startup file, which I copied from the RedHat example, looks >like this: The example startup file is outdated and broken. Don't use it. -- Peter Eisentraut [EMAIL PROTECT

[BUGS] jdbc1 & debug

2001-02-12 Thread Schmidt, Peter
the default for WAL_FILES zero? Should I be concerned with this message? DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES Thanks, Peter Schmidt Prismedia Netwoks [EMAIL PROTECTED]

Re: [BUGS] bool type could be better documented

2001-02-13 Thread Peter Eisentraut
alter the font. Maybe monospaced would be appropriate? Actually, the issue might be served better by showing an example. > Its a bit like talking about a car which is named car... its > obvious to the writer, but to the reader they just assume "concept of > automobile" whenever t

Re: [BUGS] Sequence increased before constraint check

2001-02-14 Thread Peter Eisentraut
ber sequence then you cannot use serial. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] create table bug with reserved words?

2001-02-15 Thread Peter Eisentraut
parser cope with any reserved words as > identifiers? > > Thanks, > Chris > > > > > -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

RE: [BUGS] create table bug with reserved words?

2001-02-16 Thread Peter Eisentraut
with relative certainty that it will not be possible to change the parser to accept SELECT as an identifier in all contexts without butchering the grammar beyond reason. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] On NetBSD, had to add -Wl,-R/usr/local/postgres/lib tothe src/Makefile.global LIB variable

2001-02-16 Thread Peter Eisentraut
gt; or something like that). In the past we have suggested to set the LD_LIBRARY_PATH variable appropriately. Version 7.1 fixes this by using the option you mention. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] Regresstion Tests do not find PGLIB directory

2001-02-16 Thread Peter Eisentraut
IBDIR should have been set, whereas now > it seems not to be set. I have not been able to find any reference to > PGLIB > in the postgresql documentation. LIBDIR should be in src/Makefile.global. What does it say there? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] No support for int8 sized binary/hex literals

2001-02-17 Thread Peter Eisentraut
nd X'1F...' SQL92 literal syntax is not for integer types at all. The upcoming version 7.1 will implement the BIT and BIT VARYING types, which have virtually unlimited length. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] Regresstion Tests do not find PGLIB directory

2001-02-19 Thread Peter Eisentraut
believe that? I have not added any > definitions of LD_LIBRARY_PATH or LIBDIR elsewhere such as in the > /etc/profile file (did make the suggested entry in the /etc/ld.so.conf). This issue has absolutely nothing to do with the dynamic linker. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] Not able to connect to PostgreSQL in Linux!

2001-02-19 Thread Peter Eisentraut
ta/pg_hba.conf file is > localalltrust > hostall127.0.0.1255.255.255.255trust > hostalllocalhost255.255.255.255trust ^^^ Must be an IP address. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] Problem using Postgres 7.0.3 on SCO Unixware 7.1.1

2001-02-23 Thread Peter Eisentraut
Joel Quinet writes: > I try to use Postgres 7.0.3 on SCO Unixware 7.1.1. You'll be better off using a 7.1 beta. We've fixed quite a few problem with UnixWare in there. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] postgresql-7.1beta5 configure

2001-02-27 Thread Peter Eisentraut
d change /bin/sh to /bin/sh -x and reconfigure. That should print a shell trace of what the directory creation thing does. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] postgresql-7.1beta5 with Heimdal-0.3e

2001-02-27 Thread Peter Eisentraut
b5_error These things can be fixed with proper configure checks. I'll see what I can do. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] jdbc1 compile problem still present in beta5 (java 1.1.8/freebsd 4.2-STABLE)

2001-03-01 Thread Peter Mount
er, so the build.xml file is missing an exclude tag for it with pre Java2 vm's. Work around: find the line excluding PGblob, duplicate it and replace blob with clob on one of those lines. That should fix the build problem. Peter >This is with Java SDK 1.1.8 on freebsd >uname -a: >FreeBS

Re: [BUGS] select problem

2001-03-01 Thread Peter Mount
limit. However as JDBC's DatabaseMetaData expects to return a value for a call, it's says 64K. However this shouldn't really affect anything, it's just a returned value. Pre 7.1 was limited to 8k. These were backend limitations not JDBC. Peter

Re: [BUGS] Installation bug

2001-03-02 Thread Peter Eisentraut
added --with-includes=/usr/include/g++ when I run ./configure. However, > the postgresql-7.0.3/src/interfaces/libpq++/Makefile doesn't have this > include path in its CXXFLAGS. Consider upgrading to 7.1. Installation should be easier there. -- Peter Eisentraut [EMAIL PROTECTED]

Re: [BUGS] Using libpq to access a repote database from a c triggerfunction breaks.

2001-03-07 Thread Peter Eisentraut
cutable override symbols in the shared library unless you use this option. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscri

Re: [BUGS] Pbm with aggregates on empty output

2001-03-07 Thread Peter Eisentraut
Jean-Francois Rabasse writes: > (I use PostgreSQL 6.5.3 on i686-pc-linux-gnu): Time to upgrade. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? h

Re: [BUGS] absolute(int rownumber) method not implemented as per Sun guidlines

2001-03-12 Thread Peter Mount
the text "Cannot move to index of 0". >As per Sun JDK specs ,if i will call rs.absolute(1) then it should move >cursor to row 1. It currently moves to row 1 (internal row 0). What version of the driver are you using? Peter ---(end of broadcast)--

Re: [BUGS] createStatement(int,int) of interface Statement not implemented

2001-03-12 Thread Peter Mount
;createStatement(int,int) of interface Statement not implemented Implemented in 7.1 (actually about 6 weeks ago) ;-) Peter >Sample Code > > >No file was uploaded with this report > > >---(end of broadcast)--- >TIP 2: you c

[BUGS] referential integrity problem upon deletion and reinsertion

2001-03-12 Thread Peter Barker
set constraints all deferred; insert into foo (2,1); insert into foo (1,null); commit; === ( moving the set_constraints below the delete) does work. This "hack" works in this case but may not in others. Thanks for a great product. Yours, -- Peter Barker

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-13 Thread Peter Eisentraut
oblem. The int8 tests failed with error messages like : > > INSERT INTO INT8_TBL VALUES('123','4567890123456789'); > + ERROR: int8 value out of range: "4567890123456789" Ugh. Did configure detect a working 64 bit integer? HAVE_LONG_INT_64 and HAVE_LONG_

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-13 Thread Peter Eisentraut
orts because it can't find the shared library. Yet another reason to avoid AC_TRY_RUN. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://w

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-13 Thread Peter Eisentraut
Tom Lane writes: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > >> IIRC, someone else reported a few days ago that the int8 tests failed on > >> their platform if and only if openssl was linked in. Not sure what > >> openssl could be doing to screw u

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-13 Thread Peter Eisentraut
rs when the backend is run from within initdb to check the version. If there's a shared library loading problem the postgres --version invocation will fail and the user will see a misleading error message. I'm currently changing it to print the backend's stderr if any was provi

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-14 Thread Peter Eisentraut
y, not unlikely at all with snprintf.) Instead we could run an empty test program before the real tests. If an empty program fails to run we can abort in good conscience. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of bro

Re: [BUGS] Swedish characters

2001-03-15 Thread Peter Eisentraut
hink "lower(name) like '%å%'" should match. If i try "lower(name) > like '%Å%'" I get one row. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] Doc bug: libpq PQconnectPoll()

2001-03-21 Thread Peter Eisentraut
esPollingStatusType but >a PostgresPollingStatus Type thing. > > 2. There is a typo in the parameter type. It should be PGconn not PQconn. > > In summary I think the line should be: > > PostgresPollingStatusType PQconnectPoll(PGconn *conn) > > Cheers > > Phil > >

Re: [BUGS] NetBSD 1.4.2/i386 needs to link psql with -ltermcap

2001-03-22 Thread Peter Eisentraut
o conftest -O2 -g conftest.c -lreadline -ltermcap 1>&5 [ tries with termcap, success ] Can you check around these areas why it doesn't behave as expected? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)-

Re: [BUGS] Tests randomly failed

2001-03-22 Thread Peter Eisentraut
This will avoid using Unix domain sockets, which are broken on Solaris. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [BUGS] NetBSD 1.4.2/i386 needs to link psql with -ltermcap

2001-03-24 Thread Peter Eisentraut
ehaving linker. Maybe this is a better question for a netbsd user forum. > ldd doesn't show problems: > > conf: > -ledit.2 => /usr/lib/libedit.so.2.2 (0x4001b000) > -lc.12 => /usr/lib/libc.so.12.40 (0x4002f000) How about ldd libedit? -- Peter Eisentraut

Re: [BUGS] Tests randomly failed

2001-03-24 Thread Peter Eisentraut
o with a local socket.) The bottom line here is that the switch from local sockets to TCP/IP invariably fixes the identical failure pattern. Make of that what you will. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)-

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-25 Thread Peter Eisentraut
? This has been fixed. It was a linker problem. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL P

Re: [BUGS] --enable-perl doesn't like Solaris

2001-03-25 Thread Peter Eisentraut
c. This would also give you a chance to build a shared libperl, so you can use PL/Perl. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] Please help On Alternative Database Location

2001-03-27 Thread Peter Eisentraut
Francesco Protano writes: > 1) su - username > 2) set PGDATA2 = "/home/username" (but i tried > relatives path too) > 3) initlocation $PGDATA2 > 4) createdb -D $PGDATA2 mydb initlocation PGDATA2 createdb -D PGDATA2 mydb -- Peter Eisentraut [EMAIL PROTECTED]

Re: [BUGS] Local Host Security? All users should have passwordsoptionally...

2001-03-27 Thread Peter Eisentraut
use the > user "root" without password and it fails miserably! What happens if a > hacker (or worst, a cracker!) enters to the machine somehow and I > don't ask passwords for unix domain sockets? Try changing the permissions on the socket file (chmod

Re: [BUGS] pq_shadow

2001-03-30 Thread Peter Eisentraut
e createuser -U postgres. Incidentally, this is not a bug and should be posted elsewhere. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [BUGS] unix_socket_directory isn't used by all bin tools

2001-03-30 Thread Peter Eisentraut
hatever else the client has implemented. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] I can't initialize

2001-03-30 Thread Peter Eisentraut
r/local/pgsql/dados//pg_xlog > Creating template database in /usr/local/pgsql/dados//base/template1 > ERROR: Error: unknown type 'ame'. Update to 7.1 or search the archives for the fix. (Searching for the error message should provide the answer.) -- Pet

Re: [BUGS] LATIN2 and wrong upper() and lower() functions output

2001-03-30 Thread Peter Eisentraut
nversion and ordering are controlled by *locale*, not multibyte. You need to configure with --enable-locale and set the appropriate LC_* variables. http://www.postgresql.org/devel-corner/docs/postgres/charset.html#LOCALE -- Peter Eisentraut [EMAIL PROTECTED]

Re: [BUGS] unix_socket_directory isn't used by all bin tools

2001-03-31 Thread Peter Eisentraut
e change. The primary reason for it being a run-time option, too, was for "virtual hosting" setups, and in that case it's doubtful whether a global client-readable configuration file would even be appropriate. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [BUGS] When I install postgresql using rpm it is ok. When Icompile the fonts and execute the initdb hapen a Error: unknown type 'ame'.

2001-04-11 Thread Peter Eisentraut
ate1 > ERROR: Error: unknown type 'ame'. > > ERROR: Error: unknown type 'ame'. You could upgrade to 7.1 or patch your 7.0 source. Please search the archives for this error message, it should get you a link to the patch. -- Peter Eisentraut [EMA

Re: [BUGS] compile-time-error

2001-04-15 Thread Peter Eisentraut
ing: assignment from incompatible pointer type > tab-complete.c: In function ^Psql_completion': > tab-complete.c:292: warning: implicit declaration of function > ^Completion_matches' A patch is available at http://www.postgresql.org/~petere/readline42.html. -- Pete

Re: [BUGS] readline-4.2 problem

2001-04-15 Thread Peter Eisentraut
t > problem? A patch is available at http://www.postgresql.org/~petere/readline42.html. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please s

Re: [BUGS] position('' in '') returns 1 instead of 0

2001-04-18 Thread Peter Eisentraut
l rule 2 a), if you care.) > While running an ODBC test suite against PostgreSQL 7.1, the test > software reported that the ODBC command locate("", "") failed. It > expected the result to be zero and it got a 1. Maybe the locate() function should be implemented diffe

Re: [BUGS] startup scripts don't function properly

2001-04-19 Thread Peter Eisentraut
Quick solution is to remove the extra dashes. I have added -D options to the pg_ctl invocation. Leaving in the '-' is probably a good idea. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)---

Re: [BUGS] BUG??, fault in POSTMASTER when using GMAKE

2001-04-19 Thread Peter Eisentraut
er.c2001/04/19 19:06:34 *** *** 211,216 --- 211,219 extern char *optarg; extern intoptind, opterr; + #ifdef HAVE_INT_OPTRESET + extern intoptreset; + #endif /* * postmaster.c - function prototypes ===END -- Peter Eisent

Re: [BUGS] pg_ctl restart bug

2001-04-20 Thread Peter Eisentraut
nd line options out of the opts file while preserving whitespace in them, I'm going to eliminate the quotes being put out. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] grant insert for single tables does not work

2001-04-20 Thread Peter Eisentraut
> Harald Bartel (harald.bartel@prozentor) reports a bug with a severity of 3 > It is not possible to grant insert for a single table. Granting this > right only works if grant all is used. Works here. More details required. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.h

Re: [BUGS] pg_ctl restart bug

2001-04-20 Thread Peter Eisentraut
Tom Lane writes: > pg_ctl restart works fine with this patch, but I'm not sure whether it > breaks useful cases for the other paths: Looks good. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end o

Re: [BUGS] pg_ctl restart bug

2001-04-21 Thread Peter Eisentraut
Tom Lane writes: > ! eval '$po_path' '$POSTOPTS' $logopt '&' > --- 323,335 > ! eval '$po_path' $POSTOPTS $logopt '&' Actually, I think it needs to be "$POSTOPTS" (double quoted), to preserve whitespace

Re: [BUGS] pg_regress hangs on parallel test

2001-04-24 Thread Peter Eisentraut
> Mark Hollomon ([EMAIL PROTECTED]) reports a bug with a severity of 2 > pg_regress hangs on parallel test > > Long Description > HPUX 10.20 > postgreSQL 7.1 FAQ_HPUX #5 -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter --

Re: [BUGS] Startup Problems on Win2K

2001-04-26 Thread Peter Eisentraut
Saul Hernández writes: > Cygwin 1.1.8-2 (Version 1.1.7 was not available at cygwin.com) > Cygipc 1.04 See doc/FAQ_MSWIN. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if p

Re: [BUGS] SELECT min(id) FROM test; uses seqscan

2001-05-03 Thread Peter Eisentraut
> SELECT min(id) FROM test; uses sequential scan even if an index on "id" exists. >VACUUM ANALYZE doesn't help. This is not a bug. In the current implementation, min and max cannot make use of an index directly. -- Peter Eisentraut [EMAIL PROTECTED] http://funkt

Re: [BUGS] freebsd sample startup script doesn't work

2001-05-03 Thread Peter Eisentraut
ome directory. This is fixed in the soon to be released 7.1.1. > Also, the following line in the start action of the sript is useful: > > /sbin/ldconfig -m $prefix/lib You ought to run this once, not every time the system starts. -- Peter Eisentraut [EMAIL PROTE

Re: [BUGS] debug_level 0 does not stop debug messages

2001-05-03 Thread Peter Eisentraut
t there should be a more systematic approach to what gets logged. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] Problem building PostgreSQL 7.1 with readline-4.2

2001-05-03 Thread Peter Eisentraut
d be updated to detect this. To appear in 7.1.1. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [BUGS] freebsd sample startup script doesn't work

2001-05-03 Thread Peter Eisentraut
Vivek Khera writes: > >>>>> "PE" == Peter Eisentraut <[EMAIL PROTECTED]> writes: > > >> Also, the following line in the start action of the sript is useful: > >> > >> /sbin/ldconfig -m $prefix/lib > > PE> You ought to r

Re: [BUGS] freebsd sample startup script doesn't work

2001-05-03 Thread Peter Eisentraut
Bruce Momjian writes: > You will need an updated pg_ctl that understands -D. All versions of pg_ctl understand -D. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe

Re: [BUGS] Error in Makefile.tcldefs

2001-05-03 Thread Peter Eisentraut
eate functions. How about showing the actual thing and the actual effect? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscrib

Re: [BUGS] Build fails for pl/tcl on OpenBSD

2001-05-05 Thread Peter Eisentraut
m here seems to be that the tclConfig.sh file does not provide a variable that gives a hint where to look for include files. There are a dozen variables for library things, but zero for cpp flags or includes. If someone finds one, let me know. -- Peter Eisentraut [EMAIL P

[BUGS] DATE_PART() BUG?

2001-05-28 Thread Peter Kelly
er varying(7), "purchasedate" date, "emailaddress" character varying(60), "firstname" character varying(25), "lastname" character varying(50), "customerfullname" character varying(40), "salesordernumber&qu

[BUGS] RE: DATE_PART() BUG? We have an SQL statement that is giving wrong output.

2001-05-28 Thread Peter Kelly
Thanks! That did it: tbs=# SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth; dayofmonth 31 (1 row) tbs=# SET TIMEZONE = 'GMT' ; SET VARIABLE tbs=# SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth; dayofmonth 1 (1 r

Re: [BUGS] Perl DBI Module fails to install correctly from RPM

2001-07-07 Thread Peter Eisentraut
> Perl DBI Module fails to install correctly from RPM We don't maintain or distribute the Perl DBI/DBD module. Don't confuse it with the Pg module in the PostgreSQL distribution, which is something different. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.home

Re: [BUGS] can't create timestamp field (only timestamp with timezone)

2001-07-07 Thread Peter Eisentraut
> can't create timestamp field (only timestamp with time zone) Those are the same data types. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archive

Re: [BUGS] shared library compile error

2001-07-11 Thread Peter Eisentraut
ort for GCC, since -G used to work and is still documented to work. http://gcc.gnu.org/lists.html -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once with t

Re: [BUGS] order by and union

2001-07-11 Thread Peter Eisentraut
names from the union branches are not in scope for the order by. Consider this case select cnd.cod_spe from cnd union select cnd.cod_spe from (select relname from pg_class) as cnd (cod_spe) order by cnd.cod_spe; Which "cnd" is meant here? However, you should be able to write order by cod_

Re: [BUGS] bug report: tuple is too big

2001-07-13 Thread Peter Eisentraut
Joel G Guevara writes: > I am using PostgreSQL version 6.5 (included in Red Hat Linux 6.2). bug report: version is too old -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if post

Re: [BUGS] libpgtcl doesn't use UTF encoding of TCL

2001-07-20 Thread Peter Eisentraut
Reinhard Max writes: > OK, I'll pack the new stuff inside #ifdef TCL_UTF8 and define that if > the Tcl version is 8.1 or greater. No, please add a configure check for Tcl_UtfToExternalDString or some other function representative of this interface.. -- Peter Eisentraut [EMAI

Re: [BUGS] help for:FATAL 1: configuration file `postgresql.conf'has wrong permissions

2001-08-05 Thread Peter Eisentraut
ensitive > than postgresql.conf (password files for example). Peter, what is the > rationale for having this check? Security on a module basis perhaps (a.k.a. paranoia)? I could agree on moving that check to $PGDATA but I feel it needs to be there. At least one user was going to

Re: [BUGS] help for:FATAL 1: configuration file `postgresql.conf'has wrong permissions

2001-08-06 Thread Peter Eisentraut
Tom Lane writes: > Seems to me it makes more sense to check $PGDATA, not one individual > file within the directory. Ultimately we depend on $PGDATA to have > the right permissions. Check moved. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.n

Re: [BUGS] assorted documentation errors

2001-08-13 Thread Peter Eisentraut
-- > > Edit the original files and/or fix the conversion script. Generations of programmers have tried that and failed. :-( -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2

Re: [BUGS] assorted documentation errors

2001-08-13 Thread Peter Eisentraut
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'class="PARAMETER">password' ^^^ ??? > | CREATEDB | NOCREATEDB > | CREATEUSER | NOCREATEUSER > | IN GROUP groupname [, ...] -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.n

Re: [BUGS] -ltermcap needed for psql client build on OpenBSD 2.9

2001-08-14 Thread Peter Eisentraut
s as a linker bug pending OS developer feedback. See NetBSD PR 13486: http://www.NetBSD.org/cgi-bin/query-pr-single.pl?number=13486 No reponses yet. Feel free to post this to an OpenBSD forum. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter --

Re: [BUGS] -ltermcap needed for psql client build on OpenBSD 2.9

2001-08-15 Thread Peter Eisentraut
have to beat them into submission then. I mean, the simplest thing in the world would be to link libreadline against -lcurses, so the dependency is recorded and the users of libreadline won't have to remember it. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [BUGS] Various doc errors and shortcomings

2001-08-20 Thread Peter Eisentraut
question is the name in this > registry, not the database filename. Nowhere does it say that databases have file names. Where do you get that idea? > Tutorial Chapter 2: The tutorial is not very well maintained (if at all). Thanks for finding these problems. (It was once merge

Re: [BUGS] timestamps cannot be created without time zones

2001-08-23 Thread Peter Eisentraut
regards with/without time zone is undesirable. Our timestamp type always stores the time in UTC and prints it out according to the local time zone. The fact that the type then comes out as 'timestamp with time zone' is disputed, but they are in fact one and the same type. -- Peter Eisentr

Re: [BUGS] timestamps cannot be created without time zones

2001-08-24 Thread Peter Eisentraut
n the 1800s, so attaching a timezone > to dates much older than that would be a dubious practice anyway... Thus Rainer's point is that when having times both before and after 1901 in the same data set you get inconsistencies. This seems like a good reason to introduce a true 'timestamp withou

Re: [BUGS] Bug #427: joining views

2001-08-24 Thread Peter Eisentraut
> PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 > > wrong results when joining views. Upgrade to the latest version (7.1.3). -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of

Re: [BUGS] timestamps cannot be created without time zones

2001-08-24 Thread Peter Eisentraut
he standard variable. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your mes

Re: [BUGS] problem with \d {tablename}

2001-08-31 Thread Peter Eisentraut
Andrew MacFarlane writes: > The error message I get for > \d kids; > is > Did not find any relation named "kids;". \d kids (no semicolon) -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter --

Re: [BUGS] Bug #435: Cannot connect to databases if using Capital

2001-09-01 Thread Peter Eisentraut
error: > psql: FATAL 1: Database "BUGS" does not exist in the system catalog. Will be fixed. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FA

Re: [BUGS] Bug #435: Cannot connect to databases if using Capital

2001-09-03 Thread Peter Eisentraut
Peter Eisentraut writes: > > James Pattie ([EMAIL PROTECTED]) reports a bug with a severity of 3 > > > If I create a database Ex. BUGS it shows up as bugs instead of BUGS. > > I can drop the database by saying "drop database BUGS;" and it works > > but I can

<    1   2   3   4   5   6   7   8   9   10   >