Chris Schroter wrote:
Hi,
Would you please tell me if there is a default password for the Postgres vacuum
utility?
there are no passwords for any programs, passwords are users to connect
to databases, IF the appropriate line in pg_hba.conf specifies to use
passwords.
there are also no
Bill Moran wrote:
A quick note that flash is still proprietary and not
universally available, therefore content posted only as
flash is unavailable to otherwise perfectly viable
platforms. I don't think adobe's unwillingness to change
that should be reason to ditch my preferred platform, so
pleas
Harald Armin Massa wrote:
John,
indeed, I just wandered all over www.postgresql.org with a flashblocker that
would have shown me a big fat "F" on any flash content, and saw zero, zilch,
none.
close enough not you are looking:
http://www.postgresql.org/about/news.1013
you got me
Dey, Sutapa wrote:
Hi
All,
I
am trying to build/enable plperl support for postgres.
1.
The system info is :
#
uname -a
HP-UX
unknown B.11.23 U 9000/800 1178464650 unlimited-user license
2.
The steps I followed:
a)
In
postgres user’s .profile file I
Alexandra Nitzschke wrote:
BTW... how about a block checksum that is checked just before writing
a block and just after reading it? I know this would degrade
performance, but I think we can afford that. Would it be possible to
incorporate such code without having to do too much patching?
ora
Gregory Stark wrote:
John R Pierce <[EMAIL PROTECTED]> writes:
oracle has had an option for some time that uses read/only page protection for
each page of the shared buffer area... when oracle knows it wants to modify a
page, it un-protects it via a system call. this catches an
Tom Lane wrote:
Whatever strchrnul is, it isn't very portable --- the buildfarm is
breaking out in red too. Please change that.
sigh, more gnuish code
— Function: char * *strchrnul* (const char *string, int c)
|strchrnul| is the same as |strchr| except that if it does not find
Peter Eisentraut wrote:
No really, the built-in geometry types are considered kind of legacy.
Indeed, I was reviewing the postgres 'history' on the website the other
day, and noted that stuff was put in Postgres *BEFORE* it was SQL.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresq
JOHN_MCY wrote:
hai,
I am new to SQL...
I am trying to get the result of some mathematical calculation with
group by some key.
I can get the result without grouping. here with i specified my table
information and the SQL i have used to get the result..
can anybody
chris wood wrote:
Apology in advance, this is not a bug, just wanted to ask if the
following issue is being considered:
Cloud computing seems to be quickly gaining ground as a deployment
technology for web apps.
From what I see this has not been good for Postgres. Google App Engine
cannot
chris wood wrote:
At a detailed level (which is NOT the direction I want this thread to
go) I do not agree with your statement that my proposal has no “hope
of ACID compliance or transactional integrity”. When the “slices” are
stored back to the cloud, this is the equivalent of a commit and the
Gurjeet Singh wrote:
This mail landed in my Spam box... with this message:
"Warning: This message may not be from whom it claims to be. Beware of
following any links in it or of providing the sender with any personal
information"
it must have been at your end, it arrived via the [bugs] list
lftsang wrote:
Dear Sir,
I tried to install PostgreSQL 8.1.15 on Freebsd 7.0. When I extracted
the .tar.gz and inputed 'make' it shows the following error:
"/usr/share/mk/bsd.port.mk", line 11: Could not find
/usr/ports/Mk/bsd.port.mk
"Makefile", line 177: Malformed conditional (${ARCH} == s
aerkain wrote:
- It is Windows Vista Business.
- ..\PostgreSQL\8.3\data is existing and empty.
- during uninstallation postgre has reported an error: unable to stop
service
- I have deleted PostgreSQL directiory (after uninstall), but when I try to
install it still display message that "The datab
r m wrote:
Hello
I uninstall postgresql
When I try install it again I can not do it
It requset password.
I forgot it
That is why I reinstall your software.
What should I do?
I delete all I can include ODBC system DNS registration
wild guess says you're on a Microsoft Windows system? a
Jason wrote:
I let the installer pick a password for me. What it picked was 31
characters long, and included characters that I can't actually type on my
keyboard. Quite possibly some can't even be displayed on my system, as
several are listed as "?". One of the other characters is the section
Harald Armin Massa wrote:
that password is ONLY used for the Windows Service login, not anything you'd
ever see again.
Only when reusing the service account to do a PostgreSQL update... or
when doing the not so uncommon "uninstall, reinstall" raindance fix
for windows (which indeed helps i
Harald Armin Massa wrote:
John,
the postgres windows uninstaller probably should be offering to delete the
postgres user account when it deletes the service, since the installer
created that account in the first place.
deleting the postgres-windows-account is not really what someone
s
ash...@symcor.com wrote:
I have ./postgres/8.3-community/lib/64/libpq.so.5 so how do i make it use
it.
assuming you're using sh/ksh/bash and not csh, in the script thats
launching your application, or in your account ~/.profile ...
export LD_LIBRARY_PATH;
LD_LIBRARY_PATH=/path/to/p
Harald Armin Massa wrote:
Prachi,
the current Version of PostgreSQL is 8.3.x; you should use that.
To solve the problem with "> invalid username specified: logon
failure: unknown username or bad password.", change the password of
the postgres-user in windows to something you know and specify th
Manuel G Vazquez B/Mexico/IBM wrote:
Hello
I have a customer who bought an IBM Power Systems, running AIX 5.3 and
wants to install the PostgresSQL 8.1.9. Can you pls tell me where I
can Download this version for AIX? and if youa have some documentation
or FAQs about the installation you can
Dafina.Abernathy wrote:
To Whom It My Concern,
I am a member of a small group using PostgreSQL has a data backend
and I writing to request and MD5 checksum for PostgreSQL 8.7.3.
If an MD5 is not available, I would appreciate the location of an RPM
for 8.7.3, if there is one available.
Thank
John R Pierce wrote:
Dafina.Abernathy wrote:
I am a member of a small group using PostgreSQL has a data backend
and I writing to request and MD5 checksum for PostgreSQL 8.7.3.
If an MD5 is not available, I would appreciate the location of an RPM
for 8.7.3, if there is one available.
Thank
Dafina.Abernathy wrote:
Hello Mr. Pierce,
You are correct it is for version 8.3.7. for Redhat. My apologies for
the mix-up.
A member of the group has checked http://yums.postgresql.org and was
unable to locate an RPM for Redhat.
"Redhat" describes a dozen versions of Linux and a half dozen
feridun türk wrote:
İ have two question,
Backup and restore with C# (windos form) interface, or postgre scripts?
thats one question, and its missing information, but as expressed, it
seems a choice between two alternatives... A) use the existing pg_dump
utility, or B) write your own backup p
Stephen Frost wrote:
* Peter Eisentraut (pete...@gmx.net) wrote:
The new firefox just says "invalid certificate" and nothing else, and then
somewhere below there is a small link to "Add an exception" and you need a
total of four clicks to proceed. So that looks a lot like that they are
mov
John R Pierce wrote:
for self-signed certs, you first create a rootca, you can import the
rootca public key/cert to your browser, by offering it as the proper
mime type (I forget the specifics), once accepted into your browser,
the browser will trust any certs created off that root, same as if
gs wrote:
The following bug has been logged online:
Bug reference: 4772
Logged by: gs
Email address: g...@freenet.am
PostgreSQL version: 8.3.1
Operating system: Fedora 9
Description:The server is hanging
Details:
Hello, the Linux server is going down, we don't kno
Oleg Kharchenko wrote:
Hi! Tell me please mail support or help to solve my problem. I can not download PostgreSQL 8.0.3, not version above. How do I know the link for download?
Why would you want such an old and buggy version? If you require 8.0,
the current bug-fixed version is 8.0.21
Markus Meyer wrote:
The following bug has been logged online:
Bug reference: 4794
Logged by: Markus Meyer
Email address: mar...@7val.com
PostgreSQL version: 8.3.3
Operating system: Debian 2.6.22.19-vs2.2.0.7
Description:server closed the connection unexpectedly
Detai
root wrote:
at rpm pachage.
but , I take server Xen in www.server-linux.info
and postgresql install,
I couldn't initdb , at www.
'Report bugs to ' you.
thats far too cryptic to answer, I cant even tell what the question
is.whats www.server-linux.info, I'm getting a DNS error from that U
mcronix wrote:
Hi
First time poster and complete postgres noob. I basically only ever use it
along side an online poker database program, Holdem manager - I've been
running postgres 8.2 with HEM for ages now, with no problems, when earlier
today I had a window popup from the task bar saying Delay
suylivar wrote:
Dear sir/madam,
I am from Cambodia. I want to use PostgreSQL. But I am poor of
knowledge to install could you please help me give some guide to
install PostgreSQL on Solaris 10,
Thanks for your respond and value times.
this isn't really a bug report, and probably shoul
ajmcello wrote:
The only downside with adding o to tar that I can see is if it isn't
supported by a non-GNU version of tar.
On solaris 9 and 10 at least, tar -o means set ownership of extracted
files to the runner and not the uid in the tar, which I assume is what
we want here.
Note, this
Greg Stark wrote:
I don't know where to find Postgres logs on Windows but it
shouldn't be hard to find.
$(INSTALLDIR)/data/pg_log
D:\postgres\8.3\data\pg_log on mine here.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.po
Sam Mason wrote:
On Wed, Aug 26, 2009 at 02:55:37PM +, Ken Smith wrote:
I also noted
that if I try to run from the commandline that you use '/' in some of the
program paths causing the OS to say it cannot find the file - "C:/Program
Files/Java/jdk1.5.0_16/jre/bin/java.exe".
I'm pre
Alan Rubin wrote:
The following bug has been logged online:
Bug reference: 5029
Logged by: Alan Rubin
Email address: alanrubi...@yahoo.com
PostgreSQL version: unknown
Operating system: Windows XP
Description:Download Trouble
Details:
i'm trying to download postgre
Craig Ringer wrote:
[for SATA disks]: does smartctl from the smartmontools package indicate
anything interesting about the disk(s)? (Ignore the "health status",
it's a foul lie, and rely on the error log plus the vendor attributes:
reallocated sector count, pending sector, uncorrectable sector co
Yaming Gu wrote:
Hi, List,
Because my previous mail contains some Chinese character, now I
modified it, the whole problem is described as below:
I need to create language Pl/Perl. I have checked all dependencies of
plperl.dll and all is ok.
have you installed perl? I believe the p
Tom Lane wrote:
There is special-purpose software out there that can compute exactly
with rational numbers, but you aren't likely to find it embedded in any
general-purpose tools like databases --- the use-case just isn't wide
enough. One reason why not is that it'll still fall down on irrationa
Michał Pasternak wrote:
1 month / 1 day equals 30.
or 31 or 28 or 29...
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Tomas Studva wrote:
My case is WIN XP SP 2 and also when applied SP3. My system has only
one speciality as I know, that is I have windows installed on F
partition.
I was installing on path F:\Program Files\PostgreSQL\8.4 and also
tried C:\Program Files\PostgreSQL\8.4, problem is probably
Mike Landis wrote:
Can you please stop displaying the email addresses on bug reports?
It's one thing to require an email address - it's another thing
entirely to publish it for spam address harvesting bots.
This is an example page...
http://archives.postgresql.org/pgsql-bugs/2009-12/msg00092.
top is not the be-all and end-all of analysis tools. I'm sure you
know that, but it bears repeating.
More importantly, in a virtualised environment the tools on the inside
of the guest don't have a full picture of what's really going on.
Indeed, you have hit the nail on the head.
does an
John R Pierce wrote:
top is not the be-all and end-all of analysis tools. I'm sure you
know that, but it bears repeating.
More importantly, in a virtualised environment the tools on the
inside of the guest don't have a full picture of what's really going on.
Indeed, y
zhong ming wu wrote:
Would any of these rpms let me relocate to any directories I want? Can
I install them as local-postgresql-1.2.4 without overwriting current
package postgresql-1.2.3 ?
I don't know, but the packager is on this list and can perhaps better
answer than I.His rpm.spec fi
Raphael Palestino Serpa wrote:
Hi, I tried to install PostgreSQL Version 8.4.2-1 for Windows XP and
need a password, I tried some passwords that I used in the instalation
in the University but didn't work. What can I do? What is the password?
what exactly is asking for this password? was the
beulah prasanthi wrote:
hello
I deleted existing DB and i created new DB
i am getting below error how can i resolve it can any one help please
"language "plpgsql" already exists"
um, whats the problem? that just means someone already did the CREATE
LANGUAGE "plpgsql"; possibly in template
Boszormenyi Zoltan wrote:
Loading this dump into another database that happens
to have a different locale than hu_HU fails.
But then any operator between two money values would
only work if both values have the same currency.
indeed, its all a big tarpit. next, you'll want currency convers
Chris Travers wrote:
Hmm... Back to the drawing board on that helper module :-).
like I said, its a big tarpit.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Then again, I never did have a very high opinion of big name SAN
vendor hardware - I have always achieved better results at a fraction
of the cost with appliances I've built myself.
yeah, its so easy to slap together 1000 spindle half petabyte storage
arrays with 5-nines reliability and 500K
Greg Sabino Mullane wrote:
Bugzilla is the worst form of bug tracking out there, except for
all the others.
flyspray isn't half bad, especially because its really simple and fairly
clean.
supports pgsql too.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make chang
shanmugavel wrote:
The following bug has been logged online:
Bug reference: 5437
Logged by: shanmugavel
Email address: shanmugave...@onwardgroup.com
PostgreSQL version: 8.3
Operating system: linux RHEL 5
Description:Production db down
Details:
Hi,
i'm shanmugavel
Michael Meskes wrote:
On Wed, May 19, 2010 at 08:53:12AM +, Michael Enke wrote:
If you run it through ecpg, in the resulting c file
the variable test has type long on 64 bit system.
On 32 bit system it is long long.
Apparently when this code was written "long long" was 64bit, but i
Magnus Hagander wrote:
Hey,
I am trying to install the Postgreql 8.1.3 on the windows 2k
platform. While installing I am getting the following error :
"Your local 'Power Users' group contains 'Authenticated
Users' ". This Error has been previously discussed in the
mailing list. (
http://arch
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?
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-
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 ...
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
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
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
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-
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
(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
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
"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,
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
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
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
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
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)
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
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
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
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.
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
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
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
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...
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
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
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
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
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
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
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
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
1 - 100 of 205 matches
Mail list logo
