Most web appl servers have settings to do this for you, or APIs you can
use.
e.g. for J2EE see SessionBindingListener
regards
mark
Egor Shipovalov wrote:
Is there a way to make transaction automatically COMMIT or ROLLBACK after
certain period of time?
I want website visitors to be able to pag
Is there a way to make transaction automatically COMMIT or ROLLBACK after
certain period of time?
I want website visitors to be able to page through search results using
single cursor. Since users can leave the site at any time, I can't know when
to end their transaction.
I guess I can write a bro
Hi Folks!
I don´t know whether it would be possible or not, but wouldn´t it be
time to update the license text to the text of the current BSD
license template? Or at least to replace "University of California"
with "The PostgreSQL Global Development Group" ?
Christoph Nelles
--
Mit freundlich
I have a class that I designed that contains some objects in its fields,
that are derived from the TList class.
I want to use the TList Sort procedure to sort the items that are in the
derived class. The derived class has an extra field that specifies how to
sort the items.
The problem I have
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Rory
Campbell-Lange) transmitted:
> Essentially the call (as defined below) asks for an update and adds
> a LIMIT parameter on the end of the UPDATE. (eg update where x=1
> limit 1). Postgres doesn't like this and I assume i
Can anyone reccomend a career path or maybe past experience on a good
career path to becoming a DBA? I recently took a class on Intro to SQL
at the local college and enjoyed it very much. I dont want to become a
full-time PHP, SQL, ASP, Java,etc. programmer, though. My background is
in Windo
Hi,
Holger Marzen wrote:
On Thu, 11 Sep 2003, pginfo wrote:
> Hi,
> I am runing linux red hat 7.3 (standart install)
> on dual athlon box , 1 GB ram and pg 7.3.4.
>
> If I try to access with pgAdmin one from my tables (i contains ~
1 M
> records)
> the linux box crashes.
> In my pg log I can fin
I think there are a lot of resources out there to get up to speed on
Microsoft SQL Server. You can purchase a full developer edition for $50 and
start playing with it. You might be able to get up to speed on MS-SQL faster
than other database systems.
You can start by reading BOL, you can download
running the following script
select ('cabal\\' || user_name) into temporary user_access from
tbl_user_access where access_profile_id = 4;
copy user_access to '/temp/users.txt' delimiters '|';
The result of the output file is...
domain\\users
but the field in the temp table is...
domain\users
I n
After a long battle with technology,[EMAIL PROTECTED] ("scott.marlowe"), an earthling,
wrote:
> I still feel MySQL is somewhat overstepping the bounds of the GPL.
> The GPL makes it clear that if I don't link to GPL code, I'm not
> bound by it.
If all the other "open source" software had the same
Scott et co.,
Thanks for your comment. Here is my response.
First of all, let's remember that neither I nor MySQL AB (nor any of
us) is an official authority for interpreting the GPL. Legally,
affirmative answers can only be given by a competent court. The FSF
is a natural authority on the GPL
I have a little problem.
there is a way to get last id inserted into db or i have to make a new query?
I explain better my question:
in vbscript using sqlserver2000 i can use this code:
varBookmark=rs.Bookmark
rs.Update
rs.Bookmark=varBookmark
in this way in I the new id just inserted!!!
how
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write:
> I'm trying to retrieve a limited number of random rows, and order them by a
> column, and am not having any luck with that last part:
>
> SELECT * FROM tablename ORDER BY random(), id LIMIT 10
>
> Returns everything more or le
Oops! [EMAIL PROTECTED] ("scott.marlowe") was seen spray-painting on a wall:
> On Tue, 23 Sep 2003, Marten G Mickos wrote:
>> Scott et co.,
>>
>> Thanks for your comment. Here is my response.
>>
>> First of all, let's remember that neither I nor MySQL AB (nor any of
>> us) is an official authori
We are pleased to announce the release of Rekall V2.1.0 beta 2
Rekall is a programmable cross platform database independant GUI client
front end. Rekall includes plugin drivers for PostgreSQL, MySQL, and xBase.
There available additional native code drivers for Oracle, DB2, and ODBC
The following
so.. what exactly are you trying to say here? ;)
I think this is the funniest post I've ever seen on this list!!!
Travis
-Original Message-
From: Nigel J. Andrews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 5:47 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re:
On Tue, 23 Sep 2003 [EMAIL PROTECTED] wrote:
> Hello,
>
> I'm trying to retrieve a limited number of random rows, and order them by a
> column, and am not having any luck with that last part:
>
> SELECT * FROM tablename ORDER BY random(), id LIMIT 10
So it's sorting by random() then id.
> Retu
A, ok :)
Sorry, I just misunderstood how the sorting was being applied, I thought it
would sort on one, and then the next, not on one, and then theother where
the first is equal !
I thought I'd tried a nested SQL, but had gotten some errors ...
Anyways thanks to your examples I got it workin
On Tue, 23 Sep 2003 [EMAIL PROTECTED] wrote:
> Hello,
>
> I'm trying to retrieve a limited number of random rows, and order them by a
> column, and am not having any luck with that last part:
>
> SELECT * FROM tablename ORDER BY random(), id LIMIT 10
>
> Returns everything more or less as expec
I just searched all the 7.2 manuals, the latest I have, and there is not
one explanation of using random to order a query
[EMAIL PROTECTED] wrote:
Hello,
I'm trying to retrieve a limited number of random rows, and order them by a
column, and am not having any luck with that last part:
S
On Tue, 23 Sep 2003 [EMAIL PROTECTED] wrote:
> Hello,
>
> I'm trying to retrieve a limited number of random rows, and order them by a
> column, and am not having any luck with that last part:
>
> SELECT * FROM tablename ORDER BY random(), id LIMIT 10
>
> Returns everything more or less as expecte
[EMAIL PROTECTED] writes:
> I'm trying to retrieve a limited number of random rows, and order them by a
> column, and am not having any luck with that last part:
> SELECT * FROM tablename ORDER BY random(), id LIMIT 10
> Returns everything more or less as expected, except for the fact that the
> re
[EMAIL PROTECTED] wrote:
> Hello,
>
> I'm trying to retrieve a limited number of random rows, and order them by a
> column, and am not having any luck with that last part:
>
> SELECT * FROM tablename ORDER BY random(), id LIMIT 10
How about:
SELECT * FROM
(SELECT * FROM tablename ORDER BY rand
victor silalahi <[EMAIL PROTECTED]> wrote:
>get any information about DSN less according to
>ConnectionString property in my VB6 application. is there
>possible to use DSN Less to connect to postgresql dbms ?
>and what kind of ConnectionString that i will use
>to connect postgresql dbms (with D
On Tue, 23 Sep 2003, shreedhar wrote:
> If I try to delete a record from my table which is giving following error
>
>
> Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in
> /xxx/database.inc on line 73
>
> What might be the problem.
Looks like line 73 of your /xxx/database
On Tue, 2003-09-23 at 05:57, shreedhar wrote:
> If I try to delete a record from my table which is giving following error
>
>
> Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in
> /xxx/database.inc on line 73
>
> What might be the problem.
What version are you running?
Co
If I try to delete a record from my table which is giving following error
Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in
/xxx/database.inc on line 73
What might be the problem.
Regards,
Sreedhar Bhaskararaju
---(end of broadcast)---
Hi,
> I have a table in my database which can grow very quickly. Is
> there some way to partition the table so that when it reaches a certain
> size the
> information in it is copied to a temporary table and the
> original table is free again.
You can create a view and update the view definition
Hi David,
I'd say that if it is a new app develop it with 7.4 and use statement level
triggers otherwise you could use normal triggers and perform a count each
time but that will slow things down dramatically.
Other option is to use cron and write a daemon/script to periodically check
the size
I have a table in my database which can grow very quickly. Is
there some way to partition the table so that when it reaches a certain size the
information in it is copied to a temporary table and the
original table is free again.
Or is this possible at all. If not is there any sort of perfomanc
30 matches
Mail list logo