Make sure you're using PostgresQL 7.0 or greater.
Cheers,
Gavin
vijayendra mohan agrawal wrote:
> Hi all,
>
> I have used FOREIGN KEYs in some of my tables, while creating those tables,
> notice message comes :
> "NOTICE: CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented"
>
> Pleas
Hi all,
I have used FOREIGN KEYs in some of my tables, while creating those tables,
notice message comes :
"NOTICE: CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented"
Please tell me what to do, because I have to use the referential integrity.
Thank You,
Best Regards,
Vijay
If your define your table using varchar(32), instead of char(32), your
query will work fine.
--
banghe
Herbert Ambos wrote:
> On Tue, 19 Sep 2000, Vladimir V. Zolotych wrote:
>
> > Hi all,
> > Can you help me a bit ?
> > The question is: how can I compare TEXT and CHAR(32) types ?
> > More d
Hi there,
does anybody know how I can prevent that users which don't own a database
can connect to that database and can create tables in that very database.
Best regards,
Jan-Hendrik Benter
--
#--->
#
# contact me by
#
On Tue, 19 Sep 2000, Vladimir V. Zolotych wrote:
> Hi all,
> Can you help me a bit ?
> The question is: how can I compare TEXT and CHAR(32) types ?
> More detailed description:
> my=> create table foo (tt text, cc char(32));
>
> CREATE
> my=> insert into foo values ('aa', 'ab');
>
>
On Tue, 19 Sep 2000, Vladimir V. Zolotych wrote:
> Hi all,
> Can you help me a bit ?
> The question is: how can I compare TEXT and CHAR(32) types ?
> More detailed description:
> my=> create table foo (tt text, cc char(32));
>
> CREATE
> my=> insert into foo values ('aa', 'ab');
>
> I
Hi all,
Can you help me a bit ?
The question is: how can I compare TEXT and CHAR(32) types ?
More detailed description:
my=> create table foo (tt text, cc char(32));
CREATE
my=> insert into foo values ('aa', 'ab');
INSERT 27476810 1
my=> insert into foo values ('aa', 'aa');
INSERT
