Re: [BUGS] BUG #3563: DATESTYLE feature suggestion

2007-08-22 Thread Peter Eisentraut
put functions with something that calls to_char on the value. You can even register your own configuration parameter to control the template used by to_char. If this is the only thing stopping you from making a major technology choice, you can have it fixed by dawn. -- Peter Eisentraut http://devel

Re: [BUGS] BUG #3504: Some listening sessions never return from writing, problems ensue

2007-08-27 Thread Peter Koczan
handle listen (it was pointless to have it listen anyway) and all seems well. While it may technically be a bug that a database handle will get into this state after ~800 unprocessed notifications, I'd say that's much more the fault of the application programmers. Anyway, t

Re: [BUGS] BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1

2007-09-21 Thread Peter Eisentraut
mething like ceil($argument / (360/4)) or however one would calculate the quarter exactly. The current behavior makes no sense to me either. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1

2007-09-21 Thread Peter Eisentraut
gh 4. > And it doesn't "always return 1": > > regression=# SELECT EXTRACT(QUARTER FROM INTERVAL '3 months'); > date_part > --- > 2 > (1 row) SELECT EXTRACT(QUARTER FROM INTERVAL '200 days') gives 1.

Re: [BUGS] BUG #3661: Missing equality comparator: string = integer

2007-10-09 Thread Peter Eisentraut
Am Dienstag, 9. Oktober 2007 schrieb David Bachmann: > This does not function any more under PG 8.3-beta1: > > select '5'::varchar = 5; > ERROR: operator does not exist: character varying = integer That is intentional. Fix your application by inserting appropriate expli

Re: [BUGS] Provide a way to not ask for a password in psql

2007-10-10 Thread Peter Eisentraut
at doesn't check whether the server is actually answering requests. And it cannot check remote hosts. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by do

Re: [BUGS] libpq5 8.3 breaks 8.2 compatibility with encodings

2007-10-12 Thread Peter Eisentraut
on. Perhaps we should leave a gap where JOHAB used to be and add it at the end. Otherwise we may have to do a soname exercise. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] BUG #3735: Can't create xml-stylesheet processing instruction

2007-11-09 Thread Peter Eisentraut
've installed a fix into CVS. > The w3c XML 1.0 spec says that PIs starting with 'xml' are reserved. That's what I thought as well, but they actually only reserve names being exactly 'xml' modulo case differences. -- Peter Eisentraut http://developer.postgre

Re: [BUGS] BUG #3735: Can't create xml-stylesheet processing instruction

2007-11-11 Thread Peter Eisentraut
Ben Leslie wrote: > utf8len = 4; /* FIXME: How do we know how many characters it could > be?*/ utf8char = xmlGetUTF8Char(&p[5], &utf8len); Where do you get the information that the second parameter of xmlGetUTF8Char is used on input? -- Peter Eisentraut http://developer.postgres

Re: [BUGS] BUG #3741: translation mistake

2007-11-11 Thread Peter Eisentraut
Andreas wrote: > FEHLER: Spalte »...« muss in der GROUP-BY-Klausel erscheinen oder > in einer Aggregatfunktion verwendent werden > > the word verwendent is incorrect, correct is verwendet. This was already fixed recently. -- Peter Eisentraut http://developer.postgresql

Re: [BUGS] BUG #3734: Invalid XML schema output.

2007-11-11 Thread Peter Eisentraut
Euler Taveira de Oliveira wrote: > I'm attaching another small patch to strip some space and be > consistent with other xml tags. Having a space before /> appears to be common practice, including in the examples in the SQL/XML spec. -- Peter Eisentraut http://developer.postgres

Re: [BUGS] BUG #3758: Postmaster Service

2007-11-19 Thread Peter Eisentraut
m is poor. But it's hardly possible for anyone to tell what's wrong with it with the given information. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ig

Re: [BUGS] BUG #3764: Update count returns zero for a view with 'on update' rules when criteria contains updatable field

2007-11-20 Thread Peter Eisentraut
Am Dienstag, 20. November 2007 schrieb Eugene M. Hutorny: > Description:Update count returns zero for a view with 'on update' > rules when criteria contains updatable field This is known and documented. -- Peter Eisentraut http://developer.postgr

