Re: [BUGS] Building documentation in PostgreSQL 7.2devel

2001-09-04 Thread Peter Eisentraut
ools mature. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] linking with readline

2001-09-04 Thread Peter Eisentraut
ollowing line in > src/Makefile.global: > > LIBS = -lz -lresolv -lcompat -lm -lutil -ltermcap -lreadline That's a good fix. The current CVS tip also works around this problem. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [BUGS] Build problem with CVS version

2001-09-04 Thread Peter Eisentraut
owing (completely untested): # for local Python install make install python_moduledir='$(pkglibdir)' python_moduleexecdir='$(pkglibdir)' # (yes, single quotes) # for local Perl install make install mysterious_feature=yes # (seriously) -- Peter Eisentraut [EMAIL PROTECTED]

Re: [BUGS] Build problem with CVS version

2001-09-06 Thread Peter Eisentraut
all it). This is currently the default behaviour, if you recall. ;-) -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [BUGS] Trouble in SELECT query

2001-09-10 Thread Peter Eisentraut
eld = NULL' should also be false, but PostgreSQL treats it as 'field IS NULL' to allow broken clients to work. See also <http://www.de.postgresql.org/users-lounge/docs/7.1/postgres/functions-comparison.html>. -- Peter Eisentraut [EMAIL PROTECTED] http://funk

Re: [BUGS] Bug #447: lost connection to back end

2001-09-11 Thread Peter Eisentraut
ve left in your $PGDATA directory. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] PostgreSQL 7.1.3 vs. gcc 2.95.4 and GNU libc 2.2.4

2001-09-11 Thread Peter Eisentraut
nstalled a fix for this in the development sources; I understand that you were able to fix this yourself. The more interesting question is why it's trying to use on_exit() when it should be using atexit(). If you're interested, you can try to look through config.log to see what'

Re: [BUGS] Bug #448: 7.1.3 interfaces build fail on solaris w. gcc

2001-09-11 Thread Peter Eisentraut
es) LINK.shared = $(CC) -shared else LINK.shared = $(CC) -G endif else ifeq ($(GXX), yes) LINK.shared = $(CXX) -shared else LINK.shared = $(CXX) -G endif endif (Or just change the -G if you don't care about generality

Re: [BUGS] SQLCODE==-209

2001-09-13 Thread Peter Eisentraut
es not mention -209, at least in the ecpg documentation I'm looking > at, 7.2 doesn't document it either... -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked

Re: [BUGS] plpgsql & temp table -bug

2001-09-13 Thread Peter Eisentraut
Szima Gabor writes: > Table-OID are cached and not flushed after DROP TABLE? Something like that, but what are you expecting? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you

Re: [BUGS] SQLCODE==-209

2001-09-17 Thread Peter Eisentraut
m the documentation. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] Bug #458: serial data type problem

2001-09-20 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > How can I make the transaction_code not to increase if the record is > not added into the table? This is a question, not a bug report. Sequences may contain holes. If you don't want that you can't use sequences. -- Peter Eisentraut [EMAIL P

Re: [BUGS] Bug #466: Unable to remove /root/tmp/initdb:xxxx.xxx

2001-09-21 Thread Peter Eisentraut
completely incomprehensible workaround, but since you didn't post the exact outputs above I cannot guess what actually happened here. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] Bug #468: psql field separator......

2001-09-24 Thread Peter Eisentraut
_ESE| PE_CS_I > 252 | W_SIFITES_ESE| SD_SR_I > 253 | | The field separator only works in the unaligned output mode (\a). -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)

Re: [BUGS] Long options for psql in 7.1.3

2001-10-04 Thread Peter Eisentraut
o support it on all installations we had to give it some special treatment. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

[BUGS] Possible bug in Postgres String comparison routines

2001-10-25 Thread Peter Breton
re 'ken' > 'k, '; # Does not work!!! select current_time where 'kens' > 'k, P'; # Also does not work select current_time where 'ens' > ', P'; For "Works", I mean returns a result (the where expr

Re: [BUGS] Documentation nits

