Daniel Caune wrote:
Hi,
Is there any option to set so that psql provides the execution time of
each SQL statement executed?
\timing (either as a manual command or as a default in your .psqlrc file).
Cheers,
Steve
---(end of broadcast)---
TI
Hi,
Is there any option to set so that psql provides the execution
time of each SQL statement executed?
Regards,
--
Daniel CAUNE
Ubisoft Online Technology
(514) 4090 2040 ext. 5418
Dear Humble Geek ,
-- id is primary key
insert into users (id, username) values (nextval('someSeq'),'somename');
-- id is also a PK
insert into log (id, uid, message) values (nextval('someOtherSeq'),XXX,'New
Account');
Assume XXX is the id from the first insert. How do I get that number? Not
currv
Hi all. Quick and perhaps silly question, but...
I am using Pg 7.3. I am writing a function using pgplsql. This function will
perform multiple inserts. Let's say two of the inserts are as follows:
-- id is primary key
insert into users (id, username) values (nextval('someSeq'),'somename');
-- id
"David M. Richter" <[EMAIL PROTECTED]> writes:
> FATAL 2: ZeroFill(/usr/local/pgsql/data/pg_xlog/xlogtemp.30164) failed:
> No such file or directory
You ran out of disk space.
Yes, the error message is misleading. That's fixed in current sources.
See also
http://www.ca.postgresql.org/mhonarc/
"David M. Richter" <[EMAIL PROTECTED]> writes:
> The query works, but not right.(apart from the timeaspect)
> UPDATE image SET seriesoid = r.parentoid
> FROM image i JOIN relseries_image000 r ON i.chilioid=r.childoid;
You shouldn't mention "image i" in the FROM clause --- since image is
already
Hi, there,
http://www.postgresql.org/doxlist.html
I.10, III.45
Paulo Roberto Siqueira wrote:
> Where can I find a tutorial on PL/SQL for postgres? Is there any
> documentation focused on it on postgres' site?
>
> Thank you
--
Jie LIANG
Internet Products Inc.
10350 Science Cent
Sr. Siquiera,
> Where can I find a tutorial on PL/SQL for postgres? Is there any
> documentation focused on it on postgres' site?
Try: http://www.postgresql.org/users-lounge/docs/v7.0/postgres/c4091.htm
-Josh
--
__AGLIO DATABASE SOLUTIONS___
Where can I find a tutorial on PL/SQL for postgres? Is there any
documentation focused on it on postgres' site?
Thank you