Re: [BUGS] BUG #3764: Update count returns zero for a view with 'on update' rules when criteria contains updatable field

2007-11-21 Thread Peter Eisentraut
Am Mittwoch, 21. November 2007 schrieb Eugene Hutorny: > Peter, you mentioned it is documented, may you please point me to the > document you meant? http://www.postgresql.org/docs/8.2/static/rules-status.html This is the part that addresses this. If you find that between what is writt

Re: [BUGS] BUG #3771: function pg_catalog.btrim(numeric, unknown) does not exist

2007-11-21 Thread Peter Eisentraut
Am Mittwoch, 21. November 2007 schrieb Oliver Artelt: > works on 8.2.4 and older But in 8.3 you need to ... > Hinweis:No function matches the given name and argument types. You might > need to add explicit type casts. This is an intentional change. -- Peter Eisent

Re: [BUGS] BUG #3734: Invalid XML schema output.

2007-11-21 Thread Peter Eisentraut
Bruce Momjian wrote: > Euler Taveira de Oliveira wrote: > > Peter Eisentraut wrote: > > > Having a space before /> appears to be common practice, including in > > > the examples in the SQL/XML spec. > > > > Agreed. Feel free to add whitespace before every

Re: [BUGS] BUG #3734: Invalid XML schema output.

2007-11-23 Thread Peter Eisentraut
es seem to use it for stylistic reasons, but I fail to see the advantage. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nom

Re: [BUGS] BUG #3734: Invalid XML schema output.

2007-11-25 Thread Peter Eisentraut
patch that replaces the use of some single quotes with double quotes in > the XML attributes output. I have committed the quoting changes. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 3: Hav

Re: [BUGS] BUG #3782: table_to_xmlschema and xsd:simpleType

2007-11-28 Thread Peter Eisentraut
ment > .' > > The simpleType should have a child element. Is this a bug or am I missing > something? Oh yes, I didn't consider the XML Schema specification well enough. Please try the attached patch. Do you know of an XML Schema checker that we could use to check this? --

Re: [BUGS] BUG #3822: Nonstandard precedence for comparison operators

2008-01-02 Thread Peter Eisentraut
hange nothing, this would be useful for documentation. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[BUGS] BUG #3859: version designation

2008-01-09 Thread Peter Speck
The following bug has been logged online: Bug reference: 3859 Logged by: Peter Speck Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC1 Operating system: any Description:version designation Details: Version 8.3 has huge improvements for users over 8.0/8.1

Re: [BUGS] Minor mathematical error in documentation

2008-01-17 Thread Peter Eisentraut
ECT ... WHERE (x >= 0 AND y > 1.5*x) OR y < 1.5*x; which obviously isn't simpler. So I suggest that we just delete the parenthetical note. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[BUGS] BUG #3902: Segmentation faults using GSSAPI authentication

2008-01-25 Thread Peter Koczan
The following bug has been logged online: Bug reference: 3902 Logged by: Peter Koczan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: Red Hat Enterprise Linux 5 Description:Segmentation faults using GSSAPI authentication Details

Re: [BUGS] BUG #3902: Segmentation faults using GSSAPI authentication

2008-01-27 Thread Peter Koczan
27;s a way to get a stack-trace at the point of the crash, please let me know how and I'll get you that information. Also, why the connection is trying to reconnect without SSL intrigues and concerns me. Peter ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [BUGS] BUG #3902: Segmentation faults using GSSAPI authentication

2008-01-28 Thread Peter Koczan
> I think you misunderstand what is happening. The parent postmaster > process is not restarting, because it did not crash. The crash is > happening in a child process that is forked off by the postmaster to > service a particular connection. I see what you're saying, that it's one particular co

Re: [BUGS] BUG #3902: Segmentation faults using GSSAPI authentication

2008-01-29 Thread Peter Koczan
> > No, we want a stack trace from the crash. You could attach gdb to the > > child process after forking and before you provoke the crash; or arrange > > for a core dump file to be produced and gdb that. > > I should be able to get that for you tomorrow, if we don't figure out > the issue sooner.

