Patrick,
> I tried recently (pgsql 7.1.2) to establish the oid of one table as
> foreign key
> in another.
> To no avail : there was no uniqueness constraint on that column
> Naturally, it seems impossible to add a uniqueness constraint to such
> a system
> column.
> As far as i know, the oid
On Tue, 11 Sep 2001 [EMAIL PROTECTED] wrote:
> hello all
> I tried recently (pgsql 7.1.2) to establish the oid of one table as foreign key
> in another.
> To no avail : there was no uniqueness constraint on that column
> Naturally, it seems impossible to add a uniqueness constraint to such a sys
hello all
I tried recently (pgsql 7.1.2) to establish the oid of one table as foreign key
in another.
To no avail : there was no uniqueness constraint on that column
Naturally, it seems impossible to add a uniqueness constraint to such a system
column.
As far as i know, the oid is by nature uniqu
(hopefully this doesn't double post... stupid mail system)
On Tue, 11 Sep 2001, Christof Glaser wrote:
> On Tuesday, 11. September 2001 10:04, Kevin Way wrote:
> > I'm having a little trouble with some inherited tables and a foreign
> > key. Here's a simplified case, to show the trouble.
> >
>
On Tuesday, 11. September 2001 11:12, I wrote before I thought:
> On Tuesday, 11. September 2001 10:04, Kevin Way wrote:
> > I'm having a little trouble with some inherited tables and a foreign
> > key. Here's a simplified case, to show the trouble.
> >
> > CREATE TABLE node (
> > node_id
On Tuesday, 11. September 2001 10:04, Kevin Way wrote:
> I'm having a little trouble with some inherited tables and a foreign
> key. Here's a simplified case, to show the trouble.
>
> CREATE TABLE node (
> node_id SERIAL NOT NULL,
> nameTEXT NOT NULL,
> PRIMARY KEY (node_i
Dear all,
I want to do a query to my PostgreSQL database. I want to use it in a PHP web
client that I have got, but also
I have tried in the back-end.
I have the following tables on my database ( I translate the field names from
Spanish into English)
cdroms
---
code_cdroms
items
-
I'm having a little trouble with some inherited tables and a foreign key. Here's
a simplified case, to show the trouble.
CREATE TABLE node (
node_id SERIAL NOT NULL,
nameTEXT NOT NULL,
PRIMARY KEY (node_id)
);
-- works just fine
CREATE TABLE users (
email TEXT
Jeff Barrett wrote:
> Thanks for the suggestions.
>
> I am running 7.1.2 and going to 7.1.3 soon.
>
> If I use pl/tclu or pl/perlu I can call this executable from within the
> code?
>
> I have a signifigant limitation, I cannot duplicate the action of the
> programs I want to call in a program I w
