Re: [BUGS] BUG #2477: Aggregate Integer divisors incorrectly yield integer-type quotient

t to get my analytical functions to work properly on anything but very small scale tables-otherwise I just run of out disk space a small part of the way through. Thanks for any guidance you can offer on this-I'd love to stick with PostgreSQL! Best regards, John Rylander -Original Me

Re: [BUGS] BUG #2365: can't install

mario ruggier wrote: Plus, how do I delete the DOMAIN/postgres user on the XP system? I do not see this user listed when I do Control Panel/User Accounts (i am not a windows guy, so please excuse my windows ignorance)? Should I try to install from sources, or will that not make any difference?

[BUGS] RHEL4 RPM packages

the PGDG .rpm's for RHEL4 have a bit of an annoyance... RHEL4 ships with postgres 7.4.x, and various RHEL4 RPMs have a dependency on libpq.so.3 ... # rpm -Uvh postgresql-8.2.3-1PGDG.i686.rpm \ > postgresql-libs-8.2.3-1PGDG.i686.rpm \ > postgresql-server-8.2.3-1PGDG.i686.rpm \ > postgresql-

Re: [BUGS] RHEL4 RPM packages

John R Pierce wrote: RHEL4 ships with postgres 7.4.x, and various RHEL4 RPMs have a dependency on libpq.so.3 ... Using the CentOS 4 base repository, I've identified these RPMs as depending on libpq.so.3, which is obsoleted and removed by the postgresql-libs-8.2.3-1PGDG RPM ...

Re: [BUGS] RHEL4 RPM packages

Devrim GÜNDÜZ wrote: Hi, On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote: (or, there should be a compat-postgresql-libs-3 ?) Hmm. Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend, to rhel-4 directories; so that people can find that package e

Re: [BUGS] RHEL4 RPM packages

Devrim GÜNDÜZ wrote: Hi, On Thu, 2007-03-01 at 18:23 -0800, John R Pierce wrote: (or, there should be a compat-postgresql-libs-3 ?) Hmm. Ok, I'll upload compat-postgresql-libs-3 to our ftp server this weekend, to rhel-4 directories; so that people can find that package e

Re: [BUGS] RHEL4 RPM packages

Guillaume Smet wrote: But you only need the compat package with libpq.so.3 to install 8.1 and 8.2 on RHEL 4. but, again, I only see the compat -4 here... no -3. http://www.postgresql.org/ftp/binary/v8.2.3/linux/rpms/redhat/rhel-es-4/ the 8.2.1 equiv of that path has a comment thats flat wr

Re: [BUGS] RHEL4 RPM packages

Devrim GÜNDÜZ wrote: Hi, On Wed, 2007-04-11 at 01:10 -0700, John R Pierce wrote: well, it makes it VERY hard to install 8.2.3 on a RHEL4/CentOS4 system that also has, say, RH's build of Apache + PHP + PG access, as thats linked to the -3 libraries Uh? So installing only compat-

Re: [BUGS] RHEL4 RPM packages

Guillaume Smet wrote: On 4/11/07, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote: On Fri, 2007-03-02 at 09:17 -0800, John R Pierce wrote: > looks like the RPMs for libpq.so.4 and libpq.so.3 can't coexist. Ok, I got lots of complaints about this. I will work on this today and announce ne

[BUGS] INSTALL appnote for Solaris 10...

I just built a version of postgres 8.2.4 on Solaris 10 x86 ... a few things that could be mentioned in INSTALL, and or in the Solaris notes There is a Sun supplied version of gnu readline is on the Solaris "Companion" DVD as package SFWrline ... cd /mnt/Solaris_Software_Companion/Solar

[BUGS] BUG #3297: psql won't open

The following bug has been logged online: Bug reference: 3297 Logged by: ;John D. Tiedeman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.4 Operating system: Linux (Kubuntu 7.4) Description:psql won't open Details: Errer message says at least one c

[BUGS] BUG #2934

from previous installation 4. Install again Thanks John S. Gakhokidze ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [BUGS] Bug in all version with encryption

Suresh Gupta VG wrote: I had recently upgraded my pgsql 7.4.2 to pgsql 8.2.5 on Solaris 9 Sparc machine. All the installation went normally as per install documents of Postgresql. In between the installation, I got the following error. But at the end I could create database and can use the D

Re: [BUGS] Bug in all version with encryption

