Jasbinder Singh Bali napsal(a):
Instead of that, I re-engineered my while loop in the stored procedure
as follows.
...
I was wondering how to implement the SLEEP functionality here.
Hello.
I can't comment the function itself, but I want to bring something else
to your attention. Note, that
Hello Tam Wei,
tam wei wrote:
I am intending to store the files inside the postgres DB using the
type text (all the files will be pre-encode into base64. The reason
for not using the type bytea as I encountered some undesired
format(the original file alignment can't be preserved) while
extractin
Hello.
We started using, in one of our applications, the LOCK ... NOWAIT
functionality. It works as it's supposed to, but there is one, albeit
tiny, annoyance about it.
When the LOCK cannot be immediately obtained, this statement logs an
ERROR message. But in this case, I think it is not appropr
fect.
And so that this would not be just a literary exercise and to answer
Emi's question--you can't do that, but use some valid date which you are
never going to use for your ordinary data (like the '-infinity', or
1.1.1970 00:00). Just make sure you make a note of it somewh
like this:
"
alter table salesreport add column emoicon after
report
"
Read the manual on ALTER TABLE command
<http://www.postgresql.org/docs/7.4/static/sql-altertable.html>. You can
do this easily.
--
Michal Taborsky
http://www.taborsky.cz
---(end of bro
See:
http://www.postgresql.org/docs/7.4/interactive/datatype-datetime.html
--
Michal Taborsky
http://www.taborsky.cz
---(end of broadcast)---
TIP 8: explain analyze is your friend
I have a web server running FreeBSD 3.4. I installed postgres 7.0.3 and
tried to run not too large database (200k records, 20MB in size) accessed
via PHP. I keep getting this i my logfile:
syslogd: /var/run/utmp: Too many open files in system
I have filelimit set to 5000, so I think it should be
