NTO master VALUES ( 2, 3) ;
UPDATE master SET m2 = m2+1 ;
- Original Message -
From: Anoo Sivadasan Pillai
To: Ardian Xharra
Cc: pgsql-general@postgresql.org
Sent: Tuesday, September 25, 2007 12:27 AM
Subject: Re: [GENERAL] Why the ERROR: duplicate key violates unique
Probably you are using a sequence, and if so you need to update the value of
sequence prior to update:
SELECT setval('master_m1_seq',((SELECT id_m1 FROM master ORDER BY 1 DESC LIMIT
1)+1));
- Original Message -
From: Anoo Sivadasan Pillai
To: pgsql-general@postgresql.org
Cc: A
You can use kill PID
- Original Message -
From: Ashish Karalkar
To: pggeneral
Sent: Tuesday, April 10, 2007 8:01 AM
Subject: [GENERAL] Kill session in PostgreSQL
Hello all,
is there any command just like ORACLE Uses kill session to kill a particular
session .
tried wit
Yes, the problem was the memory (testing with memtest)
I took us long to have the machine check
Thanks,
- Original Message -
From: "Richard Huxton"
To: "Ardian Xharra" <[EMAIL PROTECTED]>
Cc: "postgreSQL postgreSQL"
Sent: Friday, November 17, 200
chard Huxton"
To: "Ardian Xharra" <[EMAIL PROTECTED]>
Cc: "postgreSQL postgreSQL"
Sent: Friday, November 17, 2006 5:44 AM
Subject: Re: [GENERAL] Why the data changes it's value by itself!
Ardian Xharra wrote:
For the column: date(varchar 8) '2000606'
sale=28382
gives: 48
regards Ardian
- Original Message -
From: "Richard Huxton"
To: "Ardian Xharra" <[EMAIL PROTECTED]>
Cc: "postgreSQL postgreSQL"
Sent: Thursday, November 16, 2006 1:47 PM
Subject: Re: [GENERAL] Why the data changes it's value
No, sorry about the name of the table it's the same table.
Yes, the change is in live database during a select
Regards, Ardian
- Original Message -
From: "Richard Huxton"
To: "Ardian Xharra" <[EMAIL PROTECTED]>
Cc: "postgreSQL postgreSQL"
S
Hello,
We been having a problem lately with some data changing their value without
modifying them.
We used to backups to see the difference:
this was the first backup
INSERT INTO journal
VALUES(28382,698,754,7116,7,0.01,'20060606','15415773',1,3,4,1,1,5,77,1,17,2,1,1,15,1,1,2,0,32252,0,14183,0,
Yes, the Symantec Antivirus.
We are going to modify A/V to not scan the database
Thanks for your time
- Original Message -
From: "Shelby Cain" <[EMAIL PROTECTED]>
To: "Ardian Xharra" <[EMAIL PROTECTED]>
Cc: "postgreSQL postgreSQL"
Sent: Wed
- Original Message -
From: "Jeff Davis" <[EMAIL PROTECTED]>
To: "Ardian Xharra" <[EMAIL PROTECTED]>
Cc: "postgreSQL postgreSQL"
Sent: Tuesday, November 14, 2006 2:12 PM
Subject: Re: [GENERAL] Data corruption
On Tue, 2006-11-14 at 13:34 -05
Hi all,
We have a database installed on Intel Xeon (Dell) and running on postgreSQL
8.1.
And the database couldn't start. Here is the logfile of what happend:
2006-11-14 00:28:38 PANIC: could not write to log file 6, segment 239
at offset 6430720, length 16384: Permission denied
2006-11
If you look on pg_indexes you find the index and
the table.
- Original Message -
From:
Chris Hoover
To: pgsql-general@postgresql.org
Sent: Monday, October 02, 2006 9:19
AM
Subject: [GENERAL] How to trace index to
table?
I'm trying to build some queries t
Go to Start/ Control Panel / Administrative tools / Computer Management /
and you see Local Users and groups
Delete the user from there
- Original Message -
From: "Gibson" <[EMAIL PROTECTED]>
Cc: "pgsql general"
Sent: Friday, September 01, 2006 2:31 AM
Subject: Re: [GENERAL] Fatal erro
Sorry, the exact version is
PostgreSQL 7.3.3 on sparc-sun-solaris2.8, compiled by GCC gcc (GCC) 3.3.2
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Ardian Xharra (Boxxo)" <[EMAIL PROTECTED]>
Cc: ; "Martijn van Oosterhout"
Sent:
No, it doesn't work always the same message:
ERROR: parser: parse error at or near "(" at character 47
- Original Message -
From: "Martijn van Oosterhout"
To: "Ardian Xharra (Boxxo)" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, April 05, 2006 3
Hello,
I have a client who is still using the version 7.4.3
and creating an index like this doesn't work:
CREATE INDEX client__ascname__idx ON client
(TO_ASCII(lower(name),'LATIN 1'));
Does exists another way of creating an index in varchar who take
on consideration also the accents
I'm having some troubles restoring a database on Windows and I found this
difference between PostgreSQL running on Linux and Windows.
When I create a table like this:
CREATE TABLE fee_payment1(id_fee_payment1 serial NOT NULL) WITH
OIDS;
On Linux platform it will be:
CREATE TABLE fee_p
Hello, there
I installed PostgreSQL on windows and when I try to
run some query's pgadmin says an error. I know that if I change the query this
it will work but is it possible to make this quey work in this
way
SELECT atthasdef FROM pg_attribute WHERE
attrelid=pg_class.oid AND pg_class.rel
Thank you Micheal it was the add_missing_from
And sorry for the last post I didn't read the whole message from you.
Ardian
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.11/219 - Release Date: 02/01/2006
I was doing the queries in SQL
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Ardian Xharra (Boxxo)" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, January 02, 2006 4:29 PM
Subject: Re: [GENERAL] Query in postgreSQL version Windows
> On Mon, Jan
Hello, there
I installed PostgreSQL on windows and when I try to
run some queries pgadmin says an error. I know that if I change the query this
it will work but is it possible to make this quey work in this
way
SELECT atthasdef FROM pg_attribute WHERE
attrelid=pg_class.oid AND pg
Hello, there
I installed PostgreSQL on windows and when I try to
run some queries pgadmin says an error. I know that if I change the query this
it will work but is it possible to make this quey work in this
way
SELECT atthasdef FROM pg_attribute WHERE
attrelid=pg_class.oid AND pg
22 matches
Mail list logo