Suresh Gupta VG wrote: Thanks for your reply. As per your suggestion, if we remove “CREATE FUNCTION” statement, we cannot use that function. Actually, we need this feature. Can you pls suggest some url or docs to help us in developing the c-language code to rectify this as we had done earl

Re: [BUGS] BUG #4047: case preserve for columns

Eugen Konkov wrote: Is there any workaround other then quoting to get working 1) and 2) as expected? The SQL standard actually says everything not quoted should be upshifted to upper case. PostgreSQL opted for lower case a long time ago and has stuck with this for legacy. If your "100K

Re: [PATCHES] Re: [BUGS] BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data

Tom Lane wrote: That's what I meant. Heikki is quoting himself from a message that hasn't appeared anywhere public, and he must have had at least one message from the OP that hasn't appeared either. So the rest of us are still mostly in the dark about the problem. I got this one, which app

Re: [BUGS] BUG #4104: Uninstall/remove not working correctly

alex wrote: I recently uninstalled 8.3.1 and I deleted the remaining files not removed from the uninstaller. I then proceed to install 8.3.1 again using same user info as before. The installer proceeded to install until the creation of the user and it says "user postgres already exists" and then

Re: [BUGS] problem in installing pgsql-8.3.1

shohorab hossain wrote: Dear sir/madam, This is to inform you that I am an oracle database user/administrator. But I am going to join in a company where I have to administrate postgresql database. I am new to this database system. For few days I am trying to install postgresql-8.3.1 in RHEL4

Re: [BUGS] BUG #4172: postgres stops working after restart

Heikki Linnakangas wrote: The log folder doesn't show any error problems. When I run the psql.exe on the command line i get: "psql: could not connect to server: Connection refused (0x274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port

Re: [BUGS] [ADMIN] problem in installing pgsql-8.3.1

Devrim GÜNDÜZ wrote: Hi, On Thu, 2008-05-15 at 04:21 -0700, shohorab hossain wrote: For few days I am trying to install postgresql-8.3.1 in RHEL4. My machine configuration is Intel Pentium IV. I have followed the installation document of postgresql that was included with source distribution.

Re: [BUGS] BUG #4176: process

claudio furukawa wrote: PostgreSQL is in many process. There are 6 process equal. Using ~42Mega Ram of memory. I already called and turned off/on the service and continues with the same processes. This is normal? yes.there is the master process, then a writer process, a logger process

Re: [BUGS] BUG #4219: fseeko test failure in configure script

Nathan Reed wrote: The following bug has been logged online: Bug reference: 4219 Logged by: Nathan Reed Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Sparc Solaris 10 - 08/07 release Description:fseeko test failure in configure script D

[BUGS] Bug in pg_dump

POSTGRESQL BUG REPORT TEMPLATE Your name : Robert John Shepherd Your email address

Re: [BUGS] Bug in pg_dump

k up for tsearch in the next week or so, which should help other newbies like myself who want to use full text indexing in postgresql. Yours Unwhettedly, Robert John Shepherd. Technical Director DVD REVIEWER The UK's BIGGEST Online DVD Magazine http://www.dvd.reviewer.co.uk For a co

[BUGS] Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2

tly brings the whole database to a crawl, which no amount of index rebuilding, vacuuming and analysing helps. Help! (And sorry if this is the wrong list) Yours Unwhettedly, Robert John Shepherd. Editor DVD REVIEWER The UK's BIGGEST Online DVD Magazine http://www.dvd.reviewer.co.uk For a

Re: [BUGS] BUG #1232: Singapore Timezone missing

The following bug has been logged online: ... The timezone designation SGT is not recognized on inserts to "timestamp with time zone" fields. ... fyi, I am on this list, if anyone wants to tell me I'm way off base here or whatever :) something tells me I'm going to hit this problem again when ou

Re: [BUGS] BUG #1232: Singapore Timezone missing

so all of china uses CST, which is *NOT* CST as we know it here in North America ;-/ Yeah, it's going to be difficult to do much about this stuff with the current approach of a hardwired table of zone names. There are other unresolved conflicts (IST is one I think). Yeah, its a maze of twisty litt

Re: [BUGS] Change Request

(1) I can install PostgreSQL as a service without having to create a new Account Name & Password why not? Its *VERY* standard procedure on all sorts of systems to run RDBMS servers as a dedicated user. there are all kinda system accounts already in XP used by various system services, whats one

