'
)
This should give the same result set, but it's really faster than the
previous one, more than one thousand time faster.
Is there a reason for this huge difference of performance?
Thanks in advance.
--
Olivier Hubaut
North Bears Team
SCMBB - ULB
---(end of broadcast
On Mon, 29 Nov 2004 12:19:12 +, T E Schmitz
[EMAIL PROTECTED] wrote:
Hello,
I need to be able to perform wildcard searches on a VARCHAR(100) column
of the form
SELECT * FROM item WHERE serial_no LIKE '%12345678%'
Would an index on serial_no do anything at all for this search?
No, It
Hi,
I've a strange bug on PgSQL 7.3.3 with function, constraints and
transactions.
As the foreign key are too heavy for a massive insert, even set defered,
we've decided to put them in a function in order to enable/disable them.
So, in such a transaction, first we disable the constraints,
On Tue, 6 Apr 2004 14:32:04 +0530, kumar [EMAIL PROTECTED] wrote:
Dear Friends,
Postgres 7.3.2 on Linux 8.
I wanna move about 100 tables from one schema to another (within a
database). Is possible to do that? Seems pg_dump doesnt have an option
to script only the schema.
Else, it possible
On Wed, 31 Mar 2004 10:33:20 -0500, Tom Lane [EMAIL PROTECTED] wrote:
Olivier Hubaut [EMAIL PROTECTED] writes:
When I want to execute this set of queries in a function:
...
It takes only 2 seconds.
But when I tried to do it directly in the psql term (replacing the $1
value with the same used
I'm doing some test on our PgSQL 7.3.4 and I can't believe what I see:
When I want to execute this set of queries in a function:
DELETE FROM oly.amaze_log_report WHERE batch = $1 ;
INSERT INTO oly.amaze_log_report
SELECT $1, 'DATA', 'MISSING_NEWREF_DECLARATION', 'ERROR', tmp.error_count,
Tom Lane wrote:
van Elsacker Frans [EMAIL PROTECTED] writes:
All my tables (more than 100) have a field datumi of type date default
today, as this example:
CREATE TABLE tabel (
datumi date DEFAULT 'today',
);
This does not work anymore in PG 7.4. You need something like
I'm trying to do a create function using JDBC 3,0 in Eclipse IDE with JFaceDBC plugin.
This function doesn't work:
CREATE FUNCTION @[EMAIL PROTECTED]@[EMAIL PROTECTED] ()
RETURNS boolean
LANGUAGE SQL
AS '
ALTER TABLE @[EMAIL PROTECTED]@[EMAIL PROTECTED]
Sorry for this misplaced question.
Olivier Hubaut wrote:
[snip]
--
Ci-git une signature avortee.
** RIP **
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I can put all the other constaints deferrable, but the *NOT NULL* one
seems to be undeferrable.
Is ther a way to by-pass this or is do you know if this is planned in
the future versions?
--
Ci-git une signature avortee.
** RIP **
---(end of
Hi,
I tried to use the COPY function in v7.3.4 but I have a problem.
According to the documentation, anyboy having the good rights on the
table he want to copy could do it without any problem.
When I tried it, I found that using this command is impossible if you
aren't an administrator for
11 matches
Mail list logo