| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | If PostgreSQL failed to compile on your computer or you found a bug
that
is likely to be specific to one platform then please fill out this form
and...
Riccardo G. Facchini
|
11-10-2004 11:38 AM
Tom Lane  | 1 | 366 |
| | | The following bug has been logged online:
Bug reference: 1311
Logged by: Bernhard Rosenkraenzer
Email address: bero (AT)...
PostgreSQL Bugs List
|
11-10-2004 11:33 AM
Tom Lane | 1 | 209 |
| | | Hey all,...
I've faced a "bogus" situation in postgreSQL while using "to_char" function
with locale resources that was described before...
Netto
|
11-10-2004 07:35 AM
Netto | 0 | 238 |
| | | The following bug has been logged online:
Bug reference: 1310
Logged by: Tom O'Connell
Email address: toconnell (AT) bphnx (DOT)...
PostgreSQL Bugs List
|
11-10-2004 03:01 AM
Magnus Hagander | 1 | 205 |
| | | The following bug has been logged online:
Bug reference: 1309
Logged by: Christina Zhang
Email address: czhang (AT)...
PostgreSQL Bugs List
|
11-09-2004 04:48 PM
Tom Lane | 1 | 166 |
| | | The following bug has been logged online:
Bug reference: 1308
Logged by: Simon Lesage-Tremblay
Email address: simonlt (AT)...
PostgreSQL Bugs List
|
11-09-2004 03:39 PM
Kris Jurka | 1 | 191 |
| | | I have an annoying problem with some kind of a hang or deadlock triggered
sometimes when running a vacuum on a table with a pair of read only
cursors...
Craig Ruff
|
11-09-2004 09:01 AM
Craig Ruff | 2 | 331 |
| | | kael (AT) canada (DOT) com writes:
Hmm, I'm betting you are on a machine where shifting a 32-bit quantity
left 32 bits doesn't reliably give zero. ...
Tom Lane
|
11-08-2004 03:44 PM
Gaetano Mendola | 1 | 154 |
| | | Please see the pginstaller FAQ on
http://pginstaller.projects.postgresql.org/FAQ_windows.html,
specifically questions 3.1 and 3.2. Remember to check...
Magnus Hagander
|
11-08-2004 04:06 AM
Magnus Hagander | 0 | 258 |
| | | Good morning, I'm from Brazil and I trying install the postgre 8 beta and
found this error: "filed to create process for initdb". Look that I...
Estevan Rech
|
11-08-2004 01:20 AM
Harald Armin Massa | 1 | 175 |
| | | Hi PG team ,
my database is in UNICODE
I try this (with Bulgarian chars):
SELECT 'Тест проба' ~* 'тест' as result
returns FALSE
above...
dev
|
11-08-2004 12:11 AM
Tom Lane | 1 | 164 |
| | | David Dick <david_dick (AT) iprimus (DOT) com.au> writes:
Apparently psql is picking up an old libpq.so version from
/usr/local/pgsql/lib. You may...
PostgreSQL Bugs List
|
11-08-2004 12:05 AM
Tom Lane | 5 | 220 |
| | | On Mon, 1 Nov 2004, Laferriere, Al wrote:
Doubtful:
jurka=# insert into catalog.schem.tab.col values (1,2,3);
ERROR: improper qualified name (too...
Kris Jurka
|
11-07-2004 10:05 PM
Tom Lane | 1 | 201 |
| | | On Fri, 5 Nov 2004, Martin Sldek wrote:
I didn't realize you were going to report this (as this post got held for
moderator approval), so I...
Kris Jurka
|
11-07-2004 08:37 PM
Kris Jurka | 0 | 187 |
| | | On Mon, 1 Nov 2004, Laferriere, Al wrote:
This is the expected behavior. The 8.0 release of the JDBC driver
includes strong typing. Previous...
Kris Jurka
|
11-07-2004 07:07 PM
Kris Jurka | 0 | 172 |
| | | As subject, i got a stored function that returns an int2
i successfully call it using a callable statement, exactly as it is written in the manual,...
Federico Fissore
|
11-07-2004 02:15 PM
Kris Jurka | 2 | 226 |
| | | ipc-daemon2 &
1424
Done ipc-daemon2
Administrator@DEMENTOR ~
$ ps
PID PPID PGID WINPID TTY UID STIME...
contact
|
11-07-2004 07:03 AM
contact | 0 | 171 |
| | | As best I can tell, this is coming out because pgtz.c thinks that
/usr/share/timezone is where Postgres' own timezone files are; which
implies that...
Josh Berkus
|
11-06-2004 05:10 PM
Tom Lane | 21 | 497 |
| | | Creating a domain on bit(N) doesn't seem to work as expected when casting
to the domain type.
CREATE DOMAIN bit4 AS bit(4);
SELECT 7::bit(4),...
Kris Jurka
|
11-06-2004 11:49 AM
Tom Lane | 2 | 185 |
| | | The following bug has been logged online:
Bug reference: 1307
Logged by: Thomas Jacob
Email address: jacob (AT) internet24 (DOT)...
PostgreSQL Bugs List
|
11-06-2004 09:59 AM
Stephan Szabo | 2 | 177 |
| | | Hello,
I can't install the beta 4 on my windows system because it is XP Home
Edition.
The choices about rights made for the installer seem to be a...
Alexis Doutriaux
|
11-06-2004 08:06 AM
Alexis Doutriaux | 0 | 160 |
| | | ============================================================================
POSTGRESQL BUG REPORT...
Thomas Jacob
|
11-05-2004 02:24 PM
Thomas Jacob | 0 | 244 |
| | | =?iso-8859-2?B?U1rbQ1MgR+Fib3I=?= <surrano (AT) mailbox (DOT) hu> writes:
SIGTERM on individual backends is not recommended or supported.
FWIW,...
Tom Lane
|
11-05-2004 10:02 AM
Tom Lane | 0 | 168 |
| | | Guess what happend here:
$ bin/pg_ctl -D data -l log start
postmaster starting
$
No, postmaster was not starting - it was configured to listen on...
Markus Bertheau
|
11-05-2004 09:50 AM
Markus Bertheau | 2 | 167 |
| | | It is indeed installed. The activation of the module in 'template1' is
optional and *not* enabled by default, though. But there is a checkbox
for...
Magnus Hagander
|
11-05-2004 08:52 AM
Luiz K. Matsumura | 1 | 172 |
| | | The following bug has been logged online:
Bug reference: 1290
Logged by: Troels Arvin
Email address: troels (AT) arvin (DOT)...
PostgreSQL Bugs List
|
11-04-2004 03:22 PM
Simon Riggs | 15 | 290 |
| | | I'm trying to create a function like so:
create function get_lid_prefix (text) returns setof int as
'select lid from ilemma where lemma ~ \'^\' +...
Nishad Prakash
|
11-04-2004 01:32 PM
Tom Lane | 1 | 161 |
| | | The following bug has been logged online:
Bug reference: 1305
Logged by: Károly Segesdi
Email address: jazzkutya (AT) wom (DOT)...
PostgreSQL Bugs List
|
11-03-2004 12:50 PM
Stephan Szabo | 1 | 190 |
| | | Brendan,
This is by design. ORDER BY for anything but output is a PostgreSQL
extension, which we support strictly so that subselects can use...
Josh Berkus
|
11-03-2004 10:33 AM
Josh Berkus | 0 | 176 |
| | | The following bug has been logged online:
Bug reference: 1303
Logged by: Yevgeniy Kondratiev
Email address: sundaw (AT) rex400...
PostgreSQL Bugs List
|
11-03-2004 10:03 AM
Tom Lane | 1 | 181 |
| | | The following bug has been logged online:
Bug reference: 1304
Logged by: Brendan Fagan
Email address: bfagan (AT) harthosp (DOT)...
PostgreSQL Bugs List
|
11-03-2004 09:27 AM
Peter Eisentraut | 1 | 268 |
| | | Michael, Ralph, etc.:
The reason it comes up often is that the "log" example is in our docs. Since
it doesn't work as expected, I think we need...
Josh Berkus
|
11-02-2004 10:49 AM
Josh Berkus | 0 | 168 |
| | | The following bug has been logged online:
Bug reference: 1302
Logged by: Alex Koh
Email address: alexkoh (AT) hotmail (DOT)...
PostgreSQL Bugs List
|
11-02-2004 08:50 AM
Bruce Momjian | 3 | 265 |
| | | Hi PostgreSQL developers!
Currently (i. e. in 7.4.6) psql seems to use the default database
encoding as locale for both its own messages and for...
Martin Pitt
|
11-02-2004 02:38 AM
Peter Eisentraut | 1 | 163 |
| | | Hi, I've just upgraded Roma 7.3.x to 7.4.5 on a Mandrake 10.1 community.
I've used pg_dumpall (Roma version 7.4.5) to dump my previous databases to...
Andrea D.
|
11-01-2004 11:53 AM
Gaetano Mendola | 2 | 201 |
| | | Hi,
I think this is a bug (I hope not a feature).
Description:
--------------------
The table 'tmp' gets records added, and uses a serial to...
Ralph Heinkel
|
11-01-2004 09:12 AM
Michael Fuhr | 2 | 158 |
| | | Hi,
I just got the following on 7.4:
oocms=# delete from objects where object_id = 3993;
ERROR: update or delete on "objects" violates foreign key...
Markus Bertheau
|
11-01-2004 08:38 AM
Markus Bertheau | 0 | 162 |
| | | Hi !
I discovered this particular feature in "createdb" tool 8.0.0beta4
running on Win32 Platform:
-------------------- Cut And Paste...
Silvio Scarpati
|
11-01-2004 07:34 AM
Silvio Scarpati | 2 | 168 |
| | | Hello,
maybe some known issues regarding subj. in version 7.4.5? I have a web
application which is gathering date from postgre DB. And with a bach...
Edgars
|
11-01-2004 03:42 AM
Edgars | 0 | 175 |
| | | Hi again!
Martin Pitt :
I will look at this and remove it if appropriate. Thanks for the hint.
BTW, I actually used
CFLAGS += $(shell...
Martin Pitt
|
11-01-2004 02:17 AM
Martin Pitt | 4 | 173 |
| | | The date_trunc function is making some off-by-one errors when working at
a DST border.
=> select date_trunc('minute', '2004-10-31...
Matthew \Cheetah\ Gabeler-Lee
|
10-31-2004 09:56 AM
Tom Lane | 1 | 219 |
| | | pgsql running on port 5480, connect to template1 as non-superuser "phppgadmin"
who does not have createdb privileges. attempt to run a script that...
Robert Treat
|
10-31-2004 09:29 AM
Robert Treat | 1 | 150 |
| | | in response to;
tar -jxf postgresql-8.0.0beta4.tar.bz2
cd postgresql-8.0.0beta4
../configure
make check
combination, i received the following...
David Dick
|
10-31-2004 02:22 AM
David Dick | 0 | 158 |
| | | Hello pgsql-bugs,
The bug description is as follows:
Then server with running postmaster unexpectedly shut down, server
cannot be started next...
Sergey Ushakov
|
10-31-2004 02:00 AM
Sergey Ushakov | 0 | 184 |
 | | The following bug has been logged online:
Bug reference: 1301
Logged by: hongyi
Email address: hongyi_gao (AT) hotmail (DOT)...
PostgreSQL Bugs List
|
10-29-2004 04:06 PM
Tom Lane | 1 | 149 |
| | | I am running PostgreSQL 8.0 Beta 4 (Windows installer) on Windows XP Pro
SP2.
The query below has three ORDER BY clauses. When I execute it with...
Scott Eade
|
10-29-2004 02:22 PM
Tom Lane | 1 | 196 |
| | | I installed PostgreSQL-8.0beta4 on Linux Fedora Core2.
and first I made database test1. and create table t1, copy data from
file 'test.dmp'
$...
Sil Lee
|
10-29-2004 02:20 PM
Tom Lane | 1 | 280 |
| | | You told me restricted foreign key cannot deferable in PostgreSQL 8.0.0 Beta 4.
2004-10-21 22:33 tgl
* doc/src/sgml/ddl.sgml,...
杨邕
|
10-29-2004 01:33 PM
Stephan Szabo | 1 | 171 |
| | | Lucas Sultanum wrote:
Sounds as if you're not using the correct client encoding; your app is
probably non-unicode, but you're using client encoding...
Andreas Pflug
|
10-29-2004 01:07 PM
Andreas Pflug | 0 | 215 |
| | | Hello,
on dropdb i get often this since first Beta of 8.0 (actualy i use 8.0.0 Beta
4
from PostgreSQL Installer Project):
WARNING: could not...
Thomas Wegner
|
10-29-2004 12:44 PM
Bruce Momjian | 1 | 166 |