[BUGS] vacuum problem

Got something really odd happening here. Simple test program, in java, with jdbc, postgres 7.4.5, on a redhat linux system... app does a heavy loop of a prepared UPDATE, then Commit, 1s of times. the table has a few columns, nothing fancy at all.On our Redhat Enterprise 2.1 server (d

Re: [BUGS] vacuum problem

"John R Pierce" <[EMAIL PROTECTED]> writes: Got something really odd happening here. Simple test program, in java, with jdbc, postgres 7.4.5, on a redhat linux system... app does a heavy loop of a prepared UPDATE, then Commit, 1s of times. the table has a few columns,

Re: [BUGS] vacuum problem

About an hour after mailing that, I realized that the buggy RHEL2.1 system was running with Intel Hyperthreading enabled (so it appeared as 4 CPUs) while the no-problems RH8.0 system had hyperthreading enabled (we'd previously been benchmarking some multithreaded stuff both ways). So, its *ju

Re: [BUGS] vacuum problem

there are no background programs. I've done all the usual checking of `ps' outputs looking for such. in the test case I mailed to this list, I had created a standalone database with one table, and run the test program directly against it. That sounds suspiciously like you think that only backgr

Re: [BUGS] BUG #1258: backend memory leak after massive 'CREATE/DROP USER'

Description:backend memory leak after massive 'CREATE/DROP USER' wild guess says that its not really neccessarily a memory leak unless all the shared_buffers are getting consumed and its *still* growing... CREATE USER adds a row to a system table, and DROP USER deletes that row, the tabl

Re: [BUGS] psql missing feature: show permissions for functions

I was trying to check some permissions on functions and then I noticed that there's no command in psql to show that information. I've tried using "\z", "\df" and "\df+" without success on PostgreSQL 7.4.5. It would be an interesting addition to have that, as we do have the commands to show permiss

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: I think CSIDL_APPDDATA is probably the way to go, but one of the heavy Windows hitters will know better than I do. Now that I look at it, there are several places that are depending on getenv("HOME") or getenv("USERPROFILE") (on Windows)

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

Actually, the server doesn't depend on home directories in any way shape or form. The places that we are concerned about are on the client side, either in libpq or in psql. So what we have to think about is the environment that libpq might see. libpq could be called from a service, such as ineti

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

win2000 Pro system (using www.sysinternals.com's excellent Process Explorer tool, btw). HOME is not set. USERPROFILE is set to "C:\Documents and Settings\postgres"... For services that are running as 'NT AUTHORITY\SYSTEM', the profile is "C:\Documents and Settings\Default User" (and the USER

Re: [BUGS] psql: no chance to enter password in certain situations

Christoph Becker wrote: OS ist Windows XP Prof, PgSQL version is rc5 via windowsinstaller When trying to restore a db, psql does not ask for the password but responds imediately with an erromessage as in the following example: F:\doka\bak>psql -U postgres template1 < pg_dump_all_2005-01-11.txt Pa

Re: [BUGS] PGPASSWORD

postgresbugs wrote: Tom Lane wrote: Agreed, which is why we invented .pgpass. But that argument scales up to beyond one invocation of this hypothetical script, does it not? regards, tom lane I guarantee you that his process which includes binaries and scripts is not hypothetical.

Re: [BUGS] We are not following the spec for HAVING without GROUP

select 1 from tab having 1=1; returns 2 rows I'm curious whats in those two rows... {{1} {1}} ? ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [BUGS] float conversion / presentation problem ?

Tom Lane wrote: Enrico Weigelt <[EMAIL PROTECTED]> writes: i've noticed an problem with conversion from real to float - this produces ugly values. (in fact it seems to be real->float8) You do realize that float4/real is only good to six decimal places on most platforms? You can take the issue up

Re: [BUGS] request

I would really like postgres to model the alter syntax of mysql, which is really easy to modify table schema especially to include the AFTER col_name part. A) why does the order of the columns in a particular table matter at all? B) is this any sort of SQL standard? ---(e

Re: [BUGS] Missing tables in postgresql 7.2.4

P.S.:A TODO for me: CRON Script for weekly VACUUM ;) on heavy use databases, mine generally does a light vacuum every 4 hours, and a once a day full on everything. also, a weekly full reindex on a really really heavy use systems like this one message board server I ad-mangle something like...

Re: [BUGS] BUG #1756: PQexec eats huge amounts of memory

Neil Conway wrote: Denis Vlasenko wrote: The same php script but done against Oracle does not have this behaviour. Perhaps; presumably Oracle is essentially creating a cursor for you behind the scenes. libpq does not attempt to do this automatically; if you need a cursor, you can create on

Re: [BUGS] Sun inline assembler ...

Tom Lane wrote: Here's what I see in REL8_0_STABLE and in HEAD (s_lock.c 1.35): 244 #ifdef SUNOS4_CC 245 asm(".seg \"data\""); 246 asm(".seg \"text\""); 247 #else 248 asm(".section \"data\""); 249 asm(".section \"text\""); 250 #endif I see that template/sunos4 adds -DSUNOS4_CC

Re: [BUGS] postmaster graceful shutdown time !!!

Sivaraman K.G wrote: Hi, Has any one have the statistics that how long the postmaster takes for graceful shutdown (when SIGTERM is send) ? that would be EXTREMELY dependent on a large number of variables. an idle instance with no pending writes on a reasonably fast modern 'nix system shoul

Re: [BUGS] BUG #1819: COPY filename rejects Windows format path

Steve Peterson wrote: Running COPY FROM on a Windows server; using a Windows-format fully qualified path with backslashes results in the backslashes being interpreted as escapes. Windows APIs are perfectly happy with regular / forward slashes in pathnames, in fact, I use them everywhere BUT i

Re: [BUGS] Help

Stephan Szabo wrote: On Mon, 22 Aug 2005, Paul Bramble wrote: Is there an easy way to get started so I can quickly install Postgress and load my schema? You didn't say what kind of system you're running, but getting a packaged version of PostgreSQL (RPM, DEB, Windows Installer) will probabl

Re: [BUGS] bug on starting postgres

Puvi Subramanian wrote: Hi, we installed postgres 8.0.3 in fedora core 4 successfully. We created the super user named as postgres to start postgres. When i execute the command "/usr/local/pgsql/bin/postmaster -i -D data" in my terminal it gives bur that postmaster cannot access the s

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

test=> select test-> ('2005-10-30 13:22:00-05'::timestamptz - test(> '2005-10-29 13:22:00-04'::timestamptz); ?column? -- 25:00:00 (1 row) Is that actually the correct answer? Disregarding daylight savings, there is 25hrs betwee

Re: [HACKERS] [BUGS] BUG #2052: Federal Agency Tech Hub Refuses to

Bruce Momjian wrote: If someone wants to create a separate web page to track fixes related to CVE number, that is fine. My guess is that most people reading the release notes don't care about the CVE numbers themselves (just that each release has all known security bugs fixed), and most bugs tha

Re: [BUGS] BUG #2244: silent installation to set password never expires

Can someone help to provide some guideline how to do the silent installation WITH setting the services account password never expires. There's no such functionality. You'll need to create the account prior to installing PostgreSQL, and set the flags then. it could be created with a command l

Re: [BUGS] BUG #2305: "No bufferspace available" error on large insert

... Upon issuing the insert statement I receive the following error message: "could not send data to server: No buffer space available (0x2747/10055)" I suspect that this happens because we are inserting a lot of data: the first BYTEA column is about 1.8MB, while the second is about 0.5MB.

Re: [BUGS] BUG #5496: Link does not open though wish to use following site

Sunny wrote: The following bug has been logged online: Bug reference: 5496 Logged by: Sunny Email address: goodmeet7...@naver.com PostgreSQL version: 8.4 Operating system: windows xp Description:Link does not open though wish to use following site Details: Link do

Re: [BUGS] Postgres on AIX5.3 and AIX6.1

On 06/23/10 6:02 PM, Chris Browne wrote: There is already an FAQ on issues relating to AIX. It is, in recent versions, part of the documentation tree: can I take this opportunity to point out a problem on that pag

Re: [BUGS] Libpq.dll: File not recognized

On 06/30/10 3:23 PM, Bidski wrote: Hi all, I downloaded the "one-click" installer for PostgreSQL 9.0 beta2 for Windows x64 (postgresql-9.0.0-beta2-windows-x64.exe) and installed it on my Windows 7 64 bit system. Installation seemed to go off without a hitch, but when I tried to link to libpq i

Re: [BUGS] Libpq.dll: File not recognized

On 06/30/10 3:40 PM, Bidski wrote: John R Pierce writes: wild guess says your project is 64 bit, but libpq.dll is 32 bit. Why would there be a 32bit dll in the 64bit pre-built package? look and see if there's another /lib64/ or similar directory ? I didn't notice earlier th

Re: [BUGS] BUG #5653: Error reading the C:/Program Files/PostgreSQL/8.4/data/postgresql.conf"

On 09/12/10 8:23 AM, Kesavan wrote: PostgreSQL version: 8.4.0-1 Operating system: Windows 8.4.0? thats rather old 8.4.4 is the current build of the 8.4 family, and the bug fixes listed in the release notes for each of the interrim versions (8.4.1, .2, .3, .4) are fairly long. and,

Re: [BUGS] pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails

On 10/11/10 4:09 PM, Chris English wrote: C:\WINDOWS\system32>pg_dumpall.exe --port 5433 username--"postgres" --schema-onl y >"c:/windows/system32/pg_upgrade_dump_all.sql" Access is denied. why are you writing the .sql output to the windows system32 directory?!?!? thats a TERRIBLE place t

Re: [BUGS] BUG #5723: Can not start postgres after install

On 10/25/10 7:50 AM, Marcus wrote: The following bug has been logged online: Bug reference: 5723 Logged by: Marcus Email address: marcusboos...@mailinator.com PostgreSQL version: 9.0.1 Operating system: Ubuntu 10.10 Description:Can not start postgres after install De

Re: [BUGS] BUG #5737: LIKE and ILIKE strange behaviour

On 10/31/10 12:28 PM, Radu Ilies wrote: id, char[25] name, text The first row is: id='radu' name='Radu Ilies' The following queries does not find any result (fail): SELECT * FROM my_table WHERE id LIKE 'radu' SELECT * FROM my_table WHERE id ILIKE 'radu' 'radu'::char[25] ==> 'radu__

Re: [BUGS] BUG #5801: characters not encoded properly for column names

On 12/23/10 2:34 AM, Marc Cousin wrote: No, from a Linux psql client (inside a kde konsole). You can setup any charset in it. I have exactly the same behaviour with psql under windows anyway, with a chcp 1252 in the cmd console. It's not a console charset problem, I've tripled checked that :) An

Re: [BUGS] insert statement going into infinite loop

On 12/27/10 10:31 PM, Trimurthulu Bandaru wrote: Can you produce a single .sql file that creates the tables and does the problem insert? Can you please make me clear in this issue.. he's asking if you can produce a test case in the form of a .SQL file that creates a schema and demonstrates t

Re: [BUGS] BUG #5802: configure script does not check for perl devel files

On 12/28/10 3:22 PM, Peter Eisentraut wrote: On tis, 2010-12-28 at 12:19 +, Mario Ohnewald wrote: However, during the make, postgres requires perl devel. Should this not be covered in the configure script? No, it's not configure's job to do the job of make or the compiler. I believe he's

Re: [BUGS] BUG #5839: pgAdmin makes bad query for creating a table when default value specified

On 01/14/11 8:12 PM, Aren Cambre wrote: This came from pgAdmin's *Default value* field. This field is supposed to accept anything other than a string? default value can be any valid expression -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscriptio

Re: [BUGS] Duplicate table name within the sme schema

On 02/08/11 10:20 AM, Tom Lane wrote: Cyril DE MURCIA writes: We use postgresql 7.3.2 under Linux Red Hat 9.0. We periodically dump and restore our database. I don't know if an error occured during a dump restore but our DB seems to be corrupted. Our base contains many pair of table with the sa

Re: [BUGS] BUG #5901: Delayed Write Failed

On 02/27/11 7:13 PM, Gie Rizkiadi wrote: I have installed PostgreSQL 8.4.1 running on 112 Embedded PC OS Microsoft Windows XP Embedded Version 2002 Service Pack 2 Intel(R) Atom(TM) CPU N270 @1.60 GHz 1.32 GHz, 0.99 GB of RAM and 8GB Harddisk ( 6GB Free ) which are connected to LAN, most of that d

Re: [BUGS] BUG #5913: invalid page header

On 03/03/11 6:56 PM, Cristian Lazarte wrote: The following bug has been logged online: Bug reference: 5913 Logged by: Cristian Lazarte Email address: cristianlaza...@hotmail.com PostgreSQL version: 8.0.2 Operating system: WINDOWS XP Description:invalid page header De

Re: [BUGS] BUG #5924: bug or feature?

On 03/11/11 12:18 AM, Ferenc Lutischan wrote: The following bug has been logged online: Bug reference: 5924 Logged by: Ferenc Lutischan Email address: yours...@freemail.hu PostgreSQL version: 8.3.14 - 9.0.3 Operating system: Linux Description:bug or feature? Details:

Re: [BUGS] psql crashes with bad history file in 9.0.3

On 03/22/11 1:40 PM, Josh Berkus wrote: All, At two sites I'm not allowed to share data from (grrr), I've encountered core dumps of psql. In once case the core dump happens as soon as you run any query. In the second case, it occurs when you exit. What both sites have in common is that there

Re: [BUGS] BUG #5944: COPY FROM doesn't work with international characters

On 03/23/11 4:32 PM, Nathan Davalos wrote: ... SET CLIENT_ENCODING TO 'WIN1251'; copy tmpintermediate from 'thefile.txt'; Sample contents of thefile: 230002 Alto Desempeño, S.A. De C.V. When using WIN1251 or WIN1252 I get nothing in the second field, it just ignores the data. Same thing for L

Re: [BUGS] BUG #5944: COPY FROM doesn't work with international characters

On 03/23/11 5:42 PM, Nathan M. Davalos wrote: Just in case the reply didn't go through the character in question is F1. I replied to the message using pgsql-bugs@postgresql.org, but I'm a wee bit new to the bug reporting stuff using the mailing list. The hex of the file in total is 32.33.30.3

Re: [BUGS] default password for user postgres

On 03/31/11 6:50 PM, Raphael Giovanini wrote: I`m change the default passwod, and not conect for this user. What the default password? there is no default password. on most unix and linux distributions, the default authentication mode is set to 'ident' which means a given unix user X can onl

Re: [BUGS] BUG #5967: Db maintainace

On 04/07/11 6:53 AM, Halli, Savita wrote: Yes, I am going through that. Its mentioned that some of the commands need to be run. My question is how frequently we need to run those commands(commands for db maintainance). how frequently do you need to do file system maintenance? or for that m

Re: [BUGS] BUG #5982: recursive type crashes postgres

On 04/15/11 2:04 PM, Rikard Pavelic wrote: This feature would reduce object-relational impedance mismatch in DDD, objects aren't relational.deal with it. OOPS may be a reasonable methodology for coding, however its purely hierarchical, and doesn't map at all well to relational calculus.

Re: [BUGS] BUG #5983: creating accounts

On 04/15/11 12:33 PM, Yanish wrote: The following bug has been logged online: Bug reference: 5983 Logged by: Yanish Email address: yanish_3...@hotmail.com PostgreSQL version: 9.0 Operating system: Windows Seven 64-bit Description:creating accounts Details: hello i h

Re: [BUGS] BUG #5996: CURRENT_TIMESTAMP uses often undesired TRANSACTION_TIMESTAMP, instead of STATEMENT_TIMESTAMP

On 04/28/11 12:33 PM, Brian S. Krug wrote: The following bug has been logged online: Bug reference: 5996 Logged by: Brian S. Krug Email address: bk...@usatech.com PostgreSQL version: 9.0.3 Operating system: Solaris Description:CURRENT_TIMESTAMP uses often undesired T

Re: [BUGS] BUG #5994: Can't excute DBI->connect to oracle by client site

On 05/10/11 8:09 PM, 李紅兵 wrote: I run my test program with 2 ways in the same login environment.One succeed and one fail. 1) psql -d dbi_link_test -->connect succeed 2) psql -h HOSTNAME -d dbi_link_test -->connect fail The different is connection options(Unix Domain Sockets/TCP Sockets). is

Re: [BUGS] BUG #6062: psql terminates on auto-complete

e on other Unix platforms such as Solaris. I have zero OS X specific knowlege -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscrip

Re: [BUGS] BUG #6118: Server doesn't listen

nstaller. After you do this, you should be able to START the service. note this password you set in User Manager has nothing to do with the password (if any) for the postgres role you use to log onto the database server for administration. -- john r pierce

Re: [BUGS] BUG #6132: Cannot install rpm files

/Guide_to_reporting_problems D) this wasn't a 'bug' by any stretch of the imagination. -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your sub

[BUGS] Help-PGRES_FATAL_ERROR

Please help I can not replicate with Slony - PGRES_FATAL_ERROR select "_replicaterminal".storeNode

Re: [BUGS] BUG #6171: Sockets Issue

clients do not inherently support by checking the configuration of the server. libpq running in the client user's context usually has no access to the postgresql.conf file which is generally in a mode 700 directory owned by the service account. -- john r pierce

Re: [BUGS] BUG #6186: out of memory while analyze

On 08/30/11 10:25 PM, Lampa wrote: Also tried change maintenance_work_mem to 2G and same result. Imposible to set over 2GB (FATAL: 3145728 is outside the valid range for parameter "maintenance_work_mem" (1024 .. 2097151)) is this a 32bit postgres ? -- joh

Re: [BUGS] In Windows Server 2008 PostgreSQL8.3 service on Local Computer started and then stopped.

elieve Windows supports ident, alternately, it could be 'trust', but this would say any process or user on your system could connect as any postgres role without any verification or authentication at all. caveat emptor. -- john r pierceN 37, W 122 santa cruz c

Re: [BUGS] drop enum problem

e "rainbow" already exists PEBCAK. drop type rainDow create type rainBow -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6204: Using plperl functions generate crash

important is what perl is in the POSTGRES SERVICE's path, not your desktop users. windows doesn't make this easy to determine. -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (

Re: [BUGS] BUG #6252: After drop the default database 'postgres', I can not create a database by 'createdb.exe'

On 10/12/11 9:28 AM, Kevin Grittner wrote: This is not a bug. The workaround is to not drop the database which is automatically created on installation. or to explicitly connect to another database to do the create -- john r pierceN 37, W 122 santa cruz ca

Re: [BUGS] char(0)

On 10/17/11 7:41 AM, Andreas Pflug wrote: Sounds much too straight forward, not mysql-ish autistic enough... I fixed your spelling. HTH! -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] BUG #6266: Create temp tables on Slave

les on the slave side would render the WAL files inherently unusable. to do what you want would require using a fundamentally different replication method, such as Slony or Bucardo. -- john r pierceN 37, W 122 santa cruz ca mid-left coast

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

rver. 2) postgres is assuming postgres is running on the same server which of these two statements makes more sense? -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

anyways, this is NOT a postgresql bug, so this is the wrong list for this discussion. -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscripti

Re: [BUGS] BUG #6281: need to remove

it from you. Doesn't make it any easier to fix when so much of the systems activity is hidden away. Sigh. this all conspires to make it really hard to help someone out remotely. -- john r pierceN 37, W 122 santa cruz ca mid-

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

On 11/09/11 11:46 PM, Torsten Zuehlsdorff wrote: Lossing data is very bad, the solution provided by Robert is really simple. I support Roberts approach. you support changing localhost to be something other than 127.0.0.1 to hack around a poorly designed application?!? seriously? -- john

Re: [BUGS] BUG #6290: converting interval from weeks to days

On 11/10/11 1:15 PM, Alexey Nalbat wrote: => select '10 weeks'::interval; interval -- -1589934592 days a billion weeks is like 19 million years. somehow, I don't think that postgresql's date math has quite that ran

Re: [BUGS] CREATE ROLE jdbc vs pgadmin

md50eb617ecacedd0cfae723bbe53c75918' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION; It would be a bug in jdbc? I am using PostgreSQL 9.1 and linux. what is the problem? -- john r pierceN 37, W 122 santa cruz ca mid-left coast --

Re: [BUGS] Postgres DB creation error WINXP pro

error you're getting? -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] About Wince App

, it probably belongs on the main pgsql-general email list. -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6397: I am getting error on CIFS with fsync parameter on

ed as a backing file store, in particular, there's no guarantee that writes will be done in a valid order or even that random writes will work correctly. the fact that it seemed to work in a much older version was purely happenstance. -- john r pierceN 37,

Re: [BUGS] BUG #6451: problem while installing gridsql

(below)?none of this appears to have anything to do with PostgreSQL I see references to EnterpriseDB (com.edb, as well as the username), so perhaps you should contact them, as they support their own software. -- john r pierceN 37, W 122 santa cruz ca

<    1   2   3   4   >