2001-11-17 Thread Peter Eisentraut
Rich Morin writes: > It is a ToC entry, looking like > >"12.1.7. The #random# test ... 76" > > where the '#'s actually show up as squares. Those are supposed to be double quotes. It's possible that the Microsoftish "smart quotes" snuck in

Re: [BUGS] Documentation nits

2001-11-15 Thread Peter Eisentraut
ould be on page "iii". Also, >there seem to be two sequences of Arabic page numbers (e.g., the >Preface is not the first item, yet it is listed as Page "i"). > >In Table 3-10, the text is jammed up against the lefthand rules. Peculiar. >On page

Re: [BUGS] text(bool), text(numeric)

2001-11-28 Thread Peter Eisentraut
our own choice with CASE WHEN value THEN 'value if true' ELSE 'value if false' END The issues are similar with numeric=>text, but the to_char() family of functions should be able to solve all your problems in this area. -- Peter Eisentraut [EMAIL PROTECTED] --

Re: [BUGS] Long options for psql in 7.1.3

2001-10-05 Thread Peter Eisentraut
Arcady Genkin writes: > That's fine, but IMO "psql -h /var/pgsql --help" and "psql --help" > should either both work, or both not work. I don't think so. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [BUGS] Bug #482: psql (7.1.3) doesn't like sysid=0

2001-10-16 Thread Peter Eisentraut
not > clear in the docs that sysid should be positive and > the error message is a little bit confusing. peter=# select version(); version - PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96 (1

Re: [BUGS] \lo_unlink results in "ERROR: pg_description: Permission

2001-10-04 Thread Peter Eisentraut
Tom Lane writes: > Peter, what do you think of hacking psql to only try the pg_description > actions if pset.issuper? The alternative is to invent COMMENT ON LARGE > OBJECT, which is more work than I have time for at the moment. Sounds reasonable. -- Peter Eisentraut [EMAIL

Re: [BUGS] Bug #481: java-building ant confused with xscreenhack-ant

2001-10-14 Thread Peter Eisentraut
> Markus Mikkolainen ([EMAIL PROTECTED]) reports a bug with a severity of 3 > java-building ant confused with xscreenhack-ant by .configure Already fixed in 7.2. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of bro

Re: [BUGS] probably a bug of data-type serial

2001-10-15 Thread Peter Eisentraut
lumn of type serial is not beeing > droped automatically when the table containing the serial-column is > droped. Does it make sense to store a sequence without a corresponding > table ? Possibly you want to use it for more than one table. -- Peter Eisentraut [EMAIL PROTECTED] http:

Re: [BUGS] Bug #542: 7.1.3 will not compile/install on SCO Open

2001-12-18 Thread Peter Eisentraut
xt release. If time allows please get the latest beta of PostgreSQL 7.2 from a mirror near you, test it on your platform, and send a report (good or bad) to [EMAIL PROTECTED] so we can include it on the "supported" list or iron out the remaining problems. -- Peter Eise

Re: [BUGS] case-sensitivity inconsistency in quoted column aliases

2002-01-09 Thread Peter Eisentraut
ml#SQL-SYNTAX-IDENTIFIERS -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the m

Re: [BUGS] libpq not reentrant

2002-01-18 Thread Peter Eisentraut
ehaves, you need to use "info libc". -- 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] libpq not reentrant

2002-01-18 Thread Peter Eisentraut
" > it wasn't always portable between OS's. Is that how we want to go? -- 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] 7.2b5 libpq++ include files broken?

2002-01-22 Thread Peter Eisentraut
ing I recall it needing is the namespace configure test, which it already gets via pg_config.h. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] Bug #572: Double Format

2002-02-04 Thread Peter Eisentraut
> With glibc 2.2 and linux-i386 MAX_DBL must be formated with 17 digits, > not with 15 Says who? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [BUGS] Bug #574: can not create tables that start with "Clinic"

2002-02-06 Thread Peter Eisentraut
use there is no such data type. The RAW(x) data type used elsewhere also doesn't exist. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] Bug #587: Postgresql will not build on HP-UX 11.0 in

2002-02-13 Thread Peter Eisentraut
/backend/access/heap/heapam.c > cc: error 1405: "/opt/ansic/lbin/ccom" terminated abnormally with signal 11. That is a compiler bug. Complain to your vendor. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscr

Re: [BUGS] CURRENT_TIMESTAMP not work correctly insinde a transaction.

2002-02-22 Thread Peter Eisentraut
able effect. > > This is not a bug, but the behavior required by SQL9x afaicr. AFAIK, this is PostgreSQL bugward compatibility. SQL says that current_timestamp returns the "current timestamp", which you can interpret any way you want to. -- Peter Eisentraut [EMAIL PROTECT

Re: [BUGS]

2002-03-11 Thread Peter Eisentraut
f three-valued Boolean logic.) If you want a <> b to return true if one of a and b is NULL and the other is not NULL then you will have to do a bit more work. For example, (a <> b) or (a is null and b is not null) or (a is not null and b is null) -- Peter Eisentr

Re: [BUGS] Case sensitive table names ?

2002-03-13 Thread Peter Eisentraut
Per Winkvist writes: > When creating a table from psql named 'tblProduct' that is turned into > tblproduct. Unless you double-quote it. > However, when creating a table with the tcl/tk application pgaccess you > can create a table that have capital letters. Isn't t

Re: [BUGS] sequence havn't been dropped.

2002-03-13 Thread Peter Eisentraut
ce isn't owned by the table. It might be used elsewhere as well. -- 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] Bug #617: In SQL the tableowner is not allowed

2002-03-15 Thread Peter Eisentraut
> It seems that it is not allowed to specify the tableowner in an SQL statement And this is a bug exactly why? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? h

Re: [BUGS] psql's \r does not reset parenthesis depth counter

2002-03-17 Thread Peter Eisentraut
if ((value = GetVariable(pset.vars, "ECHO")) && strcmp(value, "all") == 0) puts(options.action_string); - successResult = HandleSlashCmds(options.action_string, NULL, NULL) != CMD_ERROR + successResult = HandleS

Re: [BUGS] Bug #612: PostgreSQL 7.2 does not build according to

