[BUGS] BUG #8407: json_populate_record case sensitivity

The following bug has been logged on the website: Bug reference: 8407 Logged by: Possible bug with json_populate_record? Email address: george.strag...@gmail.com PostgreSQL version: 9.3rc1 Operating system: Ubuntu Description: Using PostgreSQL 9.3beta2. SELECT versi

Re: [BUGS] BUG #7815: Upgrading PostgreSQL from 9.1 to 9.2 with pg_upgrade/postgreql-setup fails - invalid status retrieve

So, is pg_upgrade starting postmaster? If yes, then when (at which step) and why pid file check is done. That's all what we all want to know, right? Best regards, George Machitidze On Sat, Jan 19, 2013 at 8:27 PM, Tom Lane wrote: > Bruce Momjian writes: > > Why is

[BUGS] BUG #6609: pattern matching (version 8.2 or so...)

The following bug has been logged on the website: Bug reference: 6609 Logged by: biju george Email address: biju.geo...@ust-global.com PostgreSQL version: Unsupported/Unknown Operating system: Linux Description: I have a text column which have values like '0

Re: [BUGS] BUG #6583: for loop cursor

Hi Tom, Well I thought I was running version "8.4.*" but it turned out to be "8.2.14" when I did a show server_version in pgAdminIII. So, is this a known issue? Well I won't possibly be able to upgrade the version as its bundled with the DB. :-( Cordiall

[BUGS] BUG #6583: for loop cursor

The following bug has been logged on the website: Bug reference: 6583 Logged by: Biju George Email address: biju.geo...@ust-global.com PostgreSQL version: 8.4.0 Operating system: Linux Description: Just this simple code throws below error -- CREATE OR REPLACE

[BUGS] Known Issues Page

Hi, I have been using PostGreSQL as a part of our healthcare product. As an important part of releasing a stable product it is important to also document the known issues found in a PostGRE release. I would be grateful if someone could forward me to the Known Issues Page(if any). On these lines h

[BUGS] BUG #5298: emedded SQL in C to get the record type from plpgsql

The following bug has been logged online: Bug reference: 5298 Logged by: George Email address: sunduozh...@revenco.com PostgreSQL version: 8.4.2 Operating system: Red Hat Linux AS 4 Description:emedded SQL in C to get the record type from plpgsql Details: CREATE OR

Re: [BUGS] BUG #5144: Issue changing password

Many thanks. That helped. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wednesday, October 28, 2009 2:01 PM To: Francis, George Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #5144: Issue changing password "George Francis" writes: > I am tryi

[BUGS] BUG #5144: Issue changing password

The following bug has been logged online: Bug reference: 5144 Logged by: George Francis Email address: g...@liquidpoint.com PostgreSQL version: 8.3 Operating system: Windows 2000 Description:Issue changing password Details: I am trying to recover my lost password

[BUGS] BUG #4812: statistics not available on tables containing only hstore column

The following bug has been logged online: Bug reference: 4812 Logged by: George Su Email address: george...@efrontier.com PostgreSQL version: 8.3.6 Operating system: SUSE Linux Description:statistics not available on tables containing only hstore column Details: If

[BUGS] BUG #3732: Select returns 0 rows for varchar field

The following bug has been logged online: Bug reference: 3732 Logged by: George Woodman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Windows 2000 Description:Select returns 0 rows for varchar field Details: I created a table with the

[BUGS] BUG #3586: Time zone problem in SQL query

The following bug has been logged online: Bug reference: 3586 Logged by: George Wright Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: SUSE Linux 10.2 Description:Time zone problem in SQL query Details: I checked release notes up to

Re: [BUGS] "--enable-thread-safety" fails on snapshot version

On 6/11/07, Tom Lane <[EMAIL PROTECTED]> wrote: "George Sakkis" <[EMAIL PROTECTED]> writes: > After digging in config.log, the error turns out to be the lack of the > a test file: > conftest.c:144:43: ./src/test/thread/thread_test.c: No such file or directory

[BUGS] "--enable-thread-safety" fails on snapshot version

conftest.c:144:43: ./src/test/thread/thread_test.c: No such file or directory Actually the whole src/test directory is missing from the snapshot versions. After copying it over from my stable version (8.2.3), it configures fine. Is this is an accidental omission or deliberate ? Thanks, George

[BUGS] BUG #3308: Nested outer join gives wrong results

The following bug has been logged online: Bug reference: 3308 Logged by: George Sakkis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Linux Description:Nested outer join gives wrong results Details: I have the following two subqueries

[BUGS] BUG #2868: Help

The following bug has been logged online: Bug reference: 2868 Logged by: George Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: Mac OSX Tiger 10.4 Description:Help Details: PGAdmin Vs. 1.6.1 crashes when trying to search in the help

[BUGS] connection problem in postgresql

"postgres", "sadeen");   here sadeen is my password. But i don't know what to give where i underlined. I am working as postgres#    prompt  in database.   I have created database with -- create database mydatabase; how to use that database as use mydatabase in mysql.   Looking forward to hear from you, Yours truly, George        

[BUGS] BUG #2375: ALTER COLUMN TYPE on composite types

The following bug has been logged online: Bug reference: 2375 Logged by: George Barbarosie Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Gentoo 2006.0 Description:ALTER COLUMN TYPE on composite types Details: Trying to change the type

[BUGS] BUG #2308: pg_dump -a does not respect referential dependencies

The following bug has been logged online: Bug reference: 2308 Logged by: Matthew George Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Darwin Kernel Version 8.5.0: Sun Jan 22 10:38:46 PST 2006; root:xnu-792.6.61.obj~1/RELEASE_PPC Power Macintosh

[BUGS] BUG #1811: unique index problem

The following bug has been logged online: Bug reference: 1811 Logged by: George Jansen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: RedHat ES 4 Description:unique index problem Details: Importing a database in preparation for a

Re: [BUGS] [SQL] [GENERAL] plPGSQL bug in function creation

- A | B | A | B (1 row) e=# select version(); version -- PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease) (1 r

[BUGS] postgresql-7.3rc2 python interface fails

kages/pgdb.py", line 149, in getdescr self.__source.execute( _pg.error: ERROR: Attribute "typprtlen" not found >From the postgres log, the offending query was: SELECT typname, typprtlen, typlen FROM pg_type WHERE oid = 19 What was typprtlen supposed to mean? Most of my po

[BUGS] three VERY minor things with 7.1 final

I want to thank you for the excellent and fast responses I have received in the past. Especially while troubleshooting the sfio problem. These problems are VERY minor and easily worked around. Part of the reason I am posting them is just in case someone else runs across the same things. I am r

Re: [BUGS] segmentation fault in psql

Tom Lane wrote: > Uh, what are sfio and stdio anyway, and why would we want them? putc is > in plain old libc in every system I've dealt with. If you remove both > sfio and stdio from configure, does it work any better? Thanks. Removing sfio from configure.in and reconfiguring/making did the

Re: [BUGS] segmentation fault in psql

Tom Lane wrote: > Can't tell a lot from that. Could you rebuild psql with debug symbols > so we can see a more complete backtrace? Here is a backtrace with debug enabled: (gdb) bt #0 0x446cc in putc () #1 0x26748 in print_aligned_text (title=0x0, headers=0x746d0, cells=0x746e0, footers=0x746f