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
subscribe-nomail
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
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 che
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 sec
<[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.
>>
> 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 ) for those records in
> which the primary column is NULL. It works well for my app.
Michael,
t
>>>"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,
>>
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 departmen
>> 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 DOM
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 an
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 ar
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 );
>
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.
re
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
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
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 t
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
> >
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
upda
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
> > > databa
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
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 ch
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 ju
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 finis
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 ar
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 applie
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
>
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
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
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 wh
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 directo
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 execu
> 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 --
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 r
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 impleme
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 select
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 exam
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
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
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
> 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" t
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 functio
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 variab
>> 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 S
>> 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:
>
> http://archives.postgresql.org/pgsql-odbc/20
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 g
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 fo
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.
>
>
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 no
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 vac
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 b
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 ) for those records in
which the primary column is NULL. It works well for my app.
Mic
On 7/18/05, Lincoln Yeoh 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 curiosity, do I und
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 t
Dan Armbrust <[EMAIL PROTECTED]> writes:
> The index that is failing is CREATE INDEX i1 ON conceptproperty USING
> btree (codingschemename, property, propertyvalue).
>
> Usually, the 'propertyValue' field is fairly short - 100 chars or
> less. And in those cases, I need to be able to do an indexe
> 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
71 matches
Mail list logo
