Hi all.
Implimenting a custom permission system is fairly easy to do with
triggers, views, and rules.
Here is my suggestion. Put your data tables in a shadow schema and
don't give users access to them. Then create views that select the
information from the tables that they have access to.
SuSE 10 is the "commercial" release from Novell. It contains additional
packages not in the opensuse.org open source version. There is an eval
cd and dvd set that can be downloaded of the "commercial" release -
though I do not believe it is licensed for anything beyond evaluation
purposes, but I co
Hello,
How can I know which rows are locked?
Thanks in advance!
Benkendorf
Promoção Yahoo! Acesso Grátis: a cada hora navegada você acumula cupons e concorre a mais de 500 prêmios! Participe!
On Tue, 11 Oct 2005, Hrishi Joshi wrote:
> I need to define a Unique index on 3 non-PK fields (composite key) on my
> table in PostgreSQL 8.0.3.
>
> The problem is, if any of those 3 fields is Null, PostgreSQL allows
> duplicate rows to be inserted. While searching through archives, I found
> mor
Jan Wieck <[EMAIL PROTECTED]> writes:
> And look at it, all Oracle would have to do is to be so open source
> friendly that they make InnoDB GPL only. Can you imagine the confusion
> in the MySQL fan club if Oracle releases the next GPL version of InnoDB
> and MySQL AB announces that they ripped
Hrishi Joshi <[EMAIL PROTECTED]> writes:
> I need to define a Unique index on 3 non-PK fields (composite key) on my
> table in PostgreSQL 8.0.3.
> The problem is, if any of those 3 fields is Null, PostgreSQL allows
> duplicate rows to be inserted.
That is the behavior defined by the SQL standard.
Hello, i'm using xampp 1.4.13 for windows.
I already installed PostgreSQL 8.0 and also
phpPgAdmin-3.5.5.
I've updated php.ini which locate in
/xampp/apache/bin/, and i've unmarked :
extension=php_pgsql.dll
But when i run phpPgAdmin, i got an error message :
"Your PHP installation does not support
Jim C. Nasby was quoted as saying:
> > Jim C. Nasby wrote:
> > > Of course one flip-side to all this is that if Oracle does attack us it
> > > actually lends credibility; it means they see PostgreSQL as a threat. At
> > > this point that could do more good for us than harm, depending on how
> > > e
I agree with Jan.
I think a good part of this whole situation has more to do with MySQL
having a core part of its product be dependent on an external entity.
Be they open source or not. I would think they have thought about
this possibility at various points in the past.
From where I sit,
On 10/11/2005 6:31 PM, Bruce Momjian wrote:
Jim C. Nasby wrote:
Of course one flip-side to all this is that if Oracle does attack us it
actually lends credibility; it means they see PostgreSQL as a threat. At
this point that could do more good for us than harm, depending on how
exactly the atta
[ Comment asking what we can do to protect ourselves.]
We can't do much, actually. The trademark thing can be secured, but
other than that, I see no other defenses we could use. We can't prevent
people from being hired, and we can't guard against patent attacks.
Seems you could argue that if
On Tue, Oct 11, 2005 at 02:22:23AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Out of curiosity... why don't we have unsigned ints?
>
> Quick, is 42 an int or an unsigned int?
>
> I think it'd create a slew of new ambiguous cases in the
> numeric-datatype hierarchy, fo
On Mon, Oct 10, 2005 at 11:52:40PM -0700, Dann Corbit wrote:
> How about something like:
>
> CREATE DOMAIN unsigned_small AS smallint check (VALUE >= 0)
>
> CREATE DOMAIN unsigned_int AS integer check (VALUE >= 0)
>
> CREATE DOMAIN unsigned_big AS bigint check (VALUE >= 0)
>
> The objection mig
On Tue, Oct 11, 2005 at 10:14:37AM -0700, Russ Brown wrote:
> Has there ever been any discussion about moving away from CVS? We couldn't
> possibly go back to it now.
Many times. See -hackers archives.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software ht
Note that pgcluster is statement-based, which has some drawbacks. AFAIK
MySQL's 'clustering' is as well.
Many people use Slony to replicate to many slaves and use pgpool to hit
them. But remember if you do that you need to make sure any statement
that changes data hits your master and not the slav
On Tue, Oct 11, 2005 at 02:39:24PM -0400, Tom Lane wrote:
> =?iso-8859-2?Q?Zlatko_Mati=E6?= <[EMAIL PROTECTED]> writes:
> > That's the reason why I ask. If a user that executes pg_autovacuum must be
> > owner of tables or a superuser, that it is a security problem to pass
> > password as plain te
On Tue, Oct 11, 2005 at 06:52:16PM -0400, Bruce Momjian wrote:
> We can't do much, actually. The trademark thing can be secured, but
> other than that, I see no other defenses we could use. We can't prevent
> people from being hired, and we can't guard against patent attacks.
Actually, I think t
Here is a followup to this email. A few people asked me questions off
list, and here are my replies:
[ Comment mentioning Open Office and Mozilla have not been attacked.]
Cconsider that one thing that has restrained Microsoft (and previously
IBM) was US Department of Justice oversight. Oracle
On Tue, Oct 11, 2005 at 06:31:06PM -0400, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > Of course one flip-side to all this is that if Oracle does attack us it
> > actually lends credibility; it means they see PostgreSQL as a threat. At
> > this point that could do more good for us than harm, depe
Hi,
I need to define a Unique index on 3 non-PK fields (composite key) on my
table in PostgreSQL 8.0.3.
The problem is, if any of those 3 fields is Null, PostgreSQL allows
duplicate rows to be inserted. While searching through archives, I found
more information about this.
But I need to know how
John Dean wrote:
> Hi
>
> That is terrific news being a former employee of MySQL - Oracle buys
> Innobase. I was never a fan of MySQL, personally but when Marten Mikos and
> the rest of the business wonks joined the Company I knew then it was time
> to get out. I met the author of Innobase once
Jim C. Nasby wrote:
> Of course one flip-side to all this is that if Oracle does attack us it
> actually lends credibility; it means they see PostgreSQL as a threat. At
> this point that could do more good for us than harm, depending on how
> exactly the attacked.
Well, that was MySQL's reaction t
Of course one flip-side to all this is that if Oracle does attack us it
actually lends credibility; it means they see PostgreSQL as a threat. At
this point that could do more good for us than harm, depending on how
exactly the attacked.
On Tue, Oct 11, 2005 at 06:04:40PM -0400, Bruce Momjian wrote
We have entered a new phase in the possible attacks on PostgreSQL.
The purchase of InnoDB clearly shows Oracle is ready to expend money to
slow down competitive database technology. Now that MySQL has been
attacked, we should expect to be the next target.
Let's assume Oracle is willing to spend
On Tue, 2005-10-11 at 07:55 +0200, Sim Zacks wrote:
> I tried it on a test RedHat server
> PostgreSQL 8.0.2beta1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
> 20020903 (Red Hat Linux 8.0 3.2-7)
> and the problem didn't occur. It is a slightly newer version, though,
> so it doesn't prove an
On Mon, Oct 10, 2005 at 06:41:42PM -0500, Jim C. Nasby wrote:
> On a side note, have you considered submitting a case study about the
> work you're doing? One place where MySQL AB and it's zealots likes to
> beat PostgreSQL over the head is with it's list of clients. It'd be nice
> to be able to s
On Oct 11, 2005, at 3:07 PM, Florian G. Pflug wrote:
On the whole, the update as quite easy ride, but I'd still
recommend you to test all aspects
of your software after the migration, since 8.0 isn't bug-for-bug
compatible with 7.4
I'll second this. One thing we found out too, was we al
> Hello.
> I downloaded 8.0.4 Windows installer and wanted to update my
> previos 8.0.3 installation, by using upgrade.bat.
> Unfortunately I was not able to do it. Just before the end of
> installation an error apears "Service 'PostgreSQL Database
> Server 8.0' (pgsql-8.0) could not be installe
Neil Conway <[EMAIL PROTECTED]> writes:
> I think debbugs is fairly close to what we'd need, for reasons stated
> earlier:
>
> http://archives.postgresql.org/pgsql-hackers/2005-05/msg01156.php
>
> (I think Bugzilla is *completely* the wrong tool for the Postgres
> development model.)
>
> I've h
On Tue, Oct 11, 2005 at 08:36:12AM -0700, Ludwig Isaac Lim wrote:
>I just upgraded my PostgreSQL from version 8.0.3 to
> version 8.0.4. I noticed that the \dD command in psql does
> not show the check constaint of a domain. I am surpised
> becaused the archives stated that a patch for displayi
Gary Horton wrote:
I'm needing to convince my boss that we should upgrade from 7.3.4 to 8.x
Postgresql. I've already enumerated the upsides, but now we need to
consider the risks...I wonder if anyone can mention/summarize any
issues, problems, gotchas, etc. that have happened in anyone's upgrad
On Tue, 2005-10-11 at 10:50, Gary Horton wrote:
> I'm needing to convince my boss that we should upgrade from 7.3.4 to
> 8.x Postgresql. I've already enumerated the upsides, but now we need
> to consider the risks...I wonder if anyone can mention/summarize any
> issues, problems, gotchas, etc. that
Dan Armbrust wrote:
Is there a better way to do this? Is there a flag I could specify for
psql that would cause it to output INSERT or COPY statements as a result
of a query - select * from foo where terminologyId=foo? Then I could
just have 15 select statements batched up in a file, and pi
Hi,
I did a bunch of updates from databases that where on 7.4 and there were
no issues at all.
You could always setup a test server on win32,linux or whatever and
simply restore one of your databases and see how it goes.
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresq
On Tue, 2005-11-10 at 14:43 +0200, Martijn van Oosterhout wrote:
> My personal favourite bug-tracker is debbugs, as used by the Debian
> Project. You can submit bugs by email, they get forwarded to
> maintainers (which can be a mailing list) via email. When they reply,
> the reply is also stored wi
My use case is not so much for database backup purposes as it is for
fine grained export and import.
Our database schema consists of 15 tables that represent a terminology.
Each database can hold multiple terminologies - every table has a
terminologyId column which distinguishes one termino
On Tue, Oct 11, 2005 at 07:24:12PM +0200, Rafael Montoya wrote:
> I'm migrating some triggers from oracle to postgresql and i can´t find the
> equivalent of the following two sentences:
> 1)
> DECLARE
> TMP_COD_PRO PRODUCT.COD_PRO%TYPE;
See "Declarations" in the PL/pgSQL documentation for th
On 10/11/05, Dan Armbrust wrote::
> Now I'm just filling the mailing list with mis-information. It actually> ignores all but the last -t flag - so this only allows me to specify one> table at a time, rather than several tables.
There's always the low-tech option of:
for table in `cat /tmp/tabl
=?iso-8859-2?Q?Zlatko_Mati=E6?= <[EMAIL PROTECTED]> writes:
> That's the reason why I ask. If a user that executes pg_autovacuum must be
> owner of tables or a superuser, that it is a security problem to pass
> password as plain text...
> How peple solve this problem ?
Put the password in a ~/.p
I know this is a bit off-topic, but this is part of the problem I'm
encountering. I can't find a definitive document on SuSe
licensing and what is 'eval' and what I have to pay for... can I still
download the full version for free? or is that just the eval?
It's kind of confusing. Does anyone ha
On 10/11/05 11:34 AM, "Emi Lu" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I know there is a script in perl can transform all sql commands in mysql
> into the queries supported by postgreSQL.
>
> Since we have not finished moving all data from mysql into postgresql,
> we need dump around 60 tables f
On Tuesday 11 October 2005 09:37, Gregory Youngblood wrote:
> And to move it back on topic -- now, it appears PostgreSQL is not
> on the DVD either. For the record, this is the Eval SuSE 10.0 DVD.
Probably just because it's the eval version. Check out
http://www.novell.com/products/suselinux/app
I'm migrating some triggers from oracle to postgresql and i can´t find the
equivalent of the following two sentences:
1)
DECLARE
TMP_COD_PRO PRODUCT.COD_PRO%TYPE;
I don't know if its equivalent exists in PostgreSQL
2)
EXCEPTION
when no_data_found then null;
what i tried :
exceptio
Don't forget that MySQL replication also has a habit of silently
failing on you and in my experience needs continuous monitoring to
make sure it actually keeps reasonably up to date (e.g. not days of
data behind on the slaves.)
That was a while ago though, maybe they fixed it?
British Telec
Dan Armbrust wrote:
>>
> Now I'm just filling the mailing list with mis-information. It actually
> ignores all but the last -t flag - so this only allows me to specify one
> table at a time, rather than several tables.
>
> I need to write up my use case so the maintainers can see why I want to
>
Dan Armbrust wrote:
Bricklen Anderson wrote:
pg_dump --help
...
-n, --schema=SCHEMA dump the named schema only
-s, --schema-onlydump only the schema, no data
-t, --table=TABLEdump the named table only
...
Just after I sent the e-mail, I realized that I forgot that
Bricklen Anderson wrote:
pg_dump --help
...
-n, --schema=SCHEMA dump the named schema only
-s, --schema-onlydump only the schema, no data
-t, --table=TABLEdump the named table only
...
Just after I sent the e-mail, I realized that I forgot that I saw that
option -
On Mon, 2005-10-10 at 11:04 -0700, Steve Crawford wrote:
> > > Gregory Youngblood <[EMAIL PROTECTED]> writes:
> > >> I've been using SuSE and PostgreSQL for a fairly long time.
> > >> Recently (last 12 months), I've noticed that the 9.x (9.2 and
> > >> 9.3 specifically) versions of SuSE do not incl
Dan Armbrust <[EMAIL PROTECTED]> writes:
> Does postgresql have any facility to dump anything more fine grained
> than a database to a text file?
You can dump a single table with the -t option. Right now you can't
specify an arbitrary set of tables to dump.
> For example, to mention a bad word,
That's the reason why I ask. If a user that executes pg_autovacuum must be
owner of tables or a superuser, that it is a security problem to pass
password as plain text...
How peple solve this problem ?
Thanks,
Zlatko
- Original Message -
From: "Matthew T. O'Connor"
To: "Zlatko Mati
On Mon, 2005-10-10 at 15:16, Travis Brady wrote:
> All,
>
> Forgive me if this has been answered before, but I've searched the
> archives and the net extensively and have come up mostly empty so far.
>
> I'm working at convincing my firm to implement a postgresql database
> cluster.
> Specifical
Dan Armbrust wrote:
> Does postgresql have any facility to dump anything more fine grained
> than a database to a text file?
>
> For example, to mention a bad word, MySQL's dump command allows you to
> specify individual tables to dump
> PostgreSQL's pg_dump command seems rather limited in its
On Tue, 2005-10-11 at 11:20, Dan Armbrust wrote:
> Does postgresql have any facility to dump anything more fine grained
> than a database to a text file?
>
> For example, to mention a bad word, MySQL's dump command allows you to
> specify individual tables to dump - and not only that - you can a
Does postgresql have any facility to dump anything more fine grained
than a database to a text file?
For example, to mention a bad word, MySQL's dump command allows you to
specify individual tables to dump - and not only that - you can also
specify a SQL query that must be satisfied for a row
Hello Travis,
I don't know if there are a Oracle RAC style cluster system for
PGSQL but this software that can do something similar,
http://pgcluster.projects.postgresql.org/feature.html may help.
You can always use Slony for replication services.
Cheers,
Aly.
On M
On Mon, 10 Oct 2005 23:23:45 -0700, Tino Wildenhain <[EMAIL PROTECTED]>
wrote:
But trac (http://www.edgewall.com/trac/ ) does support it. I'm running
it for quite a time and very much like it. Of course, trac is SVN only,
so this might be a show stopper unfortunately :(
Regards
Tino
-
On Oct 11, 2005, at 2:23 AM, Tino Wildenhain wrote:
But trac (http://www.edgewall.com/trac/ ) does support it. I'm running
it for quite a time and very much like it. Of course, trac is SVN
only,
so this might be a show stopper unfortunately :(
And there's Richard Hipp's CVSTRAC which seem
I'm needing to convince my
boss that we should upgrade from 7.3.4 to 8.x Postgresql. I've already
enumerated the upsides, but now we need to consider the risks...I
wonder if anyone can mention/summarize any issues, problems, gotchas,
etc. that have happened in anyone's upgrade from 7.x to 8.x .
All,Forgive me if this has been answered before, but I've searched the archives and the net extensively and have come up mostly empty so far.I'm working at convincing my firm to implement a postgresql database cluster.
Specifically, we'd like to get a few machines running to be more available and t
Hi:
I just upgraded my PostgreSQL from version 8.0.3 to
version 8.0.4. I noticed that the \dD command in psql does
not show the check constaint of a domain. I am surpised
becaused the archives stated that a patch for displaying
check constraint in \dD command has already been applied
(http://a
Hello,
I know there is a script in perl can transform all sql commands in mysql
into the queries supported by postgreSQL.
Since we have not finished moving all data from mysql into postgresql,
we need dump around 60 tables from postgresql 8.0 to mysql 3.0 on a
daily basis.
So, I am looking
Oskars Ozols wrote:
We were successfully running PostgreSQL 8.0 on Win2003 for several
months without downtime.
Then suddenly PostgreSQL crashed and there were following info in log file
[snip]
2005-10-09 03:51:24 PANIC: could not rename file "C:/Program
Files/PostgreSQL/8.0/data/pg_xlog/0
Oskars Ozols <[EMAIL PROTECTED]> writes:
> We were successfully running PostgreSQL 8.0 on Win2003 for several
> months without downtime.
> Then suddenly PostgreSQL crashed and there were following info in log file
> 2005-10-09 03:51:24 PANIC: could not rename file "C:/Program
> Files/PostgreSQL
On 10/3/2005 5:38 PM, Chris St Denis wrote:
Can anyone suggest good forums software to use with postgresql? I want to
integrate the forums users into my website's user base with a view.
phpBB2 ... works just fine including upgrade procedures.
Jan
I know of FudForums but it doesn't work w
Zlatko Matić wrote:
For pg_dump minimum privilages is to have select right on tables.
For vacuumdb, one must be owner of tables or a superuser.
What are minimum rights for user that is trying to execute pg_autovacuum ?
Not sure exactly, you need to have permission to vacuum every table in
th
On Tuesday 11 October 2005 00:49, Bruce Momjian wrote:
> [EMAIL PROTECTED] wrote:
> > What is Oracle after? Small DB technology? They already have rdb.
> > Firebird, back in the Groton Database Corporation days, was built to be
> > compatible with rdb. Marrying those technologies through modific
On Tuesday 11 October 2005 02:25, Tino Wildenhain wrote:
> Am Montag, den 10.10.2005, 22:12 -0300 schrieb Marc G. Fournier:
> > On Mon, 10 Oct 2005, Joshua D. Drake wrote:
>
> ...
>
> > Just as a suggestion/thought ... *if* you have the resources (or someone
> > else wants to step up to it), why no
We were successfully running PostgreSQL 8.0 on Win2003 for several
months without downtime.
Then suddenly PostgreSQL crashed and there were following info in log file
2005-10-09 03:51:10 WARNING: there is no transaction in progress
2005-10-09 03:51:10 WARNING: there is no transaction in pro
On Tue, Oct 11, 2005 at 10:27:04AM +0200, Magnus Hagander wrote:
> Or integrating them with the web. Not sure if any of the "popular
> bugtrackers" support that today, or if they all want to "be their own
> site" that we'd link to. That'd work, of course, but it'd be nicer to
> get something that a
Magnus Hagander schrieb:
I have thought about that, however I would at least at some
...
Or integrating them with the web. Not sure if any of the "popular
bugtrackers" support that today, or if they all want to "be their own
site" that we'd link to. That'd work, of course, but it'd be nicer
> > I have thought about that, however I would at least at some
> level want
> > a blessing. For example, if we did that would we do it with
> pgFoundry
> > bug tracking? Or would we use Trac? Or Bugzilla?
>
> I think the main thing that's killed previous proposals in
> this line is that we c
Magnus Hagander schrieb:
On Mon, 10 Oct 2005, Joshua D. Drake wrote:
...
Btw. how do you work with the WWW guys? I _never_ ever got any answer.
Post to the -www list... From what I can tell in the archives, you've
never posted there, so you probably posted to the wrong place. (Yeah, it
may n
For pg_dump minimum privilages is to have select
right on tables.
For vacuumdb, one must be owner of tables or a
superuser.
What are minimum rights for user that is
trying to execute pg_autovacuum ?
How can I monitor vacuuming by pg_autovacuum
?
Thanks,
Zlatko
On Sun, 9 Oct 2005 at 18:59, Devrim GUNDUZ wrote:
> On Sun, 9 Oct 2005, Tom Lane wrote:
>
> > Gregory Youngblood <[EMAIL PROTECTED]> writes:
> > > I've been using SuSE and PostgreSQL for a fairly long time.
> > > Recently (last 12 months), I've noticed that the 9.x (9.2 and
> > > 9.3 specifical
For implementing "Multi-relation/column keyword indices", which modules
of postgres might be required to change or need to be look into?
BTW anyone has clear idea about "Multi-relation/column keyword indices"?
Cheers,
---(end of broadcast)---
TIP
On 10/10/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Old-timers will recall that we already had one bad experience with an
> early open-source bug tracker, which has left people a bit shy of the
> concept too. I think a large part of that had to do with confusion
> between the purposes of bug *repor
> > On Mon, 10 Oct 2005, Joshua D. Drake wrote:
> ...
> > Just as a suggestion/thought ... *if* you have the resources (or
> > someone else wants to step up to it), why not setup the bug
> tracker,
> > work with the -www guys on having the 'bug submission'
> stuff feed into
> > it, and get a
>
How about something like:
CREATE DOMAIN unsigned_small AS smallint check (VALUE >= 0)
CREATE DOMAIN unsigned_int AS integer check (VALUE >= 0)
CREATE DOMAIN unsigned_big AS bigint check (VALUE >= 0)
The objection might be that we lose one bit of field width.
But the extra safety is probably wor
78 matches
Mail list logo
