alonso wrote:
I've got it, but I don't know the reason of it.
In the database table the records have duplicated and I've
two rows for
every primary key - with different OIDs.
Very strange however...
Very strange indeed.
Are you positive that there is a primary key constraint on
the column?
Hi,
I noticed that I have too many records in my pg_ catalog files with the same
name. For example
if I give this query, which checks for the triggers that do not have
corresponding tables in the pg_class
select * from pg_trigger where tgrelid not in (select relfilenode from
pg_class),
I get
Josh Harrison [EMAIL PROTECTED] writes:
if I give this query, which checks for the triggers that do not have
corresponding tables in the pg_class
select * from pg_trigger where tgrelid not in (select relfilenode from
pg_class),
This query is wrong --- relfilenode is not a join column for any
Thanks Tom.
I tried it using pg_class.oid and I still have some records which r not in
the pg_class files. What can I do about that?
(BTW what does relfilenode in pg_class stands for?)
Thanks again
Josh
On 9/17/07, Tom Lane [EMAIL PROTECTED] wrote:
Josh Harrison [EMAIL PROTECTED] writes:
if I
On Sep 17, 2007, at 9:02 AM, Josh Harrison wrote:
On 9/17/07, Tom Lane [EMAIL PROTECTED] wrote: Josh Harrison
[EMAIL PROTECTED] writes:
if I give this query, which checks for the triggers that do not have
corresponding tables in the pg_class
select * from pg_trigger where tgrelid not in
Thanks Eric,
ll try to explain as much as possible
When i try to give this query
UPDATE payment
SET desc='New description'
WHERE payment_id='xyz'
I got the error
ERROR: could not open relation with OID 672178
This error was consistent for this query and it yielded the same OID every time.
Josh Harrison [EMAIL PROTECTED] writes:
Yes...there is a relation in pg_class with the name 'payment' but its oid is
not 672178. So why is it giving me could not open relation with OID 672178
when i try an update statement ?
Well, are there any other relations that the UPDATE might need to
Hi
Sometimes when I create a table with the
CREATE TABLE sql command,
it creates a table but with some warnings
For example, I create this table in Aqua studio as
create table foo(col1 varchar2);
gives
Warnings: ---
W (1):
---
0 record(s) affected
The table is created. So
On Sep 17, 2007, at 11:57 AM, Josh Harrison wrote:
On 9/17/07, Tom Lane [EMAIL PROTECTED] wrote: Josh Harrison
[EMAIL PROTECTED] writes:
When i try to give this query
UPDATE payment
SET desc='New description'
WHERE payment_id='xyz'
I got the error
ERROR: could not open relation with
On Sep 17, 2007, at 12:31 PM, Josh Harrison wrote:
Thanks.
Actually Im currently testing oracle to postgres migration with a
small dataset. I haven't started working with the real dataset. I
wanted to check with a small dataset before I start with the big one.
I know the records that I
On 9/17/07, SHARMILA JOTHIRAJAH [EMAIL PROTECTED] wrote:
sorry about that. I copied it.This is proper one
create table foo(col1 varchar);
i use aqua studio
Can you copy the error too? Or is it in some kind of popup that makes
it hard to do? It just seems odd that you get a warning with
sorry about that. I copied it.This is proper one
create table foo(col1 varchar);
i use aqua studio
Thanks
Scott Marlowe [EMAIL PROTECTED] wrote: On 9/17/07, SHARMILA JOTHIRAJAH wrote:
Hi
Sometimes when I create a table with the
CREATE TABLE sql command,
it creates a table but with some
Hi,
Yes...there is a relation in pg_class with the name 'payment' but its oid is
not 672178. So why is it giving me could not open relation with OID 672178
when i try an update statement ?
I use version 8.2. I think the problem started when i manually deleted some
rows from the pg_class catalog
Ow Mun Heng escreveu:
I've created a new custom datatype
eg:
create type foo as (
id smallint
data1 int
data2 int
)
to view the datatype in psql I do
= \d foo
what is the equilvalent on pgadmin3 or any other SQL query tool?
Within pgAdmin3: File Option Display tab set Types
As i
Hi
I had installed postgresql-8.2.4 and tsearch2 with dictionary spanish.
My problem is:
prueba=# select to_tsvector('espanol','melón');
ERROR: Affix parse error at 506 line
And if execute:
prueba=# select lexize('sp','melón');
lexize
-
On 9/17/07, SHARMILA JOTHIRAJAH [EMAIL PROTECTED] wrote:
Hi
Sometimes when I create a table with the
CREATE TABLE sql command,
it creates a table but with some warnings
For example, I create this table in Aqua studio as
create table foo(col1 varchar2);
gives
Warnings: ---
W (1):
On 15/09/2007 14:53, rihad wrote:
I'm still unsure if the timezone issue is at all important when
comparing timestamps (greater/less/etc), or when adding intervals to
preset dates?
Do you have situations where the interval you're dealing with spans a
change between winter summer time?
Josh Harrison [EMAIL PROTECTED] writes:
When i try to give this query
UPDATE payment
SET desc='New description'
WHERE payment_id='xyz'
I got the error
ERROR: could not open relation with OID 672178
Hmm, there apparently *is* a pg_class row for relation 'payment', else
you'd not get this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I wanted to drop a line and let everyone know that the current list of
speakers has been finalized for the conference. The list and their talks
can be found here:
http://www.postgresqlconference.org/
A general synopsis of each talk will be
Thanks for the advice, for right now I went with the second option of
preprocessing the text before passing it to the to_tsquery.
However I would like to see what it would take to get some of the
dictionaries available out there to be hooked into the postgres on windows.
Does anyone have any
Thanks.
Actually Im currently testing oracle to postgres migration with a small
dataset. I haven't started working with the real dataset. I wanted to check
with a small dataset before I start with the big one.
I know the records that I deleted from the pg_class file. so what do i do
next? Will it
On Mon, 2007-09-17 at 17:28 -0300, Roberto Spier wrote:
Ow Mun Heng escreveu:
I've created a new custom datatype
to view the datatype in psql I do
= \d foo
what is the equilvalent on pgadmin3 or any other SQL query tool?
Within pgAdmin3: File Option Display tab set Types
Just wondering how everyone is doing aggregration of production data.
Data which runs in the vicinity of a few million a week.
What are the methods which will effectively provide the
min/max/average/count/stdev of the weekly sample size based on different
products/software mix etc.
and still be
The manual is vague. Several threads about this, in language that is
ambiguous to me.
So a YES/NO question:
Q: To get rid of index bloat, is a VACUUM ANALYZE enough? Or must I
reindex/cluster indexes?
Thanks.
---(end of broadcast)---
TIP 3: Have
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Phoenix Kiula wrote:
The manual is vague. Several threads about this, in language that is
ambiguous to me.
So a YES/NO question:
Q: To get rid of index bloat, is a VACUUM ANALYZE enough? Or must I
reindex/cluster indexes?
If you overrun your
On Mon, 2007-09-17 at 22:14 -0700, Joshua D. Drake wrote:
Phoenix Kiula wrote:
So a YES/NO question:
Q: To get rid of index bloat, is a VACUUM ANALYZE enough? Or must I
reindex/cluster indexes?
If you overrun your max_fsm_pages, no:
else yes;
Maybe my english suck, but I don't
26 matches
Mail list logo