Dinesh Pandey wrote:
From where can I download?
Postgres 8.x + required packages and installation instruction of
Postgres for Fedora Core 2 OS.
Umm - did you try the website: http://www.postgresql.org/
Click Downloads, click FTP Browser, look in v8.03, linux, rpms,
fedora,
Is there such a thing? PHP would be preferable, I don't want to maintain
a MySQL-Server for such a small thing..
Thanks in advance
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
On 7/18/05, Hannes Dorbath [EMAIL PROTECTED] wrote:
Is there such a thing? PHP would be preferable, I don't want to maintain
a MySQL-Server for such a small thing..
Thanks in advance
I have used phpwiki (http://phpwiki.sourceforge.net/) with it. It's not
really a full blown wiki system, but
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read the DELETE command docs but havent found any function.
Any idea ?
Andrus.
---(end of broadcast)---
TIP 3: Have you
Hi,
in the release docs it says:
Non-deferred AFTER triggers are now fired immediately after completion of
the triggering query, rather than upon finishing the current interactive
command. This makes a difference when the triggering query occurred within a
function: the trigger is invoked
At least, you can do a select count(*) from ... just before the
delete, better if inside a transaction, if the query itself is not too
much expensive
Andrus wrote:
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read
This week is looking busy for me but hopefully I'll be able to play around
with various vacuuming frequencies for this table ...
Thanks for all of your help; I'll report on my progress
-Dave
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 13, 2005
Use 127.0.0.1 instead of localhost
In this case DNS is not used.
Andrus.
Scott cox [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I am running PostgreSQL 8.0 on WinXP
When I try to connect
psql.exe -h localhost -p 5432 template1 postgres
I have to wait
30 seconds before the
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote on 07/15/2005 02:49:09 PM:
On Fri, Jul 15, 2005 at 20:08:32 +0300,
Andrus [EMAIL PROTECTED] wrote:
So I'll think still continuing to use null as unrestricted department
access.
Is it reasonable to
I was faced with a similar issue. One suggestion I got from the Internet
was to create a shadow column that contains the values used in the Index,
with a dummy entry (in my case, the string NULL) for those records in
which the primary column is NULL. It works well for my app.
Michael,
if department _id is NULL, user has access to all departments data.
This is your problem. You've assigned meaning to the value NULL.
CREATE TABLE permission (
id serial,
user_id CHAR(10) NOT NULL REFERENCES user,
permission_id CHAR(10) NOT NULL REFERENCES privilege,
UNIQUE (user_id,
Ropel, thank you.
I'm looking for a better solution because
1. Some deletes take big amount of time. This increases run time a LOT
2. This requires the use of transaction if somebody changes data between
SELECT COUNT(*) and DELETE commands.
When transaction isolation level I must set for this
On 7/18/05, Andrus [EMAIL PROTECTED] wrote:
That's a lot of overhead for doing something very simple, like defining a
department key that means ALL and a row in the foreign table for it to
point to. Maintaining indices is a nontrivial performance trade-off.
Yes, adding department ALL may
If I add ALL to department table, I must restrict all other tables of
having
ALL department. This is a big work and cannot be done nicely in Postgres.
Not true. :) You simply need to add CHECK (departament_id 0) (assuming
0 is the ID of ALL departaments. You can even CREATE DOMAIN with
Andrus, Is correct. There is no DNS involved because I am using 127.0.0.1 in
my config
and when connecting. But there is still a ~60second delay connecting and
more delays
to return the select * query.
I have other servers using 127.0.0.1 like Apache,MySql and none have this
delay connecting
Hello all,
We am running PostgreSQL 7.4.5 and recently we have noticed some strange
behaviour with regards to the TRUNCATE statement.
I think it would help to provide a quick overview of what we are doing
with the table in question in order to properly explain this.
The application which
On Fri, 2005-07-15 at 13:46 +0300, Andrus wrote:
I have table
CREATE TABLE test( col1 CHAR NOT NULL, col2 CHAR,
UNIQUE (col1, col2) );
This table allows to insert duplicate rows if col2 is NULL:
INSERT INTO test VALUES ( '1', NULL );
INSERT INTO test VALUES ( '1', NULL );
does NOT
Janning Vygen [EMAIL PROTECTED] writes:
I have lots of tables with mutli-column PK and multi-column FK. All FK are
cascading, so updating a PK should trigger through the whole database.
This worked earlier in 7.4:
UPDATE tipprunden SET tr_kurzname = 'schwarze2' where tr_kurzname =
Andrus [EMAIL PROTECTED] writes:
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I'm sure ODBC provides a way to do that, but you're asking the wrong
list about what it is ... try pgsql-odbc.
On Jul 18, 2005, at 7:00 AM, Andrus wrote:
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read the DELETE command docs but havent found any function.
Any idea ?
I don't use ODBC, but you should get that directly back
* Joe Maldonado ([EMAIL PROTECTED]) wrote:
It seems that TRUNCATE is first posting a lock on the table and then
waiting for other transactions to finish before truncating the table
thus blocking all other operations.
Is this what is actually going on or am I missing something else? and is
Joe Maldonado [EMAIL PROTECTED] writes:
It seems that TRUNCATE is first posting a lock on the table and then
waiting for other transactions to finish before truncating the table
thus blocking all other operations.
That's what it's supposed to do. If you have a problem with the length
of the
On Mon, 18 Jul 2005, Tom Lane wrote:
Janning Vygen [EMAIL PROTECTED] writes:
I have lots of tables with mutli-column PK and multi-column FK. All FK are
cascading, so updating a PK should trigger through the whole database.
This worked earlier in 7.4:
UPDATE tipprunden SET tr_kurzname =
On 7/18/05, Andrus [EMAIL PROTECTED] wrote:
If I add ALL to department table, I must restrict all other tables of
having
ALL department. This is a big work and cannot be done nicely in Postgres.
Not true. :) You simply need to add CHECK (departament_id 0) (assuming
0 is the ID of ALL
After an application updates, deletes, or inserts rows, it can call
SQLRowCount to determine how many rows were affected. SQLRowCount returns
this value whether or not the rows were updated, deleted, or inserted by
executing an UPDATE, DELETE, or INSERT statement, by executing a positioned
Am Montag, 18. Juli 2005 16:28 schrieb Stephan Szabo:
On Mon, 18 Jul 2005, Tom Lane wrote:
Janning Vygen [EMAIL PROTECTED] writes:
I have lots of tables with mutli-column PK and multi-column FK. All FK
are cascading, so updating a PK should trigger through the whole
database.
Stephan Szabo [EMAIL PROTECTED] writes:
On Mon, 18 Jul 2005, Tom Lane wrote:
AFAICS, if it worked for you in 7.4 it was only by pure chance. There
was not then, and is not now, any logic that would prevent the FK checks
from being applied in an order you don't want.
True, although I think
Janning Vygen [EMAIL PROTECTED] writes:
But why doesn't it work if i make alle FK deferrable initially deferred?
You didn't do it right --- I don't believe the code actually looks at
pg_constraint, it looks at pg_trigger. And if you are going to hack
pg_trigger directly, be careful to only
On 7/18/05, Dawid Kuroczko [EMAIL PROTECTED] wrote:
On 7/18/05, Andrus [EMAIL PROTECTED] wrote:
I have meaningful primary key in department table (department code used
inside enterptise), not a surrogate number (I use meaningful primary keys
whenever possible).
OK, so then just define
Thanks...I just wanted to verify that it was the intended behaviour
prior to going in and changing code :)
- Joe Maldonado
Tom Lane wrote:
Joe Maldonado [EMAIL PROTECTED] writes:
It seems that TRUNCATE is first posting a lock on the table and then
waiting for other transactions to finish
Am Montag, 18. Juli 2005 16:56 schrieb Tom Lane:
Janning Vygen [EMAIL PROTECTED] writes:
But why doesn't it work if i make alle FK deferrable initially deferred?
You didn't do it right --- I don't believe the code actually looks at
pg_constraint, it looks at pg_trigger. And if you are going
On Mon, 18 Jul 2005, Tom Lane wrote:
Stephan Szabo [EMAIL PROTECTED] writes:
On Mon, 18 Jul 2005, Tom Lane wrote:
AFAICS, if it worked for you in 7.4 it was only by pure chance. There
was not then, and is not now, any logic that would prevent the FK checks
from being applied in an order
Stephan Szabo [EMAIL PROTECTED] writes:
On Mon, 18 Jul 2005, Tom Lane wrote:
I don't see why.
Except that before I think the order would have looked like (for 1 row)
Originating Action
Trigger A on originating table that does update
Trigger B on originating table that does update
Trigger
I looked in the data directory of postgres -- where else should I look for it?
Akash
On 7/6/05, Michael Fuhr [EMAIL PROTECTED] wrote:
On Wed, Jul 06, 2005 at 06:55:09PM -0700, Akash Garg wrote:
This is Suse Enterprise 9.0 running on a quad Opteron Newisys machine.
It has 32 gb of RAM. We
I get this error when I run a VACUUM:
INFO: vacuuming pg_toast.pg_toast_100194
vacuumdb: vacuuming of database friend failed: ERROR: could not
open segment 1 of relation pg_toast_100194_index (target block
1226167840): No such file or directory
I'm assuming I can just delete and recreate the
In the Postgre documentation I could find ODBC references only to Postgre
7.2 and older.
Can anyone point me to ODBC documentation for version 8?
Bob Pawley
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I'm sure ODBC provides a way to do that, but you're asking the wrong
list about what it is ... try pgsql-odbc.
Tom,
pgsql.odbc newsgroup has only 5 messages in the whole
Akash Garg [EMAIL PROTECTED] writes:
I get this error when I run a VACUUM:
INFO: vacuuming pg_toast.pg_toast_100194
vacuumdb: vacuuming of database friend failed: ERROR: could not
open segment 1 of relation pg_toast_100194_index (target block
1226167840): No such file or directory
I'm
My ODBC client is Microsoft Visual FoxPro
I ran delete command using its sqlexec() function like:
SQLEXEC(nConnhandle, DELETE FROM mytable)
sqlexec() function returns the result from ordinary select table in a
cursor SQLRESULT
Unfortunately, no result is returned if DELETE command is
Or better:
CREATE UNIQUE INDEX permission_unique_key
(user_id,permission_id,department_id);
CREATE UNIQUE INDEX permission_uninull_key (user_id,permission_id)
WHERE department_id IS NULL;
...you may want to add WHERE department_id IS NOT NULL to the first query
(or not). Anyway -- this
Nevermind this question...
Where is the documentation on tsearch2?
Google first, ask second, I remind myself again... I knew I hadn't
seen it mentioned in the official postgresql manual.. didn't think
about it being an extension.
Dan
Dan Armbrust wrote:
Hmm, well, I don't know if it
Akash Garg [EMAIL PROTECTED] writes:
Sounds good -- I will try that. Will this REINDEX lock any queries
that are currently running on the database? And is there anway to
find out what table this toast table is related to?
IIRC, 100194 is the OID of the owning table.
I believe the correct way is the following.
1. get the oid from pg_class for relname='pg_toast_100194'
2. lookup up the relname from pg_class where reltoastrelid = the oid from the
first query.
so on my system
select oid from pg_class where relname='pg_toast_17070';
oid
---
17072
(1
On Mon, 2005-07-18 at 15:17, Dan Armbrust wrote:
We have built a Model for terminologies that we call The Lexical Grid
(more info http://informatics.mayo.edu/LexGrid/index.php)
LexGrid has multiple backend data storage mechanisms, including LDAP
and SQL. We do our best to remain
Hello,
May I know the commands to retrieve objects' privileges info please?
Something like:
Object Type, Object name,creator,grantee,privilege,
is_creatable
===
table T1user1 user2
We have built a Model for terminologies that we call The Lexical Grid
(more info http://informatics.mayo.edu/LexGrid/index.php)
LexGrid has multiple backend data storage mechanisms, including LDAP
and SQL. We do our best to remain implementation independent - our SQL
implementations, for
On Mon, 2005-07-18 at 16:01, Dan Armbrust wrote:
Hmm, well, I don't know if it is actually building an index properly
on this column, I just assumed that it was. It doesn't fail on every
insert, only on the one that has a really long text value. I know it
doesn't use the index when I do
Hmm, well, I don't know if it is actually building an index properly on
this column, I just assumed that it was. It doesn't fail on every
insert, only on the one that has a really long text value. I know it
doesn't use the index when I do "ILIKE" queries, resulting in poor
performance... but I
Hi, folks!
Reading previous posts on returning composite types in pl/pgsql, I
still haven't found a good answer for this issue:
Let's say we create this table:
/*/
CREATE TABLE tbl_estadosoporte (
id CHAR(1)
Dan Armbrust [EMAIL PROTECTED] writes:
All of my other limitations on changing things aside - given a query
like this:
Select * from conceptproperty where codingSchemeName='foo' AND
property='anotherfoo' and propertyValue ILIKE 'valu%'
What indexe(s) would be recommended?
I'd index on
Juan Miguel Paredes [EMAIL PROTECTED] writes:
DECLARE
res helpdesk.tp_res_conestadosdisponiblessoporte;
BEGIN
IF estadoactual = 'Abierto' THEN
SELECT INTO res.filas *
FROM tbl_estadosoporte
Without having looked at the code, I suspect that plpgsql just assumes
res.filas is of
Although others have suggested that you're going to need an additional
table, I've not seen anyone explicitly state why this is causing you
problems.
Clearly, NULL should not be used to mean Any. However, the only reason
you're doing this is because you want a FK to the department table.
Shane wrote:
Hi,
I am attempting a query using lseg values to find the point
of intersection. The following query taken from the PG
manual isn't working over here.
select
point(lseg '((-1,0),(1,0))', lseg
'((-2,-2),(2,2))')
ERROR: function point(lseg, lseg) does not exist
HINT: No
I'm trying to load some data into PostgreSQL 8.0.3, and I got the error
message index row size 2904 exceeds btree maximum, 2713. After a
bunch of searching, I believe that I am getting this error because a
value that I am indexing is longer than ~ 1/3 of the block size - or the
BLCKSZ
Unfortunately, no result is returned if DELETE command is executed.
There is no SQLRowCount function in FoxPro.
That's probably a feature of the language and will be so regardless of the
database used. I expect it wraps the ODBC APIs up in a more managable
form.
Paul,
If Microsoft SQL
pgsql.odbc newsgroup has only 5 messages in the whole this year. None of
them has got any replies.
I think you're making the classic mistake of equating the usenet news
versions of a list with the actual mailing list.
Take a look here:
Sounds good -- I will try that. Will this REINDEX lock any queries
that are currently running on the database? And is there anway to
find out what table this toast table is related to?
Thanks,
Akash
On 7/18/05, Tom Lane [EMAIL PROTECTED] wrote:
Akash Garg [EMAIL PROTECTED] writes:
I get
On 18/07/2005 17:47 Andrus wrote:
Unfortunately, no result is returned if DELETE command is executed.
There is no SQLRowCount function in FoxPro.
That's probably a feature of the language and will be so regardless of the
database used. I expect it wraps the ODBC APIs up in a more managable
On Mon, 2005-07-18 at 11:53, Andrus wrote:
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I'm sure ODBC provides a way to do that, but you're asking the wrong
list about what it is ... try pgsql-odbc.
Tom,
Shane [EMAIL PROTECTED] writes:
I am attempting a query using lseg values to find the point
of intersection. The following query taken from the PG
manual isn't working over here.
select
point(lseg '((-1,0),(1,0))', lseg
'((-2,-2),(2,2))')
ERROR: function point(lseg, lseg) does not exist
On Mon, Jul 18, 2005 at 14:44:26 -0500,
Dan Armbrust [EMAIL PROTECTED] wrote:
I'm trying to load some data into PostgreSQL 8.0.3, and I got the error
message index row size 2904 exceeds btree maximum, 2713. After a
bunch of searching, I believe that I am getting this error because a
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
INFO: free space map: 195 relations, 96448 pages stored; 417104 total
pages needed
DETAIL: Allocated FSM size: 1000 relations + 9 pages = 588 kB
shared memory.
I'm confused, do I need to set my fsm settings to 96448 or 417104 based
on this output?
Are fsm settings updated during a
I believe that one should leave such on-the-fly disk compression to the
O/S. Postgresql already does compression for TOAST.
However, maybe padding for alignment is a waste on the disk - disks being
so much slower than CPUs (not sure about that once the data is in memory ).
Maybe there should
Andrus wrote:
I was faced with a similar issue. One suggestion I got from the Internet
was to create a shadow column that contains the values used in the Index,
with a dummy entry (in my case, the string NULL) for those records in
which the primary column is NULL. It works well for my app.
On 7/18/05, Lincoln Yeoh lyeoh@pop.jaring.my wrote:
However, maybe padding for alignment is a waste on the disk - disks being
so much slower than CPUs (not sure about that once the data is in memory ).
Maybe there should be an option to reorder columns so that less space is
wasted.
Out of
Dan Armbrust wrote:
Hmm, well, I don't know if it is actually building an index properly on
this column, I just assumed that it was. It doesn't fail on every
insert, only on the one that has a really long text value. I know it
doesn't use the index when I do ILIKE queries, resulting in poor
Andrus wrote:
How I can read and reply to all messages without receiving them all
to my e-mail mailbox ?
From the Mailing Lists page of the PostgreSQL site
http://www.postgresql.org/community/lists/:
The mailing lists are also available at the PostgreSQL news server.
However, in order to
Dan Armbrust [EMAIL PROTECTED] writes:
The index that is failing is CREATE INDEX i1 ON conceptproperty USING
btree (codingschemename, property, propertyvalue).br
br
Usually, the 'propertyValue' field is fairly short - 100 chars or
less.nbsp; And in those cases, I need to be able to do an
I'm trying to load some data into PostgreSQL 8.0.3, and I got the error
message index row size 2904 exceeds btree maximum, 2713. After a
bunch of searching, I believe that I am getting this error because a
value that I am indexing is longer than ~ 1/3 of the block size - or the
BLCKSZ
The index that is failing is CREATE INDEX i1 ON conceptproperty USING btree
(codingschemename, property, propertyvalue).
I don't think you could create indexes on text fields... there are
other type of indexes for that... tsearch2 for example
--
Atentamente,
Jaime Casanova
(DBA: DataBase
Sorry this question is off topic.
Does anyone know a good resource for tomcat tuning
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
72 matches
Mail list logo