hi,
I'm using CVS source built postgres, may be one day later
then the main site, but found one problem:
I've set PGCLIENTENCODING environment before, for easy of
typing, like export PGCLIENTENCODING=GBK in my .profile,
but after I upgrade my postgresql to current CVS, I found
problem, the
Michael Glaesemann zei:
OIDS are a system level implementation. They are no longer required
(you can make tables without OIDS) and they may go away someday.
Out of curiosiry: how will we handle blobs once the OID's are gone?
---(end of
Am Dienstag, 16. November 2004 10:01 schrieb Joolz:
Michael Glaesemann zei:
OIDS are a system level implementation. They are no longer required
(you can make tables without OIDS) and they may go away someday.
Out of curiosiry: how will we handle blobs once the OID's are gone?
They won't go
On Nov 16, 2004, at 6:42 PM, Peter Eisentraut wrote:
Am Dienstag, 16. November 2004 10:01 schrieb Joolz:
Michael Glaesemann zei:
OIDS are a system level implementation. They are no longer required
(you can make tables without OIDS) and they may go away someday.
Out of curiosiry: how will we handle
Hi,
i am testing a few queries in my postgresql DB. The first query after reboot
is always slower because of an empty OS page/file cache.
I want to test my queries without any files in the linux kernel cache, just to
know what would be the worst execution time. At the moment i stop postgresql
Am Dienstag, 16. November 2004 10:52 schrieb Michael Glaesemann:
You sound pretty certain. I can imagine there might be a way to handle
BLOBs without OIDs. I'm not saying that I know what it is, but I
recognize the possibility.
There are certainly ways to handle this. But no one has seriously
On Tue, 16 Nov 2004 08:01 pm, Joolz wrote:
Michael Glaesemann zei:
OIDS are a system level implementation. They are no longer required
(you can make tables without OIDS) and they may go away someday.
Out of curiosiry: how will we handle blobs once the OID's are gone?
I would guess
Hi all
I have to develop an embedded database using memory FLASH and memory RAM
Some tables must be saved in RAM and some tables in FLASH ( RAM and FLASH
are two different mounted directories in the file system).
I saw it's possible to save different databases in different directories
with CREATE
Am Dienstag, 16. November 2004 11:25 schrieb [EMAIL PROTECTED]:
It's possible to save only some tables in different directories??
That will be possible in 8.0.
If I want to work with two different databases, it's possible to do a
single transaction on two different databases ??
No.
--
Peter Eisentraut wrote:
There are certainly ways to handle this. But no one has seriously proposed
getting rid of OIDs and presented a plan for fixing all the other holes that
move would leave.
Right; I certainly have no intention of trying to remove OIDs any time
soon. However, I _will_ be
In 8.0beta:
http://candle.pha.pa.us/main/writings/pgsql/sgml/plperl-database.html
and in 7.4.x:
http://www.postgresql.org/docs/7.4/interactive/plperl-database.html
On Tue, 16 Nov 2004 10:19:01 +0500, Anatoly Okishev [EMAIL PROTECTED] wrote:
Anatoly Okishev wrote:
How the function
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A little bit OT, but:
is there a way of removing duplicate rows in a table without OIDs?
Mit freundlichem Gruß / With kind regards
Holger Klawitter
- --
lists at klawitter dot de
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2
On Nov 16, 2004, at 8:32 PM, Holger Klawitter wrote:
A little bit OT, but:
is there a way of removing duplicate rows in a table without OIDs?
One method that I believe works (haven't tried it in a while):
BEGIN;
CREATE TEMP TABLE foo_temp AS
SELECT DISTINCT bar, bat, baz
FROM foo;
TRUNCATE foo;
On Tue, 16 Nov 2004 08:01 pm, Joolz wrote:
Michael Glaesemann zei:
OIDS are a system level implementation. They are no longer required
(you can make tables without OIDS) and they may go away someday.
Out of curiosiry: how will we handle blobs once the OID's are gone?
I would
Hi,
I'm sure this has been asked before, but my searches haven't come up
with an example.
I'm writing a generic trigger function called from different tables in
plpgsql that needs to get the value of the primary key column from OLD.
I can find out the pkey column name by querying the system
Hi,
We are pleased to announce the awaited DBManager Professional 3.0.
This version is a new GUI with lots of new features. DBManager is a client
application to manage your databases for Windows environments.
Some of the features in this version are
- Manage all objects in the database server:
SUCK MY WHITE COCK!
SWALLOW MY FUCKING CUM!
LICK AROUND THE CRACK OF MY ASSHOLE!
LICK MY FORESKIN CHEESE!
BLACK NIGGERS EAT WATERMELON!
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi Chris and Karim,
I haven't been following this thread, so excuse me if I suggest something
that has already been tossed out.
Solaris allows multiple IP addresses to be assigned to a single NIC. I
just looked at the man page for Linux ifconfig but didn't see quickly how
to do this. If Linux
LICK MY BALLS and ASSHOLE and COCK
Mike Cox
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
SWALLOW CUM from my COCK HOLE
Mike Cox
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
FUCK YOUR MOTHERS CUNT
Mike Cox
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Hi,
OIDS are a system level implementation. They are no longer required
(you can make tables without OIDS) and they may go away someday.
What about tableoids? Are they from the same generator as row oids (and
hence may suffer wrap-around)? Or are they unique across the db?
I ask because
CUM ON MY ASSHOLE
Mike Cox
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hi,
On Tue, 2004-11-16 at 14:17, [EMAIL PROTECTED] wrote:
Hi Chris and Karim,
I haven't been following this thread, so excuse me if I suggest something
that has already been tossed out.
Solaris allows multiple IP addresses to be assigned to a single NIC. I
just looked at the man page
Matt wrote:
So, two questions:
1. Is there a better way of getting arbitrary columns from a record?
Not really.
2. If not, will I run into problems with the name of the temporary table
if two processes call this function at the same time, or are temp names
unique to the particular session?
On Tue, 2004-11-16 at 12:32, Holger Klawitter wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A little bit OT, but:
is there a way of removing duplicate rows in a table without OIDs?
ALTER TABLE ... ADD COLUMN myoid int;
CREATE TEMP SEQUENCE myoidsequence;
UPDATE ... SET
FUCK MY WIFES CUNT and TITS
Mike Cox
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
TIT-FUCK my wife's CUNT and ASSHOLE
Mike Cox
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
BLACK NIGGERS are SPOOKS and JIGGABOOS
Mike Cox
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message
NIGGERS SUCK COCK and SWALLOW CUM LOADS
Mike Cox
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message
AFRICAN NIGGERS FUCK CUNTS
Mike Cox
Joolz
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
All this fucking crap is all your fault!
You're such a fucking asshole!
Go fuck yourself up the anus with a broomstick, BITCH!
FUCK YOU!
MOTHER FUCKER!
Goutam Paruchuri
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading
Thanks for the quick response!
Really, you'd be better off using one of the more interpreted languages
for this specific task though.
Was afraid someone would say that. Time to polish up those tarnished
perl skills ;)
Matt
---(end of
This is all the fault of that penis breath Mike Cox. FUCK HIM!
Tino Wildenhain
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
He is responsible for all this Usenet c
Tino Wildenhain
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Mike Cox is responsible for all this Usenet crap!
Mike Rylander
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Peter Eisentraut zei:
Am Dienstag, 16. November 2004 10:01 schrieb Joolz:
Michael Glaesemann zei:
OIDS are a system level implementation. They are no longer
required
(you can make tables without OIDS) and they may go away someday.
Out of curiosiry: how will we handle blobs once the OID's
I am currently creating a database with less than 20 simple tables (only
SQL 92 types, simple constraints, no PostgreSQL specific stuff, no stored
procedures...)
Unfortunately, some of those tables will contain up to 4 Million entries,
making the size of the entire database 700-1000MB.
In order
All that I'm doing for you fucking people. Be grateful!
Mike Cox
Mike Cox
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
BITCHES!
All that I'm doing for you fucking people. Be grateful!
Mike Cox
Mike Cox
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED]
EAT SHIT AND FUCK YOURSELVES
Mike Cox
Mike Cox
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Nov 16, 2004, at 11:44 PM, Joolz wrote:
Btw what's going on on the list??? I seems someone is posting a lot
of obscene nonsense, using my email address.
net.kook
I saw this happen
before with someone else. Is there anything I can do about it?
Filter aggressively and be patient. Not a happy
--- Jerry III [EMAIL PROTECTED] wrote:
Which means that sometimes they do not return the
correct value - if you
have a trigger that inserts another record you will
not get the right value.
If you are new to PostgreSQL, as you say, then why are
you so sure of this? Perhaps you may profit
I am creating a database which is supposed to contain many data entries
(events) that differ only in the date they occur.
So let's say event 1 occurs every Monday, Tuesday and Sunday between
January 1st and May 30th 2005.
How do I store and manage such data in a meaningful way?
The simple idea
--- Joolz [EMAIL PROTECTED] wrote:
Thanks.
Btw what's going on on the list??? I seems someone
is posting a lot
of obscene nonsense, using my email address. I saw
this happen
before with someone else. Is there anything I can do
about it?
This is the down side of free will. Human
Suck my big penis!
Mike Cox
Mike Cox
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to
Weiping [EMAIL PROTECTED] writes:
[ database encoding is unicode ]
now I can login, but when I do a:
DHY_JJG=# \dt
ERROR: invalid byte sequence for encoding UNICODE: 0xed
but, after:
DHY_JJG=# \encoding gbk
DHY_JJG=#\dt
woule be ok.
This is a risk no matter what encoding is used in
Hi,
I know that the disk space of the database server should never run
out but it can happen.
Which is the worst case? May the database be corrupted?
Mage
--
http://mage.hu
---(end of broadcast)---
TIP 9: the planner will ignore
I would say it all depends on what you want to do with the data.
If you want to look up all the possible occurences for an event, it
might be useful to have the simple solution you described. If you will
only look up the next n occurences starting from a given date, you might
be better off storing
Janning Vygen [EMAIL PROTECTED] writes:
So how do i easily empty all page/file caches on linux (2.4.24)?
Probably the closest you can easily get is to put the Postgres data
files on their own partition, and unmount/remount that partition
before running yuour tests. Unmounting will sync and
[EMAIL PROTECTED] wrote:
I am creating a database which is supposed to contain many data entries
(events) that differ only in the date they occur.
So let's say event 1 occurs every Monday, Tuesday and Sunday between
January 1st and May 30th 2005.
How do I store and manage such data in a meaningful
On Tue, 16 Nov 2004, Jeff Eckermann wrote:
--- Jerry III [EMAIL PROTECTED] wrote:
Which means that sometimes they do not return the
correct value - if you
have a trigger that inserts another record you will
not get the right value.
If you are new to PostgreSQL, as you say, then why
Jeff Eckermann [EMAIL PROTECTED] writes:
--- Jerry III [EMAIL PROTECTED] wrote:
Which means that sometimes they do not return the
correct value - if you
have a trigger that inserts another record you will
not get the right value.
If you are new to PostgreSQL, as you say, then why are
you
I hate to ask for a restriction of the 1st ammendment, but the life of
many colleagues and mine would be much easier if those racists and
idiots would not waste our bandwidth.Nobody but them is -to my beliefs-
interested in their flaming each other.
Please knock them off the board.
with kind
Am Dienstag, 16. November 2004 16:11 schrieb Tom Lane:
This is a risk no matter what encoding is used in the client-side .po
files; as long as it's different from the current client_encoding,
there is a potential for mis-conversion and other problems. I don't
see a simple solution.
Here's
Tino Wildenhain wrote:
Hi,
On Tue, 2004-11-16 at 14:17, [EMAIL PROTECTED] wrote:
Hi Chris and Karim,
I haven't been following this thread, so excuse me if I suggest something
that has already been tossed out.
Solaris allows multiple IP addresses to be assigned to a single NIC. I
just looked at
On Mon, 2004-11-15 at 16:03, Nadeem Bitar wrote:
I've searched unsuccessfully on google and the archives for a technical
comparison of Oracle and PostgreSQL.
Is there any free and recent comparison that covers more than just the
basic differences.
I don't think so. FWIW there is a new
Am Dienstag, 16. November 2004 16:39 schrieb Doug McNaught:
Janning Vygen [EMAIL PROTECTED] writes:
So how do i easily empty all page/file caches on linux (2.4.24)?
Probably the closest you can easily get is to put the Postgres data
files on their own partition, and unmount/remount that
Sorry, but no reply on [EMAIL PROTECTED]
-- Forwarded message --
From: Alejandro D. Burne [EMAIL PROTECTED]
Date: Mon, 15 Nov 2004 15:00:58 +0100
Subject: Problem installing Postgresql on MDK10.0
To: [EMAIL PROTECTED]
I'll be trying to install postgres 8.0b1/b4; when I make the
The world rejoiced as [EMAIL PROTECTED] (Janning Vygen) wrote:
So how do i easily empty all page/file caches on linux (2.4.24)?
You can empty them of PostgreSQL-related data by filling them with
something else.
You might head to some directory that has more data in it than you
have memory, and
Thanks Joshua,
I just played with it and it is more flexible that Solaris. Linux allows
alias to be four characters, but Solaris only allows low numbers. I like
this:
ifconfig eth0:dbms 192.1.1.100 up
Tino's right about the ARP tables. Gotta watch that one, especially with
lower grade
Thanks for the answer.
If I go that way, though, I am afraid I will have very long query times.
And I have no idea how to handle large databases of that kind without
losing performance.
If I store the pattern - is there a way to still perform the query in the
database? Or do I have to do that in
Thanks
The standard case is: I enter a date and 2 parameters of the event and I
get the result set.
Even though with Java date arithmetics are quite simple and I could
therefore extend my software in that fashion, I would much rather perform
all queries entirely in the database.
So in case I go
Title: default Signature
No problem, I replied to save typing the email addresses and forgot to
remove the subject!
You are fine + I apologize! I just got sooo tired of the
'professionalism' that seems to take over and you were 'the lucky
winner' whom I abused as the address template.. I've
When I've said date arithmetics, I was referring to Java date
arithmetics... I've been there, and I can tell you that it's not
pleasant to have the application go haywire 2 times a year on
sommer/winter time switching, and this is not the only thing which can
go wrong - and you'll only see it
Alejandro D. Burne [EMAIL PROTECTED] writes:
I'll be trying to install postgres 8.0b1/b4; when I make the config a
message appear:
configure: error: readline library not found
$ rpm -qa | grep readline
libreadline4-4.3-7mdk
libreadline4-devel-4.3-7mdk
Try looking at the config.log output
guenter strubinsky [EMAIL PROTECTED] writes:
... I've been in this list
(on and off) since more than 3 years now. I was either off or this is
the first time that people forget their basic communication skills
(assuming they had those skills ever)
None of this is coming from actual list
I'm working on a plpgsql function that creates and populates a
temporary table. I would like the function to first drop the temp
table, if it already exists. I'm not sure how to accomplish this,
though. My first inclination was to simply wrap the 'drop table'
command in an exception
On Tue, Nov 16, 2004 at 01:39:45PM -0600, Timothy Perrigo wrote:
begin
execute 'drop table my_temp';
exception
-- do nothing
end;
That didn't work; apparently the WHEN condition is necessary. What
condition should I be trapping for?
I assume you're using one of the 8.0 betas; earlier
That would be the perfect solution for us, but apparantly not for the rest
of the world.
Since they are offering us 4 and saying we can apply for the other 16 in 6
months, I would take that and not try to take an all or nothing attitude.
More of a work with the newsgroup people then against them
Hello,
I'm working on a datatype which I call dnaseq. The basic stuff like
input/output functions, comparison operators, etc., work well.
I have overloaded the CHARACTER_LENGTH function without problems:
CREATE OR REPLACE FUNCTION character_length(dnaseq)
RETURNS integer
AS
--On Dienstag, November 16, 2004 17:39:12 +0100 Alejandro D. Burne
[EMAIL PROTECTED] wrote:
Sorry, but no reply on [EMAIL PROTECTED]
-- Forwarded message --
From: Alejandro D. Burne [EMAIL PROTECTED]
Date: Mon, 15 Nov 2004 15:00:58 +0100
Subject: Problem installing Postgresql on
Matt [EMAIL PROTECTED] writes:
I ask because I'm currently using them to join a single table to rows in
arbitrary tables, something like:
+-+
| JOINME |
+-+
| foreign_oid |
| foreign_id |
| ... |
+-+
Where foreign_oid is the tableoid
Troels Arvin [EMAIL PROTECTED] writes:
I assume this is because the POSITION function uses IN to separate
arguments, in stead of a comma. Is there a way to overload it?
Double-quote position in the create function command --- it's a
keyword.
Be aware also of the argument order gotcha. Per
On Tue, 16 Nov 2004 15:56:00 -0500, Tom Lane wrote:
[... cut advice ...]
Thanks.
How wedded are you to being able to say IN?
It's only a would-be-nice-to-have.
My dnaseq data type exploits the fact that DNA sequences are made from a
very small alphabet (four characters), so strings can be
On Nov 16, 2004, at 2:11 PM, Michael Fuhr wrote:
\set VERBOSITY verbose
SELECT foo();
ERROR: 42P01: table my_temp does not exist
CONTEXT: SQL statement DROP TABLE my_temp
PL/pgSQL function foo line 2 at SQL statement
LOCATION: DropErrorMsgNonExistent, utility.c:144
The error code is 42P01,
On second thought, I am now confused. The data is updatable when using
linked tables, just not when using ADO recordsets connected to forms. I
tried connected to PostGreSQL using DAO, and I got the recordset back, but
it was also non-updatable.
For the time being I am using Linked Tables, even
Ok :))
I am developing a Windows application, under NT 4 version.
I am connecting to database throught ODBC (I had installed postgreSQL
drivers)
My database version... mmm... I am not sure, but I think 7.4.2 version
I am programing in Visual FoxPro 8.0, but this information is not important
I
You can have a cron job download the file to your local machine and then use
the copy command to process it into your tables. I don't think that copy
would be able to handle an Internet location, though I could be wrong.
chris [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi!
Is
Hy
i have a problem with the following statement:
SELECT MAX(id) FROM apconfig;
if i send this statement i got the following error:
ERROR: column id does not exist
Can anyone explain me this error? There is the column id, and there are
also entries in it.
thx
---(end of
hat pretty much solves my problem. Also I found that Access doesn'r support
ODBC updateable cursors until at least Access 2002 (we're using Access
2000), though I thought I had figured out how to get around that and it
didn't work.
I assumed the ODBC driver did support updateable cursors simply
Marc G. Fournier [EMAIL PROTECTED] wrote:
On Sat, 13 Nov 2004, Gary L. Burnore wrote:
This isn't about encouraging ISP's to carry your lists. It's about
fixing a problem caused by your list's gateways.
A problem that you perceive, yet nobody else seems to ... very isolated
problem ...
Hi!
Is there any Way or have somebody a Function to do something like this
copy skurs from
'http://ichart.finance.yahoo.com/table.csv?s=TKAG.DEd=10e=15f=2004g=da=3b=5c=1991ignore=.csv';
Would be great if you could help me!
THX
Christian Meier
---(end of
[EMAIL PROTECTED] (Brian {Hamilton Kelly}) writes:
(Personally, I blame the original authors of Netscape for incorporating a
news reader that could access multiple servers. Before then, most
readers of news had no option other than to read ALL their desired
newsgroups from ONE server, that of
Of course you would only want a cron job if you wanted to automate the
process. Otherwise you would just download the file and save it and then use
the copy command.
Sim Zacks [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
You can have a cron job download the file to your local
How do you make use of this? It seems like you would need your code to know
which foreign_oid referred to which table to actually perform the join.
Sorry, wasn't very clear about what it does:
select * from mytable t left join joinme j on t.id = j.foreign_id and
t.tableoid = j.foreign_oid;
I have batch files with entries such as
INSERT INTO country VALUES (248,'ALA','AX','Åland Islands');
INSERT INTO country VALUES (384,'CIV','CI','Côte d\'Ivoire');
I tried to execute them using pgsql \i filename.sql
Unfortunately, I keep getting an error message:
ERROR: invalid byte sequence
On Mon, Nov 15, 2004 at 01:44:47PM +0100, Sandro Daehler wrote:
SELECT MAX(id) FROM apconfig;
if i send this statement i got the following error:
ERROR: column id does not exist
Can anyone explain me this error? There is the column id, and there are
also entries in it.
The column
I have to execute fairly large batch files (200-300MB) with several million
INSERT commands.
When I do that from pgsql using the \i switch, I get the echo
INSERT 0 1
for every single insert statement of my batch file.
Since I assume that this slows down the whole process I would like to know
if
I have batch files with entries such as
INSERT INTO country VALUES (248,'ALA','AX','Åland Islands');
INSERT INTO country VALUES (384,'CIV','CI','Côte d\'Ivoire');
I tried to execute them using pgsql \i filename.sql
Unfortunately, I keep getting an error message:
ERROR: invalid byte
On Wed, Nov 17, 2004 at 02:17:16AM +0100, [EMAIL PROTECTED] wrote:
I have to execute fairly large batch files (200-300MB) with several million
INSERT commands.
Can these files be rewritten to use COPY instead of INSERT?
Performance might improve.
When I do that from pgsql using the \i
Michael,
I don't mind at all.
3.244 ms compared to 15706.179 ms.
A sizeable difference.
Screen scraps follow.
Allan
mill2= set enable_seqscan=off\g
SET
mill2= explain analyse select count(*) from history where pointname =
'MILL2-SPEED' and dt (now() - interval '5 minutes')::timestamp\g
On Wed, Nov 17, 2004 at 12:41:20PM +1100, Harvey, Allan AC wrote:
mill2= explain analyse select count(*) from history where pointname =
'MILL2-SPEED' and dt (now() - interval '5 minutes')::timestamp\g
How typical is this query? How many distinct values does pointname
have? Have you
Thank you for your response, however that is not what I am trying to do.
I would like to be able to add records and modify data directly in the form.
What I was trying to do was grab an ADO recordset and attach it to the form,
which works fine, but then the data is not updatable.
I found a MS
On Monday, in article
[EMAIL PROTECTED]
[EMAIL PROTECTED] Tim Skirvin wrote:
[EMAIL PROTECTED] (Brian {Hamilton Kelly}) writes:
(Personally, I blame the original authors of Netscape for incorporating a
news reader that could access multiple servers. Before then, most
readers of
Hi all
I have to develop an embedded database using
memoryFLASH and memory RAM
Some tables must be saved in RAM and some tables in
FLASH ( RAM and FLASH are two different mounted directoriesin the file
system).
I sawit's possible to savedifferent
databases in different directories with
Martijn van Oosterhout wrote:
Let's start with the version of postgresql you're using.
Next, were you running VACUUM FULL regularly?
It sounds like XID wraparound to me, no idea how to solve that. Got
backups?
On Wed, Nov 10, 2004 at 12:56:33PM +0200, Liviu BURCUSEL wrote:
Hi !
I'm in the ultimate
Nice interface, but its crippleware. Anything that may be of use is locked
out from testing exactly what they would tell me. I tried to run reports.
Need to purchase. Tried to diagram but not sure what that did for me other
than tell me what tables I already had. could see some benefit for
If you have a primary key you can self join the table on the rows that would
define a table as duplicate and delete the one with a higher primary key
field. If the table is related to other tables (ie the pk is an fk in
another table) you have to make sure you update all the rows to point to the
I have a table that is essentially a log where new entries are streaming in
continually and from time to time I throw old entries away to
keep the table from growing.
I understand that in addition to issue a
DELETE FROM log WHERE date xxx
I also need to issue a
VACUUM log
so that new
1 - 100 of 103 matches
Mail list logo