On Wednesday 17 September 2003 22:33, Stephan Szabo pronounced:
> On Wed, 17 Sep 2003, tom baker wrote:
> > i am (probably) shooting myself in the foot, but here goes the question.
> >
> > inside of a begin transaction/commit block, i am attempting to insert a
> > record into a parts table, and the
On Thu, 18 Sep 2003, tom baker wrote:
> ah, yes, i DID not see the NOT. that is fixed. here is the code that is having
> problems (paired down; all error checking has been removed!)
>
> $res=pg_query( "BEGIN TRANSACTION" ) ;
>
> $sql = "LOCK TABLE parts IN SHARE ROW EXCLUSIVE MODE" ;
> $res = pg_q
Hi list,
I've searched the interactive docs and found this link:
http://www.postgresql.org/docs/7.3/interactive/plpgsql-trigger.html
There is no answer to the question below: How to set foo:= NEW or foo:=
OLD in plpgsql trigger function
(I have the same problem)
Any help is appreciated.
Than
On Thursday 18 September 2003 11:24, Stephan Szabo pronounced:
> On Thu, 18 Sep 2003, tom baker wrote:
> > ah, yes, i DID not see the NOT. that is fixed. here is the code that is
> > having problems (paired down; all error checking has been removed!)
> >
> > $res=pg_query( "BEGIN TRANSACTION" ) ;
>
Dear Gurus,
Is there a way to automate the backup databases using
pg_dump (like in SQL server)?
Regards
Kumar
Dear Friends,
I was looking for a structure like oracle or ms
Sql server in Postgres. What I have expected is individual datafiles for
individual databases. But i cant fine such items in the /usr/local/pgsql/data
directory.
Will the postgres create individual data file for
databases?
H
Hi
Recently I receive massive mail attack. This attack comes from some
postgresql mailing list users. All send-to adresses are taken from users
mailboxes which contain postgresql posts. Currently I found two kinds of
viruses:
1. Empty post with "Undelivered message to..." body
2. Microsoft "Dear
Hey guys,
I'm not sure if this is good or bad but when I want to have a record count
of a view it takes at least 75 seconds to complete (PII 1.4Ghz 256Mb RAM).
Also when I do a record count of one single table (same table but not
joined) it just takes a long time. Firt I want to make sure that the
explain select count(*) from sq_logfile;
Not too helpful.
Better choice is:
explain analyze select * from sq_logfile;
Your explains show that selecting from view is 4 times slower than
selecting from a table (35988:128282). It is possible.
Anyway counting 1 million rows usualy takes a long time...