2002-03-18 Thread Peter Eisentraut
> Ignore my submission about sh-vs-bash in configure. Configure is > still broken (doesn't set HAVE_SNPRINTF_DECL properly), and the > resulting tree still doesn't build under IRIX with MIPSpro ($CC > accidentally got reset to gcc between tries). Shows us the confi

Re: [BUGS] Bug #623: Compling 7.2 on a Tru64 V5.1 UNIX

2002-03-25 Thread Peter Eisentraut
ccIdlVTM.s:7 Segmentation fault > line: .file 1 "hashstrat.c" > > make[4]: *** [hashstrat.o] Error 1 If the compiler crashes then that's a bug in your compiler. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--

Re: [BUGS] Bug #631: pg_dumpall does not accept -F or -f

2002-04-10 Thread Peter Eisentraut
> The pg_dumpall script seems to ignore the file and format switches > that are used with pg_dump. pg_dumpall always writes to stdout in > text format. Also, the -b switch can not be used with pg_dumpall > since text output is being forced. That's not a bug. -- Peter Ei

Re: [BUGS] Bug #631: pg_dumpall does not accept -F or -f

2002-04-10 Thread Peter Eisentraut
Bruce Momjian writes: > Peter Eisentraut wrote: > > > The pg_dumpall script seems to ignore the file and format switches > > > that are used with pg_dump. pg_dumpall always writes to stdout in > > > text format. Also, the -b switch can not be used with pg_dump

[BUGS] libpgtcl

2002-04-18 Thread Peter Koll
/postgreSQL/source/postgresql-7.2.1/src« gmake: *** [install] Fehler 2 Whats my mistake mfg peter koll begin:vcard n:koll;peter tel;cell:0171 - 7941591 tel;fax:02981 - 923736 tel;work:02981 - 923712 x-mozilla-html:FALSE url:http://www.p-a-d.de org:p.a.d. karosserietechnik gmbh;winterberg adr

Re: [BUGS] [Win32] Problem with rename()

2006-06-16 Thread Peter Brant
Really? If there was a patch, I missed it. My recollection is that there was general agreement about this particular problem (see, for example, http://archives.postgresql.org/pgsql-bugs/2006-04/msg00189.php ), but things kind of trailed off after that without a resolution. As far as the complete

Re: [BUGS] [Win32] Problem with rename()

2006-06-17 Thread Peter Brant
>>> On 16.06.2006 at 23:21:21, in message <[EMAIL PROTECTED]>, Bruce Momjian wrote: > Yea. Where you using WAL archiving? We will have a fix in 8.1.5 to > prevent multiple archivers from starting. Perhaps that was a cause. > Not at the time, no. The rename in question was just a regular WAL s

Re: [BUGS] BUG #2540: function upper(..) and operator 'like' problem

2006-07-20 Thread Peter Eisentraut
radoslaw wisniewski wrote: > function upper combined with like opertaor and german umlauts (db > encoding UTF8) fails. You have probably configured the wrong locale, but you have not given nearly enough information to reproduce your problem. -- Peter Eisentraut http://developer.postgres

Re: [BUGS] BUG #2554: ILIKE operator works incorrectly

2006-08-03 Thread Peter Eisentraut
JarosÅaw Bojar wrote: > ILIKE operator works incorrectly with UTF8 encoding and Polish > characters. What does SHOW lc_collate say? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 4: Have you search

Re: [BUGS] BUG #2564: configuring secondry database as primary in replication.

2006-08-06 Thread Peter Eisentraut
be the right one. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] error in upper()

2006-08-26 Thread Peter Eisentraut
Richard Troy wrote: > I'm unaware of any upper case or lower case for 'ß' It's a matter of taste whether you leave 'ß' as is or replace it by 'SS' when upper casing. PostgreSQL does upper-casing character by character, so there is no support for one

Re: [BUGS] BUG #2600: dblink compile with SSL missing libraries

2006-08-31 Thread Peter Eisentraut
$(filter -lintl -lssl -lcrypto -lkrb5 -lcrypt -lm, $(LIBS)) $(PTHREAD_LIBS) ifeq ($(PORTNAME), win32) # Link to shfolder.dll instead of shell32.dll SHLIB_LINK += -lshfolder endif Presumably the same would be necessary everywhere else libpq is used. -- Peter Eisentraut http://developer.pos

[BUGS] BUG #2602: nnnone

2006-08-31 Thread Peter Jones
The following bug has been logged online: Bug reference: 2602 Logged by: Peter Jones Email address: [EMAIL PROTECTED] PostgreSQL version: nonw Operating system: noen Description:nnnone Details: none ---(end of broadcast

Re: [BUGS] wrong behavior using to_char()

2006-09-14 Thread Peter Eisentraut
Bruce Momjian wrote: > One idea would be to handle C locale behavior differently from non-C > locale. Right. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #2632: createuser language poblem

2006-09-18 Thread Peter Eisentraut
tters that are actually expected as answers. I'll look into it. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #2688: Building from source with PL/Python fails ("distutils not found")

2006-10-12 Thread Peter Eisentraut
my Python installation: > /usr/local/lib/python2.5/distutils/ That proves only that a directory by that name exists, but you haven't shown any evidence that an importable Python module by that name exists. -- Peter Eisentraut http://developer.postgresql.org/~petere/ --

Re: [BUGS] IYYY: unexpected behaviour

2006-10-12 Thread Peter Eisentraut
produce unexpected result for column 'strange': > > strange | to_char | to_char > ++ > 2005-01-01 | 2006-01-02 | 2006-01-01 This is correct. January 1, 2006 belongs to 2005 in this "ISO" way of counting.

Re: [BUGS] BUG #2690: GRANT does not allow periods in database or schema names

2006-10-13 Thread Peter Eisentraut
ear "." at character 30 You are making the faulty assumption that example.com and "example.com" are the same thing. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] BUG #2693: Abut SQL ASCII through JDBC

2006-10-17 Thread Peter Eisentraut
Delight Chen wrote: > Initdb with SQL_ASCII is work. If you do that, most of the encoding stuff won't work correctly. Use some other encoding. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- T

Re: [BUGS] BUG #2698: Update table alias not supported

2006-10-20 Thread Peter Eisentraut
Lachhman Dass wrote: > In the Update statement alias must be supported Says who? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #2709: how to start postgresql at startup

2006-10-21 Thread Peter Eisentraut
manoj wrote: > how to start postgresql at startup That is not a bug. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #2712: could not fsync segment: Permission

2006-10-23 Thread Peter Brant
The same problem exists in 8.1 too. See this thread http://archives.postgresql.org/pgsql-bugs/2006-04/msg00177.php Tom and Magnus tracked down a cause, but I don't think a fix was ever implemented. FWIW, we were bitten by the fsync problem which you noticed too. Unfortunately we were never ab

Re: [BUGS] BUG #2712: could not fsync segment: Permission

2006-10-23 Thread Peter Brant
That might be one cause (or it might otherwise exacerbate the problem), but it isn't the only cause. We weren't running anti-virus software and neither is Thomas. Unfortunately with the last go around, we collectively ran out of ideas before an underlying cause could be identified. Pete >>> Tom

Re: [BUGS] BUG #2712: could not fsync segment: Permission

2006-10-23 Thread Peter Brant
Move to Linux. :-) In our case, everything but the database servers were already Linux so it was an easy choice. Things have been rock solid since then. Once things get stuck, I don't think there is an alternative besides "stop -m immediate". However, since the problem is caused by an idle back

