Excuse my ignorance but I have browsed TODO list and haven't found
anything...
What is WAL?
Greets.
David
I'd like consulting past messages.
Greets.
David
Hi, all.
An extrange behavior with PostgreSql 7.0.2:
select * from foo where exists
(select * from foo)
works fine. But:
select * from foo where exists
((select * from foo))
shows an error:
ERROR: parser: parse error at or near "("
Is this a bug?
Question is:
I want to use key words like SERIAL, PRIMARY KEY, etc, for creating tables,
but this words create indexes asociated to tables.
If i use COPY to poblate tables, indexes make tranfer very slow.
How can i deactivate indexes temporaly for making a COPY?.
Any other strategy?.
Thanks
Hello.
I have a problem with a script creating database. I don't know where can be
error. Can you help me, please.
* Error:
Relation 'empleado' does not exist
* script:
-8--
create database multi;
\connect multi
On Fri, Nov 24, 2000 at 01:32:38AM +0100, Giovanni Tummarello wrote:
Hello .. on the same machine i have several DBs.. i owuld like to do a query
that joins results from different ones .. is ther eany way to do it in
postgres?
It is in the TODO list. Take a look ;)
Greets.
Hi all.
I want to create a new tuple of main info and detail tuples (in
different tables) that are joined by a key field. Key field is created by
generator automatically and I need that number in order to assign to detail
tuples. How can I to get that number in a safe way?.
Thanks for
On Mon, Feb 12, 2001 at 11:08:55AM +, Oliver Elphick wrote:
DaVinci wrote:
Hi all.
I want to create a new tuple of main info and detail tuples (in
different tables) that are joined by a key field. Key field is created by
generator automatically and I need that number
On Mon, Feb 12, 2001 at 01:08:01PM -, Michael Ansley wrote:
The number returned by the sequence for the serial ID is retained within the
session, and so it can be returned by calling currval, e.g.:
...[a detailed example]...
Typically, the insert for a person, and for all the
On Mon, Feb 12, 2001 at 10:22:30AM -0500, Tom Lane wrote:
DaVinci [EMAIL PROTECTED] writes:
On Mon, Feb 12, 2001 at 01:08:01PM -, Michael Ansley wrote:
Typically, the insert for a person, and for all the associated addresses
would be done in the same transaction so that if the insert
On Tue, Feb 13, 2001 at 09:56:18AM -, Michael Ansley wrote:
Hi,
Well, the number is 'locked', because once it's given to you, that's it,
it's gone from the 'list of available numbers' (i.e.: the sequence).
However, between the insert, and the read of the ID, if another transaction
On Tue, Feb 13, 2001 at 09:52:21AM -0500, Tom Lane wrote:
DaVinci [EMAIL PROTECTED] writes:
procedencia int2 references procedencia,
línea int2 references línea,
empresa int2 references empresa,
Depending on the data values you are working
On Wed, Feb 14, 2001 at 06:34:01AM -0500, Jan Wieck wrote:
DaVinci wrote:
Problem is with referential integrity like you say. But I don't understand
well reason. Interlocks should appear only when values of referenced tables
are changed, added or removed, shouldn't
Hi all.
I want to make a LEFT JOIN of table A with detail tables B and C. How can I
make that?:
SELECT A.*, B.*, C.* FROM A LEFT JOIN B ON A.foo = B.bar ???
I don't know where to put info of JOIN between A and C.
Any help, please? Thanks.
Hello. I have a problem with Postgresql 7.1 beta (Debian packages).
When I am in middle of transaction and there is an error, for example
caused by trying to insert a tupla with a "not null" value without valor, I
get error:
NOTICE: current transaction is aborted, queries ignored
Hello. Only a question.
I have a table and want to make a view updateable with rules. Table has a
sequence that creates default value to primary key when inserting.
And now the question: Is it posible to return value of primary key from
rule of inserting with NEW? Is that value what i
Hello.
When I create next function:
create function pilpot() returns integer as '
declare
foo integer;
begin
foo = insert into aviso(user) values(1);
return foo;
Hello.
I am trying to insert a tupla in a view with rules for inserting from a
function. This is my data:
---
create table direccin (
cod serial primary key,
calle text,
va int2
On Wed, Apr 18, 2001 at 12:55:07PM +0200, Konstantinos Agouros wrote:
I once read in Oracle Performance Tuning, that if one inserts or changes large
amounts of data in a table, it might be better to drop indices before doing
this and recreating them afterwards. Could someone give a hint on
Hi.
I have this rule for inserting in a view:
--
te rule v_address_ins as on insert to v_address do instead
(insert into address(calle,vía,localidad,provincia) values (
NEW.calle,
get_vía(NEW.vía),
get_localidad(NEW.localidad),
On Wed, May 09, 2001 at 10:31:27AM +0200, Renaud Thonnart wrote:
Does PostgreSQL create an index when a table is created?
Yes, with PK.
Does it create index even if there is no PK for this table?
No.
I know that indexes increase performance for SELECT but it is the
contrary when
On Mon, Jun 04, 2001 at 11:12:56PM +0200, Rasmus Resen Amossen wrote:
If I add a where clause on my views, I can't insert or update them
anymore. Why?
Example:
CREATE TABLE temp (a int);
CREATE VIEW tview AS SELECT a FROM temp WHERE a10;
INSERT INTO tview VALUES (13);
ERROR: Cannot
22 matches
Mail list logo