the configure scripts etc. might
have a look.
Regards,
Scott
retty intensly re going into version
7.2) on our QNX (6.2) development system at work...it seems to have worked
no problems. Though I didn't try installing the patched version under cygwin
or building the libpq stuff under windows...
Scott
- Original Message -
From: "Bruce M
-
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To: "Scott" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, August 18, 2002 1:46 AM
Subject: Re: [BUGS] bug in config for cygwin
> Scott writes:
>
> > I'm not sure if what I've notic
The following bug has been logged online:
Bug reference: 5613
Logged by: Scott
Email address: wheels7...@hotmail.com
PostgreSQL version: 8.4
Operating system: vista
Description:cannot delete
Details:
I have recently tried to install PostgreSQL to use with poker
The following bug has been logged online:
Bug reference: 4451
Logged by: Scott V
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: Mac OS X 10.5.4
Description:initcap() function capitalizes incorrectly
Details:
initcap() capitalizes
Note sure what the correct settings should be, but output from SHOW
ALL in psql says:
lc_collate C
lc_ctype C
On Mon, Oct 6, 2008 at 5:37 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> Scott V wrote:
>>> PostgreSQ
The following bug has been logged online:
Bug reference: 4575
Logged by: Scott Carey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.5, 8.3.4
Operating system: Linux (CentOS 5.2 2.6.18-92.1.10.el5)
Description:All page cache in shared_buffers pinned
nt: Thursday, December 11, 2008 12:35 AM
To: Scott Carey
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4575: All page cache in shared_buffers pinned
(duplicated by OS, always)
On Thu, Dec 11, 2008 at 5:37 AM, Scott Carey wrote:
>
>
> Run top, and note the largest value o
er characterize it in ways that would be useful to that end, that
would be great.
I should have time to set shared_buffers above 50% and see if it kills things
later today -- this sort of test would not require any special cache flushing
particular to linux to see.
Thanks,
Scott
___
in that
realm. Now that I am comfortable that you understand the symptoms I see, and
you are confident its elsewhere, I trust that the issue's cause must be
elsewhere.
Thanks!
-Scott
On 12/11/08 1:16 PM, "Tom Lane" wrote:
Scott Carey writes:
> I am 99.9% certian its not a
Linux, CentOS 5.2, Postgres 8.3.4, 8.3.5. System tables and user tables listed
below have been VACUUM'd, ANALYZE'd and REINDEX'd.
Summary:
Simple update / delete queries that hit a parent table façade of a large
partitioned database are taking 15 to 20 seconds to plan (and a couple ms to
exec
The following bug has been logged online:
Bug reference: 4699
Logged by: Scott Reed
Email address: sr...@avacoda.com
PostgreSQL version: 8.3
Operating system: Windows XP
Description:pg_restore hangs with incorrect file format
Details:
"pg_restore " ha
in pgAdmin Backup and Restore? I will resubmit if you think it
would be useful.
Scott
Tom Lane [3/10/2009 3:43 PM] wrote:
"Scott Reed" writes:
> "pg_restore " hangs if the file format is not one of the
> non-plain-text formats created by pg_dump.
When I try to reprod
en archiving is on so the warm
> standby server can catch up.
You make an excellent point. If you're looking for a way to mitigate this
risk, run:
select pg_switch_xlog() ;
Before shutting down.
--Scott
>
>
> Regards.
> Andreas
>
> --
> Sent via pgsq
8.3.5 as well as 8.3.7
Please help.
-Scott
D. Scott Wells
Systems Administrator II
Apollo Group Inc.
STS | 4325 S. 30th Street | Suite 200 | M/S AA-M002 | Phoenix, AZ 85040
(602) 557.6673
This message is private and confidential. If you have received it in error,
please notify the sender
on to help us with your problem though, maybe you
should submit to pgsql-general list with your actual problem. I'm sure that
we can help. When submitting, you should include things like:
OS
PG Version
Installer you're using
Error messages / logs
Thanks
--Scott
have to subscribe yourself. I recommend that you
unsubscribe.
--Scott
>
> _
> Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.
>
> http://www.microsoft.com/windows/windowslive/products/photos.aspx
> --
>
either by default or through
their package manager.
Good luck
--Scott
ther by default or through
their package manager.
Good luck
--Scott
If you're using Postgres Plus Advanced Server, that is a commercial product
released by EnterpriseDB. It is not supported here. Please use '
supp...@enterprisedb.com'
--Scott
ckaging thing, but if it's a '.bin' file, it could be
the one-click installers. It'd be helpful to know where the OP downloaded
the installers from.
--Scott
it's a '.bin' file, it could be
the one-click installers. It'd be helpful to know where the OP downloaded
the installers from.
--Scott
2009/11/24 RD黄永卫 :
> Dear all,
>
>
>
> When "reindex" operation do,this error occurred:
> Nov 22 10:22:27 SUC11 postgres[14145]: [2-1] ERROR: could not create unique
> index
> Nov 22 10:22:27 SUC11 postgres[14145]: [2-2] DETAIL: Table contains
> duplicated values.
> Nov 22 10:22:27 SUC11 postgr
2009/11/24 RD黄永卫 :
>
> 发件人: Scott Marlowe [mailto:scott.marl...@gmail.com]
> 发送时间: 2009年11月25日 14:44
> 收件人: RD黄永卫
> 抄送: pgsql-bugs@postgresql.org; pgsql-gene...@postgresql.org
> 主题: Re: [GENERAL] How duplicate data produce when a UNIQUE index exite ?
>
> 2009/1
referring to phpPGadmin, an administration tool for the database?
--Scott
gt;
> I doubt it. postgresql.conf should be parsed identically on any
> platform, I would think.
>
I've seen this when I accidentally use the wrong pg_ctl on a data directory
(i.e. my 8.1 pg_ctl is in the PATH and I use it to try and start an 8.3
cluster).
--Scott M
e
>
> In advance thank you very much.
>
>
Does the '/var/run/postgresql' directory exist and is it writeable by the
postgres user? If it is not, I would say it's a bug for the packager of
this install of postgres. Typically, postgres puts its lock / sockets in
'/tmp&
On Thu, Apr 15, 2010 at 12:47 PM, Scott Mead
wrote:
> On Thu, Apr 15, 2010 at 10:33 AM, suresh adapa wrote:
>
>>
>>
>> I am on Linux using postgresql-8.3.6-1PGDG
>>
>>
>>
>> Taking Dump using
>>
>> =
>>
>>
and other messages seen above.
>
This is because you're restoring into the same database that you backed up
from. I recommend creating a new database 'suresha_new'
Then, restore into that new database. Once you've restored, you can:
ALTER DATABASE suresha RENAME TO suresha_orig;
ALTER DATABASE suresha_new RENAME TO suresha;
--Scott
>
>
>
>
> Thanks
>
> SureshA
>
er via a
> secondary script or maybe your init.rc script is wrong?
>
>
>
> On Thu, Apr 15, 2010 at 8:51 AM, Scott Mead
> wrote:
>
>>
>> On Wed, Apr 14, 2010 at 8:15 PM, Alex Soto Paez <
>> alejandro.soto...@gmail.com> wrote:
>>
>>>
&g
er via a
> secondary script or maybe your init.rc script is wrong?
>
>
>
> On Thu, Apr 15, 2010 at 8:51 AM, Scott Mead
> wrote:
>
>>
>> On Wed, Apr 14, 2010 at 8:15 PM, Alex Soto Paez <
>> alejandro.soto...@gmail.com> wrote:
>>
>>>
&g
to install PGAdmin3, is it possible on Suselinux? *
>
>
>
Have you tried the OpenSuse RPMS?
http://www.postgresql.org/ftp/pgadmin3/release/v1.10.0/opensuse/11.1/
If all else fails, download the one-click installer for your platform. It
has PGAdmin in there.
--Scott
query="select * from product where cat1 like 'Home decoration--%'"
this query does not return any tuples in v7.02 but return 1 tuple in v6.5x
with the same database population.
I ran another query="select * from product where cat1='Home
decoration--musical'". This query return one tuple.
I ran an
problem if another process which is
not the result of a fork tries to attach to the shared memory.
The Direct pointers will not be valid for in this case.
Thanks,
Myron Scott
[EMAIL PROTECTED]
On Mon, 5 Feb 2001, Tom Lane wrote:
> Myron Scott <[EMAIL PROTECTED]> writes:
> > May I suggest that watiHolder and waitLock pointers
> > in the proc struct in proc.h be changed from direct
> > pointers to SHMEM_OFFSET. They are both shared memory
> > struct
er installation
reported that it couldn't find libpg (`-lpq.2 => Not Found'
or something like that).
Remarks:
There's almost certainly a better way, since src/Makefile.global is
automatically generated, but I'm still getting acclimated to NetBSD
and Postgres build.
- Scott Williams
I've seen a few postings in multiple newsgroups saying that in 7.1.x and
up, literals in SQL statements are implicitly cast to strings.
For example in:
select distinct 'hello' from mytable;
the 'hello' is implicitly assumed to be 'hello'::text
However, in both 7.1.3, and a fresh build of 7.2b4
I've got some 'legacy' code that I'm dealing with - sometimes it will
receive query requests that are simply the union of two easier requests
it already knows the sql for.
These 'easier' queries have 'distincts' in them, and the code doesn't go
to the trouble of removing by hand when doing a un
The following bug has been logged online:
Bug reference: 3046
Logged by: Cedric Scott
Email address: [EMAIL PROTECTED]
PostgreSQL version: odbc 8 2 200
Operating system: WindowsXP
Description:odbc zip file corrupt
Details:
I downloaded 4 versions of psqlodbc
The following bug has been logged online:
Bug reference: 3544
Logged by: Scott Harper
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.9
Operating system: Debian Linux (2.6.18-4-486)
Description:SQLException from JDBC driver
Details:
I have installed
The following bug has been logged online:
Bug reference: 3706
Logged by: Scott Bailey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3beta1
Operating system: Tru64
Description:ecpg regression: "MOVE FORWARD"
Details:
The following statement:
exe
E MoverSQL FROM :mover;
[...]
EXEC SQL EXECUTE MoverSQL USING :RowMove;
[...]
EXEC SQL DEALLOCATE PREPARE MoverSQL;
Assuming the new restriction on the original "MOVE FORWARD" is
intentional, it would be nice to see a warning that code changes are
required get into the documentation.
Tha
The following bug has been logged online:
Bug reference: 4264
Logged by: Scott Carey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3
Operating system: Linux (CentOS)
Description:Optimizer fails to use hash_aggregate when appropriate.
Details:
The query
query planner Tom,
and the reminder that DISTINCT forces a sort -- I forgot all about that.
-Scott Carey
On Wed, Jun 25, 2008 at 1:55 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Scott Carey" <[EMAIL PROTECTED]> writes:
> > The query optimizer fails to use a hash ag
Pg 104 of "A Guide to THE SQL STANDARD" Fourth Edition by Date/Darwen says:
...
2. Observe that the definition makes no mention of row ordering. As
explained in Chapter 2, the rows of an SQL table have no ordering (and the
same is true of true relational tables). It is possible, as we will see in
give me an error message telling me how to subscribe without getting
postings. ;-)
R. Scott Bailey
EDS - Global Operations Solutions Delivery - Midwest
MS 2O
1075 West Entrance Drive
Auburn Hills, MI 48326
* phone: +01-248-276-5770 (8-351)
* mailto:[EMAIL PROTECTED]
www.eds.com
> This e-m
POSTGRESQL BUG REPORT TEMPLATE
Your name : Gavin Scott
Your email address : [EMAIL
I've encountered a problem where the PostgreSQL database crashes when
attempting to load pltcl.so on Mac OS 10.3. PostgreSQL fails because
memory cannot be allocated during a shmget call. Here is the exact
error message:
FATAL: could not create shared memory segment: Cannot allocate memory
DET
it's doing it
on Mac OS 10.3. Here are the commands I'm using, in the order I'm using
them. I'll be glad to admit I'm the one screwing it up, but I don't see
where.
# Define vars
ROOT=/Users/scott/m
INSTALL=$ROOT/install
PG=$INSTALL/postgresql
PGLIB=$PG/lib
/usr/bin, and in the
same place in FreeBSD source tree.
/s.
On Nov 6, 2003, at 2:41 PM, Tom Lane wrote:
Scott Goodwin <[EMAIL PROTECTED]> writes:
psql:/Users/scott/m/ops/database/sql/add_languages.sql:13: server
closed the connection unexpectedly
This probably means the se
es, so it doesn't dump me back to the gdb command line. I'll have
to set breakpoints, have GDB do something with the signal, or mod PG to
not catch it. That'll have to wait until tomorrow or Saturday.
thanks for the assist,
/s.
On Nov 6, 2003, at 2:41 PM, Tom Lane wrote:
S
Awesome! Thanks so much for the fix -- I depend on PostgreSQL and Tcl
on my powerbook to do development work.
cheers,
/s.
On Nov 8, 2003, at 2:09 PM, Tom Lane wrote:
It turns out that the "createlang pltcl" failure on OS X 10.3 was due
to
our ps_status code doing the wrong thing. I have comm
e. Has anything changed in the
connection handling, as if connections are not being released this could
easily cause the first problem? Again, this appears peculiar to 7.4.1.
Thanks.
Scott.
---(end of broadcast)---
TIP 2: you can get off all lis
On Feb 21, 2004, at 1:51 AM, Tom Lane wrote:
Scott Goodwin <[EMAIL PROTECTED]> writes:
Hoping someone can help me figure out why I can't get PL/Tcl to load
without crashing the backend on Mac OS 10.3.2.
FWIW, pltcl seems to work for me. Using up-to-date Darwin 10.3.2
and PG CVS tip, I
rtup script to 'unset LS_COLORS' before starting PG,
and this works great. Has anyone else tried to duplicate this problem?
I'm using Mac OS 10.3.2, PG 7.4.1, Tcl 8.4.5.
/s.
On Feb 22, 2004, at 12:21 PM, Tom Lane wrote:
Scott Goodwin <[EMAIL PROTECTED]> writes:
Found the
I'll grab the CVS PG copy and try it out. Is this something the Darwin
folks should be notified about? It might cause problems with other
apps.
thanks,
/s.
On Feb 22, 2004, at 4:47 PM, Tom Lane wrote:
Scott Goodwin <[EMAIL PROTECTED]> writes:
Found the problem. If I have a very long
On Mon, 2004-06-07 at 12:11, Alexander S. wrote:
> There is bug in 7.4.2, concerning unicode and russian letters. For db
> in unicode russian data doesn`t order in alphabetical order (rows group
> with the same first letter but not in alphabetical order).
> SELECT "person" from my_table ORDER BY
On Fri, 2004-10-22 at 00:59, Davide Negri wrote:
> Hello,
>
> i have installed postgres 8.0 beta3 as a program on my pc on windows
> xp. I have read on the installation note file that postgres server
> will not run with administrative permissions. I have read on your
> forum that this happened be
nstaller) I get
something completely nonsensical:
ERROR: syntax error at or near "ROLLBACK" at character 897
Thanks,
Scott
--
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au
---(end of broadcast)---
TIP 8: explain analyze is your friend
The following bug has been logged online:
Bug reference: 1355
Logged by: Scott Stillwell
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Windows XP Pro SP2
Description:8.0.0 rc2 installer fails
Details:
When installing PostgreSQL 8.0.0
.microsoft.com/fwlink/events.asp.
No further information is in the System or Security event logs.
Thanks for the reply...I'll forward more information as I acquire it.
Regards,
Scott Stillwell
-Original Message-
From: Magnus Hagander [mailto:[EMAIL PROTECTED]
Sent: Thursday, Dec
Found the problem...it's been reported before.
http://archives.postgresql.org/pgsql-bugs/2004-11/msg00195.php
I was a bad boy and left off the part about the missing ordinal in
libeay32.dll...
Dunno if that's something that still needs to be fixed, but at least
I've got a wor
The following bug has been logged online:
Bug reference: 1569
Logged by: Gavin Scott
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Fedora Core 3
Description:Threads don't see ecpg default connection
Details:
When using postgresq
]> for a bug in
thread
support.
----
--
Gavin Scott
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
The following bug has been logged online:
Bug reference: 2226
Logged by: Doug Scott
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows XP Pro
Description:Can't delete elements from Enterprise Architect diagram
when using Postg
The following bug has been logged online:
Bug reference: 2299
Logged by: Gavin Scott
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: fedora core 4
Description:pg_dump error w/ renamed primary keys
Details:
If you rename a primary key
the pg_stat_tmp file
is used for?
> Date: Thu, 12 Aug 2010 16:39:54 -0400
> Subject: Re: [BUGS] BUG #5613: cannot delete
> From: robertmh...@gmail.com
> To: wheels7...@hotmail.com
> CC: pgsql-bugs@postgresql.org
>
> On Wed, Aug 11, 2010 at 1:41 PM, Scott wrote:
> >
On Mon, Nov 29, 2010 at 8:02 AM, Mohammed Rashad
wrote:
>
> I am running ubuntu 10.04
> I have problem installing postgresql-8.4
> when i tried to start postgresql
> /etc/init.d/postgresql-8.4 start
> I am getting this error
> * Starting PostgreSQL 8.4 database server
>
The following bug has been logged online:
Bug reference: 5898
Logged by: Scott Dunbar
Email address: sc...@xigole.com
PostgreSQL version: 9.0.3
Operating system: Ubuntu 10.10
Description:Nested "in" clauses hide bad column names
Details:
I have a nested
ong" but I do understand what's going on.
Thanks for your help.
On 02/22/2011 10:45 AM, Tom Lane wrote:
"Scott Dunbar" writes:
I have a nested in clause like:
select respondent_id from respondent where respondent_id in (select
respondent_id from chat_session where project
First, this isn't a bug... this is more of a discussion for -general or
-admin.
On Wed, Apr 27, 2011 at 9:44 AM, Kevin Grittner wrote:
> "Suprabhat" wrote:
>
> > FATAL: too many connections already and there are too many
> > postgres processes on the server. We have used connection
> > pooling
Cannot install rpm files
> Details:
>
> Hi
>
> I cannot install postgresql on Fedora 15, please provide the installation
> procedure for Fedora 15.
>
> A) Where did you download them from (exact URL) ?
B) What is the error you are getting?
C) http://wiki.postgresql.org/wiki/
ase server
>
>
> The following also needs to be added:
>
> ### BEGIN INIT INFO
> # Provides: PostgreSQL
> # Required-Start:
> # Required-Stop:
> # Default-Start: 3 5
> # Default-Stop: 0 1 6
> # Description: Start/Stop Script for PostgreSQL 8.4 database server
> ###
quot;/var/lib/pgsql/data"}
> createdb DatabaseName
> psql DatabaseName
> su - root
> cd /home/download/pgadmin3-1.14.0
> ./configure --with-pgsql=/var/lib/pgsql
>
/var/lib/pgsql is your data directory. --with-pgsql is looking for
binaries.
try ./configure --with-pgsql=/usr/
or
./c
his is most likely a configuration issue, not a bug. Please refer to
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems in order to get
the solution to your problem.
--Scott
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
Chrystel,
I just verified, you never need to register in order to download
postgres from the OpenSCG site.
If you hit this link (from the postgres download site:
http://www.openscg.com/se/postgresql/packages.jsp). You can click through
and download without ever registering.
--Scott
On
On Tue, Jan 8, 2013 at 2:47 PM, Scott Mead wrote:
> Chrystel,
>
>I just verified, you never need to register in order to download
> postgres from the OpenSCG site.
>
> If you hit this link (from the postgres download site:
> http://www.openscg.com/se/postgresql/packages
Sorry for the confusion and ambiguity of the request. The files we are
requesting the MD5 checksum for are located here:
http://www.postgresql.org/ftp/binary/v8.3.7/linux/rpms/redhat/rhel-4-i386/
Thanks!
P. Scott Hill
Software Engineer, Web Development Group
National Coastal Data Development
78 matches
Mail list logo
