Hello,
Sorry, I forgot the trigger:
-- public stuff
SET search_path = public, pg_catalog;
CREATE TABLE customer(
customer_id SERIAL,
customer_notification INTEGER,
CONSTRAINT customer_notification CHECK notification = 0) OR
(notification = 1)) OR (notification = 2))),
);
CREATE
Hello,
I have a question about inherited tables w/r to triggers... Hopefully
this will make some sense... (I'll try to keep the schema example as
simple as possible):
Given the follow schema/tables:
-- public stuff
SET search_path = public, pg_catalog;
CREATE TABLE customer(
customer_id SER
Sorry.
I didn't know which list best served general installation questions for the
Windows version. My question has been answered. Thanks for your attention.
Regards,
Hagop
-Original Message-
From: Reini Urban [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 06, 2005 7:27 AM
To: Hagop H.
Hi all, i am trying to restore a database, the dump is produced under
linux using pg_dump, and i get the following error every time:
ERROR: missing data for column "xxx"
CONTEXT: COPY table_yyy, line 18986: "18833 ?Î"
I can restore the dump under linux just fine, both postgresql (under
win32/lin
Hope this is the correct group.
I am running 8.0.1 on XP P4 2.6 1GB for dev work
and the following simple query takes 5+ minutes
to complete. Would like to get this down to <2-3 seconds.
Other RDBMS complete it in <1 second.
select i.internalid, c.code
from local.internal i
inner join country.ip
Disclaimer:
This electronic transmission and any files attached to it are strictly
confidential and intended solely for the addressee. If you are not
the intended addressee, you must not disclose, copy or take any
ac
unsuscribe
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
---(end of broadcast)---
TIP 2: you can get off all lists at
Matthew,
This is from long ago, but I've finally had some time to continue to
investigate the problem of CPU spikes in pg_autovacuum. update_db_list
is provably one of the culprits, but it doesn't seem to be the only
one.
In looking through the code, it doesn't seem as though any vacuuming
can
On Mon, 2005-03-07 at 13:35 -0600, Scott Marlowe wrote:
> Tune both reasonably according the the best practices for each database.
>
Also, you should consult people on the MySQL lists to make sure it's
being tuned properly as well. And make sure both databases have access
to the same hardware res
On Mon, 2005-03-07 at 12:00, Rick Schumeyer wrote:
> Iâm interested in comparing the performance of postgresql and mysql
>
> on various combinations of user loads and database sizes. I have seen
>
> a few statements to the effect of âmysql is faster for small, low use
>
> applications, but post
Rick Schumeyer wrote:
I'm interested in comparing the performance of postgresql and mysql
on various combinations of user loads and database sizes. I have seen
a few statements to the effect of "mysql is faster for small, low use
applications, but postgresql is better for bigger stuff". I would l
I’m interested in comparing the performance of postgresql
and mysql
on various combinations of user loads and database sizes.
I have seen
a few statements to the effect of “mysql is faster for
small, low use
applications, but postgresql is better for bigger stuff”.
I would like
to run
>
> It's a fairly corner case feature, only for the case where you're
> looking for the existance of an index key but don't want any other
> data. I don't personally have any queries that could use such a
> construct, though maybe I'm missing the point.
I understand the difficulty of implementat
On Mon, 7 Mar 2005 13:42:48 -0400, Hugo Takada <[EMAIL PROTECTED]> wrote:
> hello,
>
> Is it possible to restore a DB Schema in a different schema but in the
> same Database? or restore the schema with a different name? or restore
> a set of objects into a different schema from where they were
> b
hello,
Is it possible to restore a DB Schema in a different schema but in the
same Database? or restore the schema with a different name? or restore
a set of objects into a different schema from where they were
backed-up?
thanks in advance
Hugo
---(end of broadcast)-
On Mon, Mar 07, 2005 at 05:06:19PM +0100, FERREIRA William (COFRAMI) wrote:
> is it possible to know the number of rows into a cursor ? does any function
> exists ?
Not without scanning the result. See previous discussion:
http://archives.postgresql.org/pgsql-general/2005-01/msg01264.php
http:/
On Mon, Mar 07, 2005 at 11:31:06AM +0100, Ladislav Linhart wrote:
> I have a question. How is using LIMIT in SELECT on the application layer.
> Create temprorary table before applyes LIMIT ? Exists any way for don't
> create temporary table with all records ?
Could you describe what you're tryin
Title: number of rows in a cursor
hi
is it possible to know the number of rows into a cursor ? does any function exists ?
thanks in advance
Will
On 2/6/2005 4:31 PM, Greg Stark wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
No, Peter.
Posting a vulnerability on a public mailing list "before" there is a known fix
for it means that you put everyone who has that vulnerability into jeopardy.
Vulnerabilities are a special breed of bugs and need to
On Mon, 7 Mar 2005 12:13:37 +0100, Ali B. <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm a new user (novice) of this database. I would like to optimise it...
> I've already created indexes...
> I see that it is possible to use 'Postmaster' in order to...
>
> But how can I use it? I don't know... I'm
Hello,
I'm a new user (novice) of this database. I would like to optimise it...
I've already created indexes...
I see that it is possible to use 'Postmaster' in order to...
But how can I use it? I don't know... I'm using Version 8 with Windows XP
Pro.
Thanks to help me because it's working too
Hi,I have a question. How is using LIMIT in
SELECT on the application layer. Create temprorary table before applyes
LIMIT ? Exists any way for don't create temporary table with all records
?thank you for your answers
LADiS
NTPT wrote:
3: One process, multiple threads, all threads share the same one
persitant connection. Because one thread serve one request in present
time, but threads can run "concurently" (AFIAK ), I am affraid, that
multiple transactions over the single connection in this scenario will
res
Martijn van Oosterhout writes:
> It's a fairly corner case feature, only for the case where you're
> looking for the existance of an index key but don't want any other
> data. I don't personally have any queries that could use such a
> construct, though maybe I'm missing the point.
You don't ha
24 matches
Mail list logo
