[BUGS] SIGSEGV in Postgres 8.0.3 (libpq4)

2005-10-19 Thread Anand Kumria
Hi, I have a set of perl scripts which invoke each other (via system()); eventually I found that they were crashing and ultimately causing Perl to SIGSEGV. I am using Debian testing and have recompiled postgres-8.0.3-15 to include debugging symbols. This is a dual-CPU dual-stacked IPv4/IPv6 host

[BUGS] BUG #1976: steps to reproduce BUG #1438: Non UTF-8 client encoding problem

2005-10-19 Thread Stanislav Sukholet
The following bug has been logged online: Bug reference: 1976 Logged by: Stanislav Sukholet Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.8.1.FC3.1 Operating system: 2.6.12-1.1378_FC3 Description:steps to reproduce BUG #1438: Non UTF-8 client encoding probl

[BUGS] BUG #1977: Na data in GDV Spatial Commander

2005-10-19 Thread Ulrike
The following bug has been logged online: Bug reference: 1977 Logged by: Ulrike Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 beta3 Operating system: Windows XP Description:Na data in GDV Spatial Commander Details: I try to use the GDV Spatial Commander (

[BUGS] union bug

2005-10-19 Thread Ivan
Hello, PostgreSQL 8.1beta3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) Windows XP SP2 The following query CREATE DOMAIN test_domain AS varchar(64) NOT NULL; CREATE TYPE test_type AS ("Id" int4, "Data" test_domain); CREATE OR REPLACE FUNCTION union_test

[BUGS] Function taking compound type defined on a view with ORDER BY

2005-10-19 Thread Richard Huxton
Earlier today Hakan Kocaman ([EMAIL PROTECTED]) posted a query on general "Issue with functions in Rule". Turned out the problem is with a function that takes a compound type based on a view with ORDER BY. If you add/remove ORDER BY to the view definition in the attached it doesn't recognise t

Re: [BUGS] BUG #1976: steps to reproduce BUG #1438: Non UTF-8 client encoding problem

2005-10-19 Thread Tom Lane
"Stanislav Sukholet" <[EMAIL PROTECTED]> writes: > mydb=# create table b (bb integer primary key); > ERROR: ignoring unconvertible UTF-8 character 0xd3cf Can't reproduce this here. What locale settings are you using in the database? (Particularly lc_ctype and lc_messages)

Re: [BUGS] union bug

2005-10-19 Thread Tom Lane
Ivan <[EMAIL PROTECTED]> writes: > CREATE DOMAIN test_domain > AS varchar(64) > NOT NULL; > CREATE TYPE test_type AS >("Id" int4, > "Data" test_domain); > CREATE OR REPLACE FUNCTION union_test() > RETURNS SETOF test_type AS > $BODY$ > select 1 as "Id", 'string1'::test_domain a

Re: [BUGS] Function taking compound type defined on a view with ORDER BY

2005-10-19 Thread Tom Lane
Richard Huxton writes: > The error is different in 8.0.x and 8.1.x but occurs in both. Fixed in CVS tip --- will look at the 8.0 branch later. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] BUG #1970: Existing /etc/pam.d/postgresql clobbered by

2005-10-19 Thread Devrim GUNDUZ
Hi, On Tue, 18 Oct 2005, Tom Lane wrote: Devrim GUNDUZ <[EMAIL PROTECTED]> writes: I can't see any problems with adding account required pam_stack.so service=system-auth See also https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=167040 which is what inspired this to start with. Not kn

Re: [BUGS] BUG #1976: steps to reproduce BUG #1438: Non UTF-8 client encoding problem

2005-10-19 Thread Tom Lane
Stanislav Sukholet <[EMAIL PROTECTED]> writes: >> Can't reproduce this here.  What locale settings are you using in the >> database?  (Particularly lc_ctype and lc_messages) > mydb=> SHOW client_encoding ; > client_encoding > - > KOI8 > (1 запись) > mydb=> show LC_CTYPE;