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 col
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 set
"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
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:
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 tgreli
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.
When
"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 nee
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 rel
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 del
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 som
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 f
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
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: --->
>
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?
Ray
"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 g
-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 up
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 point
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 t
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 y
-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 overru
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ow Mun Heng wrote:
> 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
Just a short background.
using Perl-DBI to pull data from mssql into PG and \copy into a temp
table where the following is done.
my $query1 = "DELETE FROM $table_name
WHERE $unique_id in
(SELECT $unique_id from $table_name_loading)";
my $query2 = "INSERT INTO $table_n
On Mon, 2007-09-17 at 09:42 +0800, Ow Mun Heng wrote:
> On Mon, 2007-09-17 at 09:21 +0800, Ow Mun Heng wrote:
> > Hi,
> >
> > I want to use a SRF to return multi rows.
> >
> > current SRF is pretty static.
> >
> > create type foo_type as (
> > id smallint
> > data1 int
> > data2 int
> > )
> >
>
I'm just starting with pgcrypto, and I'm curious if it's
needed/recommended to use an initialization vector/value (IV) with
the pgp_sym_encrypt() function.
The docs hint that an IV is used automatically, but encrypting plain
text that starts the same seems to result in initial common cipher
text.
Hi,
I have 3 tables
foo
foo_loading_source1
foo_loading_source2
which is something like
create table foo (a int, b int, c int)
create table foo_loading_source1 (a int, b int, c int)
create table foo_loading_source2 (a int, b int, c int)
Is there a way which can be made easier to keep these 3 t
31 matches
Mail list logo
