Re: [SQL] memory usage

Ms. Wong, > This program seems to use a lot of the memory on the > linux server, and > the memory doesn't seem to be released at the end of > execution. The same > thing occurs when I try to connect to the database from > MS Access via > ODBC. It's been my experience that Win32 ODBC does not dr

[SQL] memory usage

I have a Borland C++ program (running on NT server) which connects to PostgresSQL (V6.5) via ODBC (V6.5). The program reads data file and updates database at regular intervals. The program has close all connections when execution finishes. This program seems to use a lot of the memory on the lin

Re: [SQL] copying/moving from one table to another

Hi, there, I do not quite sure is this what you want? 1. if newtable(one you want save) does not exist: select * into newtable from oldtable; or create table newtable as select * from oldtable; 2. if newtable existed, you append some record into it: insert into newtable select * from oldtable whe

[SQL] copying/moving from one table to another

Hi all, is there a handy way to copy or (preferrably) move a whole record from one table to another, equally structured table in the same DB? Background: I have some tables which hold information concerning our staff, where people quite so often come and go, because their employment contract is

[SQL] Getting number of days

Hi All, Does anybody know how to convert an interval into a number of days. Say I have something like '2 years 4 months 4 ago', I need to get the total number of days, something like 800 (ish). Is there a built in function? Thanks W __ Do You Ya

[SQL] Setting the transaction isolation level for a stored procedure

Sorry, I forgot to put a subject title in my last email. So here it is again. Hi ppl, Just wondering if anyone knows if its possible to set the transaction isolation level from inside a stored procedure in plpgsql. Or do I need to run the 'set transaction isolation level' command before I call

[SQL]

Hi ppl, Just wondering if anyone knows if its possible to set the transaction isolation level from inside a stored procedure in plpgsql. Or do I need to run the 'set transaction isolation level' command before I called the stored procedure? I'm not even sure that would work, I assume plpgsql u

[SQL] New used in Non-Rule Query problem solved

The problem is solved, there was a syntax error in the code I failed to spot time after time... tnx anyway, Koen Antonissen

[SQL] Change of behaviour of pg_get_userbyid & pg_get_viewdef - do it?

Based on the lack of reaction on GENERAL and SQL, I am inclined to go ahead with the changes below at least as far as returning NULL instead of 'Not a View' or 'unknown (UID=)' (as per Tom's request), if noone objects... At 13:15 24/09/00 +1000, Philip Warner wrote: > >Two routines do eccentri