Re: [BUGS] BUG #3902: Segmentation faults using GSSAPI authentication

2008-01-30 Thread Peter Koczan
oc(). The active context at this point is PostmasterContext, > which *is* going to go away soon, leaving a gaping hole in the environ > list. > > I still couldn't reproduce a crash with that knowledge, but I bet that > if you apply the attached patch, things will get better. Th

Re: [BUGS] BUG #3922: Problems migrating databases.

2008-02-02 Thread Peter Eisentraut
swer soon. Thanks. This is now handled by texteq. But you shouldn't be using those functions directly anyway. Use the '=' operator. Is this the result of a dump or do you have a reason for accessing the function directly? -- Peter Eisentraut http://

Re: [BUGS] BUG #3924: Create Database with another encoding as the encoding from postgres

2008-02-02 Thread Peter Eisentraut
codings that match. This was always true, but not it is enforced. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [BUGS] Vers. 8.3.0: "make check" fails dismally

2008-02-06 Thread Peter Eisentraut
Am Mittwoch, 6. Februar 2008 schrieb Mike Dowling: > Naively checking the build using "make check" (yes, gnu make, and as an > unprivaleged user) fails all tests.  The apparent reason is that > postgres cannot find its shared libraries. Which platform? -- Pe

[BUGS] configure warnings

2008-02-15 Thread Peter Kovacs
-- ## Thanks Peter ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] configure warnings

2008-02-16 Thread Peter Kovacs
sle-free either -- and I expect it would take more time than I currently have for setting this up. Thanks again for help. Peter On Feb 16, 2008 4:55 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Peter Kovacs" <[EMAIL PROTECTED]> writes: > > bash-3.00# uname -a > &

Re: [BUGS] configure warnings

2008-02-16 Thread Peter Kovacs
The gcc 4.2.2 binaries for a number of HP-UX platforms can be downloaded from here: http://hpux.cs.utah.edu/ And that does the job. Thanks for pointing to the right direction. Peter On Feb 16, 2008 2:49 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Peter Kovacs" <[EMAIL PRO

Re: [BUGS] [PATCH] Don't bail with legitimate -N/-B options

2008-02-17 Thread Peter Eisentraut
orresponds to 128 connections under the old arithmetic, which seems reasonable all around. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [BUGS] BUG #3990: PostgreSQL does not work

2008-02-25 Thread Peter Eisentraut
Rafael Aguilar wrote: > The PostgreSQL 8.0 does not work with Windows Vista 32 bits. 8.0 is 3 years old (compare Vista: 1 year) and deprecated on Windows. Use something newer. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadc

Re: [BUGS] BUG #3968: ssh tunnel instructions could use improvement

2008-02-26 Thread Peter Eisentraut
cs/postgres/ssh-tunnels.html in a few minutes. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTE

Re: [BUGS] BUG #3968: ssh tunnel instructions could use improvement

2008-02-26 Thread Peter Eisentraut
the documentation I've read. Good point. Added. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] bug or not bug, xmlvalidate(xml, text) can read and show one line from file

2008-02-29 Thread Peter Eisentraut
Am Freitag, 29. Februar 2008 schrieb Tom Lane: > Sergey Burladyan <[EMAIL PROTECTED]> writes: > > [ xmlvalidate is a security hole ] > > Given that this function is not documented nor tested in the regression > tests, I propose diking it out entirely. Yes, it was accidentally left over from previo

Re: [BUGS] BUG #4010: psql does not honour -c after database name

