Try:
select * from "Dx";
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 11:17 AM
To: [EMAIL PROTECTED]
Subject:relation does not exist
I am trying to convert a MS SQL database to postgres. I have done it
t
I'd like to do a copy of a text file into a table. I follow the procedure and it
works fine, except default values for empty fields are never enacted. I have a
timestamp field which uses "DEFAULT CURRENT_TIMESTAMP". It never gets fired
during a "copy from...", although it works fine for "insert in
Do you have any triggers or constraints defined
on that table?
What does
select * from pg_proc where oid=1646;
show?
On Mon, 26 Feb 2001, guard wrote:
> error message
>
> getTables(): relation 'adju':cannot find function with oid 1646 for
> trigger.
>
You can use the serial type to make the id,
although serial only guarantees uniqueness
not sequential numbers. something like:
create table foo (
id serial primary key,
name text
);
On Mon, 26 Feb 2001, si wrote:
> Hi,
>
> I am new to postgresql, Please can you guide me:
>
> I have created
Hi,
I am new to postgresql, Please can you guide me:
I have created a table and I would like all the entries to be indexed with a number
when the data is entered into the database, hence giving it a new id, every time some
data is entered.
e.g.
I.D.| Name
1 | Jack
2 | J
hi i'm re-sending this mail again to seek more help since i haven't got
any solution as yet. Additionaly , could it be an oracle taking up so much
resource so that i postgres can't get any of them?
Katsu
-- Forwarded message --
Date: Sun, 18 Feb 2001 15:27:47 +1100 (EST)
From
error message
getTables(): relation 'adju':cannot find function with oid 1646 for
trigger.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> R D <[EMAIL PROTECTED]> writes:
> > i'm storing col1 to col3 as integers to save
> storage
> > space(infact they are fixed point).I have many
> tables
> > ctrated using this template only the view devidor
> > constants are different for each table. Here t
