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.
hi,
could anyone tell me how to open stat log in postgres? and how to monitor its
concurrent connection number as well as the current sql(s) execution. thanks!
---
http://www.126.com260M;!
, !
---(end of
On Wed, 2004-10-13 at 17:26, postgres2008 wrote:
and how to monitor its concurrent connection number as well as the
current sql(s) execution. thanks!
http://www.postgresql.org/docs/7.4/static/monitoring-stats.html
-Neil
---(end of
Ted Shab wrote:
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
Hi,
how come, if you create a user with no permissions at all, having been granted
nothing, he can still log into any database, list available tables, create new here,
and then delete them again. Seems odd...:
medusa:~% createuser odd
Shall the new user be allowed to create databases? (y/n) n
hello everybody,
i ve got two big tables with the same
structure.
i would like to add the second one to the first one
directly without generating a sql file. (each table is about 1 Million
line)
Is it a way with an sql command?
INSERT INTO TAB1... (select * from TAB2)
???
thanks
fx
Hi,
On Wed, 2004-10-13 at 10:55, fx gamoy wrote:
hello everybody,
i ve got two big tables with the same structure.
i would like to add the second one to the first one directly without
generating a sql file. (each table is about 1 Million line)
Is it a way with an sql command?
INSERT
Hi again,
On Wed, 2004-10-13 at 10:55, fx gamoy wrote:
hello everybody,
i ve got two big tables with the same structure.
i would like to add the second one to the first one directly without
generating a sql file. (each table is about 1 Million line)
Is it a way with an sql command?
Henriksen, Jonas F wrote:
Hi,
how come, if you create a user with no permissions at all, having
been granted nothing, he can still log into any database, list
available tables, create new here, and then delete them again. Seems
odd...:
Is this right, or is there something wrong with my settings
Hi,
When I execute a
function, I would like psql to show me only RAISE NOTICE messages but not all
function calls
Indeed, I currently
get some messages that I don't care about :
PL/pgSQL function
"adm_user" line 321..
CONTEXT: SQL query
"SELECT."
Is there a way to
Hi:
I've migrated a couple of weeks ago from 7.4.2 to 7.4.5 and I am getting
this error after executing a query:
Warning: pg_exec() query failed: ERROR: could not access status of
transaction 4244329 in /home/wisconsin/www/_proc/bbdd/_c_bbdd.php on
line 160
ERROR ACCESO BASE DE DATOSERROR:
Hi
I have just to install postgreSQL-7.5. in windows 2003.
and the system send me this error :
Bad system call postmaster
Someone can help me ?
thanks U
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi
I want to test PostgreSQL v8 native windows taht allows to create a table or
column with 128 characters !!
Where can i get it ?
Thanks U for help !!
Hondjack
- Original Message -
From: DEHAINSALA Hondjack [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 1:45
Dear All,
Within a transaction, now() and current_timestamp are constant and give
the time that the transaction started. This is normally what you want.
But I have a case where I actually need the time that the transaction
is committed, or something similar. Is there a way to get it? Here
Hi,
I think that timeofday() should solve your issue.
Just take care that this function returns text instead of timestamp... You
will have to cast it.
Patrick
--
-
Patrick Fiche
email : [EMAIL PROTECTED]
Hello everyone,
I would like to know if anyone has found or developed any monitoring
software for Postgres. I would like to be able to gather statistics
about the database.
How often certain tables get hit, whats the current status of things
etc. I couldn't find much in the lists about this.
Phil Endecott wrote:
Dear All,
Within a transaction, now() and current_timestamp are constant and give
the time that the transaction started. This is normally what you want.
But I have a case where I actually need the time that the transaction
is committed, or something similar. Is there a
Bob Powell wrote:
Hello everyone,
I would like to know if anyone has found or developed any monitoring
software for Postgres. I would like to be able to gather statistics
about the database.
How often certain tables get hit, whats the current status of things
etc. I couldn't find much in the
I have just started exploring this product:
http://www.hyperic.net/products/manager/product-specs/postgresql-management.htm
Hope it helps.
On Wed, 2004-10-13 at 07:25, Bob Powell wrote:
Hello everyone,
I would like to know if anyone has found or developed any monitoring
software for
Ann wrote:
I found the reason of this question and fixed the bug :))
Why then don't you share it ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Wed, Oct 13, 2004 at 12:37:35AM -0600, Michael Fuhr wrote:
Comments? Can anybody think of why cascading GRANT and REVOKE to
implicit sequences might be A Bad Idea?
In current devel sources, ALTER OWNER cascades to implicit sequences.
It may be a precedent for making GRANT and REVOKE do so
Hi:
Is there any way to recover data from a corrupted table? I can only run
SELECTs on certain WHERE conditions.
I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex,
always get error:
ERROR: could not access status of transaction 4244329
DETAIL: could not open file
I have a large amount of data that I copy in and out of Sybase very
often. Now I also want to copy this data in and out of postgres. I
have an existing script that creates the entire database(s) from scratch
in Sybase and then uses the Sybase bulk copy tool bcp to copy the data
in.
I
[EMAIL PROTECTED] wrote:
Hi:
I've migrated a couple of weeks ago from 7.4.2 to 7.4.5 and I am getting
this error after executing a query:
Warning: pg_exec() query failed: ERROR: could not access status of
transaction 4244329 in /home/wisconsin/www/_proc/bbdd/_c_bbdd.php on
line 160
ERROR
I have a database in sql_ascii that I need to convert to Unicode. I tried using
pg_dump -Fc .. but it fails on certain characters. like this one รจ
How can I get the data transferred?
---(end of broadcast)---
TIP 8: explain analyze is your
Hi,
Im looking for instructions on installing the postgresql ODBC driver on
mac osx and windows. Is there any reference for that. Any help is
apprecitaed. BTW, i need to compile it and install it wihtout using the
windows installer.
Alex
---(end of
Patrick Fiche wrote:
Hi,
When I execute a function, I would like psql to show me only RAISE
NOTICE messages but not all function calls
Indeed, I currently get some messages that I don't care about :
* PL/pgSQL function adm_user line 321..
* CONTEXT: SQL query SELECT.
Is
[EMAIL PROTECTED] wrote:
Hi:
Is there any way to recover data from a corrupted table? I can only run
SELECTs on certain WHERE conditions.
I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex,
always get error:
ERROR: could not access status of transaction 4244329
DETAIL:
Gaetano Mendola wrote:
[EMAIL PROTECTED] wrote:
Hi:
Is there any way to recover data from a corrupted table? I can only
run SELECTs on certain WHERE conditions.
I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex,
always get error:
ERROR: could not access status of
Create a file with that name filled with zeros with the same length as
the other files in that directory. That should get you far enough to
dump the data. Then run a complete set of memory and disk checks on
your system...
On Wed, Oct 13, 2004 at 02:56:37PM +0100, [EMAIL PROTECTED] wrote:
Hi:
Richard,
Thanks for the response.
I'll look into both the dblink and iirc.
Do you know of any extended examples of either?
--Ted
--- Richard Huxton [EMAIL PROTECTED] wrote:
Ted Shab wrote:
Hi,
I'm trying to come up with a relatively simple
multi-master replication solution. This
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
ERROR: could not access status of transaction 4244329
DETAIL: could not open file /usr/local/pgsql/data/pg_clog/0004: No
existe el fichero o el directorio
What files actually appear in /usr/local/pgsql/data/pg_clog/ ?
The standard advice
I found on
http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql-porting.html
that it is not poosible to use start or end a transaction in plpgsl.
I tried to create a plplsql-function on PostgreSQL 8.0 beta 3
I can comile
CREATE OR REPLACE FUNCTION insert_many_commit(
On Wed, Oct 13, 2004 at 08:32:04AM -0700, Ted Shab wrote:
Thanks for the response.
I'll look into both the dblink and iirc.
That's actually only dblink. IIRC is an acronym, meaning if I recall
correctly, IIRC.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
The West won the world not by
Ted Shab wrote:
Richard,
Thanks for the response.
I'll look into both the dblink and iirc.
Do you know of any extended examples of either?
dblink is in the contrib/ folder of the source distribution and possibly
your packaged version if you use such a thing. Never needed it myself,
but the
Thanks. I was thinking iirc was the transport
protocol :-)
Looks like dblink is the best bet here.
--Ted
--- Richard Huxton [EMAIL PROTECTED] wrote:
Ted Shab wrote:
Richard,
Thanks for the response.
I'll look into both the dblink and iirc.
Do you know of any extended
Am Mi, den 13.10.2004 schrieb Michael Kleiser um 17:44:
I found on
http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql-porting.html
that it is not poosible to use start or end a transaction in plpgsl.
I tried to create a plplsql-function on PostgreSQL 8.0 beta 3
I
On Wed, Oct 13, 2004 at 00:37:35 -0600,
Michael Fuhr [EMAIL PROTECTED] wrote:
Comments? Can anybody think of why cascading GRANT and REVOKE to
implicit sequences might be A Bad Idea?
Since you can do odd things using explicit sequences, limiting implicit
sequences to make things convenient
Don Kelloway [EMAIL PROTECTED] writes:
I'm a first-time user with PostgreSQL so please forgive my ignorance.
I've purchased (and read) Practical PostgreSQL (O'Reilly) and
PostgreSQL Essential Reference (New Riders). So far, so good. I
think learning PostgreSQL will not be as difficult as I
On Wed, 2004-10-13 at 18:01 +0200, Robin Ericsson wrote:
Using exact timestamp makes the query go back as it should in speed (see
explain below). However I still have the problem using a stored
procedure or even using the ago-example from above.
Well, changing ago() to use timestamp without
Sorry, this should have been going to performance.
Regards,
Robin
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Leave assembliesBatch out of the FROM and just put the condition in the
WHERE. Something like
UPDATE assembliesBatch
FROM assemblies
JOIN .
WHERE assembliesBatch.AssemblyID = assemblies.assemblyID
AND assembliesBatch.batchID = 5
Ian Harding
Programmer/Analyst II
Tacoma-Pierce County
Bruno Wolff III [EMAIL PROTECTED] writes:
I also think there is some merit in splitting the access rights for nextval
and setval, so that insert access grants access to nextval and update access
grants access to setval (or perhaps both nextval and setval). That way people
who can just insert
Greg Stark [EMAIL PROTECTED] writes:
I can't think of a good approach for migration of old pg_dumps though, so
perhaps this is more trouble than it's worth.
That would probably be the major objection to any redefinition of the
meanings of the individual sequence permissions. We could possibly
In reference to the pg_clog errors I'm having, I am still looking for
tips or help. Here's the info again:
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
Now, despite creating an 8k file
David Rysdam [EMAIL PROTECTED] writes:
In my brute force port, I just bulk copied the date
fields into temporary tables and then did a to_timestamp(field, 'Mon DD
HH:MI:SS:MSAM').
Again, I created a temporary table and did a decode(field, 'hex') to the
real table.
This is the
On Wed, 2004-10-13 at 11:17 -0400, Alexander Cohen wrote:
Hi,
Im looking for instructions on installing the postgresql ODBC driver on
mac osx and windows. Is there any reference for that. Any help is
apprecitaed. BTW, i need to compile it and install it wihtout using the
windows
On Wed, Oct 13, 2004 at 10:06:58AM -0400, David Rysdam wrote:
Sybase bulk copies the date fields out in this format:
Mar 4 1973 10:28:00:000AM
Postgresql's COPY (or psql \copy) doesn't like that format.
You could filter the data through a script that reformats certain
fields, then feed
Michael Fuhr wrote:
On Wed, Oct 13, 2004 at 10:06:58AM -0400, David Rysdam wrote:
Sybase bulk copies the date fields out in this format:
Mar 4 1973 10:28:00:000AM
Postgresql's COPY (or psql \copy) doesn't like that format.
You could filter the data through a script that reformats certain
Greg Stark wrote:
David Rysdam [EMAIL PROTECTED] writes:
In my brute force port, I just bulk copied the date
fields into temporary tables and then did a to_timestamp(field, 'Mon DD
HH:MI:SS:MSAM').
Again, I created a temporary table and did a decode(field, 'hex') to the
real
Hello
I am going to do a comparison betweem PgSQL and MySQL replication system.
I hear there are some replication projects available for PgSQL. Which are
still active and serious, because I hear that some are not active or
incomplete?
Will any of these projects be merged with PgSQL soon?
I
On Wed, 2004-10-13 at 20:02 +0200, [EMAIL PROTECTED] wrote:
Hello
I am going to do a comparison betweem PgSQL and MySQL replication system.
I hear there are some replication projects available for PgSQL. Which are
still active and serious, because I hear that some are not active or
On Wed, 2004-10-13 at 10:59 -0700, Robby Russell wrote:
On Wed, 2004-10-13 at 20:02 +0200, [EMAIL PROTECTED] wrote:
Hello
I am going to do a comparison betweem PgSQL and MySQL replication system.
I hear there are some replication projects available for PgSQL. Which are
still active
Hello,
There are two heavily supported and active replication projects.
1. Slony - http://www.slony.info
2. Mammoth Replicator - http://www.commandprompt.com/
Slony is Open Source and uses triggers and a replication schema to
replicate data.
Mammoth Replicator is commercial and uses a
On Wed, Oct 13, 2004 at 01:32:01PM -0400, David Rysdam wrote:
Michael Fuhr wrote:
You could filter the data through a script that reformats certain
fields, then feed the reformatted data to PostgreSQL. This is
usually a trivial task for Perl, awk, sed, or the like.
Right, I *can* do this.
Here is a good overview.
http://jeremy.zawodny.com/blog/archives/000846.html
Note that http://pgreplicator.sourceforge.net/ is a
multi-master solution using TCL. Despite the dire
home page, it is actively supported. However, our
experience with it was that it was not industrial
strenght. We
Right, I *can* do this. But then I have to build knowledge into that
script so it can find each of these date fields (there's like 20 of them
across 10 different files) and then update that knowledge each time it
changes.
In your case that's a reasonable argument against filtering the
data with
Michael Fuhr wrote:
On Wed, Oct 13, 2004 at 01:32:01PM -0400, David Rysdam wrote:
Michael Fuhr wrote:
You could filter the data through a script that reformats certain
fields, then feed the reformatted data to PostgreSQL. This is
usually a trivial task for Perl, awk, sed, or the like.
Hi
I'm trying to create a select statement that will return all rows that
are older than 30 milleseconds. Is either of these correct?
select event_id from event where (current_timestamp-timestamp).030
or
select event_id from event where
(current_timestamp-timestamp)00030.00
thanks,
Phil
Hi Gaetano:
This procedure to recover data from a corrupted table should be
documented somewhere... If it is, I could not find it!
Now I wonder if I have lost any data, because after creating the
pg_clog/0004 and running VACCUM everything seems ok.
Thanks a lot for your help.
Ruben.
Gaetano
I'm in the process of adding more historic information to one of my
databases. I've liked the theoretical treatment of the concept in
Temporal Data and the Relational Model, by Date, Darwen, Lorentzos.
A lot of it is not realizable without a lot of user defined
types/functions/etc. I was
Steve Wolfe [EMAIL PROTECTED] writes:
So, I did dd if=/dev/zero of=/usr/local/pgsql/data/pg_clog/0089
bs=8k count=1. I did an ls to verify that the file existed. I started
the postmaster back up, tried a VACUUM, and got:
vacuumdb: vacuuming of database hyperseek failed: ERROR: could
On Wed, 13 Oct 2004, Joshua D. Drake wrote:
Hello,
There are two heavily supported and active replication projects.
1. Slony - http://www.slony.info
2. Mammoth Replicator - http://www.commandprompt.com/
Three, actually ...
3. eRServer - http://www.pgsql.com
We're currently working on the next
Thanks to Patrick and Richard for pointing out timeofday(); I was
imagining that I'd have to do some server-side-code magic to get that.
But I'm still hoping that someone will have a better solution - using
this I still need a near-global lock between setting the timestamps and
committing the
Hi all,
We, Software Research Associates, Inc., have started PostgreSQL CE
(PostgreSQL Certificated Engineer), on Oct 1st. PostgreSQL CE is an
entry level PostgreSQL engineer certification program. We expect at
least several hundreds of people will take the examin by April
2005. We also hope that
What is the PostgreSQL project's official stance/view/comment on this?
aaron.glenn
On Thu, 14 Oct 2004 10:48:26 +0900 (JST), Tatsuo Ishii
[EMAIL PROTECTED] wrote:
Hi all,
We, Software Research Associates, Inc., have started PostgreSQL CE
(PostgreSQL Certificated Engineer), on Oct 1st.
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Joshua D.
Drake) transmitted:
Slony replicates data every (10?) transactions.
No, Slony-I replicates each and every transaction that it processes,
identifying it as a transaction independent of others.
In practice, it is
Scott Cain [EMAIL PROTECTED] writes:
I am trying to create audit tables for all of the tables in my
database. The function, table and trigger create statements are below.
Apparently, I am not doing it quite right, because I get these messages
when I try to run the create statements below:
First, apologies in advance for this somewhat OT post ...
I'm looking for a source of information on using the psycopg
interface to postgresql. A mailing list would be ideal. I've
poked at their wiki, but not found what I'm looking for.
Also, new to both postrgresql psycopg, my questions appear
Hello,
I am trying to create audit tables for all of the tables in my
database. The function, table and trigger create statements are below.
Apparently, I am not doing it quite right, because I get these messages
when I try to run the create statements below:
CREATE FUNCTION
CREATE FUNCTION
Aaron Glenn wrote:
What is the PostgreSQL project's official stance/view/comment on this?
Uh, I work for SRA, but the community has always stated that the project
can not certify anyone. Just like the Linux kernel group doesn't
certify anyone, Red Hat and other companies do, the same is true of
I would like to
unsubscribe my address from the mailing list, please advise how to go about
this?
Regards
Joseph
On Wed, 13 Oct 2004, Aaron Glenn wrote:
What is the PostgreSQL project's official stance/view/comment on this?
Should we have one? And why?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ:
Is there any way to remove a password, specifically from the postgres
user? I installed the 8.0 Windows version via the installer, and it
forces you to set a password. I'd like to reset this so that there is
no password (basically, to match the setup on several other machines -
and no, for a
74 matches
Mail list logo