Re: [BUGS] Sugestion for PostgreSQL Developer´s TEAM!

2006-11-03 Thread Peter Eisentraut
Marcio wrote: > Is complicated encrypt the procedures/functions on Database like > Oracle or similar? In order to execute the code you will have to be able to read it, so there will be no security gained by encryption. -- Peter Eisentraut http://developer.postgresql.org/~

[BUGS] BUG #2741: Double-free on error in ECPGconnect

2006-11-09 Thread Peter Harris
The following bug has been logged online: Bug reference: 2741 Logged by: Peter Harris Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 and earlier Operating system: Linux Description:Double-free on error in ECPGconnect Details: When using more than one

Re: [BUGS] BUG #2758: missing quotes in SQL sentence

2006-11-14 Thread Peter Eisentraut
Dave Page wrote: > No, it's the intended behaviour. pgAdmin doesn't have any idea how > you want to quote SET values, so it leaves it to you to add them. Just quote them all. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(

[BUGS] BUG #2899: psql-odbc logging does not work for ordinary users

2007-01-16 Thread Peter Hardman
The following bug has been logged online: Bug reference: 2899 Logged by: Peter Hardman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows XP Pro Description:psql-odbc logging does not work for ordinary users Details: Checking MyLog

Re: [BUGS] BUG #2908: ISO8601 Date / Time Format Incompatibility

2007-01-21 Thread Peter Eisentraut
David Lloyd wrote: > According to the ISO standard, 8601: The date/time input format in PostgreSQL is determined by the SQL standard, not ISO 8601. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1:

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-21 Thread Peter Eisentraut
; argument type". Computing requires exactness. Aside from the apparent discrepancy between the documentation and the actual behavior, is there an actual use case where this is a problem? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadca

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-21 Thread Peter Eisentraut
sing warning along the road, couldn't you have > walked around that stone ?" No, I'm asking what kind of stone it was and why it is a problem. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #2948: default null values for not-null domains

2007-02-01 Thread Peter Eisentraut
Tom Lane wrote: > I'm starting to get the feeling that the entire idea of NOT NULL > domains is broken :-( How is that so very different from having a default value of 5 with a domain that rejects 5? -- Peter Eisentraut http://developer.postgresql.org/~petere/

Re: [BUGS] BUG #2952: where is the user guide

2007-02-01 Thread Peter Eisentraut
Jessica wrote: > Description:where is the user guide That is a usage question, not a bug report. Perhaps you want to join the pgsql-novices list to learn about using PostgreSQL. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadc

Re: [BUGS] BUG #2977: dow doesn't conform to ISO-8601

2007-02-07 Thread Peter Eisentraut
d "dow" fields conform to each other ? They don't. > If "dow" can not be changed for reasons of backward compatibility, I > suggest a new subfield "dayofweek" that does conform to the standard. That might be reasonable. (Or maybe "isodow".) -- Pe

[BUGS] Weird misinterpretation of EXECUTE in PL/pgSQL

2007-02-09 Thread Peter Eisentraut
# select test2(); ERROR: query "SELECT 'select a', 'b'" returned 2 columns CONTEXT: PL/pgSQL function "test2" line 1 at execute statement In the presence of a comma-separated list of arguments it seems to intepret the EXECUTE command wildly dif

Re: [BUGS] BUG #2994: avg() calculates wrong on Interval-type

2007-02-12 Thread Peter Eisentraut
y system thinks that the average of '1 day 12 hours' and '8 hours' is 22 hours, and also that the average of '2 days' and '3 days' is 2 days and 12 hours, so it does make the assumption that 1 day = 24 hours. -- Peter Eisentraut http://developer.postgre

Re: [BUGS] BUG #3056: strange behave of CHECK constraint

2007-02-22 Thread Peter Eisentraut
Pavel Stehule wrote: > check constraint doesn't work correct: There is nothing incorrect happening here. I think you are confused. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 7: You can help

Re: [BUGS] BUG #3038: information_schema.constraint_column_usage has wrong information for foreign keys

2007-02-23 Thread Peter Eisentraut
Eli Green wrote: > This makes it impossible to know column information for both sides of > a foreign key. I think the information you want is in KEY_COLUMN_USAGE. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of bro

Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

2007-02-23 Thread Peter Eisentraut
vate library that seems to provide a similar interface?" is a "Frequently Asked Question". -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] BUG #3092: character varying and integer cannot be matched

2007-03-01 Thread Peter Eisentraut
Andrew Rass wrote: > ERROR: IN types character varying and integer cannot be matched > SQL Status:42804 Please provide the complete table definitions necessary to reproduce the problem. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of bro

Re: [BUGS] BUG #3087: Endiannes, of all things

2007-03-01 Thread Peter Eisentraut
Michael Witten wrote: > Now I have to issues all of these commands and follow all of these > protocols when a simple copy should have done the trick. What is your point? Complain to your CPU manufacturer if you don't like how they lay out data in memory. -- Peter Eise

Re: [BUGS] BUG #3093: Error with converting error messages between server and client encodings

2007-03-01 Thread Peter Eisentraut
Ilya Storozhilov wrote: > 1. Create database in UTF8 encoding You have likely forgotten to set a matching locale. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner w

Re: [BUGS] initdb error message

2007-03-23 Thread Peter Eisentraut
, the daemon must be running in a different directory, and there is no definite reason why you should stop that one. It might be serving some other application. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)---

