Releases before 7.4 are spotty about supporting backwards scan of
complex queries --- if you have a join or aggregate in the query,
it likely won't work, yielding either strange errors or wrong answers.
It will work if the top plan node in the query is a SORT, though, so
a possible workaround is
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 then insert
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_query( $sql
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.
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 ) ;
$sql =
Dear Gurus,
Is there a way to automate the backup databasesusing
pg_dump (like in SQL server)?
Regards
Kumar
Dear Friends,
I was looking for a structure like oracle or ms
Sqlserver 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?
How