I would like to know if there is anyway to move a section of some tables into RAM to work on them.
I have large table, about 700MB or so and growing. I also have a bizarre collection of queries that run hundreds of queries on a small section of this table. These queries only look at about 100
In what way could a database like PostgreSQL not be "faithful to relational theory"? Does he give any explanation as to what that means?
Some people mistake the word relational for the meaning of normalization, but they do not have the same meaning. If Fabial is mistaking relational for normal
Is there a database file system?
I have a project that needs very advanced permission control like that offered by Novell NDS. I am wanting to know if anyone knows of a (PHP | Perl | Samba | SQL ) (object | plug-in | module ) that would allow me to serve files from a connection that is control
I have some multi-line address fields in my Linux PostgreSQL that get populated as Linux lines with CR line terminators. This works fine until a Windows client connects to it over ODBC and then barks because the end of line is not in CRLF format.
Is there a simple fix for this? Is there anythi
ery here window.
Sometimes you just gotta use what you can get. Some of them have
history and all that fancy stuff, they just live inside a GUI app.
Me personally, I switched of Windows long ago due to issues like this.
On Thu, 2006-03-02 at 10:34, Roy Souther wrote:
> CLI = Command Line Interface
CLI = Command Line Interface
GUI = Graphical User Interface
WSI = Web Server Interface
I need a CLI app. Sorry I was not clear on this.
On Thu, 2006-03-02 at 10:05 -0600, Scott Marlowe wrote:
On Wed, 2006-03-01 at 17:00, Roy Souther wrote:
> I love Linux, any tool you need it has it. J
I love Linux, any tool you need it has it. Just try to find the most basic of tools for Windows, what a joke.
I need an Open Source SQL command line tool for Windows that will let me script queries to a database over an ODBC connection. It must use ODBC because it may or may not be PostgreSQL.
I am trying to get the ODBC client to log but I just can't. I have included my odbc.ini and odbcinst.ini. Can anyone tell me why there is never a log file created? I connect to the database with isql and OpenOffice, run queries and get data but never do I ever get a log file.
Shouldn't it just
< 0 THEN (value * -1) || ' (K)'
END AS givekeepamount
FROM (
SELECT mmpuncorvol, ((mmpuncorvol - uutuncorvol)::float4 / 1000)::NUMERIC(5,3) AS value
FROM runs
WHERE status ILIKE '%init%'
AND status ILIKE '%fast%'
AND inactive='f'
AND evaluation = repo
t the field to be a unique index. As the query is run again and again I want more tuples appended to the table and each time the counter should start at 1 and count up.
Roy Souther
www.SiliconTao.com
Let Open Source help your business move beyond.
For security this message is digi
I cannot find any information about wether PostgreSQL has EXTPROC or not. Can
someone tell me if it dose or if there is a better way to do this.
I need to be able to run a program when some data is requested from the
database. Some query will do a SELECT on a known table and I need to have
some
hen pass them to a local port then on into the server. Is this the only way?
--
Roy Souther <[EMAIL PROTECTED]>
01100010 10101110 11000110 11010110 0100 10110010 10010110 11000110
01001110 0110 11001110 00010110 10010110 00101110 1100 1100
12 matches
Mail list logo