Re: [BUGS] postgresql 8.1.5 psql -P recordsep='\n' not work

2007-04-02 Thread Peter Eisentraut
, it's a "\" followed by an "n". You need to actually enter two newlines psql -At -P recordsep=" " -U postgres -c "select generate_series(1,3)" or figure out how your shell makes escapes available. -- Peter Eisentraut http://developer.postgresql.org/~pete

Re: [BUGS] order by question.

2007-05-04 Thread Peter Eisentraut
Jose Blanco wrote: > This second time I did, see > > select author, sort_author from itemsbyauthor where sort_author like > 'tan%' order by 2; No, your posts didn't contain that query. -- Peter Eisentraut http://developer.postgresql.org/~petere/ -

[BUGS] BUG #3266: SSL broken pipes kill the machine and fill the disk

2007-05-10 Thread Peter Koczan
The following bug has been logged online: Bug reference: 3266 Logged by: Peter Koczan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: CentOS Linux 4.4 (RHEL 4) running on Pentium 4 Description:SSL broken pipes kill the machine and fill

Re: [BUGS] BUG #3280: wrong german-translation

2007-05-15 Thread Peter Eisentraut
ht > ebenfalls Tabelle »...«'. löscht is like drop, and this is wrong. The > correct sentence must to be 'Truncate-Vorgang leert ebenfalls Tabelle > »...«'. Fixed. Thanks. -- Peter Eisentraut http://developer.postgresql.org/~petere/ --

Re: [BUGS] BUG #3266: SSL broken pipes kill the machine and fill the disk

2007-05-18 Thread Peter Koczan
One more quick addendum...I tried this with non-SSL connections, and this problem did *not* arise when using non-SSL connections. Peter Koczan wrote: Yes, #2829 seems quite similar to my plight. I did take a look through the code tree and there appear to be checks for an EINTR status within

