I had this code in a script:
UPDATE food_foods SET included=true WHERE verification_status = 'I';
UPDATE food_foods SET included=false WHERE verification_status IS NULL;
I tried replacing it with:
UPDATE food_foods SET included=(verification_status = 'I');
However, that set included to true
2. deal with circles in GRANT graph.
Can you give an examle for how this is any different for column-level
GRANTs?
When judging if there are any circles in the grant graph, we can represent
table priviledges as column priviledges, thus make things easier. I have not
think hard enought to
Robert Treat wrote:
On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
Mark Kirkwood said:
...
A nicer idea would be something like a utility could we ship that will
download, build and install module foo for you. Then we could publish many
many modules on pgfoundry, their authors could
On Mon, Jan 30, 2006 at 04:44:21PM +0800, Christopher Kings-Lynne wrote:
I had this code in a script:
UPDATE food_foods SET included=true WHERE verification_status = 'I';
UPDATE food_foods SET included=false WHERE verification_status IS NULL;
I tried replacing it with:
UPDATE food_foods
On Mon, Jan 30, 2006 at 10:25:39AM +0100, Thomas Hallgren wrote:
Actually I don't think it would be all that hard. You just need to have
each project produce an xml file with bits of package information (name,
dependencies, version info, etc...) which could then be combined with all
the
It's used for ecpg, IIRC, when compiled in thread-safe mode.
//Magnus
Thanks Magnus,
Here is another question for you.
Is it documented anywhere or does someone know what is the
bare minimum requirements to run the server on a production box?
No, I don't think so :-)
I want to
Magnus Hagander wrote:
I want to create the litest possible setup for use in my IM
server (Lightning Messenger), and eliminate any unneeded
files so I can have the smallest setup I can get.
I already have a complete working setup built with Inno
setup(it's 4.8 mb), now I just need to get
Josh Berkus wrote:
Andrew,
A nicer idea would be something like a utility could we ship that
will
download, build and install module foo for you. Then we could publish
many
many modules on pgfoundry, their authors could look after them, and
installing them would be trivial. pgxs should
Michael Fuhr wrote:
On Mon, Jan 30, 2006 at 12:20:25PM +0900, Michael Glaesemann wrote:
On Jan 30, 2006, at 12:23 , Andrew Dunstan wrote:
A nicer idea would be something like a utility could we ship that will
download, build and install module foo for you.
CPAN modules, Ruby
kevin brintnall [EMAIL PROTECTED]
...
(SQL99, 10.5 privileges, General Rules, 15-18)
15) SELECT with neither privilege column list nor privilege method
list specifies the SELECT privilege on all columns of T including any
Andrew Dunstan wrote:
Michael Fuhr wrote:
On Mon, Jan 30, 2006 at 12:20:25PM +0900, Michael Glaesemann wrote:
On Jan 30, 2006, at 12:23 , Andrew Dunstan wrote:
A nicer idea would be something like a utility could we ship that will
download, build and install module foo for you.
On 1/27/2006 10:53 AM, Alvaro Herrera wrote:
Tom Lane wrote:
I think this is the fault of the stats system design. AFAICT from a
quick look at the code, inserted/updated/deleted tuples are reported
to the collector in the same way regardless of whether the sending
transaction committed or
On 1/27/2006 10:56 AM, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Tom Lane wrote:
I think this is unquestionably
a bug, at least for autovacuum's purposes --- though it might be OK
for the original intent of the stats system, which was simply to track
activity levels.
Any
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
I tried replacing it with:
UPDATE food_foods SET included=(verification_status = 'I');
However, that set included to true only where verification_status=I, it
didn't set false at all.
You'd have gotten NULL, not FALSE, at the rows where
William ZHANG [EMAIL PROTECTED] writes:
Another problem is, should we allow any circles to be formed when executing
GRANTs?
This is already prohibited.
regards, tom lane
---(end of broadcast)---
TIP 3: Have you checked
Hi,
Does anyone know how the win32 server checks if the user is non
priveleged? Does it just check if the user is in the admin or power
user group?
Thanks,
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com
Hi,
Does anyone know how the win32 server checks if the user is
non priveleged? Does it just check if the user is in the
admin or power user group?
Yes and yes. See
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/port/win32/
security.c?rev=1.9
//Magnus
On Mon, 2006-01-30 at 08:25, Andrew Dunstan wrote:
Josh Berkus wrote:
Andrew,
A nicer idea would be something like a utility could we ship that
will
download, build and install module foo for you. Then we could publish
many
many modules on pgfoundry, their authors could look
On Mon, 2006-01-30 at 09:01, Christopher Kings-Lynne wrote:
Andrew Dunstan wrote:
Michael Fuhr wrote:
On Mon, Jan 30, 2006 at 12:20:25PM +0900, Michael Glaesemann wrote:
On Jan 30, 2006, at 12:23 , Andrew Dunstan wrote:
A nicer idea would be something like a
On 30 Jan 2006 11:35:13 -0500
Robert Treat [EMAIL PROTECTED] wrote:
CPAN modules, Ruby gems, PgFoundry ingots? :)
Tusks? (Extensions of the elephant.)
Trunks?
Dung?
gives a whole new meaning to the term package delivery
What about calling it
On Mon, Jan 30, 2006 at 10:01:58PM +0800, Christopher Kings-Lynne wrote:
Andrew Dunstan wrote:
Michael Fuhr wrote:
On Mon, Jan 30, 2006 at 12:20:25PM +0900, Michael Glaesemann wrote:
On Jan 30, 2006, at 12:23 , Andrew Dunstan wrote:
A nicer idea would be something like a
On Mon, Jan 30, 2006 at 10:25:39AM +0100, Thomas Hallgren wrote:
Robert Treat wrote:
On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
Mark Kirkwood said:
...
A nicer idea would be something like a utility could we ship that will
download, build and install module foo for you. Then we
On Sun, Jan 29, 2006 at 03:15:06PM -0500, Mark Woodward wrote:
Postgres generally seems to favor extensibility over integration, and I
generally agree with that approach.
I generally agree as well, but.
I think there is always a balance between out of the box vs
extensibility. I
On Sun, Jan 29, 2006 at 03:15:06PM -0500, Mark Woodward wrote:
Postgres generally seems to favor extensibility over integration, and
I
generally agree with that approach.
I generally agree as well, but.
I think there is always a balance between out of the box vs
extensibility. I
I wonder if there is a policy on when schema-qualified names should be used
in ereport/elog messages.
At the moment this doesn't seem to be consistent, even within the same
command:
template1=# VACUUM verbose t;
INFO: vacuuming public.t
[...]
template1=# VACUUM verbose tv;
WARNING: skipping
On Mon, 30 Jan 2006, Mark Woodward wrote:
It gets so frustrating sometimes, it isn't so black and white, there are
many levels of gray. The PostgreSQL project is trying so hard to be
neutral, that it is making itself irrelevant.
We are making ourselves irrelevant because we encourage the use
On Mon, 30 Jan 2006, Robert Treat wrote:
On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
Mark Kirkwood said:
Mark Woodward wrote:
There should e a big huge button and/or link
to pgfountry that shows how much is availale to PostgreSQL.
While there are links to 'em mentioned on the
Joachim Wieland wrote:
I wonder if there is a policy on when schema-qualified names should
be used in ereport/elog messages.
If it's not too hard to do, I would add the schema name in most places.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
Secondly, if there is a large group of users who want this, why
doesn't someone do it? Any one of them could take the source, and
produce a bundle (say a PostgresPHP Plus Pack) that has all the
features you think should be in there. If they can demonstrate they can
maintain it, perhaps the
Hi,
As you know, many databases that run on Linux / Unix systems have a GUI
installer which make installation easier and more attractive for some
people.
Our Windows Installer is very attractive, for example.
Now, I and Burcu Guzel, who is a Senior Programmer, decided to launch a
new project:
Devrim GUNDUZ [EMAIL PROTECTED] writes:
http://pgfoundry.org/projects/pgnixinstaller/
We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We are in planning
Hi,
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We are in planning phase,
if you join us
Devrim GUNDUZ wrote:
OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
RPM interface for the repositories. So our installer will help them a
lot. Also, our installer will have an option to download and install the
prebuilt binaries from PostgreSQL FTP site (and possible
Devrim GUNDUZ [EMAIL PROTECTED] writes:
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
What value does this bring to systems that have a good package system
and up-to-date repositories? I can install Postgres today on Ubuntu
using a GUI tool, and install another GUI tool to
Hi,
On Mon, 2006-01-30 at 20:27 -0500, Andrew Dunstan wrote:
OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
RPM interface for the repositories. So our installer will help them a
lot. Also, our installer will have an option to download and install the
prebuilt
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
Hi,
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We
Hi,
On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote:
Certainly you can install pre-built binaries without a compiler, and
let the user choose database location, autovacuum settings and stuff
like that.
That's another good point. We can adjust many settings before
installing.
Hi,
On Mon, 2006-01-30 at 21:34 -0400, Marc G. Fournier wrote:
OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
RPM interface for the repositories. So our installer will help them a
lot. Also, our installer will have an option to download and install the
prebuilt
Hi,
On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote:
You can install, but what if you need different configure options than
the package provides? This means a rebuild of the package. Instead, we
will build and install that package via the installer.
That's actually a pretty cool
On Monday 30 January 2006 16:21, Marc G. Fournier wrote:
On Mon, 30 Jan 2006, Robert Treat wrote:
On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
Mark Kirkwood said:
Mark Woodward wrote:
There should e a big huge button and/or link
to pgfountry that shows how much is availale to
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
BTW, gcc is not installed on by default AFAIR.
Wow, how do you update the kernel each week? :)
More seriously, I know under FreeBSD, one of the first things that gets
done after installing is to customize the kernel to get rid of all the
'cruft'
On Mon, 30 Jan 2006, Robert Treat wrote:
On Monday 30 January 2006 16:21, Marc G. Fournier wrote:
On Mon, 30 Jan 2006, Robert Treat wrote:
On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
Mark Kirkwood said:
Mark Woodward wrote:
There should e a big huge button and/or link
to
Hi,
On Mon, 2006-01-30 at 22:04 -0400, Marc G. Fournier wrote:
BTW, gcc is not installed on by default AFAIR.
Wow, how do you update the kernel each week? :)
More seriously, I know under FreeBSD, one of the first things that gets
done after installing is to customize the kernel to get
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on your system, do you? with every conceivable
Marc G. Fournier wrote:
More seriously, I know under FreeBSD, one of the first things that
gets done after installing is to customize the kernel to get rid of
all the 'cruft' part of the generic kernel, I take it that this isn't
something that ppl do with Linux?
The Linux kernel has
I had to deal with an installer written in python and several in Java... IMHO, Java would be a better language for this and you could build off some nice OSS installers that already exist (such as IzPack). Just my 2 cents :)
On 1/30/06, Devrim GUNDUZ [EMAIL PROTECTED] wrote:
Hi,On Mon, 2006-01-30
Marc G. Fournier [EMAIL PROTECTED] writes:
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on
We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We are in planning phase,
if you join us earlier, we will be able to share more ideas.
You'd better
On Jan 30, 2006, at 8:32 PM, Devrim GUNDUZ wrote:
However none of them are PostgreSQL Installers, none of them has the
ability to customize the packages and none of them has the ability to
install the community packages, etc. :)
You need to take a sniff over at the FreeBSD ports. Lets you
Marc G. Fournier wrote:
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on your system, do
On my Debian systems, I can install PostgreSQL quite readily via the
command apt-get install postgresql-8.1, which can get GUIed at least
somewhat if I run aptitude, synaptic, or such...
Yes Christopher, you can... I can, and Devrim can
As more and more people come on board people are
On Mon, 30 Jan 2006, Joshua D. Drake wrote:
On my Debian systems, I can install PostgreSQL quite readily via the
command apt-get install postgresql-8.1, which can get GUIed at least
somewhat if I run aptitude, synaptic, or such...
Yes Christopher, you can... I can, and Devrim can
As
I don't see why anyone has a problem with this. I am certainly never
going to use it but if it helps someone who isn't a linux person to
use it on a project when they would have used something else (like
mysql) or if it convinces someone to run postgres on linux instead of
windows because
On Mon, 2006-01-30 at 19:52 -0800, Joshua D. Drake wrote:
On my Debian systems, I can install PostgreSQL quite readily via the
command apt-get install postgresql-8.1, which can get GUIed at least
somewhat if I run aptitude, synaptic, or such...
Yes Christopher, you can... I can, and
Devrim GUNDUZ wrote:
Have you looked at AutoPackage?
http://autopackage.org
screen shots.
http://autopackage.org/gallery.html
Has a GUI wizard if X windows is available and a command line wizard if
no X is available.
Using autopackage is similar to using MSI,Wise,Inno etc on Windows.
Oracle's graphical installer is a material impediment to Oracle
adoption. The installer only works on systems where particular versions
of Java and Motif libraries are available. On 64-bit Opteron systems it
only works with the peculiar 32-bit thunking tree favored by Red Hat and
hardly
On Mon, 2006-01-30 at 20:53 -0800, Joshua D. Drake wrote:
Oracle's graphical installer is a material impediment to Oracle
adoption. The installer only works on systems where particular versions
of Java and Motif libraries are available. On 64-bit Opteron systems it
only works with the
Jeff,
So why don't you just do that with Postgres? You could call it
Bootable PostgreSQL. It would be a big hit. When a new version comes
out, you can just mail out a new DVD.
Actually, we have these. We give them out at conferences.
--Josh
---(end of
On Jan 30, 2006, at 8:48 PM, Tony Caduto wrote:
Devrim GUNDUZ wrote:
Have you looked at AutoPackage?
http://autopackage.org
screen shots.
http://autopackage.org/gallery.html
Has a GUI wizard if X windows is available and a command line
wizard if no X is available.
Using autopackage
Devrim GUNDUZ schrieb:
Hi,
As you know, many databases that run on Linux / Unix systems have a GUI
installer which make installation easier and more attractive for some
people.
If you think of the *racle-GUI-Installer, most people find it very
s*cking ;)
Our Windows Installer is very
Devrim GUNDUZ schrieb:
Hi,
...
Are you going to work with the underlying system's package manager, or
put everything in /usr/local?
We'll work with the package manager -- I'm an RPM guy ;)
RPM isnt the only packaging system out there ;)
---(end of
Jonah H. Harris schrieb:
I had to deal with an installer written in python and several in Java...
IMHO, Java would be a better language for this and you could build off
some nice OSS installers that already exist (such as IzPack). Just my 2
cents :)
Yes! Use Java for ultimate suckiness of
Joshua D. Drake schrieb:
...
As more and more people come on board people are going to want to
download a .exe (a metaphor),
double click and have it open an installer, they will then want to click
next, next, continue, finish.
You don't get that with apt-get install.
Well you can use a
On Tue, 31 Jan 2006, Tino Wildenhain wrote:
Devrim GUNDUZ schrieb:
Hi,
...
Are you going to work with the underlying system's package manager, or
put everything in /usr/local?
We'll work with the package manager -- I'm an RPM guy ;)
RPM isnt the only packaging system out there ;)
I
Rick Gigger schrieb:
I don't see why anyone has a problem with this. I am certainly never
going to use it but if it helps someone who isn't a linux person to use
it on a project when they would have used something else (like mysql)
or if it convinces someone to run postgres on linux
On Jan 30, 2006, at 7:52 PM, Joshua D. Drake wrote:
There is a reason that even Oracle has a graphical installer on
Linux, because most people installing
the software:
A. Don't know how to use it
B. Probably don't know how to use Linux
C. Don't want to.
Except that the Oracle graphical
66 matches
Mail list logo
