[BUGS] BUG #1011: Explain analyze "query" cause segv

2003-12-16 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1011 Logged by: Pawel Rutkowski Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: FreeBSD rsc.pl 4.9-STABLE FreeBSD 4.9-STABLE #22: Tue Dec 2 20:31:00 CET 2003 Description:Explain anal

Re: [BUGS] pg_dump of table including check rule fails to restore

2003-12-16 Thread Peter Eisentraut
Lewis Foti wrote: > Further to my original message I realise that the problem was due to > the text of the rule still referring to columns, src_section_id and > dst_section_id by their original names, parent_section_id and > child_section_id respectively. So the nature of the bug changes to > that

Re: [BUGS] pg_dump of table including check rule fails to restore

2003-12-16 Thread Peter Eisentraut
Lewis Foti wrote: > I have a schema which includes one table with a CHECK constraint. > After the schema is dumped (with pg_dump) as ascii text attempts to > recreate it using the psql -f command cause this one > table, called navigaion, to fail to create. This is using postgresql > 7.3.3 on Redha

Re: [BUGS] unicode upper and lower functions

2003-12-16 Thread Peter Eisentraut
Lauris Buk¨is wrote: > I have PostgreSQL 7.3.2 on Mandrake 9.1. > functions lower and upper doesn't convert UTF8 char cases... it just > leave them as thay are. Atleast I have problems with latvian and > russian letters. Database charset is set to UNICODE. Yes, next time please search the archives

[BUGS] unicode upper and lower functions

2003-12-16 Thread Lauris Bukšis
I have PostgreSQL 7.3.2 on Mandrake 9.1. functions lower and upper doesn't convert UTF8 char cases... it just leave them as thay are. Atleast I have problems with latvian and russian letters. Database charset is set to UNICODE. Where is the problem and what I should do? Lauris

[BUGS] pg_dump of table including check rule fails to restore

2003-12-16 Thread Lewis Foti
Hi   I have a schema which includes one table with a CHECK constraint. After the schema is dumped (with pg_dump) as ascii text attempts to recreate it using the psql -f command cause this one table, called navigaion, to fail to create. This is using postgresql 7.3.3 on Redhat 9.0.  The frag

Re: [BUGS] pg_dump of table including check rule fails to restore

2003-12-16 Thread Lewis Foti
Further to my original message I realise that the problem was due to the text of the rule still referring to columns, src_section_id and dst_section_id by their original names, parent_section_id and child_section_id respectively. So the nature of the bug changes to that pg_dump does not correctly e

[BUGS] PG7.4 / psqlodbc / log_duration=true & client_min_messages=log / Can't connect

2003-12-16 Thread tim
Dear List, PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1 (Mandrake Linux 9.2 3.3.1-2mdk) psqlodbc versions: 07_03_0100 & 07_03_0200 I've found a minor bug whilst using psqlodbc to connect to PostgreSQL. I have found that if you set in postgresql.conf: client_min_messag

[BUGS] BUG #1010: format_type errors oin formatting type interval.

2003-12-16 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1010 Logged by: Jeff Davis Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux, Mac OS X 10.3 Description:format_type errors oin formatting type interval. Details: head=# select ve

[BUGS] BUG #1009: ERROR: could not open segment 1 of relation...

2003-12-16 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1009 Logged by: Christopher Hodson Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: freebsd 5.2 Description:ERROR: could not open segment 1 of relation... Details: I have a script th

Re: [BUGS] BUG #1006: information schema constraint information.

2003-12-16 Thread Peter Eisentraut
Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> But if I read SQL99 correctly, only referencing not referenced > >> columns are supposed to be shown. > > > > It is supposed to show the referenced (primary key) columns. > > [ reads spec more carefully... ] Ye

[BUGS] pg_service.conf ignores dbname parameter

2003-12-16 Thread Michael Fuhr
POSTGRESQL BUG REPORT TEMPLATE Your name : Michael Fuhr Your email address : [EMAIL PROTECTED] Syst