The following bug has been logged online:
Bug reference: 5311
Logged by: John
Email address: jglas...@globaltv.com
PostgreSQL version: 8.3.9-1
Operating system: Windows XP
Description:Won't install.
Details:
When I run the installation, I get the following
The following bug has been logged online:
Bug reference: 3740
Logged by: John
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: WinXP
Description:could not load library ".../pljava.dll
Details:
I have indsert to postgresql
The following bug has been logged online:
Bug reference: 4260
Logged by: John
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3
Operating system: Windows XP
Description:Cannot even install product
Details:
After deciding to install Postgre SQL instead of
The following bug has been logged online:
Bug reference: 5565
Logged by: john
Email address: syaba...@yahoo.com
PostgreSQL version: 8.4.1
Operating system: XP XP2
Description:ERROR : syntax error at or near ")"
Details:
when insert using client dataset
artup due to startup process failure
Is this FATAL error seen on recovery a different bug or is it just a
direct result of bug #3245?
Unfortunately I do not have a way to deterministically reproduce this
problem but I have seen it 3 times so far.
thanks,
John
--
Sent via pgsql-bugs mail
onally selecting
> the "Factory" zone?
I don't think I've put the correct timezone file in /etc/localtime so
it is using some default file from the Gentoo install.
John
On Mon, Jun 30, 2008 at 12:26 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "John Smith" &l
I have just run into this issue myself and I was wondering if it is
considered a bug or a missing feature? Is there a plan to address this
in an upcoming release? Has anyone found a good work around to the
problem in the interim?
Thanks!
John.
On Wed, May 7, 2008 at 4:38 AM, Marshall, Steve
The following bug has been logged online:
Bug reference: 5055
Logged by: john martin
Email address: postgres_...@live.com
PostgreSQL version: 8.3.6
Operating system: Centos 5.2 32 bit
Description:Invalid page header error
Details:
All of a sudden we started seeing
The following bug has been logged online:
Bug reference: 5416
Logged by: John Regehr
Email address: reg...@cs.utah.edu
PostgreSQL version: git head Apr 12
Operating system: n/a
Description:int4inc() is wrong
Details:
The overflow check in int4inc() from int.c is
ed behavior for
any argument value. Therefore, any compiler which removes the test is
wrong. Both the GCC and LLVM groups will be happy to fix a bug of that
kind if it exists.
Thanks,
John Regehr
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subs
luence/display/seccode/INT32-C.+Ensure+that+operations+on+signed+integers+do+not+result+in+overflow
Even if you dislike these, please take a look at the safety checks for
shifts. The current postgresql shift functions need to be strengthened,
and it is easy to do.
John Regehr
--
Sent via pgsql-bug
from: john foderaro, [EMAIL PROTECTED]
platform: x86 running Redhat 6.2 Linux from rpm
postgresql-server-6.5.3-6
postgresql version: 6.5.3 (my guess based on rpm name).
problem: count() return the wrong result given a very simple join:
sample: we create a table of 3 elements
suggest that every point where commit and rollback are discussed,
there should be information about how to "Turn off auto-commit," even
if only a link.
Besides fixing the documentation for everyone, I'd like some information
now about how to "Turn off auto-commit."
he two queries should be
nearly identical, but this one runs very slowly.
Can anyone explain why this happens and/or how I can do a sub-select like
this and get fast results?
Thank you
John Aughey
---(end of broadcast)---
TIP 6: Have you searc
xited with status 512 - abort
[root@dugite log]#
The actual messages are no surprise.
I appreciate that I've not provided a lot of information about what I'm
trying to do. However, I don't think that ANYTHING I do should case PG
to use so much disk for so little data.
--
ble disk space.
The problems I see
1) Documentation
2) Performance - there's no obvious need to use all this space
3) Performance - there's no (or insufficient) removal of old logs.
4) Recovery. I see no means of recovering short of either adding disk
or deleting the entire database.
ent on lists; it
almost inevitable results in a 24-hour delay.
--
Cheers
John Summerfield
Microsoft's most solid OS: http://www.geocities.com/rcwoolley/
Note: mail delivered to me is deemed to be intended for me, for my
disposition.
---(end of broadcast)-
The build instructions in the INSTALL documentation does not lead to the
documentation (HTML or man pages) being built.
Here are all the directories I have having followed the instructions:
[pgtest@possum pgtest]$ ls postgresql
total 24
drwxrwxr-x6 pgtest pgtest 4096 Sep 3 16:50 .
After much fun building ant (which, at the very least proved I have a
working javac AND that I don't need JAVA_HOME set, I get this failure
building PostgreSQL 7.2devel with Java support:
configure:1499: checking for executable suffix
configure:1509: gcc -o conftest -O2 -g conftest.c 1>&5
con
erl and python components to install into the
location I specified, and to leave me to discuss with Perl and Python
the question of how to make sure I get the right versions (or even
better, offer a handy hint).
--
Cheers
John Summerfield
Microsoft's most solid OS: http://www.geocities.co
On Fri, 7 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > I have postmaster configured to use syslog. Despite this, these messages appear on
>the terminal from which I start it:
> > 2001-09-03 23:44:37 [26371] DEBUG: recycled transaction l
This is explicity allowed in db2:
void f3(int i)
{
EXEC SQL BEGIN DECLARE SECTION;
char host_var_3[25];
EXEC SQL END DECLARE SECTION;
EXEC SQL SELECT COL2 INTO :host_var_3 FROM TBL2;
}
void f4(int i)
{
char host_var_3[25];
EXEC SQL INSERT I
ually the reason it gave for not installing the perl bits is that I
didn't have the authority. It would have been completely happy if I'd
been root.
And I wouldn't have.
--
Cheers
John Summerfield
Microsoft's most solid OS: http://www.geocities.com/rcwoolley/
Note: mail del
I'm using 7.2devel from CVS, and as I've already reported, the documentation doesn't
build.
Consequently I'm forced to rely on documentation for 7.1.2/3 which does not mention
-209, at least in the ecpg documentation I'm looking at,
Nore does it appear in the DB2 documentation I'm using as sec
I checked out the latest updates about 14 hours ago.
I've also put together a new box, featuring an Athlon running at 1.3 Mhz. I cloned the
OS (Red Hat Linux 7.1) - I'd copied it from one disk to another fairly recently, and
so the software setup is pretty well precisely what I've been using al
I've tried unsuccessfully to subscribe to some list. Majordom doesn't understand me.
I asked for help. Majordomo doesn't understand that either.
Thought I'd recheck the website to see what I really ought to do. I get this:
While trying to retrieve the URL: http://developer.postgresql.org/index.
Sorry all. There was a certain amount of nonsence in my previous posting on this topic.
The failing sql command is an fact a select into.
It fails when trying to retrieve a null value. The insert worked (I can retrieve the
record
if I don't ask for the null field, so evidently the insert code i
This worked 2-3 days ago: what's changed?
vs -z9 -q update
cvs update: authorization failed: server postgresql.org rejected access to
/home/projects/pgsql/cvsroot for user anoncvs
summer@dugite pgsql$
The entry's still in ~/.cvspass
---(end of broadcast)--
On Thu, 13 Sep 2001, Peter Eisentraut wrote:
> John Summerfield writes:
>
> > I'm using 7.2devel from CVS, and as I've already reported, the documentation
>doesn't build.
>
> http://www.ca.postgresql.org/devel-corner/docs/postgres/index.html
I don't
On Mon, 17 Sep 2001, Thomas Lockhart wrote:
> ...
> > I think that if it actually reused them instead of deleting old files...
>
> That is in fact what it does for at least the upcoming 7.2 release.
>
>
It's not what I see now in 7.2devel. Unless the changes are uncommitted (or commited
in the
werbsite's out of date.
As I noted, it was working.
>
> On Tue, 18 Sep 2001, John Summerfield wrote:
>
> > This worked 2-3 days ago: what's changed?
> >
> > vs -z9 -q update
> > cvs update: authorization failed: server postgresql.org rejected access to
The instructions at
http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html#ANONCVS do not work.
pgtest@dugite pgtest$ cvs -d
:pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot login
(Logging in to [EMAIL PROTECTED])
CVS password:
cvs login: authorization failed: server postgresql
On Wed, 19 Sep 2001, Justin Clift wrote:
> Tom Lane wrote:
> >
>
> > > While trying to retrieve the URL: http://developer.postgresql.org/index.php
> >
> > Where did you get that URL from? AFAIK we have never had such a site
> > name as "developer.postgresql.org".
>
> Hi Tom,
>
> This is the ne
On Fri, 21 Sep 2001, Vince Vielhaber wrote:
> On Fri, 21 Sep 2001, Tom Lane wrote:
>
> > John Summerfield <[EMAIL PROTECTED]> writes:
> > > I get response like this
> > > subscribe
> > > Illegal command!
> > > No valid commands proc
On Sat, 22 Sep 2001, Vince Vielhaber wrote:
> On Sat, 22 Sep 2001, Tom Lane wrote:
>
> > Vince Vielhaber <[EMAIL PROTECTED]> writes:
> > >> It would seem that that page is out of date. Vince, can you fix it?
> >
> > > Actually the instructions are correct.
> >
> > Are they? The last time I sub
On Tue, 18 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > I asked for help. Majordomo doesn't understand that either.
>
> What did you do exactly? The following message brought back a help
> response for me:
I get response like this
On Tue, 18 Sep 2001, Marc G. Fournier wrote:
>
>
> go to anoncvs.postgresql.org, not postgresql.org ..
Fails the same.
I used the password postgresql (by cut&paste).
>
> On Tue, 18 Sep 2001, John Summerfield wrote:
>
> > This worked 2-3 days ago: what's
On Wed, 19 Sep 2001, Tom Lane wrote:
> John Summerfield <[EMAIL PROTECTED]> writes:
> > Or if it is reusing them, it's renaming them too.
>
> That is what the "recycling..." message is all about...
>
1) Why rename them?
2) Does anyone have a better idea
This has me foxed.
I can build the source on one machine, Numbat.
On another, Dugite it fails. I'm using the same script (copied from Numbat
to Dugite for the occasion).
Both systems are running Red Hat Linux; Dugite was upgraded from RHL 6.2,
Numbat was a fresh install.
I'm building from a t
On 4 Oct 2001, Arcady Genkin wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
>
> > > g9genarc@eddie:~$ psql -h /var/pgsql --help
> > > psql was compiled without support for long options.
> > > Use --help for help on invocation options.
> > >
> > > I guess that it was confused by havi
On Thu, 11 Oct 2001, Bruce Momjian wrote:
>
> I have added documentation for code 209. Looks like there are other
> undocumented ones. Should we document them all?
If you're asking me, I'm all in favour of documenting them;-)
I'm not a fan of "Read the source," though I do it if I'm desperat
It used to be the case that psql could be run thus:
psql -U summer -h numbat template1 <
ZZ
which is very convenient in scripting.
Now, it writes a password prompt (successfully in my case) and tries to
read the password (presumably from the tty) which fails.
Here is the entire script that f
two-major-versions-back
> release.
>
> If you can reproduce the problem in 7.2.1, then I'm all ears ...
>
> regards, tom lane
>
--
__
Web-Based Project Management and TimeSheet Sof
The following bug has been logged online:
Bug reference: 2477
Logged by: John Rylander
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Windows XP :(
Description:Aggregate Integer divisors incorrectly yield
integer-type quotient
Details
The following bug has been logged online:
Bug reference: 2538
Logged by: John Lyssy
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Windows 2003 Server
Description:Hang on insert/select
Details:
Client application hangs on doing insert
Hi,
That is strange behaviour - in summary, sometimes after running the
sample statements you get the result duplicated (as it looks in your
example), sometimes not?
I will see if I can reproduce it here and work out how that could happen.
Regards
John
---(end of
The following bug has been logged online:
Bug reference: 2546
Logged by: John Weekley
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Solaris unknown 5.11 snv_43 i86pc i386 i86pc
Description:PostgreSQL does not have native spinlock
The following bug has been logged online:
Bug reference: 2547
Logged by: John Bester
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: SUSE 10.0
Description:Notifications lost when using JDBC
Details:
I found that if I create a JDBC
On Mon, 2006-07-24 at 21:47 -0400, Bruce Momjian wrote:
> Zdenek Kotala wrote:
> > Tom Lane wrote:
> > > "John Weekley" <[EMAIL PROTECTED]> writes:
> > >> Platform is 64 bit Solaris x86.
> > >> ...
> > >> "../../../../src/i
The following bug has been logged online:
Bug reference: 2866
Logged by: john lyssy
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Windows XP
Description:cast varchar to decimal failure
Details:
This cast returns:ERROR: invalid input
The following bug has been logged online:
Bug reference: 3887
Logged by: John Cota
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: fedora core 8
Description:pgAdmin hang when click on database
Details:
Postgresql 8.2 on Fedora Core 8
The following bug has been logged online:
Bug reference: 4063
Logged by: John Whitley
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.0
Operating system: Windows XP SP2, Windows Server 2k3
Description:psql locks up on pager during dump restore
Details:
On
The following bug has been logged online:
Bug reference: 4089
Logged by: John Smith
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.0
Operating system: Linux 2.6.20-gentoo-r8
Description:When available disk space is low pg_stop_backup() fails,
as do
On Fri, Apr 4, 2008 at 7:46 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "John Smith" <[EMAIL PROTECTED]> writes:
> > Steps to reproduce:
> > -- start with a running PG instance with WAL archiving enabled
> > -- select pg_start_backup('tes
ugs/2007-08/msg00035.php
Well, it is supposed to have been fixed to version 8.2, but it's a PostgreSQL
8.2.4 x86_64 server running on Debian that triggers the error.
Thank in advance!
// John
x fixes between those versions (specifically in
> 8.2.5), but I don't know the details of them enough to say if this
> could be the problem you're hitting.
Thanks Magnus!
// John
-- Table: _replication.sl_seqlog
CREATE TABLE _replication.sl_seqlog
(
seql_seqid integer, -- Sequence
.
By the way thanks for all the effort you put into making PostgreSQL such a
marvelous database manager!
// John
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-bugs-
> [EMAIL PROTECTED] On Behalf Of Magnus Hagander
> Sent: den 22 april 2008 13:58
> To:
not what I expected. If it's normal in pgsql, would you
providing some suggestions how to let function use index.
thanks in advance.
john
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-
unsubscribe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
When running psql locally using the tcp connect with tcpip_socket = true and
hostname_lookup = true in postgresql.conf, psql does not find localhost unless
the -h option is specified.
427 bash$ psql
psql: FATAL: No pg_hba.conf entry for host localhost, user jrg4598, database
jrg4598
428 bash$ psql
Does this affect all versions of 7.3?
John Griffiths
Tom Lane wrote:
--
From: Tom Lane[SMTP:[EMAIL PROTECTED]
Sent: Saturday, October 18, 2003 3:14:37 PM
To: elein
Cc: [EMAIL PROTECTED]
Subject: Re: [BUGS] 7.3 interval casting broken (7.4 OK)
Auto forwarded by a Rule
elein
after making the changes to the files in the conf
directories may rebuild the rc files.
John
Theodore Petrosky wrote:
Neil,
I posted to the apple site asking if anyone could
recommend the 'correct' place to edit these settings.
I don't think a change like this would survive a
system
I fixed this problem by installing the package crypt under the LIB
category in cygwin.
Thanks,
John Wright
on 7.2.0: Thu Dec 11
> 16:20:23 PST 2003; root:xnu/xnu-517.3.7.obj~1/RELEASE_PPC Power
> Macintosh powerpc
I posted a more detailed description to the "porters" list a while back, for
those interested.
-John
---(end of broadcast)
y the version; instead it
seems that the version is 7.1.3.
The Supported Platforms matrix in the PostgreSQL Installation Instructions bundled
with 7.4 download has this mapping:
Linux x86 7.4
Is this right?
Thanks in advance,
John Muzzatti
(510) 817-3962
---(e
s is because the variable sort_mem in 7.4 and before was renamed to
work_mem in 7.5. If you change any occurrence of work_mem to sort_mem in
contrib/xml2 then it should work. Please let me know if you have any
further problems.
John
> I haven't found a declaration of w
Your name : John Madden
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : Intel Xeon
Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.26 (Debian 3.0)
PostgreSQL version (example
attached. Bottom line is the code looks
correct, but the expected test results looks incorrect.
Thanks,
John Kelly
*** ./expected/geometry.out Fri Oct 31 22:07:07 2003
--- ./results/geometry.out Tue Sep 21 08:48:46 2004
***
*** 117,123
| (5.1,34.5) | [(1,2),(3,4
-- Originally posted to pgsql-general, but no replies --
I was attempting to set up my psql client on the Win32 version of
postgres 8.0 beta 4 to be able to use an external editor. I set the
environment variable in windows like so:
PSQL_EDITOR="c:\progra~1\Textpa~1\Textpad.exe"
which does appea
).
FYI I have implemented my logic in a new way, so I don't need a fix, but
thought I'd pass on the details all the same.
Best Regards,
- John.
pg_log Extract
=
2004-11-16 08:58:41 NOTICE: 0: PASS: / did not raise an exception
2004-11-16 08:58:41 LOCATION: exec_stmt_raise,
f' => 'of','at' => 'at','by' => 'by','for' => 'for','with' =>
'with','about' => 'about','against' => 'against','between' => 'between','into'
=> 'into','through' => 'through','during' => 'during','before' =>
'before','after' => 'after','above' => 'above','below' => 'below','to' =>
'to','from' => 'from','up' => 'up','down' => 'down','in' => 'in','out' =>
'out','on' => 'on','off' => 'off','over' => 'over','under' => 'under','again'
=> 'again','further' => 'further','then' => 'then','once' => 'once','here' =>
'here','there' => 'there','when' => 'when','where' => 'where','why' =>
'why','how' => 'how','all' => 'all','any' => 'any','both' => 'both','each' =>
'each','few' => 'few','more' => 'more','most' => 'most','other' =>
'other','some' => 'some','such' => 'such','no' => 'no','nor' => 'nor','not' =>
'not','only' => 'only','own' => 'own','same' => 'same','so' => 'so','than' =>
'than','too' => 'too','very' => 'very','s' => 's','t' => 't','can' =>
'can','will' => 'will','just' => 'just','don' => 'don','should' =>
'should','now' => 'now' );
my $textstring = $_[0];
$textstring =~ s/[EMAIL
PROTECTED]&\*\(\)\_\+\-\=\{\}\[\]\\\|\:\;\"\"\'\'\<\>\,\.\?\/]+/ /gi;my
@words = split /\ /,$textstring;
my $res = [];
foreach my $word (@words) {
$word =~ s/([A-Z])/lc($1)/ge;
if($word ne $stopwords{$word} && $word ne '') {
push @$res,$word;
}
}
return $res;
$_$ language plperl immutable strict;
creashes the backend, UNLESS it's executed in the same session where it was
created.
Kind regards,
John
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
> Works fine for me. What encoding/locale are you using?
unicode / c
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
it_part('a b c d e f g h i j k l m n o p q r s t u v w x y
z',' ',3);
select split_part('a b c d e f g h i j k l m n o p q r s t u v w x y
z',' ',4);
should return b c, and d
returns b, c, null
... John
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
> [ shrug... ] Works fine for me in unicode, too.
never mind me,. I broke it.
seems my assumption that UCS2 == UTF16 was way off
... john
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropri
On occasion, it seems the psql history file gets truncated.
Unable to replicate, it just seems to happen every now and then.
... John
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
report it: impressive!
It seems to me you have developed a fantastic platform: I wish you every
success with the release.
- John.
From: Tom Lane <[EMAIL PROTECTED]>
To: Bruce Momjian <[EMAIL PROTECTED]>
CC: John Kennedy <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject
pls, link to the most important info - the release notes detailing
what's changed since a) RC1 abd b) 7.4.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
It seems rules don't work as expected.
I could be wrong,... In which case, what am I doing wrong?
Clearly, the first insert below should not update the table as well.
... John
CREATE TABLE test (a text, b int4[]);
CREATE RULE test_rule AS
ON INSERT TO test
WHERE exists(SELECT 1
from test;
a | b
---+---
first | 2
(1 row)
Now, the select on the first insert should NOT have happened. Since this is
a do instead rule.
The insert should of course happen, since it's not present in the table.
Or am I missing the point completely?
... John
> -Original M
The following bug has been logged online:
Bug reference: 1379
Logged by: John Gallai
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.2
Operating system: SuSE Linux 8.2
Description:pg_dumpall problem
Details:
Dear Developer Team!
I think the pg_dumpall and
. Since LOAD takes an absolute path, UNC paths may be
used on Windows, thus a low privileged database user can load an arbitrary
library from an anonymous share they have set up, escalating to the
privileges of the database user. I am still investigating the impact on
Unix.
Cheers
John
(this
The following bug has been logged online:
Bug reference: 1445
Logged by: John Anson
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.0.5017
Operating system: Windows XP SP2
Description:Installation failed during "Activating Procedural
Languages" -
The following bug has been logged online:
Bug reference: 1446
Logged by: John Anson
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.0.5017
Operating system: Windows XP SP2
Description:MSI installion fails if the postgres database password
contains an
se, that the create operator syntax be modified to accept:
PROCEDURE = function_name (type{,type})
and that checks be made for the existence of binary compatible casts between
the two (four) types.
Kind Regards,
John
---(end of broadcast)---
tatypes!
Anything less I'd consider inconsistent...
Kind regards,
John
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
ives.postgresql.org/pgsql-hackers/2004-11/msg00327.php) like so:
Select id from table inner join unnest(array[1,2,3,4,...]) as d(id) using(id);
Not only does it not crash the backend,. But it also proved to be faster, tho
admittedly not much.
... John
---(end of broadca
The following bug has been logged online:
Bug reference: 1541
Logged by: John Engelhart
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: FreeBSD 5.3-p5
Description:Unusually long INSERT times after fresh clean/CREATE
TABLES
Details
On Mar 14, 2005, at 12:13 AM, Tom Lane wrote:
"John Engelhart" <[EMAIL PROTECTED]> writes:
Since I'm developing an SQL based application, I routinely "start from
scratch" with a script that deletes all the tables in my database and
rebuilds them. A problem starte
The following bug has been logged online:
Bug reference: 1547
Logged by: John Smith
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Windows 2000
Description:CREATE TYPE AS error
Details:
When trying to create a complex type, the parser
Try the replacement upper/lower functions that I wrote:
http://archives.postgresql.org/pgsql-hackers/2005-02/msg00102.php
Kind regards,
John Hansen
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Staffan Sandberg
> Sent: Tuesday, Ma
0.0 <[EMAIL PROTECTED]>...
We don't accept mail from spammers>
Please see to it that they update their anti-spam rules.
I recent the implication of being a spammer.
... John
Try the replacement upper/lower functions that I wrote:
http://archives.postgresql.org/pgsql-hackers/200
I re-installed postgresql as a service and CREATE TYPE AS works. So I then
re-installed postgresql as a program (as I had originally done) and CREATE
TYPE AS doesn't work.
Perhaps you could check this on your system.
John Smith
--
AIL PROTECTED]>
Reply-To: pgsql-bugs@postgresql.org
To: John Smith <[EMAIL PROTECTED]>
CC: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #1547: CREATE TYPE AS error
Date: Sat, 2 Apr 2005 19:23:45 -0700
On Mon, Mar 28, 2005 at 12:51:42AM +, John Smith wrote:
> I re-installed po
The following bug has been logged online:
Bug reference: 1627
Logged by: John Danger
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.2
Operating system: Mac OSX 10.4
Description:Fails to compile
Details:
While I don't have extensive experience
http://dev.mysql.com/doc/mysql/en/alter-table.html
>
>
> thanks,
>
> Llewellyn.
>
>
... John
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Would someone be kind enough to advise this person to update his
antispam software, so that it doesn't include all of australia as
spammers?
Kind Regards,
John Hansen
_
From: System Administrator
Sent: Saturday, M
Maybe you restored to template1 by mistake?
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Toltzman
> Sent: Monday, May 23, 2005 4:38 AM
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] drop + create database restores previous
> tables a
I've seen this before, and that was due to unaligned memory access,
which is not supported on some platforms.
I thought we didn't do unaligned memory access??
... John
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
e different algorithms to
> > determine when two strings are equal?
>
> Are you sure table_two is empty when you do this?
>
And, are these the _actual_ tables?
If not, try SELECT DISTINCT ON (field1) field1 FROM table_one; instead.
>
FYI, Works just fine on gentoo with the UTF8 and ICU patches.
... John
> This bug happens in SUSE 9.3 on both Pentium 4 and AMD64,
> whether the binaries are from postgresql-8.0.1 RPMs on the
> SUSE 9.3 DVD or are built from 8.0.3 source code. However
> this bug does NOT happen w
1 - 100 of 357 matches
Mail list logo
