[BUGS] BUG #2995: PSQLRestore crash and MemoryLeaks!

2007-02-13 Thread Bruno
The following bug has been logged online: Bug reference: 2995 Logged by: Bruno Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows XP SP2 Description:PSQLRestore crash and MemoryLeaks! Details: Hello, We see many memory leaks using

[BUGS] BUG #3111: PostgreSQL Driver is compatible with Win2003 Server 64 bits?

2007-03-06 Thread Bruno
The following bug has been logged online: Bug reference: 3111 Logged by: Bruno Email address: [EMAIL PROTECTED] PostgreSQL version: v8.2.3 Operating system: Win2003 Server 64bits Description:PostgreSQL Driver is compatible with Win2003 Server 64 bits? Details

[BUGS] BUG #4583: Db stop

2008-12-18 Thread Bruno Pimenta
The following bug has been logged online: Bug reference: 4583 Logged by: Bruno Pimenta Email address: brunofpime...@gmail.com PostgreSQL version: 8.1.4 Operating system: Windows 2003 Server SP2 Description:Db stop Details: I have a system in Java and I'm usin

[BUGS] bug in psql

2000-03-09 Thread Pinaud Bruno
Your name : Pinaud Bruno Your email address : [EMAIL PROTECTED] or [EMAIL PROTECTED] System Configuration - Architecture : Pentium 3 Operating System : RedHat Linux 6.1 PostgreSQL version : PostgreSQL-7.0 Beta1

[BUGS] BUG #2497: bug initdb

2006-06-26 Thread bruno Corbin
The following bug has been logged online: Bug reference: 2497 Logged by: bruno Corbin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: linux Description:bug initdb Details: copying template1 to postgres ... FATAL: could not create file

