[BUGS] Bug: Importing files of different sizes via psql -f

2002-01-22 Thread Hans Plum
= POSTGRESQL BUG REPORT TEMPLATE = Your name : Hans Plum Your email address : [EMAIL PROTECTED] System Configuration - Architectur

[BUGS] Database can´t give the result of the query

2002-01-22 Thread Evandro
When I run this:   select c.cod_curriculo, c.mini_curriculo, c.tipo_curriculo, p.nome_pretensao from curriculo c, pretensao_profissional p, curriculo_pretensao cp, curriculo_pagamento cpag where cp.pretensao=p.cod_pretensao_profissional and c.cod_curriculo = cpag.curriculo and cp.curriculo=

Re: [BUGS] libpq not reentrant

2002-01-22 Thread Mario Lorenz
Tom, I originally worked with Federico to get the garbled passwords issue resolved which hit us (we use Psycopg, and Zope at work). Federico's suggestion to use the crypt from libssl is incomplete, and slightly wrong. The replacement function to use is des_fcrypt() and it takes an additional ar

[BUGS] Message about not null in ALTER TABLE

2002-01-22 Thread Alvaro Herrera
I think this is a bug in the error message: alvherre=> alter table test add column b int not null; ERROR: Adding NOT NULL columns is not implemented. Add the column, then use ALTER TABLE ADD CONSTRAINT. However, there is no way to add a NOT NULL constraint to an existing column in a tab

[BUGS] bug in contrib-global.mk

2002-01-22 Thread Chris Bainbridge
The rule to build .sql for contrib fails, currently its ifneq (,$(MODULES)$(MODULE_big)) %.sql: %.sql.in sed 's,MODULE_PATHNAME,$$libdir/$*,g' $< >$@ endif $libdir never gets substituted, it should be %.sql: %.sql.in sed 's,MODULE_PATHNAME,$(libdir)/$*,g' $< >$@ running: sed

Re: [BUGS] 7.2b5 libpq++ include files broken?

2002-01-22 Thread Peter Eisentraut
Tom Lane writes: > Reinhard Max <[EMAIL PROTECTED]> writes: > > as of 7.2b5 'libpq++.h' includes 'libpq++/pgconnection.h' which in > > turn tries to include 'postgres_fe.h' which can't be found because it > > has bee moved to the 'internal' subdirectory. > > Why was it moved to the internal subdi

Re: [BUGS] 7.2b5 libpq++ include files broken?

2002-01-22 Thread Tom Lane
I wrote: > Reinhard Max <[EMAIL PROTECTED]> writes: >> as of 7.2b5 'libpq++.h' includes 'libpq++/pgconnection.h' which in >> turn tries to include 'postgres_fe.h' which can't be found because it >> has bee moved to the 'internal' subdirectory. > Why was it moved to the internal subdirectory? Aft

Re: [BUGS] 7.2b5 libpq++ include files broken?

2002-01-22 Thread Tom Lane
Reinhard Max <[EMAIL PROTECTED]> writes: > as of 7.2b5 'libpq++.h' includes 'libpq++/pgconnection.h' which in > turn tries to include 'postgres_fe.h' which can't be found because it > has bee moved to the 'internal' subdirectory. Why was it moved to the internal subdirectory? This seems a clear

Re: [BUGS] Bug #564: CREATE TABLE with long table name and long serial column name can cause conflicting sequence naming

2002-01-22 Thread Brent Verner
[2002-01-20 23:49] [EMAIL PROTECTED] said: | Jeff Synnestvedt ([EMAIL PROTECTED]) reports a bug with a severity of 3 | The lower the number the more severe it is. | | Short Description | CREATE TABLE with long table name and long serial column name can | cause conflicting sequence naming This i

[BUGS] 7.2b5 libpq++ include files broken?

2002-01-22 Thread Reinhard Max
Hi, as of 7.2b5 'libpq++.h' includes 'libpq++/pgconnection.h' which in turn tries to include 'postgres_fe.h' which can't be found because it has bee moved to the 'internal' subdirectory. Are applications now required to supply -I/usr/include/pgsql/internal in addition to -I/usr/include/pgsql or