Hi,
We have found a possible bug in 7.3.1. It seems that using CROSS JOIN and
doing plain Cartesian product, listing to tables in the from clause, gives
different results. According to the documentation this should be
equivalent. The following example should explain the problem:
CREATE TABLE a
Really solid microcode actually reads the sectors
just written and confirms the write at the hardware level
by comparing it with what is in the controller memory.
It then returns with a successfull confirmation or an error
if differences were detected.
Any data storage device controller, disk,
On Tue, Oct 28, 2003 at 04:57:34PM +0100, Marco Colombo wrote:
> processing. Try and do the same in any other language, with less
> keystrokes:
>
> find / -print0 | perl -ln0e 'print if -p'
I would imagine:
find / -type p
is shorter, but that probably wasn't your point :)
--
Martijn van Ooste
Native windows support is not available in postgresql-7.4.
Hopefully it will be in 7.5
Cheers,
Claudio
-Original Message-
From: Raghu Holla
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 10/28/03 8:49 PM
Subject: [CYGWIN] Info Required!!
Hi,
Could you please let me know whether po
Dennis Gearon <[EMAIL PROTECTED]> writes:
> Is ist possible for a trigger to fork off a 'reindex' command and the
> trigger terminates leaving the reindex running?
Even if possible, ick.
I'd say the best thing to do would to have such a trigger set a flag
(value in a one-row table) and have a cr
"mlunnon @ RWA" <[EMAIL PROTECTED]> writes:
> I get:
> psql:Supplements.sql:34: ERROR: Type "test_type[]" does not exist
> psql:Supplements.sql:41: ERROR: Type "_test_type" does not exist
It works for me ... are you sure it's not something silly like mistyping
the type name, or adding/omitting d
Dave Weaver wrote:
- clustering the "obs" table on "station"
Sorry, I don't understand what you mean by this - can you explain?
Supposing obs_pkey is on (station, valid_time):
cluster obs_pkey on obs
will re-order the rows in obs based on the index obs_pkey. (This is
clustering on 'sta
quick answer: research/read the pg_hba.conf in the data directory.
Jeff MacDonald wrote:
Hi,
WHen i run pg_dumpall as the super user [postgres in my case] it asks
for a password for every database. I don't know my users passwords. Is
there a way to make the super user able to backup without pass
On Tue, 28 Oct 2003, Ati Rosselet wrote:
> I have several tables with common FKs.. the problem occurs when
> performing a large number of inserts on any of the tables at the same
> time. The first to start inserting seems to get a lock on the
> referenced FK tables and doesn't release them until
Åsmund Kveim Lie <[EMAIL PROTECTED]> writes:
> SELECT * FROM a,b NATURAL JOIN c;
This parses as
select * from a, (b natural join c)
> SELECT * FROM a CROSS JOIN b NATURAL JOIN c;
This parses as
select * from (a cross join b) natural join c
> These two example queries should give the same re
DeJuan Jackson wrote:
quick answer: research/read the pg_hba.conf in the data directory.
Jeff MacDonald wrote:
Hi,
WHen i run pg_dumpall as the super user [postgres in my case] it asks
for a password for every database. I don't know my users passwords. Is
there a way to make the super user able
I use postgresql 7.2.3
How can I use connectby ??
Must I install files ? or packages ? or it is recommanded to upgrade
dataserver ?
George Essig wrote:
hi
I have menu table:
id | integer | not null default
nextval('public.menu_id_seq'::text)
parent_id | integer |
Well, bought a new disk to my Powerbook yesterday and reinstalled Mac
OS X. I'm in the middle of restoring everything now, and need to know
where the database files where located. I thougt /usr/local/pgsql/data
would be the appropriate place, but can't find anything there that
makes sense…
Reg
I'm having severe performance issues with a conceptually simple
database. The database has one table, containing weather observations.
The table currently has about 13.5 million rows, and is being updated
constantly. The database is running on a dual 550MHz PIII with 512MB RAM.
On the whole, que
Is there an easy way (similar to COPY) to import fixed width text files
directly into Postgres tables?
COPY is fine for files with delimited fields, but I have fixed format text
files to import into tables.
Thanks,
Brent Wood
---(end of broadcast)-
Title: Message
Good
morning,
I have a contact who
is looking to speak with up to five (5) individuals regarding: open-source DBMS,
end users who are using PostgreSQL in applications that they are
using to run their business and ISVs who have based their applications on
PostgreSQL.
If yo
On Mon, Oct 27, 2003 at 06:25:46PM -0700, [EMAIL PROTECTED] wrote:
> [EMAIL PROTECTED] pgsql]$ postmaster -V
> postmaster (PostgreSQL) 7.1.3
This is pretty old already.
> EXEC SQL FETCH stck_info_crsr INTO :i_symbol :i_data_date, :i_open, :i_high,
> :i_low, :i_close, :i_volume;
If this is taken
Vivek Khera wrote:
"DM" == Doug McNaught <[EMAIL PROTECTED]> writes:
DM> The index bloat problem can occur when you have a an indexed SERIAL
DM> column whose value always increases, and you delete older rows on a
DM> regular basis. VACUUM recycles the row storage, but the index never
Looks like the new DB might have been initialized with a different locale. Read
about locales and initdb in the docs.
Good luck.
Fernando.
En un mensaje anterior, Pedro Miguel Guedes escribió:
[...]
>
> The problem seems to be on accent on letters. So I thought maybe some stuff
> on charsets/en
v7.2.2
When an insert fails because its in violation of an index (duplicate), I get
a return code 7 (PGSQL_FATAL_ERROR) in my php 4.2.3 interface.
Its not really a fatal error, is it? Shouldn't it be reported as a
NONFATAL_ERROR ?
I have a "dumb" synchronizing task, that attempts to import a
Dear sirs
I have a crazy problem here.
Nobody seems to known why.
I am not a database expert nor do known much about
Postgres.
I am just a system administrator trying to move a database from
one system to another.
O the old system (slackware linux) the postgres was downloaded
an compiled from sour
Hi everybody.
Is there any way to alter the order the columns appear in a table (apart from using
views)?
I tried changing attnum from pg_attribute... but I could only mess the server up!
Successive INSERT command crashed it until I restored the previous order... :-\
If the answer was "You hav
I'm running PostgreSQL 7.3.4 on Windows 2000/Cygwin (AMD Athlon XP+
1800, 512MB RAM).
I want to insert about 500 records into a table. The table is heavily
indexed (has about 10-12 indices created on it). The insert is performed
in a transaction block.
If I keep the indices on the table, the i
On Tue, 28 Oct 2003 [EMAIL PROTECTED] wrote:
>
> In trying to trim some data while selecting and loading from 2 tables
> into 1 I get the following:
>
> SELECT TRIM(TRAILING ' ' FROM s.strk_sym_cmplt), TRIM(TRAILING ' ' FROM
> s.stk_sym), s.c_p, o.dta_date, o.dta_date_num, o.dta_date_dys, o.strk_s
Kolus Maximiliano <[EMAIL PROTECTED]> writes:
> In order to get this, I run this query:
> SELECT ip, TO_CHAR(date, '-MM-DD'), protocol, port
> FROM tProxyPort, tProxyList, tProxyHost
> WHERE tProxyPort.listId=tProxyList.listId
> AND tProxyList.output=tProxyHost.hostId
> ORDER BY i
Perhaps I am not the appropriate one to mention this (and if you already
have a QA group,GREAT!!!) since I am not a
Postgres developer but... Is there any QA group that looks at the
design specs and does independent desk checking and test writting
according to those specs and then tests the code
I use postgresql 7.2.3
How can I use connectby ??
Must I install files ? or packages ? or it is recommanded to upgrade
dataserver ?
George Essig wrote:
hi
I have menu table:
id | integer | not null default
nextval('public.menu_id_seq'::text)
parent_id | integer |
Hi
I had a customer with a similar problem to you. I believe the solution
to your problem is to set the UseDeclareFetch to Yes. I believe this
stops it from doing the query on the Client.
Emmon Simbo
OpenLink Software
[EMAIL PROTECTED] (moonman) wrote in message news:<[EMAIL PROTECTED]>...
> H
In trying to trim some data while selecting and loading from 2 tables
into 1 I get the following:
SELECT TRIM(TRAILING ' ' FROM s.strk_sym_cmplt), TRIM(TRAILING ' ' FROM
s.stk_sym), s.c_p, o.dta_date, o.dta_date_num, o.dta_date_dys, o.strk_sym,
o.strk_yr, s.strk_num, s.exp_sym, s.exp_mo, s.exp_mo
I have several tables with common FKs.. the problem occurs when
performing a large number of inserts on any of the tables at the same
time. The first to start inserting seems to get a lock on the
referenced FK tables and doesn't release them until its done, forcing
the other apps to just wait... a
On Tuesday 28 October 2003 14:33, Jaime Casanova wrote:
> Hi everybody, can anyone tell me if there's a way to retrieve the select
> instruction executed from the catalogs, or maybe via some structure in a
> trigger?
>
> The reason is that i have some selects constructed on-the-fly (just part of
>
On Fri, Oct 31, 2003 at 11:20:27AM -0300, Carmen Gloria Sepulveda Dedes wrote:
> I have pgsql 7.3.4 and ecpg 2.10.0
>
> Does exists a patch for this version?
No, but it is rather simple. Just search for "Unterminated" in
preproc/pgc.l and you'll find some mmerror() calls. In these calls just
repl
Title: RE: [GENERAL] problem with huge joins
> > Total runtime: 317046.69 msec
Total runtime: 216001.94 msec
A lot better! Thanks!
> The hash indexes are a waste of time for this :-(
Which kind should I use?
I have a challenge to be able to grant all to the database, and then
have subsequent tables accessible by all users.
It seems to me that this is how a database should work. I do realize
that postgres doesn't do this now. Is there a way around this? Using
rules or some other mechanism?
Dave
--
Da
> "DM" == Doug McNaught <[EMAIL PROTECTED]> writes:
DM> The index bloat problem can occur when you have a an indexed SERIAL
DM> column whose value always increases, and you delete older rows on a
DM> regular basis. VACUUM recycles the row storage, but the index never
DM> shrinks.
I get this
35 matches
Mail list logo
