Fred Zellinger wrote:
I also am a Linux Nut and use Postgres whenever possible because I like the
freedom of access to the HACKERS mailing list...something only a few highly
renound DBA snobs have with Oracle.
Indeed, I think this is a significant component of the appeal of open
source
I hav
On 17 Jan 2003 at 1:16, Tom Lane wrote:
> Currently, the default sysid assigned to a user or group is computed as
> "max(sysid)+1". We've seen a couple of complaints now from people who
> deleted their newest user, made another user, and found that permissions
> from the deleted user carried over
Currently, the default sysid assigned to a user or group is computed as
"max(sysid)+1". We've seen a couple of complaints now from people who
deleted their newest user, made another user, and found that permissions
from the deleted user carried over to the new one.
It seems to me that the easiest
Hi everyone,
Over the last few days we've had patches submitted for 7.2.3 that
address a couple of things, both the WAL Recovery Bug that Tom has
developed a patch for, and a couple of buffer overflows that have been
widely reported.
Although we haven't wanted to release a 7.2.4, and have inst
Hi guys,
Just received a query through the Advocacy site's request form...
Does anyone know if PostgreSQL 7.4's native windows version will/would
be compatible with Microsoft's SMS (System Management Server)?
Looks like some places will be considering it for Enterprise Deployment
if it is.
:-
Hi everyone,
Christian Kuroki <[EMAIL PROTECTED]> is a senior member of a team that
is translating the PostgreSQL manuals to Spanish.
There isn't a website for it yet (it will be created fairly soon) but
the team is making good progress, and the manuals will be kept updated
with the main Postg
I guess I'd prefer the DROP COLUMN syntax. It means we don't have to add
another non-standard command, and people can figure out how to drop the oid
column just by trying...
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Rod Taylor
> Sent: F
> Due to the fact that we are growing out of our current system
> (PostgreSQL on
> PCs) we are looking for ways to expand and one of the suggestions
> has been to
> toss PostgreSQL in favour of Oracle with Remote Access Cluster (RAC)
> software.
You mean Real Application Clusters?
Chris
-
Peter Eisentraut wrote:
Adrian 'Dagurashibanipal' von Bidder writes:
- postgres should auto-tune itself - the *cost could perhaps be
adjusted after some statistics have been collected, and there should be
some sensible way to determine an optimal setting for the famous
shared_b
Tom Lane writes:
> If we ever got around to supporting the inverse function (add oids),
> I do not think we'd want to spell it like "ADD COLUMN oid" --- that
> would interfere with making a plain user column named "oid", which was
> one of the reasons why people wanted to be able to drop OIDs in t
On Thu, 16 Jan 2003, Tom Lane wrote:
> > mlw said:
> >>> Does anyone think it would be a good idea, or is it even practical, to
> >>> have a 'indx' subdirectory along side of the 'base' directory?
> >>>
> >>> I was thinking that, if it were an easy modification, that it could be
> >>> an easy w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this message
> Well, it is open source, so there's no reason why someone couldn't make
> these changes for 7.4 and also release a binary version in the mean time.
> I have a copy of a 7.2 psql binary for linux
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Is there really a reason why OIDs can't be a pure user-space column?
We'd need some kluge to keep "SELECT *" from including OID. Also I'd be
a bit worried about the impact on the cost of HeapTupleGetOid --- it
might not matter, or it might.
Bruce Momjian writes:
> I think the one missing item mentioned was for group ownership of an
> object. However, if we give group _permission_ to the object, I am not
> sure why ownership is an issue. Are there certain permission we can't
> give to the group?
Privilege to rename or drop the obje
Adrian 'Dagurashibanipal' von Bidder writes:
> - postgres should auto-tune itself - the *cost could perhaps be
> adjusted after some statistics have been collected, and there should be
> some sensible way to determine an optimal setting for the famous
> shared_buffers (and the default should be s
Take a look on the developers page for a few internals presentations. I
have some on my home page as well, see URL in signature.
---
Chandralaksana Natalia wrote:
>
> Hi, we're students seeking to make a visualization of p
Hi, we're students seeking to make a visualization of postgresql locking system.
We're currently clueless as where to find postgresql source codes.
Any help? :)
Thanks,
Nat
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
> mlw said:
>>> Does anyone think it would be a good idea, or is it even practical, to
>>> have a 'indx' subdirectory along side of the 'base' directory?
>>>
>>> I was thinking that, if it were an easy modification, that it could be
>>> an easy way to separate data and indexes to different hard
Rod Taylor <[EMAIL PROTECTED]> writes:
> What is the preferred syntax:
> ALTER TABLE .. DROP COLUMN oid;
> or
> ALTER TABLE .. SET WITHOUT OIDS;
If we ever got around to supporting the inverse function (add oids),
I do not think we'd want to spell it like "ADD COLUMN oid" --- that
would interfere
On Thu, Jan 16, 2003 at 10:50:49AM -0600, Ross J. Reedstrom wrote:
> suggestion to upgrade to a not yet released version invariably includes
> the option of applying the patch yourself. Not something Oracle can offer.
Not for a sane price, I guess. I believe the high end support contracts
include
On Thu, 2003-01-16 at 13:41, Rod Taylor wrote:
> ALTER TABLE .. SET WITHOUT OIDS;
I'd prefer this, as it's more similar to the CREATE TABLE syntax.
Cheers,
Neil
--
Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC
---(end of broadcast)--
On Thu, 2003-01-16 at 11:42, D'Arcy J.M. Cain wrote:
> Is [Oracle RAC] really as simple as it sounds or would we just be
> giving up the other two for a new set of problems.
That's a question you should be asking to an authority on Oracle RAC
(which pgsql-hackers is not).
> My idea is to create a
On Thu, 2003-01-16 at 17:42, D'Arcy J.M. Cain wrote:
> We are also looking at hardware solutions, multi-CPU PCs with tons (24GB) of
> memory. I know that memory will improve access if it prevents swapping but
> how well does PostgreSQL utilize multiple CPUs?
At most one CPU is used for any sin
On Thu, Jan 16, 2003 at 11:17:42AM -0500, Jeff wrote:
> On Wed, 15 Jan 2003, mlw wrote:
>
> So with all that, you gotta appreciate both sides - hte fact pg "just
> works" and the tunability of bigger db's (Oh yeah - and we've actually had
> informix on the horn about the problem - their solution w
Due to the fact that we are growing out of our current system (PostgreSQL on
PCs) we are looking for ways to expand and one of the suggestions has been to
toss PostgreSQL in favour of Oracle with Remote Access Cluster (RAC)
software. The theory is that you can just plug machines into the cluste
On Wed, 15 Jan 2003, mlw wrote:
> I just wanted to post this note.
>
> I have been in Oracle hell for four days now, and in between the 5
> minutes of work and the hours of watings, dealing with table spaces,
I've been in Informix hell for the month or so.
At first, we were getting the message "N
I don't think a semicolon is a comment. It causes the execution of the
previous statement.
Christopher Kings-Lynne wrote:
Hi,
In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
this:
DROP DATABASE au_shipping
;CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE =
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> You're right. It's a type in pg_dumpall.c
A harmless typo --- the lines aren't "commented out" (I think your
assembly-language background is showing ;-)). But it is pretty ugly
output all the same. Have applied the patch.
Does anyone think it would be a good idea, or is it even practical, to
have a 'indx' subdirectory along side of the 'base' directory?
I was thinking that, if it were an easy modification, that it could be
an easy way to separate data and indexes to different hard disks.
---
I work in an all Oracle shop, with server instances around the world. At
least 20 servers are 400Gb+ and a couple are 4 Terabyte+. I tooks $15k worth
of Oracle training, have set up my own instances and done Perl/CGI/Apache
work along with setting up really big data warehousing apps for factorie
On Thu, 2003-01-16 at 08:29, Mark Kirkwood wrote:
> Adrian 'Dagurashibanipal' von Bidder wrote:
>
> > I'm just saying that there are
> >*some* small arcane details in postgres, too (although, at least, they
> >don't affect stability, just performance).
> >
> >
> Indeed you are right... Pg has it
You're right. It's a type in pg_dumpall.c
I have attached a fix for it.
Chris
> > ;CREATE DATABASE keystone WITH OWNER = chriskl TEMPLATE =
> template0 ENCODING
> > = 'SQL_ASCII';
> >
> > Why are all the CREATE DATABASE statements commented out?
> Surely that will
> > make the restore fail?
Hi,
On Thu, 2003-01-16 at 10:13, Christopher Kings-Lynne wrote:
> In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
> this:
>
> DROP DATABASE au_shipping
> ;CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0
> ENCODING = 'SQL_ASCII';
> DROP DATABASE a
Hi,
In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
this:
DROP DATABASE au_shipping
;CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0
ENCODING = 'SQL_ASCII';
DROP DATABASE au_test
;CREATE DATABASE au_test WITH OWNER = chriskl TEMPLATE = template0 EN
Hi,
In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
this:
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
35 matches
Mail list logo
