I'd like to propose that certain GRANTs on a table cascade to the
table's implicit sequences. In the current implementation (as of
7.4.5 and 8.0.0beta3), a table owner must typically issue GRANT
statements on both the table and its sequences to allow other users
to insert records into the table.
I found the reason of this question and fixed the bug :))xiaoling he <[EMAIL PROTECTED]> wrote:
I try to detect potential memory management bugs of my program with valgrind. (PostgreSQL is at version 8.0 beta2. Operating System is Red Hat Enterprise Linux 3. Valgrind is at version 2.2.0.)
Afte
Michael Fuhr wrote:
On Tue, Oct 12, 2004 at 06:10:12PM -0700, Michael Hannon wrote:
We expect that we WILL eventually rebuild the database, but right now
we're looking for a quick fix. Our current programmer tells me that he
can't find a way to simply change the primary key "in place" in Postgre
On Tue, Oct 12, 2004 at 06:10:12PM -0700, Michael Hannon wrote:
>
> We expect that we WILL eventually rebuild the database, but right now
> we're looking for a quick fix. Our current programmer tells me that he
> can't find a way to simply change the primary key "in place" in Postgres.
Does AL
Thank you, both Scott and Jason, for your responses. You both brought
up things I hadn't thought about. I've included snippets of their posts
below.
On Sun, 2004-10-03 at 22:23, Michael Glaesemann wrote:
Recently I've been thinking about different methods of managing users
that log into a Postgr
The link is dead. I've googled the cookbook but can't find any trace of it.
No luck. Thanks anyway.
-armen
-Original Message-
From: Thomas F.O'Connell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 12:15 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL]
DROP CONSTRAINT should be able to drop your pkey and as long as your
data supports your new key... you should be set
Gavin
Michael Hannon wrote:
Greetings. We're running Postgres 7.3 on an Intel linux box (Redhat
Enterprise server, version 3.0). We find ourselves in an awkward
position: we ha
Greetings. We're running Postgres 7.3 on an Intel linux box (Redhat
Enterprise server, version 3.0). We find ourselves in an awkward
position: we have a database of attributes relating to students that
uses as its primary key the ID number of the student. This is awkward
for the following re
I try to detect potential memory management bugs of my program with valgrind. (PostgreSQL is at version 8.0 beta2. Operating System is Red Hat Enterprise Linux 3. Valgrind is at version 2.2.0.)
After Program terminated, Valgrind reports a memory lost error information as follows:==13524== 208 b
Hi Tom,
Thanks for your help. I checked types and indexes, to no avail. Vacuum
didn't help. but vacuum full did, it's now fast again.
Cheers,
Brock
On Mon, 11 Oct 2004 23:38:49 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> Brock Henry <[EMAIL PROTECTED]> writes:
> > delete from people where id
Joseph Shraibman wrote:
That is what I wanted to know, how to get the evidence for next time.
select * from pg_locks
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-
That is what I wanted to know, how to get the evidence for next time.
Tom Lane wrote:
Joseph Shraibman <[EMAIL PROTECTED]> writes:
Why then when I did a kill -INT on the vacuuming backends did everything
unfreeze?
You could have had other stuff backed up behind the VACUUM FULL lock
requests.
It's
Joseph Shraibman <[EMAIL PROTECTED]> writes:
> Why then when I did a kill -INT on the vacuuming backends did everything
> unfreeze?
You could have had other stuff backed up behind the VACUUM FULL lock
requests.
It's not impossible that you had a deadlock *outside* the database,
that is some wait
Why then when I did a kill -INT on the vacuuming backends did everything
unfreeze?
Tom Lane wrote:
Joseph Shraibman <[EMAIL PROTECTED]> writes:
Last night one of these vacuum fulls deadlocked with a query on this
table. Both were stuck doing nothing until I did a kill -INT on the
backends doin
Hi,
I'm trying to come up with a relatively simple
multi-master replication solution. This is for
multiple databases that need to be discreet, and
change relatively infrequently (10-30 updates an
hour), and almost never update each others data (less
than once a day).
The TCL-based replication
On Saturday, our database machine locked up hard on us due to some
faulty hardware. Since then, we have been getting messages like this:
ERROR: could not access status of transaction 143934068
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0089": No
such file or directory
L
Joseph Shraibman <[EMAIL PROTECTED]> writes:
> Last night one of these vacuum fulls deadlocked with a query on this
> table. Both were stuck doing nothing until I did a kill -INT on the
> backends doing the vacuum.
> So my questions:
> 1) What can I do to avoid this?
> 2) What do I do next time
I have a table that is usually really small (currently 316 rows) but
goes through spasams of updates in a small time window. Therefore I
have a vacuum full run every hour on this table.
Last night one of these vacuum fulls deadlocked with a query on this
table. Both were stuck doing nothing u
* pw <[EMAIL PROTECTED]> [2004-10-12 14:11:51 -0700]:
> I was looking at ALTER DATABASE but the docs don't disclose any
> attributes so *what the heck does one ALTER?*
The actual settings are kind of nestled in the documentation a layer
or two deep. Here are the pertinent URLs and neither of them
Tom Lane wrote:
> Gaetano Mendola <[EMAIL PROTECTED]> writes:
>
>>I feel that renice a backend will not kill your system.
>
>
> It won't kill the system, but it probably won't accomplish what you
> hoped for, either.
>
That's true but right now renice a backend is the only way to procede
in order t
Thanks for your help,
I was looking at ALTER DATABASE but
the docs don't disclose any attributes
so *what the heck does one ALTER?*
I'll try the query that you offered.
Peter
Steven Klassen wrote:
There might be something you can do with 'alter database' as well.
---(end o
* pw <[EMAIL PROTECTED]> [2004-10-12 13:48:30 -0700]:
> How can I cahnge the owner of the database to the proper user?
UPDATE pg_database SET datdba = (SELECT usesysid FROM pg_user WHERE
usename = 'user_name') WHERE datname = 'database_name;
There might be something you can do with 'alter databa
I have downloaded it but it comes with no docs that I can find.
No docs directory nothing.
There are also people that have PHPNuke running with Postgres but that
is also lacking in docs.
I really do not fault Postgres or the developers for this. I will say
that I feel that is why MySQL is gets a
Hello,
I used a user to create a database but postgreSQL insists that the
'postgres' user is the owner. It's a bit annoying to have to change
users to link sequences to counter values.
How can I cahnge the owner of the database to the proper user?
Peter
---(end of broadca
Csaba Nagy <[EMAIL PROTECTED]> writes:
> So: don't use it as a unique identifier.
>
> On Tue, 2004-10-12 at 17:01, Jerry LeVan wrote:
> >
> > Is the "Message-ID" header field a globally unique identifer?
> >
[Isn't it awfully confusing to put your answers before the thing you're
responding to?
Hi,
Am Di, den 12.10.2004 schrieb DEHAINSALA Hondjack um 20:43:
> Hi !
> sorry for my english ! I am french :-)
>
> I want to test postgreSQL v8 native Windows! Where i can get a version
> which
> allows more than 64 characters (NAMEDATALEN ~=128) to the name of
> tables and
> columns ?
>
> I g
* CSN <[EMAIL PROTECTED]> [2004-10-12 11:40:52 -0700]:
> chown -R postgres.nobody data
> chmod -R 0700 data
Try postgres.postgres, otherwise that looks okay AFAICT.
--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services
Hi !sorry for my english ! I am french
:-)I want to test postgreSQL v8 native Windows! Where i can get a
version whichallows more than 64 characters (NAMEDATALEN ~=128) to the name
of tables andcolumns ?I generate automaticly tables and the length
of some of these tables is > to64.I use Pos
My permissions on pg's data dir got changed. Largely
just curious (since pg appears to be working fine
after changing as below), is this what they should be?
chown -R postgres.nobody data
chmod -R 0700 data
__
Do you Yahoo!?
Yahoo! Mail
Steven Klassen wrote:
* Dennis Gearon <[EMAIL PROTECTED]> [2004-10-12 08:13:07 -0700]:
turn off autocommit
Per connection.
start transaction
commit transaction
They're statements themselves that change the state of the
connection. You start a transaction, run your queries, and then
commit
On Wed, Oct 06, 2004 at 05:25:58PM +0100, Mark Gibson wrote:
> I had to remove Slony's schema manually as I was having problems
> with it. I was in the process of removing all Slony related stuff,
> and all my slave tables when this problem occurred, and was going to
> start again from scratch.
Di
Roberto Mello used to maintain a PL/PgSQL Cookbook, but this link is
dead, and I don't know if it's still around:
http://techdocs.postgresql.org/redir.php?link=http://
www.brasileiro.net/postgres/cookbook
-tfo
On Oct 11, 2004, at 4:05 AM, Armen Rizal wrote:
Hello all,
Is there anybody know w
On Tue, Oct 12, 2004 at 08:50:30AM -0700, Steve Atkins wrote:
> > Is the "Message-ID" header field a globally unique identifer?
>
> Not a postgresql related issue, but, yes Message-ID: is, by
> definition, a globally unique identifier. If there are two
> messages with the same Message-ID then the
* Dennis Gearon <[EMAIL PROTECTED]> [2004-10-12 08:13:07 -0700]:
>turn off autocommit
Per connection.
>start transaction
>commit transaction
They're statements themselves that change the state of the
connection. You start a transaction, run your queries, and then
commit/rollback.
>
> From: Greg Stark <[EMAIL PROTECTED]>
> Subject: Re: Need some advice on appropriate PL strategy...
> Message-ID: <[EMAIL PROTECTED]>
>
> "Eric D. Nielsen" <[EMAIL PROTECTED]> writes:
> > I guess I could alternatively just code up a simple mail function in
> another PL
> > and then call that func
On Tue, Oct 12, 2004 at 10:43:09AM -0400, Tom Lane wrote:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > I guess my confusion comes from the way postgres interprets unadorned time
> > stamps as being in local time. And then always displays timestamps converted
> > to local time. I thought it was reme
Tom Lane wrote:
Jeff Boes <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
No kidding. A rule is a macro and therefore has the usual risks of
multiple evaluations of arguments.
But shouldn't "new.job_id" use the value that was already recorded in
the original row?
There is no "v
On Tue, 2004-10-12 at 17:11, Csaba Nagy wrote:
> No, it's not a global unique identifier.
[snip]
Hey, you know what ? Good that I read this thread :D
I'm in the process of writing a Java SMTP server, and had no clue about
this rule... although I have read a few times the relevant RFC. It's
true t
Jerry LeVan writes
> I eventually want to have a cron job process my inbox and don't
> want successive cron tasks to keep re-entering the same email :)
That's the hard way to do it, it's easier to route messages to individual files.
BTW I'm doing just that in a GPL'ed project, see the UR
Hi,
I’ve a table containing
a CIDR field.
I’m using an EJB to
create a new record in this table.
I don’t know how to pass
the CIDR value. I tried by String but I get this error :
javax.ejb.FinderException: Find failed: java.sql.SQLException:
ERROR: operator does not ex
David Siebert <[EMAIL PROTECTED]> writes:
> I also know that somewhere
> their is a version of bugzilla that runs on Postgres but I have not had
> much luck finding it.
Red Hat runs their bugzilla on Postgres:
http://bugzilla.redhat.com/bugzilla/
Source code is available from a link near the e
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> I feel that renice a backend will not kill your system.
It won't kill the system, but it probably won't accomplish what you
hoped for, either.
regards, tom lane
---(end of broadcast)
Jeff Boes <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> No kidding. A rule is a macro and therefore has the usual risks of
>> multiple evaluations of arguments.
> But shouldn't "new.job_id" use the value that was already recorded in
> the original row?
There is no "value that was already rec
On Tue, Oct 12, 2004 at 11:01:08AM -0400, Jerry LeVan wrote:
> Hi,
> I am futzing around with Andrew Stuarts "Catchmail" program
> that stores emails into a postgresql database.
>
> I want to avoid inserting the same email more than once...
> (pieces of the email actually get emplaced into several
Tom Lane <[EMAIL PROTECTED]> writes:
> "Patrick Fiche" <[EMAIL PROTECTED]> writes:
>> I'm a bit confused with the use of Label for loops in PostgreSQL.
> Sure looks like a bug to me.
Ah-hah: it's a case-sensitivity problem. The <<>> construct downcases
its label identifier, but EXIT forgets to d
Well, this is for my personal mail...I think I will
probably give it a try.
The program can log errors so in the few cases that
might occur I think I can "manufacture" my own message
id.
I guess that the bottom line is that if it exists it
is unique...
Jerry
On Oct 12, 2004, at 11:25 AM, Doug McNau
On Tue, Oct 12, 2004 at 04:15:28PM -0700, Neumann P?ter wrote:
>
> I'm fairly new to Postgres and ran into a problem quite soon. Until
> now I used MS Sql2000 and with it I was able to write a simple
> stored procedure that returned a resultset (for example: 'select *
> from table1'). But
"at the time, everybody bought Microsoft's IAS; it was the dominant web
server around—85% share, something like that. And Apache just utterly
crushed them"
What I want to know is when did Microsoft have 85% of the web server
market? I sure don't remember that. Maybe he means 85% of the Windows
> I am futzing around with Andrew Stuarts "Catchmail" program
> that stores emails into a postgresql database.
>
> I want to avoid inserting the same email more than once...
> (pieces of the email actually get emplaced into several
> tables).
>
> Is the "Message-ID" header field a globally un
On Tue, 12 Oct 2004 11:01:08 -0400, Jerry LeVan <[EMAIL PROTECTED]> wrote:
> Hi,
> I am futzing around with Andrew Stuarts "Catchmail" program
> that stores emails into a postgresql database.
>
> I want to avoid inserting the same email more than once...
> (pieces of the email actually get emplace
Jerry LeVan <[EMAIL PROTECTED]> writes:
> Hi,
> I am futzing around with Andrew Stuarts "Catchmail" program
> that stores emails into a postgresql database.
>
> I want to avoid inserting the same email more than once...
> (pieces of the email actually get emplaced into several
> tables).
>
> Is
On Tue, 2004-10-12 at 17:01, Jerry LeVan wrote:
> Hi,
> I am futzing around with Andrew Stuarts "Catchmail" program
> that stores emails into a postgresql database.
>
> I want to avoid inserting the same email more than once...
> (pieces of the email actually get emplaced into several
> tables).
Tom Lane wrote:
Michael Fuhr <[EMAIL PROTECTED]> writes:
I don't know how effective this would be, but you could wrap the
system call setpriority() in a user-defined function if your
platform supports it. This would set the "nice" value of the
backend process, which might serve as a crude prioriti
No, it's not a global unique identifier. In fact you cannot even be sure
it will always be there in all mails, depending on your mail processing
chain. Most of the email clients will add one, and most of the mail
transfer agents will also add one if missing, but there's no general
rule of how to cr
please cc me
If I am using some server side langauge to access Postgres - php,
python, perl, asp, if I make a connection, do the following actions
affect the connection, or the individual query that contains them:
turn off autocommit
start transaction
commit transaction
SET schema
--
Tom Lane wrote:
Jeff Boes <[EMAIL PROTECTED]> writes:
It appears that the rule is inserting the row copies into
job_queue_trace with a job_id value that is one higher than the job_id
from the original row. Almost as though it was re-evaluating the
sequence ...
No kidding. A rule is a ma
Hi,
I am futzing around with Andrew Stuarts "Catchmail" program
that stores emails into a postgresql database.
I want to avoid inserting the same email more than once...
(pieces of the email actually get emplaced into several
tables).
Is the "Message-ID" header field a globally unique identifer?
Greg Stark <[EMAIL PROTECTED]> writes:
> I guess my confusion comes from the way postgres interprets unadorned time
> stamps as being in local time. And then always displays timestamps converted
> to local time. I thought it was remembering the time zone specified in the
> original input. In fact i
"Patrick Fiche" <[EMAIL PROTECTED]> writes:
> I'm a bit confused with the use of Label for loops in PostgreSQL.
> I'm using PostgreSQL 8.0 Beta2 version on WIN32 platform.
> CREATE OR REPLACE FUNCTION TEST( ) RETURNS int4 AS '
> BEGIN
> <>
> LOOP
> Raise Notice ''Loop 1'';
> EXIT LOOP1;
> END
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Tom Lane <[EMAIL PROTECTED]> writes:
> >> Stuart Bishop <[EMAIL PROTECTED]> writes:
> >>> I'm trying to determine the best way of saying 'The current time in UTC
> >>> with no time zone information'.
> >>
> >> Isn't
Jeff Boes <[EMAIL PROTECTED]> writes:
> It appears that the rule is inserting the row copies into
> job_queue_trace with a job_id value that is one higher than the job_id
> from the original row. Almost as though it was re-evaluating the
> sequence ...
No kidding. A rule is a macro and therefo
On Fri, 2004-10-08 at 10:11 -0400, Tom Lane wrote:
> Robin Ericsson <[EMAIL PROTECTED]> writes:
> > -> Index Scan using idx_d_entered on data (cost=0.00..18024.04
> > rows=50360 width=16) (actual time=0.210..0.247 rows=1 loops=1)
> >Index Cond: 'now'::text)::timestam
Sim Zacks <[EMAIL PROTECTED]> writes:
> This syntax works in MS SQL Server to update exactly as I
> expected, with the difference that you have to use the
> aliasname after the update keyword and postgresql does not
> allow that.
> If anyone can help, I would
Ok. I got it working by adding
"and assembliesBatch.AssembliesBatchID=a.AssembliesBatchID"
to the where clause. This seems a bit awkward sytactically. Is there a
cleaner way of doing it?
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
___
Greg Stark <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> Stuart Bishop <[EMAIL PROTECTED]> writes:
>>> I'm trying to determine the best way of saying 'The current time in UTC
>>> with no time zone information'.
>>
>> Isn't that a contradiction in terms?
> Not if you're use
Simon Windsor wrote:
> Hi
>
> Can you provide a link to the interview?
Ops! I forget it :-(
Here it is: http://www.alwayson-network.com/comments.php?id=6186_0_4_0_C
Regards
Gaetano Mendolaa
---(end of broadcast)---
TIP 8: explain analyze is your frie
Hi Every1,
I'm fairly new to Postgres and ran into a problem quite soon. Until
now I used MS Sql2000 and with it I was able to write a simple
stored procedure that returned a resultset (for example: 'select *
from table1'). But I don't know the way how to do it in Postgres,
cause I can't
Hi,
I'm a bit confused with the use of Label for loops in
PostgreSQL.
I'm using PostgreSQL 8.0 Beta2 version on WIN32 platform.
CREATE OR REPLACE
FUNCTION TEST( ) RETURNS int4 AS '
BEGIN
<>LOOP Rais
(I thought I posted this yesterday from Google Groups, but it doesn't
appear to have "taken".)
I'm having a problem with a rule designed to log new rows inserted into
one table. The base table is very volatile; rows are inserted from
various places, including both application code and triggers.
On Oct 12, 2004, at 9:43 PM, Karsten Hilbert wrote:
I'm trying to determine the best way of saying 'The current time in
UTC
with no time zone information'.
Isn't that a contradiction in terms?
Not if you're used to the Unix concept of storing "seconds since the
epoch".
In that model the quantity
> > > I'm trying to determine the best way of saying 'The current time in UTC
> > > with no time zone information'.
> >
> > Isn't that a contradiction in terms?
>
> Not if you're used to the Unix concept of storing "seconds since the epoch".
> In that model the quantity you're storing is entirely
The following query updated all the rows in the
AssembliesBatch table, not just where batchID=5.
There are 2 rows in the AssembliesBatch table with batch ID of
5 and I wanted to update both of them with their price, based
on the data in the from clause. One
Tom Lane <[EMAIL PROTECTED]> writes:
> Stuart Bishop <[EMAIL PROTECTED]> writes:
> > I'm trying to determine the best way of saying 'The current time in UTC
> > with no time zone information'.
>
> Isn't that a contradiction in terms?
Not if you're used to the Unix concept of storing "seconds sin
73 matches
Mail list logo