[BUGS] Concatenating strings within a function definition

I'm trying to create a function like so: create function get_lid_prefix (text) returns setof int as 'select lid from ilemma where lemma ~ \'^\' + upper($1)' language 'sql'; I've tried several variations, including 'select lid from ilemma where lemma ~ ' || '^' || ' upper ($1)' 'select lid from

[BUGS] Cannot recreate DB scheme using pg_dump

I'm trying to create a new database whose schema is the same as one that already exists. To my surprise, the following steps don't work: 1) pg_dump -s db1 > db1_schema 2) createdb db2 3) psql -f db1_schema db2 Both db1 and db2 are created by the user "Bob", who also owns all the tables in db1.

[BUGS] Index not used past a certain threshold

I seem to have run into an indexing problem in postgres 7.4 on Solaris 8. An index on a certain table is not being used if a column referenced in the query has more than a certain number of rows for a given value. Here's an example: I have a table like so: Table "public.a1" Column | Ty

[BUGS] Regression test fails on Solaris 9 for 7.4.2

I've compiled and regression-tested 7.4.2 on Solaris 8 without trouble. But I'm having some issues with the same release on Solaris 9. It won't compile with gcc (3.0.4). Config.log tells me: configure:7204: gcc -c -O2 -fno-strict-aliasing -I/usr/local/include conftest.c >&5 In file included

Re: [BUGS] Bugs in bigint indexes

On Wed, 17 Dec 2003, Gustavo Scotti wrote: > > _ > > > Dear developers, > > I almost got nuts those two days I'm stuck with this issue... > Let's get straight to the point. I'm using a small portion of my actual > table, but this is enough.

Re: [BUGS] Bug #584: postgresql will not build on Solaris with cc

On Tue, 12 Feb 2002, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > postgresql will not build on Solaris with cc > > I just found out yesterday that /usr/ucb/cc doesn't work very well on > Solaris; it tries to provide a BSD-ish environment and doesn't really > succeed. You want to use the SUNpr

[BUGS] Where is postgres.h in 7.1.3?

I am upgrading from 7.0.3 to 7.1.3. canon=> select version (); version -- PostgreSQL 7.1.3 on sparc-sun-solaris2.8, compiled by /opt/SUNWspro/bin/cc -Xa I had created several compiled C fun

Re: [BUGS] locale and german umlauts

On Wed, 1 Aug 2001, Wolfgang Winkler wrote: > export LC_CTYPE=de_DE.ISO8859-1 > export LC_COLLATE=de_DE.ISO8859-1 > > and make a database with > > createdb test. > > Is there something obvious I'm doing wrong? > Two things that could help: 1) Make sure the locale has been set before starting the

Re: [BUGS] UPPER and LOWER dosen't work correctly on special caracters(umlauts)

On Tue, 17 Oct 2000 [EMAIL PROTECTED] wrote: > Gert (Pache) reports a bug with a severity of 3 > The lower the number the more severe it is. > > Short Description > UPPER and LOWER dosen't work correctly on special caracters (umlauts) > > Long Description > The Upper- and the lower function don

Re: [BUGS] \dS and \df crashing psql

On Thu, 25 May 2000, Tom Lane wrote: > > Hmm, news to us. It may be a platform-specific problem, so yes please > do send a backtrace. > CAVEAT: I may just be missing something really obvious. A high-level description of the problem is: If postmaster is started with LC_COLLATE set to en_US

Re: [BUGS] \dS and \df crashing psql

On Fri, 26 May 2000, Peter Eisentraut wrote: > The \d series of psql commands are really just shortcuts for various SQL > queries to the system catalogs. Start psql with the -E option to see them. > Therefore it is unlikely that this behaviour is entirely localized at > these functions. Have y

[BUGS] \dS and \df crashing psql

Your name : Nishad Prakash Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Sun Sparc Operating System (example: Linux 2.0.26 ELF) : Solaris 2.6 PostgreSQL version (example: PostgreSQL