Re: [BUGS] BUG: Each UNION | EXCEPT | INTERSECT query must have the same number of columns.

Jacek Konieczny <[EMAIL PROTECTED]> writes: > CREATE TABLE tb1 ( a CHARACTER(10) DEFAULT 'abc', b CHARACTER(10)); > CREATE TABLE tb2 ( a CHARACTER(10), b CHARACTER(10)); > INSERT INTO tb1(b) SELECT b FROM tb2 EXCEPT SELECT b FROM tb1; This is fixed for 7.1. regards, tom l

Re: [BUGS] LATIN2 and wrong upper() and lower() functions output

Robert Gaszewski writes: > When I try SELECT UPPER('some_text_with_polish_national_chars'); > polish chars are still in lower case but others (abcd...wxyz) are > in upper case. > I compiled PostgreSQL with --enable-multibyte and > --enable-unicode-conversion. Case conversion and ordering are co

Re: [BUGS] I can't initialize

Fernando Schutz writes: > This error ocurs when I've tried to run /usr/local/pgsql/bin/initdb -D >/usr/local/pgsql/data: > > > > This database system will be initialized with username "postgres". > This user wil

Re: [BUGS] unix_socket_directory isn't used by all bin tools

On Fri, 30 Mar 2001, Peter Eisentraut wrote: > > Jerome Alet ([EMAIL PROTECTED]) reports a bug with a severity of 2 > > The lower the number the more severe it is. > > > I've defined unix_socket_directory to be /var/lib/postgres > > in /var/lib/data/postgresql.conf > > > > it seems that at least

[BUGS] PORTS : Windows 95/98/2000

I have tried with postgresql-7.0-nt-binaries.tar.gz version on Win98(and win 2000). All runs well until I start the postmaster daemon, a this point I obtain this error: $POSTGRES.EXE: *** recreate_mmaps_after_fork_failed Startup failed - abort NOTICE: IpcMemoryDetach: shmdt(0x???): Invalid a

[BUGS] RE: [JDBC] Possible large object bug?

Hi, Tom C. and I exchanged a few emails about the issue offlist; Tom spotted after a while that the PostgreSQL data had been clobbered by the output of my cron job (not possible in normal conditions I guess)... end result being he suspects its a hardware glitch or similar (also had 'wc' dump c

Re: [BUGS] unix_socket_directory isn't used by all bin tools

> Jerome Alet ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > I've defined unix_socket_directory to be /var/lib/postgres > in /var/lib/data/postgresql.conf > > it seems that at least createuser doesn't take care of this directory > setting, b

Re: [BUGS] pq_shadow

webmaster writes: > [root@crescent1 root]# createuser webmaster -P > Enter password for user "webmaster": > Enter it again: > Shall the new user be allowed to create databases? (y/n) y > Shall the new user be allowed to create more new users? (y/n) y > psql: FATAL 1: SetUserId: user 'root' is no

[BUGS] LATIN2 and wrong upper() and lower() functions output

I have PostgreSQL 7.1RC1 with multibyte support and encoding set to LATIN2. When I try SELECT UPPER('some_text_with_polish_national_chars'); polish chars are still in lower case but others (abcd...wxyz) are in upper case. For example: (Client encoding is LATIN2) input: SELECT UPPER('łąka');

[BUGS] unix_socket_directory isn't used by all bin tools

Jerome Alet ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description unix_socket_directory isn't used by all bin tools Long Description I use 7.1RC1 I've defined unix_socket_directory to be /var/lib/postgres in /var/lib/data/postgresql

[BUGS] Error in the date field (with NULL value...).Thanks!

Subject: Importing data from Informix to PostgreSQL. Error in the date field (WITH NULL value) Hello! I'll try to explain my little problem. Well, I have this table create table mytable ( codice char(16) not null, dt_inizio date, dt_finedate, tipo_operaz

[BUGS] Please, fix!!! The backend can crash on your system!

If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the proble

[BUGS] pq_shadow

I am writing you because I am new to Postgesql and I have encountered a problem that I have not been able to solve through your doc's or mailing list. The problem is with the createuser utility. When I try to create a user I get the following error:  

[BUGS] I can't initialize

This error ocurs when I've tried to run /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data:     This database system will be initialized with username "postgres".This user will own all the data files and mus

[BUGS] BUG: Each UNION | EXCEPT | INTERSECT query must have the same number of columns.

Your name : Jacek Konieczny Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : AMD K6-II 3DNow Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.2 ELF (PLD Distribution) PostgreSQ