[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

[BUGS] Problem with interval

2004-10-06 Thread Bruno Prévost
Hi,I'm using postgres version 7.4.5 and had a problem with interval   Here is my query : select '2004/10/31'::timestamptz + '1 day'::interval;   Here is the answer : 10/31/2004 11:00:00 PM     Is it a bug or I do something wrong? I tested my query on 3 server and have always the same answer.

[BUGS] BUG #4944: Problems with using \set variables as strings in select statements

2009-07-27 Thread Bruno Scovoli Santos
The following bug has been logged online: Bug reference: 4944 Logged by: Bruno Scovoli Santos Email address: bruno.scov...@gmail.com PostgreSQL version: 8.3.7 Operating system: Ubuntu 9.04 Jaunty Jackalope Description:Problems with using \set variables as strings in

[BUGS] Bug report

2000-12-13 Thread Bruno Wolff III
POSTGRESQL BUG REPORT TEMPLATE Your name : Bruno Wolff III Your email address : [EMAIL

[BUGS] More on previous bug report

2000-12-14 Thread Bruno Wolff III
I think the problem is somehow related to roman numeral conversion when some values are null. The following seems to work: select case when gen is not null then to_char(gen,'rn') else null end, case when gen is not null then to_char(gen+1,'rn') else null end from cname; While the following doesn'

[BUGS] grant oddity

2000-12-15 Thread Bruno Wolff III
POSTGRESQL BUG REPORT TEMPLATE Your name : Bruno Wolff III Your email address

Re: [BUGS] Bug report

2000-12-19 Thread Bruno Wolff III
ug report. Can you report > simple data select (how data go into your query - for example same query > but without to_char())? > > Thanks. > Karel > > > > > > > > Here is a sample of one kind of error I was getting with the about query

[BUGS] Problem using pg_dump going from 7.0.3 to 7.1beta3

2001-01-09 Thread Bruno Wolff III
I was moving a small database I had from 7.0.3 to 7.1beta3 using pgdump and had a problem with a view. The I got a syntax error when the rule corresponding to the view was being processed. While looking around I noticed that the dump file created a table with the name of the view instead of creati

[BUGS] to_char appears fixed in 7.1beta3

2001-01-09 Thread Bruno Wolff III
A problem I reported a few weeks ago here using to_char to do a conversion to roman numerals with many of the values being null doesn't seem to be a problem in 7.1beta3.

[BUGS] possible 7.1beta3 bug with union and order by a function

2001-01-09 Thread Bruno Wolff III
The query below used to work with 7.0.3. If I change 'lower(title)' to 'title' in the order by clause, then the query is accepted. area=> select code, wbc.gameid, title from games, wbc where wbc.gameid = games.gameid union select code, null, null as title from wbc where gameid is null order by c

[BUGS] Re: round - timestamp bug

2001-01-25 Thread Bruno Wolff III
On Wed, Jan 24, 2001 at 05:50:24PM -0300, Gonzalo Arana <[EMAIL PROTECTED]> wrote: > > It seems that there is a problem when retrieving a timestamp value (rounding). > > NO minute has 61 seconds. Am I wrong? When leap seconds occur, minutes can have 61 seconds.

[BUGS] Re: Left Join/Outer Join

2001-08-21 Thread Bruno Wolff III
Are you running version 7.1 or higher? On Tue, Aug 21, 2001 at 09:25:58AM -0400, [EMAIL PROTECTED] wrote: > Martijn Beelen ([EMAIL PROTECTED]) reports a bug with a severity of 2 > > Long Description > When using left join, I get the errormessage > "ERROR: OUTER JOIN is not yet supported"

[BUGS] 'natural join' and 'join ... using' giving different results

2002-01-09 Thread Bruno Wolff III
patch to how foreign keys are checked. The machines where both running Redhat linux 6.1 with a 2.2.16 kernel. Below is a sample psql session that I think illustrates the problem. Script started on Wed Jan 9 11:17:06 2002 [bruno@wolff bruno]$ psql Welcome to psql, the PostgreSQL interactive te

Re: [BUGS] BUG #2468: how to create auto-generate primary key

2006-06-06 Thread Bruno Wolff III
Please don't use the bug reporting facilities to ask support questions. pgsql-general@postgresql.org would be a reasonable list to ask your question. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives

Re: [BUGS] BUG #2469: Error in connection to the server

2006-06-06 Thread Bruno Wolff III
Please don't use the bug reporting facilities to ask support questions. Your question would be appropiate for either the pgsql-general@postgresql.org or [EMAIL PROTECTED] mailing lists. ---(end of broadcast)--- TIP 1: if posting/reading through Usene

Re: [BUGS] BUG #2543: Performance delay acrros the same day

2006-07-21 Thread Bruno Wolff III
On Fri, Jul 21, 2006 at 07:41:02 +, Alaa El Gohary <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: The report below isn't a bug, its a performance question and should have been sent to [EMAIL PROTECTED] I am redirecting replies there. > A query on the postgresql DB

Re: [BUGS] Partially corrupted table

2006-08-30 Thread Bruno Wolff III
On Wed, Aug 30, 2006 at 10:18:46 +0200, Filip Hrbek <[EMAIL PROTECTED]> wrote: > > It is possible that the corruption was caused by a HW problem at customer's > server, and then this problem appeared also at our development environment > because of the data already beeing corrupted. I will rec

Re: [BUGS] BUG #2648: I can not create table name with capital and small characters

2006-09-28 Thread Bruno Wolff III
On Mon, Sep 25, 2006 at 14:59:46 +0200, Harald Armin Massa <[EMAIL PROTECTED]> wrote: > Asaf, > > SQL-92 states that identifiers [for dictionary objects] are limited to 128 > characters and are case-insensitive (unless delimited by double quotes), > because they are automatically translated into

Re: [BUGS] BUG #2658: Query not using index

2006-10-02 Thread Bruno Wolff III
This shouldn't have been submitted to the bugs list, as it isn't a bug. The best spot for this kind of question is the performance list so I am copying it there and redirecting followups there. On Wed, Sep 27, 2006 at 20:56:32 +, Graham Davis <[EMAIL PROTECTED]> wrote: > > SELECT assetid, m

Re: [BUGS] Sugestion for PostgreSQ

2006-11-07 Thread Bruno Wolff III
On Fri, Nov 03, 2006 at 09:50:01 -0200, Marcio <[EMAIL PROTECTED]> wrote: > I have a sugestion for pgsql 8.2 or next versions ... > Is complicated encrypt the procedures/functions on Database like Oracle or > similar? > I sugest this because we develop ERP/MRP with complex routines and we like >

Re: [BUGS] BUG #2772: Undefined Subroutine Pg::connectdb (" ");

2006-11-22 Thread Bruno Wolff III
This isn't a bug and you should have asked on a different list. I am going to move this over to pgsql-general. On Mon, Nov 20, 2006 at 12:07:25 +, "S.Balaji" <[EMAIL PROTECTED]> wrote: > > In Redhat 7.2 use Pg; command in perl Scripts will working with out any > Problem.But in CentOS use Pg

Re: [BUGS] BUG #2784: Performance serious degrades over a period of a month

2006-11-27 Thread Bruno Wolff III
This really should have been asked on pgsql-performance and would probably get a better response there.. On Sun, Nov 26, 2006 at 16:35:52 +, Michael Simms <[EMAIL PROTECTED]> wrote: > PostgreSQL version: 8.1.4 > Operating system: Linux kernel 2.6.12 > Description:Performance seriou

Re: [BUGS] BUG #2789: problem with delete statement

2006-12-03 Thread Bruno Wolff III
On Tue, Nov 28, 2006 at 00:21:27 +, Lucian Capdefier <[EMAIL PROTECTED]> wrote: > > 1. I cannot user table alias in the FROM clause of the DELETE statement. That isn't in the SQL spec, but the extension to allow it has been added to 8.2 which will be released very shortly. > 2. I cannot us

Re: [BUGS] BUG #2802: Feature request: tinyint and unsigned types

2006-12-04 Thread Bruno Wolff III
On Fri, Dec 01, 2006 at 20:41:32 +, Albert Strasheim <[EMAIL PROTECTED]> wrote: > > Description:Feature request: tinyint and unsigned types You can already use "char" to store 1 byte values, though unless there are several of these in a row, you won't save any space because of align

Re: [BUGS] BUG #3270: limit < 16 optimizer behaviour

2007-05-11 Thread Bruno Wolff III
This should have been asked on the performance list, not filed as a bug. I doubt anyone will have a complete answer to your question without EXPLAIN ANALYZE output from the query. Have you ANALYZE'd the tables recently? Poor statistics is one possible cause of the issue you are having. On Fri, Ma

Re: [BUGS] WHERE =NULL malfunction in release 7.2

2002-06-21 Thread Bruno Wolff III
On Thu, Jun 20, 2002 at 17:28:31 +0200, Ingo Ciechowski <[EMAIL PROTECTED]> wrote: > Hi, > > first of all let me tell all of you that PostgreSQL is among the best > in OpenSource! > > Unfortunaly there's a (hopefully easy to fix) bug in release 7.2 and > 7.2.1 that was not there in 7.1.3 and

[BUGS] cube output function can overrun its buffer

2002-08-18 Thread Bruno Wolff III
In cube_out 100 bytes are allocated to hold the output string. Instead using a bound on the size of g format output and separation characters, this bound times twice the dimension (possibly plus a small constant for parens and terminating 0 byte) should be used. With this approach you might want

[BUGS] c.h needed in Pg.c

2002-08-25 Thread Bruno Wolff III
When trying to build from CVS, interfaces/perl5 doesn't build unless I add an include of "c.h" in Pg.c. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMA

[BUGS] cube bug accepting -.1

2002-08-27 Thread Bruno Wolff III
The lex scanner for the cube package has an apparent error in its pattern for matching floating point numbers. It doesn't except cases where there is no digit between a sign and a decimal point. For example -.1 is not matched by the pattern. I have attached a patch to cubeparse.l and the regressi

[BUGS] Potential buffer overflow in contrib/cube/cubeparse.y

2002-08-27 Thread Bruno Wolff III
In the function cube_yyerror an output buffer of 256 bytes is allocated to be used for an error message that outputs some of the input buffer. I think the portion of the input buffer that is echod can potentially be longer than this. ---(end of broadcast)--

Re: [BUGS] c.h needed in Pg.c

2002-08-28 Thread Bruno Wolff III
On Mon, Aug 26, 2002 at 00:34:00 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > Bruno Wolff III <[EMAIL PROTECTED]> writes: > > When trying to build from CVS, interfaces/perl5 doesn't build unless I add > > an include of "c.h" in Pg.c. > > Works

[BUGS] atan2 documentation bugs for 7.3 and 7.2

2002-09-05 Thread Bruno Wolff III
In the section on mathematical functions the following is given for atan2: atan2(x, y) inverse tangent of a/x I believe the correct version should either be: atan2(y, x) inverse tangent of y/x or atan2(x, y) inverse tangent of x/y I beleive the documentation was also wrong for 7.2 where it was:

Re: [BUGS] Bug #801: now() in transaction

2002-10-18 Thread Bruno Wolff III
On Fri, Oct 18, 2002 at 07:23:29 -0400, [EMAIL PROTECTED] wrote: > Bhuvan A ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > now() in transaction > > Long Description > I am using 7.2.1. now() returns same value ever, w

Re: [BUGS] OSX 10.2.2 and beta 5

2002-11-16 Thread Bruno Wolff III
On Sat, Nov 16, 2002 at 15:18:58 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> "Random" randomly fails. It is OK. > > > So why is it a regression test, then? > > It's hard to see how you could test random

[BUGS] COPY problem with bad dates

2002-12-18 Thread Bruno Wolff III
not in the middle of a large transaction. bruno=> create table test (col1 timestamp); CREATE TABLE bruno=> copy test from stdin; Enter data to be copied followed by a newline. End with a backslash and a period on a line by itself. >> 11/31/02 >> \. ERROR: copy: line 1, Bad

Re: [BUGS] COPY problem with bad dates

2002-12-18 Thread Bruno Wolff III
On Wed, Dec 18, 2002 at 09:14:18 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > It looks like when a bad date is entered using COPY the backend connection > gets killed. I just tried it with 7.3.1 and get the same error. ---(end

Re: [BUGS] year and weeknumbers (proposal included)

2003-01-30 Thread Bruno Wolff III
On Mon, Jan 27, 2003 at 21:53:27 +0100, [EMAIL PROTECTED] wrote: > hi, > > last year (2002) the date december 31st is in week 1 of 2003. > > it is not possible to get this out of a date-column using EXTRACT or > to_char. > to_char( '2002-12-31', 'WW' ) returns 1, and > to_cha

Re: [BUGS] cvs (7/2/2003) broken?

2003-02-12 Thread Bruno Wolff III
On Tue, Feb 11, 2003 at 00:13:44 +0200, Elias Athanasopoulos <[EMAIL PROTECTED]> wrote: > > And my GNU bison is version 1.28. > > I'll maybe have to upgrade. Thanx for your answer. I think you need to upgrade to at least 1.75. ---(end of broadcast)-

Re: [BUGS] performance for MIN,MAX aggregates

2003-03-11 Thread Bruno Wolff III
On Tue, Mar 11, 2003 at 15:42:41 +0700, Ruslan A Dautkhanov <[EMAIL PROTECTED]> wrote: > Hello all, > > Just a little simple example: > > isbs=# \d radauth >Table "public.radauth" > Column |Type | Modifiers > --+

[BUGS] Important typo fix for hba.c in 7.4

2003-03-15 Thread Bruno Wolff III
A typo in src/backend/libpq/hba.c breaks local ident authentication in the SO_PEERCRED case. elif is misspelled as elsif for the test. A patch is attached. *** hba.c Sat Mar 15 10:15:46 2003 --- hba.c.old Sat Mar 15 10:15:29 2003 *** *** 1248,1254 return true;

Re: [BUGS] Security problem with Postgres sql

2003-03-21 Thread Bruno Wolff III
On Fri, Mar 21, 2003 at 16:44:07 +0530, DEEPANSHU GARG <[EMAIL PROTECTED]> wrote: > Hi, > We have a problem when logging in postgresql. > We are setting the user id and password using Create User command. > Now when we login the postgresql using > $psql -U username databasename > it does'nt prom

Re: [BUGS] Index speeds up one row table (why)?

2003-05-31 Thread Bruno Wolff III
On Sat, May 31, 2003 at 00:14:18 -0600, Dave E Martin XXIII <[EMAIL PROTECTED]> wrote: > version: 7.3.2 > > Currently this table has one row in it, where name is 15 unicode > characters long. It would seem that there would be no need for an index > on name. However, doing: It probably has one

Re: [BUGS] Bug or not...

2003-06-01 Thread Bruno Wolff III
On Fri, May 30, 2003 at 16:33:55 +0400, Nick Altmann <[EMAIL PROTECTED]> wrote: > Hello! > > I think it's not bug, but difficulty. > > I cannot use trusted connections for my localhost. I use password. But psql, > pg_dump, pg_restore doesn't support password parameter in command line. Also, i

Re: [BUGS] Index speeds up one row table (why)?

2003-06-01 Thread Bruno Wolff III
On Sat, May 31, 2003 at 16:56:56 -0600, Dave E Martin XXIII <[EMAIL PROTECTED]> wrote: > > (ok, experimented a bit more just now) > Hm, it appears that degredation occurs with the index as well, I guess > at the time I created the index, it just initially did better because it > got to skip al

Re: [BUGS] Index speeds up one row table (why)?

2003-06-01 Thread Bruno Wolff III
On Sat, May 31, 2003 at 17:17:38 -0600, Dave E Martin XXIII <[EMAIL PROTECTED]> wrote: > Speaking of which, since the row is locked with select for update (so it > can't be involved in any other transactions anyway) and the change > doesn't change the length of the row, can't it just be updated

Re: [BUGS] Bug or not...

2003-06-02 Thread Bruno Wolff III
h pg_dump (with 7.3.x), but don't know for sure. It should be easy for you to try this yourself. > > - Original Message - > From: "Bruno Wolff III" <[EMAIL PROTECTED]> > To: "Nick Altmann" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]&

Re: [BUGS] Index speeds up one row table (why)?

2003-06-02 Thread Bruno Wolff III
On Sun, Jun 01, 2003 at 01:20:03 -0600, Dave E Martin XXIII <[EMAIL PROTECTED]> wrote: > Rod Taylor wrote: > > >An 8 k page will hold approx 140 tuples based on your structure. So, > >for every ~100 updates you'll want to run vacuum (regular, not full) on > >the table > > Alas, for this applica

Re: [BUGS] Indexes not used for "min()"

2003-08-04 Thread Bruno Wolff III
On Tue, Jul 29, 2003 at 09:48:37 -0600, "Valsecchi, Patrick" <[EMAIL PROTECTED]> wrote: > > When doing the following query, it's obvious that postgres should use > the index: > > stats=# explain select min(time) from call; This has been discussed on the mailing lists numerous times. If you are

Re: [BUGS] ALTER SCHEMA problem

2003-08-20 Thread Bruno Wolff III
On Tue, Aug 19, 2003 at 21:24:50 +0800, Chris M <[EMAIL PROTECTED]> wrote: > I also find something magic when using sequence. > select nextval('seq_test'); > and > select nextval('"seq_test"'); > both refer to the same sequence: seq_test. > > If I want to use a sequence with name: SEQ_TE

Re: [BUGS] [PERFORM] pgsql inserts problem

2003-08-28 Thread Bruno Wolff III
On Wed, Aug 27, 2003 at 15:50:32 +0300, Tarhon-Onu Victor <[EMAIL PROTECTED]> wrote: > > The problems is that only ~15% of the lines are inserted into > the database. The same script modified to insert the same data in a > similar table created in a MySQL database inserts 100%. Did you

Re: [BUGS] Is it bug???

2003-09-05 Thread Bruno Wolff III
On Wed, Sep 03, 2003 at 23:19:24 -0700, Ringo <[EMAIL PROTECTED]> wrote: > What a prick.. >From observing Tom's responses here, I think this is a real question (not an RTFM response). If the documentation doesn't make it clear to new readers that explain analyze does execute the query (though do

Re: [BUGS] is this my date problem

2003-10-01 Thread Bruno Wolff III
On Wed, Oct 01, 2003 at 10:26:57 -0700, Theodore Petrosky <[EMAIL PROTECTED]> wrote: > I am not sure but i thought I read something of this > problem and maybe its not a problem but my > understanding. > > There are only 30 days in september however I can not > seem to make a query that asks for

Re: [BUGS] before trigger doesn't, on insert of too long data

2003-11-10 Thread Bruno Wolff III
On Mon, Nov 10, 2003 at 21:48:30 +0100, Gaetano Mendola <[EMAIL PROTECTED]> wrote: > Seems to me too, from the standard: > > "The order of execution of a set of triggers is ascending by value of > their timestamp of creation in their > descriptors, such that the oldest trigger executes first. I

Re: [BUGS] BUG #1001: Inconsistent authentication between psql and PQconnectdb - possible security implications?

2003-12-05 Thread Bruno Wolff III
On Fri, Dec 05, 2003 at 12:47:58 -0400, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > All is well with psql authentication. However, when I tried to > use knoda/hk_classes to access the database, I could not get authenticated. A > typical error message was IDENT authentication failed fo

Re: [BUGS] (none)

2003-12-30 Thread Bruno Wolff III
On Tue, Dec 30, 2003 at 19:32:03 +0530, Sh A Guru Prasad <[EMAIL PROTECTED]> wrote: > > Hi, How to convert number format (with decimal) into > integer only ex:to conver 100.00 to 100. Depending on what kind of rounding you want, you can just cast to an integer. You could also use ceil, floor o

Re: [BUGS] Problem with datatype REAL using the = (EQUAL) operator

2004-02-15 Thread Bruno Wolff III
On Thu, Feb 12, 2004 at 12:46:27 -0600, Javier Carlos <[EMAIL PROTECTED]> wrote: > > bd_temporal=> SELECT * FROM tbl_temp WHERE var < 0.20; > var > -- > 0.1 > 0.11 > (2 rows) > bd_temporal=> SELECT * FROM tbl_tem

Re: [BUGS] date_part returns different results with same interval.

2004-02-20 Thread Bruno Wolff III
On Thu, Feb 19, 2004 at 16:52:37 -0800, Wade Klaver <[EMAIL PROTECTED]> wrote: > Hello folks. > > I just noticed some funky behaviour on the part of date_part. If there is > some reason this is correct behaviour, I wouldn't mind knowing why. > The problem is that date_part can return different

Re: [BUGS] BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL()

2004-02-23 Thread Bruno Wolff III
On Mon, Feb 23, 2004 at 21:26:57 -0400, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > Details: > > === SQL === > > CREATE TEMP TABLE testing (col_a integer, col_b integer); > CREATE TEMP SEQUENCE seq; > > /* this statement will produce the expected result */ > INSERT INTO testing (col_

Re: [BUGS] BUG #1083: Insert query reordering interacts badly with

2004-02-27 Thread Bruno Wolff III
I am going to try to move this over the sql list, since it doesn't belong on bugs. On Tue, Feb 24, 2004 at 23:47:48 +1300, Martin Langhoff <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > > >How about > > > >SELECT nextval('seq'); -- ignore result > > > >INSERT INTO ... VALUES (currval('seq

Re: [BUGS] [HACKERS] CHECK constraints inconsistencies

2004-03-01 Thread Bruno Wolff III
On Mon, Mar 01, 2004 at 20:28:02 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Michael Glaesemann <[EMAIL PROTECTED]> writes: > > In both cases, the CHECK constraint uses a function that is stable or > > volatile. It was suggested that functions used in CHECK constraints be > > restricted to imm

Re: [BUGS] BUG #1094: date_part('week') bug

2004-03-04 Thread Bruno Wolff III
On Thu, Mar 04, 2004 at 13:56:42 -0400, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: This isn't a bug. Weeks that span years are treated as part of the year in which Thursday of that week lies. > > Bug reference: 1094 > Logged by:

Re: [BUGS] Fwd: Infinite recursion in function causes DoS

2004-03-26 Thread Bruno Wolff III
On Thu, Mar 25, 2004 at 12:25:33 +0100, Martin Pitt <[EMAIL PROTECTED]> wrote: > > Either way, this situation leads to a DoS of the database system or the > entire machine. Since any user with enough privileges to access the > database can create and execute functions, this raises a slight secu

Re: [BUGS] Fwd: Default pg_autovacuum config glitches

2004-03-26 Thread Bruno Wolff III
On Thu, Mar 25, 2004 at 16:08:49 +0100, Martin Pitt <[EMAIL PROTECTED]> wrote: > Hi PostgreSQL hackers! > > A while ago we received the bug report below against pg_autovacuum. > Since it runs as a daemon, it should detach from its controlling > terminal by executing sth like > > int nul

Re: [BUGS] Bug#225680: Fwd: Default pg_autovacuum config glitches

2004-03-26 Thread Bruno Wolff III
On Sat, Mar 27, 2004 at 00:56:47 +0100, Martin Pitt <[EMAIL PROTECTED]> wrote: > > Well, daemons that run for a long time should not log to > stdout/stderr, but to syslog. Otherwise they clutter up the screen > randomly or the messages are not seen at all (when you are only > working under X for

Re: [BUGS] Sequential Scan Index Bug

2004-04-06 Thread Bruno Wolff III
On Sat, Apr 03, 2004 at 13:51:56 -0500, Gabriel Weinberg <[EMAIL PROTECTED]> wrote: > > I have a table with an integer column with about 10M rows in it. > > This column has an index (btree). > > When I try to select a row using this column with an integer, e.g. select * > from table where id=4

Re: [BUGS] BUG #1139: Auto-increment and Rollback

2004-04-19 Thread Bruno Wolff III
On Mon, Apr 19, 2004 at 20:16:15 -0300, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 1139 > Logged by: Emil Tarazi > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.4 > > Operating system: L

Re: [BUGS] Question regarding 'not in' and subselects

2004-05-26 Thread Bruno Wolff III
On Wed, May 26, 2004 at 13:57:37 -0400, Vic Ricker <[EMAIL PROTECTED]> wrote: > Hi. I'm using PostgreSQL 7.4.2 under Fedora Core 1. > > I have two tables with a single varchar(32) column in each. I'm trying > to find all the rows from one table that don't exist in the other > table. The query

Re: [BUGS] inserting lots of values into a column that has "unique" property

2004-06-14 Thread Bruno Wolff III
On Mon, Jun 14, 2004 at 01:07:09 +0800, Fehmi Noyan ISI <[EMAIL PROTECTED]> wrote: > > I got the error message as expected. Everything is ok.Now, let's create > another table called "table_2" with an inheritence from "table_1". > > But, when I insert a new value into "table_2" with an "id" v

Re: [BUGS] BUG #1176: PHP connection

2004-06-22 Thread Bruno Wolff III
On Tue, Jun 22, 2004 at 06:29:29 -0300, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: This isn't really a bug; you should have posted you question to pgsql-novice. (Followups set to there and to you.) > > Bug reference: 1176 > Logged by:

Re: [BUGS] string concatenator || and NULL values

2004-07-01 Thread Bruno Wolff III
On Thu, Jul 01, 2004 at 16:42:29 -0300, Roberto João Lopes Garcia <[EMAIL PROTECTED]> wrote: > > When I use string concatenator || and there are fields of type date whith NULL values > the result is an enpty string. Please see example: This isn't a bug. If either operand of || is NULL, then the

Re: [BUGS] BUG #1186: Broken Index?

2004-07-02 Thread Bruno Wolff III
On Fri, Jul 02, 2004 at 04:50:07 -0300, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: This doesn't appear to be a bug at this point. It sounds like you have a self induced performance problem, so I am moving the discussion to pgsql-performance. >

Re: [BUGS] Possible bug?

2004-07-02 Thread Bruno Wolff III
On Fri, Jul 02, 2004 at 10:27:35 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > > IIRC there were objections the last time it was seriously proposed, > basically of the form "but that will break my application which relies > on writing so-and-so without a cast". We did get as far as removing all

Re: [BUGS] UNIQUE not honoured for NULL

2004-07-12 Thread Bruno Wolff III
On Mon, Jul 12, 2004 at 14:47:34 +0200, Gaetano Mendola <[EMAIL PROTECTED]> wrote: > > As someone says NULL = NULL is false As someone else pointed out, NULL = NULL is NULL which is not TRUE. ---(end of broadcast)--- TIP 8: explain analyze is you

[BUGS] \ escapes in check constraint strings?

2004-07-16 Thread Bruno Wolff III
I see the following behaivor on 7.4.3 and 7.4 stable from about a week ago: bruno=> create table test (); CREATE TABLE bruno=> alter table test add constraint test2 check('\\' = ''); ALTER TABLE bruno=> \d test Table "public.test" Column | Type | Modi

Re: [BUGS] \ escapes in check constraint strings?

2004-07-16 Thread Bruno Wolff III
On Fri, Jul 16, 2004 at 16:49:25 -0500, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > I see the following behaivor on 7.4.3 and 7.4 stable from about a week ago: > bruno=> create table test (); > CREATE TABLE > bruno=> alter table test add constraint test2 check('\\&

Re: [BUGS] BUG #1252: Optimization of SELECT for NOT NULL case

2004-09-15 Thread Bruno Wolff III
On Tue, Sep 14, 2004 at 00:57:07 +0100, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > Description:Optimization of SELECT for NOT NULL case > > Details: > > CREATE TABLE x (id int4 NOT NULL); > Populate table, for instance, 10M rows; > SELECT count(*) from x WHERE x IS NULL; > Op

Re: [BUGS] BUG #1252: Optimization of SELECT for NOT NULL case

2004-09-16 Thread Bruno Wolff III
On Wed, Sep 15, 2004 at 23:29:43 +0300, Alexander Kirpa <[EMAIL PROTECTED]> wrote: > On 15 Sep 2004, at 12:21, Bruno Wolff III wrote: > > Regarding your point of view possible exist reason for remove > optimization for case like below > SELECT count(*) from x where id>

Re: [BUGS] [pgsql-bugs] pg_dumpall (7.3) 'public' schema bug

2004-11-17 Thread Bruno Wolff III
On Wed, Nov 17, 2004 at 11:53:10 -0800, Josh Berkus <[EMAIL PROTECTED]> wrote: > Karl, > > > I don't care that much about the behavior, it's easy enough > > to delete 'public'.  I do think that a note should be > > made in the administrator manual regards system upgrades > > where pg_dump(all) s

Re: [BUGS] BUG #1332: wrong results from age function

2004-12-01 Thread Bruno Wolff III
On Mon, Nov 29, 2004 at 11:37:50 +, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 1332 > Logged by: Robert Grabowski > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.4.6 > > Operating syst

Re: [BUGS] concat fails 'sometimes' on empty colums in select

2004-12-11 Thread Bruno Wolff III
On Sat, Dec 11, 2004 at 03:33:07 +0100, Stefan de Konink <[EMAIL PROTECTED]> wrote: > Hi, > > I have a table with some empty colums, if I try to concat my colums to > eachother something strange happens. Rather empty column B produces > virtually no output using the || in the select query. But

Re: [BUGS] BUG #1349: Gap in documentation - pg_dump

2004-12-16 Thread Bruno Wolff III
On Thu, Dec 16, 2004 at 08:16:56 +, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > I'm sorry, but I didn't found a better place to report that: > > There is no information how to specify user's password in pg_dump > documentation. I have spent half of day searching for that (pg_hba.co

Re: [BUGS] BUG #1349: Gap in documentation - pg_dump

2004-12-16 Thread Bruno Wolff III
On Thu, Dec 16, 2004 at 20:21:48 +0100, Piotr Likus <[EMAIL PROTECTED]> wrote: > > Yes, maybe it is insecure, but sometimes "quick and dirty" solutions > are better than no solution at all. > After all you can add "not recommended" note to this tip. The official documentation isn't likely to be

Re: [BUGS] BUG #1388: documentation/announcement suggestion

2005-01-14 Thread Bruno Wolff III
On Wed, Jan 12, 2005 at 08:31:09 +, Holger Klawitt <[EMAIL PROTECTED]> wrote: > > There is no (at least no apparent) link > to the ChangeLog for the most recent version > of postgres in neither the announcements nor in the > news nor in the download section (at top level). > > I'd think tha

Re: [BUGS] BUG #1408: don't see index

2005-01-20 Thread Bruno Wolff III
On Tue, Jan 18, 2005 at 09:01:29 +, andrzej <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 1408 > Logged by: andrzej > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.0-rc5 > Operating system: windows XP > Descript

Re: [BUGS] BUG #1483: Index problem

2005-02-16 Thread Bruno Wolff III
On Tue, Feb 15, 2005 at 12:38:17 +, Zoltan Szmutku <[EMAIL PROTECTED]> wrote: > > My next commands : > > 1. > CREATE UNIQUE INDEX kod > ON proba > USING btree > (mezo1) > > 2. > CREATE UNIQUE INDEX kod > ON proba2 > USING btree > (mezo1) > > The second command not success, I

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-04-03 Thread Bruno Wolff III
On Tue, Mar 29, 2005 at 03:54:48 +0100, Olivier Thauvin <[EMAIL PROTECTED]> wrote: > > Maybe I will workaround by setting postgres user access as 'trust' for local > connection only, but I have to reread the doc before :). Ident is better if you can use domain sockets and the equivalent of get

Re: [BUGS] BUG #1581: Problem with capitalised DB names...

2005-04-10 Thread Bruno Wolff III
On Tue, Apr 05, 2005 at 18:09:25 +0100, "Marcus v. Scotti" <[EMAIL PROTECTED]> wrote: > > Description:Problem with capitalised DB names... > Details: > > When trying to grant database privileges to a group of users there is no way > to do this if the database name is capitalised (i.e.

Re: [BUGS] BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values

2005-04-10 Thread Bruno Wolff III
On Tue, Apr 05, 2005 at 21:11:12 +0100, Eric McGough <[EMAIL PROTECTED]> wrote: > > COPY my_table FROM STDIN WITH DELIMITER AS '|'; > \N|\N|\N > \. COPY doesn't provide a way to use default values for just some rows. You can get the default for a column by leaving it out of an explicit column l

Re: [BUGS] BUG #1581: Problem with capitalised DB names...

2005-04-11 Thread Bruno Wolff III
On Mon, Apr 11, 2005 at 09:37:08 +0100, "Marcus v. Scotti" <[EMAIL PROTECTED]> wrote: > > Thanks... (maybe include this in the manuals, I couldn't find this > information...) It is: http://developer.postgresql.org/docs/postgres/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS ---

Re: [BUGS] BUG #1633: about transactions and row level locking

2005-04-27 Thread Bruno Wolff III
On Wed, Apr 27, 2005 at 13:56:02 +0100, deepak <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: This isn't a bug, its a question. I am moving the discussion over to the general list. > Bug reference: 1633 > Logged by: deepak > Email address: [EMAIL PR

Re: [BUGS] BUG #1578: ::bit(n) behaves "differently" if applied to bit

2005-05-13 Thread Bruno Wolff III
On Thu, May 12, 2005 at 10:40:34 -0500, Celia McInnis <[EMAIL PROTECTED]> wrote: > Thanks very much Bruce and Tom for your responses and explanations. The > current mode of operation is mathematically disturbing so I'm hoping that you > can figure out some sort of a fix! Perhaps this example is

Re: [BUGS] Bulletin Board

2005-05-24 Thread Bruno Wolff III
On Mon, May 23, 2005 at 11:04:36 -0400, "Goar, Saul" <[EMAIL PROTECTED]> wrote: > Do you have a Bulletin Board, or web site for questions and answers. There are FAQs referenced off the Postgresql web site. If you want to ask specific questions than you should use the appropiate mailing lists. T

Re: [BUGS] BUG #1686: Regular expression problem

2005-05-31 Thread Bruno Wolff III
On Tue, May 31, 2005 at 11:15:23 -0400, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > (Note that our ~ regexes are powered by code of Tcl's heritage, so you > could check Tcl's manual on regexes.) Aren't they based directly on Henry Spencer's code? ---(end of broadcast)

Re: [BUGS] BUG #1697: Select getting slower on continously updating data

2005-06-02 Thread Bruno Wolff III
This does not belong on the pgsql-bugs list. The pgsql-novice or pgsql-performance lists seem more appropiate. I have set followups to the pgsql-novice list. On Thu, Jun 02, 2005 at 12:05:00 +0100, Bahadur Singh <[EMAIL PROTECTED]> wrote: > > Hello, > > I found situtation that, when I am selec

Re: [BUGS] BUG #1698: Different behavior in UNIQUE and DISTINCT

2005-06-03 Thread Bruno Wolff III
On Thu, Jun 02, 2005 at 20:22:07 +0100, Mauro Delfino <[EMAIL PROTECTED]> wrote: > > I have the these two tables: > CREATE TABLE table_one > ( field1 VARCHAR(255) ); > > CREATE TABLE table_two > ( field1 VARCHAR(255) UNIQUE ); > > table_one has 500k records. I certify that all strings are dist

  1   2   >