2008-03-05 Thread Peter Eisentraut
Am Mittwoch, 5. März 2008 schrieb Jasen Betts: > I used to do > > psql -U username database -c "some big long command" > > and that no longer works :( Whether or not this works is determined by the operating system, not by PostgreSQL. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.or

Re: [BUGS] BUG #4027: backslash escaping not disabled in plpgsql

2008-03-11 Thread Peter Eisentraut
Tom Lane wrote: > plpgsql does not consider standard_conforming_strings --- it still uses > backslash escaping in its function bodies regardless. Since the > language itself is not standardized, I see no particular reason that > standard_conforming_strings should govern it. I think plpgsql should

Re: [BUGS] BUG #4027: backslash escaping not disabled in plpgsql

2008-03-12 Thread Peter Eisentraut
Bruce Momjian wrote: > Agreed. standard_conforming_strings should affect _all_ strings. We might need another transition period over a few releases with a separate "plpgsql_standard_conforming_strings" parameter. Just changing it immediately is perhaps a bit risky. -- Sent via pgsql-bugs mai

Re: [BUGS] BUG #4040: psql should provide option to not prompt for password

2008-03-17 Thread Peter Eisentraut
Am Montag, 17. März 2008 schrieb Tom Lane: > It's not, IMHO.  You don't even know if the local database is where the > user is intending to connect to.  Moreover this presupposes some rather > obsolete ideas about what connection parameters might need to be given > on the command line. "psql " to

Re: [BUGS] BUG #4040: psql should provide option to not prompt for password

2008-03-17 Thread Peter Eisentraut
Am Montag, 17. März 2008 schrieb Mika Fischer: > Ideally, psql should provide an option --no-password which would cause it > to never promt for a password, and in case one is needed, fail as if a > wrong one was given. Something like ssh's BatchMode would be nice. -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #4078: ERROR: operator does not exist: numeric = character varying

2008-04-01 Thread Peter Eisentraut
Am Dienstag, 1. April 2008 schrieb rupesh: > ERROR:  operator does not exist: numeric = character varying at character > 675 > HINT:  No operator matches the given name and argument type(s). You might > need to add explicit type casts. > (0.735 sec) > > > This was previously working in 8.2.3 but no

Re: [BUGS] BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT

2008-04-02 Thread Peter Eisentraut
Tom Lane wrote: > I think you need to file a bug with Zeos to fix whatever their problem > is with text. Well, to be fair, type text is not SQL standard. But surely Zeos won't get very far with this superstrict typing approach. At least a little bit more context might help us understand. --

Re: [BUGS] BUG #4085: No implicit cast after coalesce

2008-04-02 Thread Peter Eisentraut
Jeff Dwyer wrote: > This works fine: > select 1 where current_date between '1900-3-3' and '1900-2-2'; > This doesn't: > select 1 where current_date between coalesce(null,current_date) and > coalesce(null, '1900-1-2'); > > This fix works: > select 1 where current_date between coalesce(null,current_

[BUGS] BUG #4092: initdb fails if the xlog directory is the same as [pg_data]/pg_xlog

2008-04-05 Thread Peter Koczan
The following bug has been logged online: Bug reference: 4092 Logged by: Peter Koczan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Red Hat Enterprise Linux 5 Description:initdb fails if the xlog directory is the same as [pg_data

[BUGS] BUG #4100: GMT offsets are wrong

2008-04-08 Thread Peter Coxhead
The following bug has been logged online: Bug reference: 4100 Logged by: Peter Coxhead Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux Description:GMT offsets are wrong Details: I find the results to selecting the time in a GMT

Re: [BUGS] BUG #4115: PostgreSQL ISO format is not really ISO

2008-04-20 Thread Peter Eisentraut
ation incompatible with the SQL standard and it will break various client drivers. If you need a different output format, use a formatting function or some other post-output formatting mechanism. As a note, the SQL-to-XML Schema coverter uses the correct format that you are looking

Re: [BUGS] Inconsistent shift operator

2008-04-20 Thread Peter Eisentraut
Tom Lane wrote: > And I still find the premise entirely unconvincing. > Maybe the user *wants* to see the local behavior of shift, whatever > it might be.  It's certainly not impossible that we'd break applications > that worked fine before (at least on the hardware they were being > used on). Cer

[BUGS] BUG #4126: KRB5/GSSAPI authenication fails for multipart kerberos principals

2008-04-23 Thread Peter Koczan
The following bug has been logged online: Bug reference: 4126 Logged by: Peter Koczan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Red Hat Enterprise Linux 5 Description:KRB5/GSSAPI authenication fails for multipart kerberos principals

Re: [BUGS] BUG #4128: The postmaster.opts.default file is begin ignored

2008-04-24 Thread Peter Eisentraut
Tom Lane wrote: > We've mostly deprecated setting options on the postmaster command > line already, so why do we need another obscure way to do that? As long as we support the pg_ctl -o option, the file still necessary so that you get the same options after a restart. -- Sent via pgsql-bugs mai

Re: [BUGS] BUG #4126: KRB5/GSSAPI authenication fails for multipart kerberos principals

2008-04-24 Thread Peter Koczan
> From: "Peter Koczan" <[EMAIL PROTECTED]> > To: pgsql-bugs@postgresql.org > Date: Wed, 23 Apr 2008 17:17:01 GMT > Subject: BUG #4126: KRB5/GSSAPI authenication fails for multipart kerberos > principals > > When trying to connect to an 8.3 server using a

Re: [BUGS] BUG: aliases does not work ((

2008-05-07 Thread Peter Eisentraut
Am Mittwoch, 7. Mai 2008 schrieb [EMAIL PROTECTED]: > SELECT > MIN(COALESCE(cmp_values(parent_td.value, parent_md.value, > parent_cmp.value),0)) as chk_parent, FROM some_table > > having chk_parent > 0 > > ERROR: column "chk_parent" does not exist at character 2342 Aliases in the select list are

Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-14 Thread Peter Eisentraut
Am Mittwoch, 14. Mai 2008 schrieb nicoanto: > I am using the 8.3.1 version of PostgreSQL. I wrote a simple function on > order to generate UUID values using the UUID-OSSP module > The code of the function is the following one : > >     CREATE FUNCTION uuidgen() RETURNS CHAR(36) AS $$ >        BEGIN

Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-14 Thread Peter Eisentraut
Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera: > Hmm, surely the problem is unrelated? He gets the same numbers on > _Windows_, whereas Ubuntu shows the good behavior. Oh, I read it backwards. So then the random number generator on Windows is the problem in this case. > Also, OOSP-UUID does

Re: [BUGS] apr integration

2008-05-19 Thread Peter Eisentraut
Am Montag, 19. Mai 2008 schrieb Bob Rossi: > Apr allows the use of the wonderful postgresql db. It has an autotools > test that checks to see if it can link against -lpq. However, checking > against just -lpq is not always enough. On linux, sometimes you need > '-lpq -lcrypt'. On windows, sometimes

Re: [BUGS] apr integration

2008-05-19 Thread Peter Eisentraut
Am Dienstag, 20. Mai 2008 schrieb Bob Rossi: > On Tue, May 20, 2008 at 12:01:32AM +0200, Peter Eisentraut wrote: > > Am Montag, 19. Mai 2008 schrieb Bob Rossi: > > > Apr allows the use of the wonderful postgresql db. It has an autotools > > > test that checks to see

Re: [BUGS] BUG #4219: fseeko test failure in configure script

2008-06-06 Thread Peter Eisentraut
Am Donnerstag, 5. Juni 2008 schrieb Nathan Reed: > LD_LIBRARY_PATH is the correct env var to use. However, you are > correct that this hamstrings the generated executable - requiring > that the LD_LIBRARY_PATH include all of the shared object libraries > in the rc scripts themselves. From doc

Re: [BUGS] BUG #4219: fseeko test failure in configure script

2008-06-06 Thread Peter Eisentraut
Am Freitag, 6. Juni 2008 schrieb Nathan Reed: > Does not change anything.  I have run the generic configure without > any parameters (--with-ssl, etc) and I get the same result.  I have > done a number of permutations, made sure that bison is in place, > etc,etc,etc. Trying countless permutations

Re: [BUGS] Bug #694: can't store {digits} using JDBC

2002-06-21 Thread Peter Mount
{vdigits}, we have no > problem. Also, it works fine in Oracle 8. This is an escape syntax. {d refers to a date, which is why you are seeing igits not {digits}. Try the Statement.setEscapeProcessing() method to turn it off. Peter > > The version of postgreSQL we are using is: >

Re: [PATCHES] [BUGS] pg_dumpall should permit quiet operation

2002-06-24 Thread Peter Eisentraut
s patch will become obsolete. (Also, I think we don't support external password files anymore, so the password is now predictable and the progress messages can be removed, if so.) -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] JDBC and BigDecimal problem

2002-07-03 Thread Peter Figuli
Dear JDBC team, I'm using pgjdbc2.jar from february and facing this problem: I have a table (UNICODE database is set up) having numeric type in it. Than something like this: statement = connection.preparedStatement( "SELECT * from account WHERE rate > ?" ); statement.setBigDecimal( 1, BigDecimal

[BUGS] Unicode collation error.

2002-07-03 Thread Peter Figuli
Dear postgres team. I'm not member of any of your list, but I decided to send this bugreport since focusing same problem for more than 2 releases of PGSQL. I'm running Linux-box 2.4.18 kernel, postgres build from your sources-7.2.1. Steps: 1. Set locales to any UTF-8 one. Do not forget LC_COLLATE

Re: [BUGS] mistakes in postgresql-snapshots (7.3)

2002-08-14 Thread Peter Eisentraut
27;{"=X"}' WHERE proacl IS NULL; The trick is that you'd need to run the first line before creating any functions. Blech. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] Long strings, short varchars

2002-08-15 Thread Peter Eisentraut
Sasa Markovic writes: > Long input string was silently trimmed. But in PG7.2 an error is triggered. > OK, I suppose this is just a new feature, not a bug but. But... > ...Is it possible to restore the old behaviour? Write a rule that truncates the string before it's insert

Re: [BUGS] bug in config for cygwin

2002-08-17 Thread Peter Eisentraut
so somwone with knowledge of patching the configure >scripts etc. might have a look. If you configure under cygwin then you can't build under not-cygwin. If you want to build the libraries for native Windows you need to follow the instructions for the native build. -- Peter Eis

Re: [BUGS] bug in config for cygwin

2002-08-18 Thread Peter Eisentraut
#x27;. Write to [EMAIL PROTECTED] to discuss your proposal. Maybe it's possible, but someone knowledgeable needs to check that it doesn't break anything else. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TI

Re: [BUGS] Bug #741: postgresql and cygwin

2002-08-27 Thread Peter Eisentraut
n't >have "postmaster", and only "postgres -master". > In this case we have to repair postmaster.c. Please explain specifically what your problem is. What are you doing, what is failing? PostgreSQL on Cygwin works for a lot of users, including myself, so you mus

Re: [BUGS] Command-line client sometimes misinterprets tabs for

2002-08-29 Thread Peter Eisentraut
, you might find it easier to start an editor using \e and paste your code there. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEma

Re: [BUGS] bug in contrib/contrib-global.mk

2002-09-03 Thread Peter Eisentraut
_PATHNAME,$(libdir)/$*,g' $< >$@ No, it's correct. The $libdir is interpreted by the server. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister com

Re: [BUGS] Unable to compile 7.3beta1 on cygwin

2002-09-06 Thread Peter Eisentraut
Ronald Kuczek writes: > I don't know the solution. It seems to be something wrong - 7.2.2 without > problems, > 7.3 - even from CVS - doesn't work. This was fixed about 24 hours ago, so either updating your CVS or using a later snapshot should work. -- Peter Eisentraut

Re: [BUGS] ecpg hackery to get ecpg to compile from FreeBSD ports...

2002-09-09 Thread Peter Eisentraut
c/interfaces/libpq -I../../../../src/include -I/usr/local/include >-I/usr/local/include -c -o connect.o connect.c Apparently you somehow put -I/usr/local/include into CFLAGS. Don't do that. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--

Re: [BUGS] pg_config Makefile bogon...

2002-09-09 Thread Peter Eisentraut
Sean Chittenden writes: > Attached is a quick patch that fixes making pg_config. When making > the port on FreeBSD, it uses commas in the LDFLAGS section of the > configure args and sed doesn't grok that so well. Patch just changes > the delimiters. -sc Fixed. -- Peter Ei

Re: [BUGS] Bug #761: Date format ambiguity while insertion!!!!

2002-09-09 Thread Peter Eisentraut
hout the user knowing it. Yes, that's a good point. But narrowing down the accepted formats would probably break a lot of code, since the acceptable date formats tend to vary heavily in the pretends-to-be-SQL world. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of br

Re: [BUGS] make unsuccessful on mac os x 10.2

2002-09-10 Thread Peter Eisentraut
Tom Lane writes: > The second is OS X's bug: it ought to take en_US as a legal setting for > LC_TIME, but seems not to. It is depressing that Apple evidently didn't > fix that in 10.2. If it's only LC_TIME we can remove that since we don't use it anyway.

Re: [BUGS] ecpg hackery to get ecpg to compile from FreeBSD ports...

2002-09-10 Thread Peter Eisentraut
ports tree you don't even need it since the location is known. [*] at least those that claim to give you the full CFLAGS, unlike pg_config -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Use

Re: [NOVICE] [BUGS] Postgres storing time in strange manner

2002-09-18 Thread Peter Eisentraut
y want this sort of optimization enabled. Today I read that __FAST_MATH__ is defined if -ffast-math is used, so it should be easy to write a test in configure. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Ha

Re: [BUGS] Passing character data to C function

2002-10-07 Thread Peter Eisentraut
pc_fn(char a1[50],char a2[50],char a3[255]){...} > > fails to work. The function _is_ called and I can _log output_ as it executes, > but no character data shows up in the arguments. Have you read the documentation? That works a lot better than making stuff up and wondering why it doesn

Re: [BUGS] unable to build on openbsd-sparc

2002-10-07 Thread Peter Eisentraut
figure-errors You're building with unixODBC support but you don't have it installed. Probably you want --with-iodbc instead. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://

Re: [BUGS] Problem compiling postgresql 7.3b2

2002-10-07 Thread Peter Eisentraut
; gmake[2]: *** [postgres] Error 1 > gmake[2]: Leaving directory `/tmp/postgresql-7.3b2/src/backend' > gmake[1]: *** [all] Error 2 > gmake[1]: Leaving directory `/tmp/postgresql-7.3b2/src' > gmake: *** [all] Error 2 > > > > > It would be great if you could help

Re: [BUGS] Bug in date/time input format

2002-10-08 Thread Peter Eisentraut
there a spot in the documentation that leads you to believe that this format is supported? If not, then it's not a bug. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [BUGS] multiple exception definition in pg_type.h -> error

2002-10-15 Thread Peter Eisentraut
ling with thread support. ;-) > Anyone object to doing > > extern int no_such_variable; > > instead? I wouldn't be surprised if some imaginative AIX linker will croak on that, but let's try it. -- Peter Eisentraut [EMAIL PROTECTED]

Re: [BUGS] Bug #799: configure does not check for -lodbcinst

2002-10-18 Thread Peter Eisentraut
t starting the build and seeing it fail. Moreover, note that you can just install the missing library and continue the build were it stopped. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading throug

Re: [BUGS] Regression test failure.

2002-10-22 Thread Peter Eisentraut
Tom Lane writes: > Robert Hentosh <[EMAIL PROTECTED]> writes: > > I am receiving a regression test failure in about 1 out of 12 test runs. > > I am amazed no one has reported this before :-( Someone did. :-) -- Peter Eisentraut [EMAIL PROTECTED] ---

Re: [BUGS] Creating server-side functions: one simple error

2002-10-11 Thread Peter Eisentraut
ocedure in > C++ (namespace modifications etc)?? Thanks for your help. Make a small wrapper that you compile with a C compiler and put the actual C++ implementation into a separate file. Maybe you could make a complete C++ language handler out of that. -- Peter Eisentraut

Re: [BUGS] hi-problem in creating database in postgresql 7.2.2

2002-11-06 Thread Peter Eisentraut
Jord Tanner writes: > PostgreSQL running under Cygwin does not operate with Unix sockets. Sure it does. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropri

Re: [BUGS] pg_ctl is fragile

2002-11-09 Thread Peter Eisentraut
stmaster isn't running. > > Ok, fair enough -- so is there any way to improve this behavior? Merge pg_ctl and postmaster executables. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[BUGS] Can't drop / access / or create database

2002-11-15 Thread Peter Muhlberger
processing the request. connection to server was lost createdb: database creation failed This isn't the first time this has happened to me. Does anyone have any suggestions on how I can get out of this mess? The database is no longer useable. Thx, Peter

Re: [BUGS] Different result when using '=' and 'like' in unicode

2002-11-17 Thread Peter Eisentraut
cilities to do a locale-aware comparison. So in general LIKE and = are not interchangeable. If the result you get for = is wrong even under some locale, then you probably don't have the right locale set on your server. Recent glibc systems require you to set your locale to xx_YY.utf8 (rat

Re: [BUGS] Different result when using '=' and 'like' in unicode

2002-11-20 Thread Peter Eisentraut
Jiang Sheng writes: > In your opinion, should I re-compile the PostgreSQL after set the $LANG > to ja_JP.utf8? or I need to set other variables' value.. Recompiling has nothing to do with that. Please see the Administrator's Guide chapter on localization for all the informa

Re: [BUGS] configure

2002-11-20 Thread Peter Eisentraut
ink it would be tricky to determine that it is in fact the missing curses library that is making things fail. You should probably look at fixing your operating system's package management system which let you create a broken readline installation in the first place. -- Peter Eisentraut

[BUGS] Minor build nits in 7.3rc1

2002-11-26 Thread Harris Peter
tions to LDFLAGS and CPPFLAGS myself to get readline noticed. 2) The makefile contains many rm. I usually like to alias rm="rm -i" for safety, so I had to answer (y/n) a lot of times. Could the makefile please use rm -f? Thanks

Re: [BUGS] Minor build nits in 7.3rc1

2002-11-26 Thread Peter Eisentraut
Harris Peter writes: > Workaround: I had to add the options to LDFLAGS and CPPFLAGS myself to get > readline noticed. As you should. > The makefile contains many rm. I usually like to alias rm="rm -i" for > safety, so I had to answer (y/n) a lot of times. Could the makef

Re: [BUGS] Can't start postmaster on Cygwin with local 'ja_JP.EUC

2002-11-26 Thread Peter Eisentraut
ll unset the locale environment variables.) -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [BUGS] createdb script bug in 7.3RC2?

2002-11-27 Thread Peter Eisentraut
Jean-Christian Imbeault writes: > But my PGLIB path is correct: PGLIB doesn't do anything. At all. Really. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an app

[BUGS] bug in vacuumlo (postgreSQL-7.3)? (fwd)

2002-12-02 Thread Peter Mount
-- Forwarded message -- Date: Sun, 1 Dec 2002 23:32:35 -0500 From: Hsin-Yu Sidney Li <[EMAIL PROTECTED]> To: Peter Mount <[EMAIL PROTECTED]> Subject: bug in vacuumlo (postgreSQL-7.3)? Hi, I'm sorry if this has already been reported. (I had no luck searchi

Re: [BUGS] Bug #837: Unable to use LATIN9 (=ISO-8859-15) encoding

2002-12-05 Thread Peter Eisentraut
> >From PSQL, if I perform: > \encoding LATIN9 > insert into i18ntest(id, data) values('Euro symbol', '¤'); > > then I would expect this to insert a euro symbol into the data column '¤' means '¤', not anything else. Maybe you want to tr

Re: [BUGS] Bug #837: Unable to use LATIN9 (=ISO-8859-15) encoding

2002-12-09 Thread Peter Eisentraut
mapISO8859_15, ULmapISO8859_15, sizeof(LUmapISO8859_15) / sizeof(pg_local_to_utf), sizeof(ULmapISO8859_15) / sizeof(pg_utf_to_local)}, /* ISO-8859-15 Latin 9 */ {PG_LATIN10, LUmapISO8859_16, ULmapISO8859_16, -- Peter Eisentraut [EMAIL PRO

Re: [BUGS] Bug #838: SSL problems in 7.3

2002-12-09 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > In 7.3 if a client exists without disconnecting from the database the > backend dumps core. I can't reproduce that. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off a

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