Re: [BUGS] BUG #3266: SSL broken pipes kill the machine and fill the disk

2007-05-18 Thread Peter Koczan
x27;t know enough about OpenSSL and it took me a long time to find out as much as I did. FYI, I compiled against OpenSSL 0.9.8d, if that makes any difference. Peter Magnus Hagander wrote: This looks a lot like bug #2829 (excep that one is Windows), as I mentioned here:

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

2007-08-02 Thread Peter Koczan
The following bug has been logged online: Bug reference: 3504 Logged by: Peter Koczan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: CentOS 4.5 Linux (RHEL 4), kernel 2.6.9-55.ELsmp Description:Some listening sessions never return from

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

2007-08-02 Thread Peter Koczan
Heikki Linnakangas wrote: Peter Koczan wrote: There is a problem where connections listening for asynchronous notifies occasionally block for writing on ther server side and never finish, resulting in connections that always have the status "notify interrupt". Apparently, this cau

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

2007-08-02 Thread Peter Koczan
Tom Lane wrote: 1Heikki Linnakangas <[EMAIL PROTECTED]> writes: Peter Koczan wrote: There is a problem where connections listening for asynchronous notifies occasionally block for writing on ther server side and never finish, Does the client read the async notifie

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

2007-08-02 Thread Peter Koczan
quick perusal of the other "notify interrupt" connections shows 13032 in the Send-Q column. They all got into this state at the same time. Peter P.S. Thanks for the help, I really appreciate it. On 8/2/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > Peter Koczan <[EMAIL PRO

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

2007-08-02 Thread Peter Koczan
ifies. They may not have happened at the same time, but it's a bit perplexing that they all have the exact same amount of data in the queue. Peter On 8/2/07, Peter Koczan <[EMAIL PROTECTED]> wrote: > > I found something pretty interesting when running netstat's: > > Be

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

2007-08-02 Thread Peter Koczan
= 70400 PQfreemem(notify); #else Safefree(notify); #endif retsv = newRV(sv_2mortal((SV*)ret)); return retsv; } /* end of dbd_db_pg_notifies */ On 8/2/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "Peter Koczan" <[EMAIL PROTECTED]> writes: > &g

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

2007-08-03 Thread Peter Koczan
I think the code is somehow interrupt based, but I don't know. I've asked the primary maintainer of the program to look into this with me. We should have more insight by early next week. Peter Tom Lane wrote: "Peter Koczan" <[EMAIL PROTECTED]> writes: This app

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

2007-08-07 Thread Peter Koczan
f the main window, so it looks like if you have more than one main window open, update_reqs would be called more often. That might have to be changed. So, it looks like the app polls for async notifies every second. Hopefully you can glean some insight from that. Peter On 8/3/07, Peter Kocz

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

2007-08-07 Thread Peter Koczan
hing every second for bad connections (so notifies are being processed somehow), and it doesn't explain why the recv-q is filling up even for good connections. Hopefully this will help somehow, though. Peter P.S. Just in case its useful, the contents of pg_listener for bad connections (I verified

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

2007-08-09 Thread Peter Koczan
On 8/6/07, Tom Lane <[EMAIL PROTECTED]> wrote: > "Peter Koczan" <[EMAIL PROTECTED]> writes: > > Here's my theory (and feel free to tell me that I'm full of it)...somehow, a > > lot of notifies happened at once, or in a very short period of time, to t

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

2007-08-10 Thread Peter Koczan
On 8/9/07, Peter Koczan <[EMAIL PROTECTED]> wrote: > On 8/6/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "Peter Koczan" <[EMAIL PROTECTED]> writes: > > > Here's my theory (and feel free to tell me that I'm full of > > > it)...some

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

2007-08-17 Thread Peter Koczan
e norm, and it seems odd to require a connection to issue a notify itself before being able to read pending notifies from another connection. Any ideas? Peter ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

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

2007-08-17 Thread Peter Koczan
ry (It's DBD::Pg in your > "real" case, isn't it?) *Light bulb lights up* AhI see what's going on now. I think I have enough information to test and fix the problem on our end. Thank you all for your help and patience. This can be considered resolved. Peter --

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