On Tuesday 16 November 2010 10:30:05 Magnus Hagander wrote:
> On Tue, Nov 16, 2010 at 03:45, Elliot Chance wrote:
> > I have made some major changes "beta2"
>
>
>
> > Extra thoughts;
> >
> > It would not be practical for the forums to create a dummy mailing list
> > email address per person or
On Sunday 12 September 2010 13:32:00 Martijn van Oosterhout wrote:
> On Sun, Sep 12, 2010 at 12:18:10PM +0200, J. Roeleveld wrote:
> > How can you ensure the snapshot is in a consistent state if the server is
> > running?
> >
> > If a snapshot is taken between 2 upda
On Sunday 12 September 2010 00:43:19 Bruce Momjian wrote:
> Gabe Nell wrote:
> > > That section has been removed from the current 9.0 docs because we are
> > > unsure it works.
> >
> > Hmm. So the only way to make a consistent backup from a standby server
> > is to shut down the standby first? Or
On Friday 25 June 2010 02:23:17 Iwao Shikase wrote:
> Hi Roeleveld-san,
>
> Thank you for your advice. But My purpose is to test PostgreSQL
> which data cluster is in NFS server.
> As your says, Cluster Filesystem is one of answer of sharing files.
> But my company still want to use NFS server. S
r Filesystem?
http://en.wikipedia.org/wiki/Clustered_file_system
NFS is nice for sharing files between multiple systems, but most server
products specifically mention it is not compatible with file sharing protocols
like NFS/CIFS/....
--
J. Roeleveld
--
Sent via pgsql-general mailing list (pgsql-general@
On Wednesday 23 September 2009 11:29:02 Richard Huxton wrote:
> agostonbejo wrote:
> > Hi!
> >
> > What I'm trying to do is to insert some data from a sql file into a
> > postgres DB by calling the ant task. My problem is that I can't get
> > special characters (even if they can be represented by
> I had a similar thing once, while compiling a program, it took the
computer
> 28 hours to complete. (on a P200)
>
> My best guess is is that it's still running, make a quick check that the
> main
> process is still running. The action you are doing requires not just alot
of
> CPU-power, but also
> Hello i start yesterday afternoon a COPY command into a table.
> the file is 15 Mb
> i've set triggers before and after insert on the table
> the before trigger just perform data check.
> the after trigger update a 10 000 rows linked table.
>
> the COPY command runs all the night ad has not yet
Hi,
I've been checking the archives and documentation for what the
system requirements are for a PostgreSQL database
It's to be used for a database with 8 users, and has MS-Access front-end
which causes app. 2 connections per user.
My idea was:
128Meg Ram
20 Gig HD
500 Mhz. Celeron
will
> Hello
>
> I like to create a user who can do the followings on a table: select,
> insert, update
> But he can't delete!
> I tried this: grant INSERT, SELECT, UPDATE on table_name to testuser;
> After this the test user can delete from the table_name table without any
> problems. The testuser is
> Hello All,
>
> I have the following situation:
>
> CREATE TABLE "Contacts" (
> "Contact" Serial,
> "StuffTheir" Text,
> "TheDate" datetime DEFAULT TEXT 'now',
> "Subj" Text,
> "CustomerId" int4,
> "Agent" int4,
> "ActionType"
Hi,
I would like to know if, and how, I can find out who's logged into
the database at any given time.
And is it possible to maintain a connection-log of log-ins and log-outs?
with kind regards,
Joost Roeleveld
Hi,
I just found a reference to descriptions to functions/tables/...etc.
and am now wondering how to add them myself?
Joost Roeleveld
ps. as an example of what I'm referring to:
mydb=> \dd currval
description
--
sequence current value
(1 row)
mydb=> \dd mytable
Hi,
I just found a reference to descriptions to functions/tables/...etc.
and am now wondering how to add them myself?
Joost Roeleveld
ps. as an example of what I'm referring to:
mydb=> \dd currval
description
--
sequence current value
(1 row)
mydb=> \dd mytable
> What filesystem? I know (thank god) very little about Linux, but
> there have been comments here by some Linux folks (Thomas, wasn't it
> you?) that indicated that ext2fs sucks for this? Are you running with
> fsync() on or off?
What is the problem with ext2fs? Is it just performance? or is t
Hi,
I was wondering if anyone knows what's being
executed first,
a Rule on a view, or a trigger set to 'before
' on a view?
Eg. what's executed first? The RULE, or the
TRIGGER?
Joost Roeleveld
ps. I hope I'm making
sense.
> Hi everyone,
>
> I've been using MS Sql Server for the last 4 years on NT and I am quite
> fed-up with it.
> So I am now seriously considering a move towards LINUX and I investigate
> the serious DB offering and PostgreSql Seems to come as a really strong
> candidate.
>
> however I have some que
Hi,
I keep running into problems with:
ERROR: DefineQueryRewrite: rule plan string too big.
Does anyone have any insights into this? And how to fix this?
Hoping for help,
Joost Roeleveld
ps. I am willing to post _all_ Create-queries I use if anyone thinks he/she
can fix it in my case.
Hi,
I keep running into problems with:
ERROR: DefineQueryRewrite: rule plan string too big.
Does anyone have any insights into this? And how to fix this?
Hoping for help,
Joost Roeleveld
ps. I am willing to post _all_ Create-queries I use if anyone thinks he/she
can fix it in my case.
Hi,
I have found what appears to be a bug in PostgreSQL, or is this a feature?
I don't think it's a feature, because the postgreSQL documentation state it
should work.
When creating delete-rules for views, i have found that only the first
expression is being executed, when
using multiple express
20 matches
Mail list logo
