Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-29 Thread depstein
Thanks everyone for the explanations. I posted a feature request for improved enum manipulation in psql-general. Dmitry Epstein | Developer Allied Testing www.alliedtesting.com We Deliver Quality. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscr

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-28 Thread Tom Lane
Josh Kupershmidt writes: >> Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011: >>> Anyway, the procedure that we used (based on >>> http://en.dklab.ru/lib/dklab_postgresql_enum/) does the necessary >>> checks before removing enum values. > Not exactly; that code is rife with race

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-28 Thread Merlin Moncure
On Wed, Sep 28, 2011 at 10:40 AM, Tom Lane wrote: > Alvaro Herrera writes: >> Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011: >>> ALTER TYPE ... ADD VALUE does not work inside transaction blocks, period, >>> whether they are executed as a multi-command string or one query at

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-28 Thread Josh Kupershmidt
On Wed, Sep 28, 2011 at 10:51 AM, Alvaro Herrera wrote: > Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011: >> Anyway, the procedure that we used (based on >> http://en.dklab.ru/lib/dklab_postgresql_enum/) does the necessary >> checks before removing enum values. Not exactly; th

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-28 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011: >> ALTER TYPE ... ADD VALUE does not work inside transaction blocks, period, >> whether they are executed as a multi-command string or one query at a time. >> Try it: > The reason it is not allowed is

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-28 Thread Alvaro Herrera
Excerpts from depstein's message of mié sep 28 07:21:17 -0300 2011: > > -Original Message- > > From: Merlin Moncure [mailto:mmonc...@gmail.com] > > Sent: Tuesday, September 27, 2011 10:31 PM > > > 1. We can use ALTER TYPE to add enum values, but there is no matching > > command to remove v

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-28 Thread Merlin Moncure
On Wed, Sep 28, 2011 at 5:21 AM, wrote: >> -Original Message- >> From: Merlin Moncure [mailto:mmonc...@gmail.com] >> Sent: Tuesday, September 27, 2011 10:31 PM >> > 1. We can use ALTER TYPE to add enum values, but there is no matching >> command to remove values, which makes this an incom

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-28 Thread depstein
> -Original Message- > From: Merlin Moncure [mailto:mmonc...@gmail.com] > Sent: Tuesday, September 27, 2011 10:31 PM > > 1. We can use ALTER TYPE to add enum values, but there is no matching > command to remove values, which makes this an incomplete solution. > > you can manually delete fr

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-27 Thread Merlin Moncure
On Tue, Sep 27, 2011 at 5:06 AM, wrote: > Hello, > > I've encountered some problems with the updated ENUM in PosgreSQL 9.1: > > 1. We can use ALTER TYPE to add enum values, but there is no matching command > to remove values, which makes this an incomplete solution. you can manually delete from

Re: [BUGS] Problems with ENUM type manipulation in 9.1

2011-09-27 Thread Kevin Grittner
wrote: > I've encountered some problems with the updated ENUM in PosgreSQL > 9.1: No matter how I tilt my head, I can't see any of those issues as bugs. You have two feature requests and a question about how to work around problems you're having with direct modifications to the system tables.

[BUGS] Problems with ENUM type manipulation in 9.1

2011-09-27 Thread depstein
Hello, I've encountered some problems with the updated ENUM in PosgreSQL 9.1: 1. We can use ALTER TYPE to add enum values, but there is no matching command to remove values, which makes this an incomplete solution. 2. "ALTER TYPE ... ADD cannot be executed from a function or multi-command stri

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-17 Thread Tom Lane
Tim Uckun writes: >> As I've stated repeatedly, your next move needs to be to increase the >> stats target, at least for that column if not globally. > Ok How do I go about doing this. If you want to do it globally for the whole database: change default_statistics_target in postgresql.conf. If

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-17 Thread Tim Uckun
> > As I've stated repeatedly, your next move needs to be to increase the > stats target, at least for that column if not globally.  You probably > don't need to have it know about every last domain id, but you need to > have it know about enough that it realizes that domains not included in > the

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-17 Thread Tom Lane
Tim Uckun writes: >> Am I right in guessing that pg_stats.n_distinct is much too low for >> the domain_id column? > the domain_id is in the topical urls. A select count of domains shows > that there are 700 domains, the pg_stats shows 170 which seems kind of > low but maybe is not out of bounds b

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-17 Thread Tim Uckun
> With a table that large, you're probably going to need a larger stats > target in order to get reasonable estimates for low-frequency values. > Am I right in guessing that pg_stats.n_distinct is much too low for > the domain_id column? the domain_id is in the topical urls. A select count of doma

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-17 Thread Tom Lane
Tim Uckun writes: > relname | pg_relation_size | reltuples | relpages > +--+-+-- > consolidated_urls | 1303060480 | 1.80192e+06 | 159065 > consolidated_urls_pkey |114745344 | 1.80192e+06 |14007

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-17 Thread Robert Haas
On Mon, Jan 17, 2011 at 8:23 AM, Tim Uckun wrote: >> Hmm.  What do you get for: >> >> SELECT relname, pg_relation_size(oid), reltuples, relpages FROM >> pg_class WHERE relname IN ('consolidated_urls', >> 'consolidated_urls_pkey'); > >        relname         | pg_relation_size |  reltuples  | relpa

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-17 Thread Tim Uckun
> > Hmm.  What do you get for: > > SELECT relname, pg_relation_size(oid), reltuples, relpages FROM > pg_class WHERE relname IN ('consolidated_urls', > 'consolidated_urls_pkey'); > relname | pg_relation_size | reltuples | relpages +--+-

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-17 Thread Robert Haas
On Sun, Jan 16, 2011 at 5:47 PM, Tim Uckun wrote: >> Hmm, autovacuum *should* have been keeping track of things for you, >> but it might still be worth doing a manual ANALYZE against that table >> to see if the estimated rowcount changes.  If not, you'll need to raise >> the statistics target for

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-16 Thread Tim Uckun
> > Hmm, autovacuum *should* have been keeping track of things for you, > but it might still be worth doing a manual ANALYZE against that table > to see if the estimated rowcount changes.  If not, you'll need to raise > the statistics target for that column (and again ANALYZE). The analyze finish

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-16 Thread Tim Uckun
> Hmm, autovacuum *should* have been keeping track of things for you, > but it might still be worth doing a manual ANALYZE against that table > to see if the estimated rowcount changes.  If not, you'll need to raise > the statistics target for that column (and again ANALYZE). > I started a manual

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-16 Thread Tom Lane
Tim Uckun writes: >> Possibly the table's never been ANALYZEd ... do you have autovacuum >> enabled? > I do have autovacuum enabled and I am running 8.4 Hmm, autovacuum *should* have been keeping track of things for you, but it might still be worth doing a manual ANALYZE against that table to se

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-15 Thread Tim Uckun
> > Possibly the table's never been ANALYZEd ... do you have autovacuum > enabled?  If it has been analyzed reasonably recently, then it might be > necessary to crank up the statistics target to get a better estimate. > It's difficult to give detailed advice when you haven't mentioned what > PG ver

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-15 Thread pasman pasmański
Both queries use the same row's estimation and cost is comparable. But execution time differs huge: 0.044s and 3100s. I think that the cost of backward index scan is too small. On 1/15/11, Tom Lane wrote: > Tim Uckun writes: >> I reported this in the pgsql-general list and was instructed to send

Re: [BUGS] Problems with adding a is not null to a query.

2011-01-15 Thread Tom Lane
Tim Uckun writes: > I reported this in the pgsql-general list and was instructed to send > the analaze outputs here. This isn't a bug, it's just a poor choice of plan based on a bad statistical estimate. The planner is estimating that there are 2643 rows having domain_id = 157, when actually the

[BUGS] Problems with adding a is not null to a query.

2011-01-15 Thread Tim Uckun
I reported this in the pgsql-general list and was instructed to send the analaze outputs here. have this query it runs reasonably quickly (but should be quicker IMHO) SELECT "consolidated_urls".* FROM "consolidated_urls" INNER JOIN "topical_urls" ON "consolidated_urls".id = "topical_urls".conso

Re: [BUGS] Problems with max_connections parameter

2010-12-14 Thread Robert Haas
On Mon, Dec 13, 2010 at 8:46 PM, Jorge Augusto Meira wrote: > Have something else I can do to reach the limit of the parameter > max_connections? > > This may be a bug? Well, I don't think you've really identified what's happening. Kevin and Tom both suggested possible explanations upthread. --

Re: [BUGS] Problems with max_connections parameter

2010-12-13 Thread Jorge Augusto Meira
Hi again Have something else I can do to reach the limit of the parameter max_connections? This may be a bug? Thanks Jorge On Mon, Dec 6, 2010 at 1:31 PM, Tom Lane wrote: > Jorge Augusto Meira writes: >> The error message was: >> "Erro Conexão: A tentativa de conexão falhou." >> or >> "Erro C

Re: [BUGS] Problems with max_connections parameter

2010-12-06 Thread Jorge Augusto Meira
Hi, Euler - How could the test program know? The test program after any operation (inser, tupdate or select) receive a message of postgres like OK or ERROR (Connection error: FATAL). - Are you using some delay between one test and another one? I would be a good idea, specially if you're restarti

Re: [BUGS] Problems with max_connections parameter

2010-12-06 Thread Euler Taveira de Oliveira
Jorge Augusto Meira escreveu: > The test program is running in other 5 client machines. > In the logs of my test program, the max_connection parameter limit is > never reached. > How could the test program know? Indeed it doesn't. Are you using some delay between one test and another one? I would

Re: [BUGS] Problems with max_connections parameter

2010-12-06 Thread Jorge Augusto Meira
Hi Tom The test program is running in other 5 client machines. In the logs of my test program, the max_connection parameter limit is never reached. Regards Jorge On Mon, Dec 6, 2010 at 1:31 PM, Tom Lane wrote: > Jorge Augusto Meira writes: > > The error message was: > > "Erro Conexão: A tenta

Re: [BUGS] Problems with max_connections parameter

2010-12-06 Thread Tom Lane
Jorge Augusto Meira writes: > The error message was: > "Erro Conexão: A tentativa de conexão falhou." > or > "Erro Conexão: FATAL: connection limit exceeded for non-superusers" Hmm ... I can't find the first of those anywhere in the 8.4 message lists; but the second one definitely says that you *

Re: [BUGS] Problems with max_connections parameter

2010-12-06 Thread Jorge Augusto Meira
Hi Thanks for the answers. Really, I didn't showed you basic informations. I used the PostgreSQL 8.4. The server configuration was: Processor: Intel Xeon Processor W3570 Quad Core Processor Mem: 20GB Network Interface: Gigabit HD: 12 x 1 TB (RAID1+0) OS: Debian

Re: [BUGS] Problems with max_connections parameter

2010-12-03 Thread Kevin Grittner
Euler Taveira de Oliveira wrote: > Talking about your problem, are you sure you're not reaching > max_connections? It also strikes me that from the minimal information given, it might be possible that pid numbers or port numbers are wrapping around before the OS is ready to allow re-use. I h

Re: [BUGS] Problems with max_connections parameter

2010-12-03 Thread Euler Taveira de Oliveira
Jorge Augusto Meira escreveu: > This is a bug? > You don't provide sufficient information. PostgreSQL version? Error message? Talking about your problem, are you sure you're not reaching max_connections? Did you check the logs? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent

[BUGS] Problems with max_connections parameter

2010-12-02 Thread Jorge Augusto Meira
Hi all, I am a master student on database systems and I'm working on a stress testing methodology. The goal is to stress testing PostgreSQL under different workloads. Thus, I would like to discuss with you some results. My methodology is based on the increment of two variables: complexity and wor

Re: [BUGS] problems instaling

2008-07-08 Thread gildas prime
@postgresql.org Objet : [BUGS] problems instaling Hello support Im having problem instaling postgresql. I nead the program to use poker tracker in windows vista. when im finishin the instalation apears this message: (User "postegres" could not be created: The user account already exist

[BUGS] problems instaling

2008-07-08 Thread filipe moreira
Hello support Im having problem instaling postgresql. I nead the program to use poker tracker in windows vista. when im finishin the instalation apears this message: (User "postegres" could not be created: The user account already exists.!) Can you help me?? thanks Filipe Moreira _

Re: [BUGS] problems compiling in 64 bits

2008-05-31 Thread Tom Lane
"Gerardo Antonio" <[EMAIL PROTECTED]> writes: > I am trying to compile Postgres 8.1.9 in the following Linux version: > Linux version 2.6.9-34.EL ([EMAIL PROTECTED]) (gcc version > 3.4.5 20051201 (Red Hat 3.4.5-2)) > but I get a bunch of errors saying " > i386 architecture of input file > `../.

[BUGS] problems compiling in 64 bits

2008-05-30 Thread Gerardo Antonio
Hi there, I am trying to compile Postgres 8.1.9 in the following Linux version: Linux version 2.6.9-34.EL ([EMAIL PROTECTED]) (gcc version 3.4.5 20051201 (Red Hat 3.4.5-2)) but I get a bunch of errors saying " i386 architecture of input file `../../src/port/libpgport_srv.a(pgstrcasecmp_srv.o)'

Re: [BUGS] Problems with UTF8 in PSQL

2006-07-12 Thread REISS Thomas DSIC DESP
Hello, When I experience the problem, the current Linux locale on my server is [EMAIL PROTECTED] Psql works fine if I change the current locale (by setting the LANG shell variable) to [EMAIL PROTECTED] I would be glad if psql may work fine without changing the LANG variable in the current se

[BUGS] Problems with UTF8 in PSQL

2006-07-12 Thread rolf
Hallo, I don't know if the problem has been reported yet, but it seems to have more implications. - Prerequisite: o PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.4 20060507 (prerelease) (Debian 4.0.3-3) o and psql o A database which was created with -E UTF8 - Des

[BUGS] problems with renaming a column of type serial & pg_dump

2006-03-15 Thread alexis
Name: Alexis Wilke email: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating System: Linux RedHat 9.0 Short Description: problems with renaming a column of type serial and GRANT/REVOKE instructions in pg_dump Details: Hi guys, I have been working on a database

[BUGS] Problems with createlang - windows

2006-02-06 Thread Márcio A . Sepp
  Hi,     There is something wrong with createlang on my windows system. Please, see the output:   C:\>"Arquivos de programas\PostgreSQL\8.1\bin\createlang.exe"  pltcl -U postgres  test createlang: language installation failed: ERROR:  could not load library "C:/Arq uivos de progra

[BUGS] Problems with index-scan on regexp in 8.1

2005-11-08 Thread Lars Kanis
Sorry, I accidentally posted this at pgsql-hackers already. Again: We're using Postgres 8.0.2 on SuSE10.0 (64-Bit). Tests on 8.1 beta 4 have shown no problems but this one: SELECT * FROM mitglieder WHERE lower(vorname::text)='lars' does a bitmap-index-scan like this: Bitmap Heap Scan on mi

[BUGS] Problems found when compare pgsql odbc 8.0 and myodbc 3.5 using EOModeler

2005-08-23 Thread YL
EOModeler is a GUI tool to model the database schema as well as the mapping between database records and EnterpriseObjects. The version I'm using comes with database adaptors for Oracle, Sybase,Informix,LDAp FlatFile,Openbase and ODBC. I've used EOModeler with many differenct databases includ

Re: [BUGS] Problems with "-w" option on pg_ctl.exe running as a windows

2004-12-21 Thread Bruce Momjian
Looking at the two patches I just applied I think it might fix your problem. The problem was actually the general problem of pg_ctl -w start not returning a non-zero. --- Steve McWilliams wrote: > Hello, > > I tried sending

[BUGS] Problems with "-w" option on pg_ctl.exe running as a windows service

2004-12-21 Thread Steve McWilliams
Hello, I tried sending this the other week but for some reason it hasn't gone through, so I am resending: I am using Postgresql-8.0.0beta4 on Windows XP Pro and have noticed that attempts to run pg_ctl as a service fail when the "-w" option is included. So if I register the service as follows:

[BUGS] Problems with "-w" option on pg_ctl.exe running as a service

2004-12-10 Thread Steve McWilliams
Hello, I tried mailing this to the pgsql-hackers-win32 list but for some reason it hasn't gone through, so I will send it to pgsql-bugs as well: I am using Postgresql-8.0.0beta4 on Windows XP Pro and have noticed that attempts to run pg_ctl as a service fail when the "-w" option is included. So

Re: [BUGS] problems with OS X and beta 2

2004-09-10 Thread Theodore Petrosky
How's this one... I realized that the machine I was testing on was running '[EMAIL PROTECTED]'.. so I quit it.. Lo and behold beta 2 compiled and made (with make check) just fine. Thanks Ted --- Tom Lane <[EMAIL PROTECTED]> wrote: > Theodore Petrosky <[EMAIL PROTECTED]> writes: > > Did I miss

Re: [BUGS] problems with OS X and beta 2

2004-09-10 Thread Theodore Petrosky
I downloaded the beta 2 source, ./configure --with-rendezvous make no other configurations... I did this same configuration on the beta 1 and it was fine. (other than a make check that we had to add an env line..) I am going to try again by throwing away the folder that starting fresh... Ted

Re: [BUGS] problems with OS X and beta 2

2004-09-10 Thread Tom Lane
Theodore Petrosky <[EMAIL PROTECTED]> writes: > Did I miss something that I should so to make 8.0beta2 > for Mac OS X. Last time I tried it (which was a couple weeks back), our CVS tip built perfectly cleanly on OS X. Other people report success too, modulo that silly minus-zero bit in one regres

[BUGS] problems with OS X and beta 2

2004-09-10 Thread Theodore Petrosky
Did I miss something that I should so to make 8.0beta2 for Mac OS X. I read the README and install and I see no specific instructions for OS X. Here is the info where the make fails. OS X 10.3.5 gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1666) What else can I send to you? Ted gcc -no-

Re: [BUGS] PROBLEMS!!!

2004-08-06 Thread Kris Jurka
On Fri, 30 Jul 2004, [iso-8859-1] liz gonzalez wrote: > Dear Sr. or Madam, > > I am writting to you because I am having problems with > the configuration of PostgreSQL v. 7.4 on LINUX, I > want to configurate it in JAVA , I set: > > $./configure --with-java > > checking whether to build Java

[BUGS] PROBLEMS!!!

2004-08-05 Thread liz gonzalez
Dear Sr. or Madam, I am writting to you because I am having problems with the configuration of PostgreSQL v. 7.4 on LINUX, I want to configurate it in JAVA , I set: $./configure --with-java The response was: [EMAIL PROTECTED] postgresql-7.4]$ ./configure --with-java checking build system type.

[BUGS] Problems renaming referencing column

2004-07-18 Thread Alexander M. Pravking
In 7.4.3, if I rename a column which references another table, constraint trigger fails on update or delete from main table. There are a couple of similar (and about rename table itself) reports for 7.0, 7.1 (as Tom Lane said, rename table is fixed in 7.2), but I see no more reports since 2001. H

Re: [BUGS] Problems renaming referencing column

2004-07-17 Thread Tom Lane
"Alexander M. Pravking" <[EMAIL PROTECTED]> writes: > In 7.4.3, if I rename a column which references another table, > constraint trigger fails on update or delete from main table. The following patch (against 7.4.*) appears to fix this problem. regards, tom lane Index: t

Re: [BUGS] Problems renaming referencing column

2004-07-17 Thread Tom Lane
"Alexander M. Pravking" <[EMAIL PROTECTED]> writes: > In 7.4.3, if I rename a column which references another table, > constraint trigger fails on update or delete from main table. > The problem goes away after re-creating the foreign key: Actually all you have to do is start a fresh backend. Th

Re: [BUGS] Problems renaming referencing column

2004-07-17 Thread Stephan Szabo
On Sat, 17 Jul 2004, Alexander M. Pravking wrote: > (sorry if it's a dup) > > In 7.4.3, if I rename a column which references another table, > constraint trigger fails on update or delete from main table. I think this probably has to do with the fact that the plan gets cached. If I close the con

[BUGS] Problems renaming referencing column

2004-07-17 Thread Alexander M. Pravking
(sorry if it's a dup) In 7.4.3, if I rename a column which references another table, constraint trigger fails on update or delete from main table. There are a couple of similar (and about rename table itself) reports for 7.0, 7.1 (as Tom Lane said, rename table is fixed in 7.2), but I see no more

[BUGS] Problems....

2004-05-03 Thread Bruno Necchi
Helo I have a problem with postgres_beta4. I wanna know as resolv this problem. I'm using Windows Server 2003. Thank You, Bruno Necchi. error: C:\winpsql\bin>createuser Enter name of user to add: e Shall the new user be allowed to create databases? (y/n) y Shall the new user be allow

Re: [BUGS] Problems with initdb

2003-12-13 Thread Chris Travers
Hi Denise, I ran into this problem for quite a while until I read the README that came with the PostgreSQL installation (under /usr/share/doc, I think). I highly recommend referring to this document. There could be a couple causes of your error, and since cygwin handles the Sysv IPC calls differ

[BUGS] Problems with initdb

2003-12-12 Thread denise
Hi, I tried installed PostgreSql using CygWin in Windows 2000. I got the following error when I tried to run initdb. creating configuration files... ok > creating template1 database in /usr/share/postgresql/data/bas > d not create shared memory segment: Function not implemented > DETAIL:

Re: [BUGS] problems...

2003-07-05 Thread Tom Lane
"Alejandro Delu" <[EMAIL PROTECTED]> writes: > IpcSe > maphoreCreate: semget(key=3D1, num=3D17, 03600) failed: Function not implem= > ented > When I want to init the database, It does the previous error, what's wrong?= > ?? Looks like your kernel doesn't have SysV shared memory support enabled. Th

[BUGS] problems...

2003-07-05 Thread Alejandro Delu
I have next error:   $ initdb -D /usr/local/postgresql/data/bases1The files belonging to this database system will be owned by user "sp01ad".This user must also own the server process.   The database cluster will be initialized with locale C.   creating directory /usr/local/postgresql/data/

Re: [BUGS] Problems with insert rule called from plpython

2003-02-14 Thread Tom Lane
Pavel Hanak <[EMAIL PROTECTED]> writes: > Now calling "select testfun()" shows this fatal error: >FATAL: SPI: improper call to spi_dest_setup Hm, I'm glad I put in that test --- it exposed a problem. Here is the patch for 7.3. regards, tom lane *** src/backend/exec

[BUGS] Problems with insert rule called from plpython

2003-02-14 Thread Pavel Hanak
Hello, I've noticed one problem by upgrading from postgresql-7.3.1 to 7.3.2. The example of this problem looks like this: create table test (a int, b text); create view testview as select * from test; create or replace rule testview_ins as on insert to testview do instead ( ins

Re: [BUGS] Problems with select chaining using INTERSECT

2002-06-13 Thread Stephan Szabo
On Thu, 13 Jun 2002, Michael Beckstette wrote: > Version: PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 > > Hi, when using SELECT queries chained by INTERSECT i get confused about the > behavour of the INTERSECT operation. I try to outline this with the following > examples.

Re: [BUGS] Problems with select chaining using INTERSECT

2002-06-13 Thread Tom Lane
"Michael Beckstette" <[EMAIL PROTECTED]> writes: > Version: PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 > Hi, when using SELECT queries chained by INTERSECT i get confused about the > behavour of the INTERSECT operation. Nested INTERSECT and EXCEPT queries are broken in 7.1.*

[BUGS] Problems with select chaining using INTERSECT

2002-06-13 Thread Michael Beckstette
Version: PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 Hi, when using SELECT queries chained by INTERSECT i get confused about the behavour of the INTERSECT operation. I try to outline this with the following examples. Example (Field query_desc is of type TEXT): select query_

[BUGS] problems with non-trust authentication methods in 7.3devel?

2002-04-24 Thread Hubert depesz Lubaczewski
Version: 7.3 devel, updated today, 7:00 am warsaw time. Operating System: Linux polpot 2.2.20 #1 Sun Mar 17 11:56:15 UTC 2002 i686 Pentium_III_(Coppermine) Compiler and libraries: $ ldd work/bin/postmaster | sed 's/^.* => //' | awk '{print $1}' | xargs ls -l lrwxrwxrwx

Re: [BUGS] Problems with my server...

2002-01-24 Thread Tom Lane
"Paulo Jorge Gomes Ferreira" <[EMAIL PROTECTED]> writes: > I've got a problem in my PostgreSQL server. Anytime I issue some commands > (like vacuum...) I got the following message: > prescricoes=> vacuum; > ERROR: cannot find attribute 3 of relation pg_views What Postgres version are you runnin

[BUGS] Problems with my server...

2002-01-24 Thread Paulo Jorge Gomes Ferreira
Hi, there !! I've got a problem in my PostgreSQL server. Anytime I issue some commands (like vacuum...) I got the following message: prescricoes=> vacuum; ERROR: cannot find attribute 3 of relation pg_views prescricoes=> what can be wrong ?? I think that all my data is there and I have no vie

[BUGS] problems linking with-tcl

2001-12-10 Thread jacques . talbot
Hi I want to install postgres sql with tcl on RISC/6000 under AIX 4.3.2 I downloaded postgresql-7.1.3.tar.gz gunziped it and extarted the tar. Then I ran ./configure --with-tcl --with-includes=/hci/root3.7.1P/tcl/include --with-libraries=/hci/root3.7.1P/tcl/lib --with-tclconfig=/hci/root3.7.1P/

[BUGS] problems after server crash

2001-10-25 Thread Martin Würtele
hi, 1. unfortunately i can't subscribe to the mailinglist - it doesn't send me the confirmation mail so please cc me. 2. we had a server crash today - had to fsck and postgres is corrupted now if i try a pg_dump i get: inetmain:/tmp/tests$ pg_dump -c -v -d factline1 > /tmp/factline1_20011025_1

[BUGS] Problems

2001-09-27 Thread Micha³ Osmenda
Hi all! I have problems wich I can't manage. psql: ERROR: Function OID 1039 does not exist - one database and psql: FATAL 1: Index 'pg_trigger_tgrelid_index' does not exist - second database What's going on? Of course I can't connect to these databases and do anaything like pg_dump. Miky [EMAI

[BUGS] Problems with remote access

2001-06-06 Thread pgsql-bugs
Elie Atallah ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Problems with remote access Long Description I installed PostgreSQL on an NTServer machine via cygwin and I had no problems accessing the databases on this machine.

Re: [BUGS] Problems with avg on interval data type

2001-05-18 Thread Tom Lane
[EMAIL PROTECTED] writes: > The query does an avg on an interval column and now gets the error: > ERROR: Bad interval external representation '0' Sorry about that :-(. A last-minute tightening of the allowed input formats for interval broke avg(interval), but you're the first one to notice. I

[BUGS] Problems with avg on interval data type

2001-05-17 Thread pgsql-bugs
Jeremy Blumenfeld ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Problems with avg on interval data type Long Description We have recently upgraded from 7.0.3 to 7.1 and a query which used to work is no longer working. The qu

[BUGS] Problems with latest tests

2001-03-22 Thread Rainer Mager
Hi all, I haven't been following the current thread on failed tests but I just had some so I thought I'd mention it. If this is a repeat then I apologize. I configured with: ./configure --enable-multibyte --enable-syslog --with-java --with-maxbackend s=70 And the test

[BUGS] Problems Compiling on a R3000 MIPS

2001-01-14 Thread Michael Richards
Hi. I'm trying to compile 7.0.3 on a MIPS1 R3000 processor under NetBSD. It pukes on the infamous s_lock.c file because of some assembler that's expecting a MIPS2 processor. gcc -I../../../include -I../../../backend -O2 -pipe -Wall -Wmissing- prototypes -Wmissing-declarations -I../.. -c -

[BUGS] problems During installation of 7.0.3

2000-12-30 Thread Lok Group of companies
I tried to install rel 7.0.3 on RH Linux. The command "gmake install" failed after creating lib and bin directories. I tried to go thru the script files. and found three variables ($LIBDIR) , ($BINDIR) & ($INCLUDEDIR) in the Gmakefile. I Could not find definition for ($INCLUDEDIR) anywhere.

Re: [BUGS] Problems with rules

2000-11-14 Thread Gena Gurchonok
Hello > Long Description > The given code is destilled from a reallife DB. All attempts to define a rule which >automatically updates the column aenderungsdatum from table mitglieder on updates >failed. The result was every > time > psql:ruleerror:17: ERROR: query rewritten 10 times, may con

[BUGS] Problems with rules

2000-11-14 Thread pgsql-bugs
Carsten Zerbst ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Problems with rules Long Description The given code is destilled from a reallife DB. All attempts to define a rule which automatically updates the column aenderung

Re: [BUGS] Problems building on IRIX 6.x

2000-03-30 Thread Tom Lane
David Kaelbling <[EMAIL PROTECTED]> writes: >> Those all look like big problems, though. They might all have a >> single root cause ... hard to tell from here. > Can you suggest how I might track them down or gather enough information > that you could diagnose the problem? In all seriousness, I

Re: [BUGS] Problems building on IRIX 6.x

2000-03-30 Thread David Kaelbling
Peter Eisentraut wrote: > > On Wed, 29 Mar 2000, David Kaelbling wrote: > > > "info.c", line 2142: warning(1551): variable "htbl_stmt" is used before > > its value is set > > > There were some "pointless comparison of unsigned integer with zero" > > messages too. The linker also whined because

Re: [BUGS] Problems building on IRIX 6.x

2000-03-30 Thread David Kaelbling
Tom Lane wrote: > > David, 6.5.2 is pretty much ancient history for us. Some of the > problems you mention have been addressed in current sources, but > I'm not sure if they all have been. Yes, sorry -- that was a typo. I was building 6.5.3. > > I also had some regression failures: > > - o

Re: [BUGS] Problems building on IRIX 6.x

2000-03-30 Thread Peter Eisentraut
On Wed, 29 Mar 2000, David Kaelbling wrote: > "info.c", line 2142: warning(1551): variable "htbl_stmt" is used before > its value is set > There were some "pointless comparison of unsigned integer with zero" > messages too. The linker also whined because fmgr_pl_finfo is multiply > defined, as

Re: [BUGS] Problems building on IRIX 6.x

2000-03-29 Thread Tom Lane
David Kaelbling <[EMAIL PROTECTED]> writes: > I built postgresql 6.5.2 for SGI IRIX 6.x systems, and ran into a few > problems. I've have diffs if anyone needs them, but they all boil down > to files in src/interfaces/odbc that use C++ comments in C code. David, 6.5.2 is pretty much ancient hist

[BUGS] Problems building on IRIX 6.x

2000-03-29 Thread David Kaelbling
I built postgresql 6.5.2 for SGI IRIX 6.x systems, and ran into a few problems. I've have diffs if anyone needs them, but they all boil down to files in src/interfaces/odbc that use C++ comments in C code. I built --without-CXX because libpq++ requires "", and so can only be built with g++. Som