Re: [BUGS] Information regarding foriegn key constraint.

2001-06-11 Thread Stephan Szabo
On Fri, 8 Jun 2001, meeta bhate wrote: > Dear Sir, > I am a Graduate student at the University of Toledo.My Master's project > involves creating a database in PostgreSQL version 6.5.3.I was wondering > if I can use SERIAL key along with a PRIMARY key as follows: > > create table ohiouniv (ui

Re: [BUGS] where clause bug

2001-06-11 Thread Stephan Szabo
On Fri, 8 Jun 2001, kyle wrote: > When specifying criteria in a where claue such as > user_id = 'value' if a non-numeric is entered the > query returns back all rows. > user_id = user_id brings back every user_id instead of > error because user_id is a numeric field and it > shouldnt be able to

Re: Re(2): [BUGS] REFERENCES fails on derived classes

2001-06-11 Thread Stephan Szabo
On Mon, 11 Jun 2001, Michael Caine wrote: > a month i was told that my possible bug submission was "sort of" a bug. > the report and reply are below. > > now i write a follow up because i don't know how to establish a workroom. > specifically, i know know that a unique constraint must be added

[BUGS] C++ interface

2001-06-11 Thread Kemin Zhou
I have HedHat 7.1 on linux I made the c++ interface with the --with-CXX option during configure process. The make had no problem. I have run a test. I have created a database it works find in interactive mode. if I typeselect * from cds it will give me some output, But my C++ program t

[BUGS] where clause bug

2001-06-11 Thread kyle
When specifying criteria in a where claue such as user_id = 'value' if a non-numeric is entered the query returns back all rows. user_id = user_id brings back every user_id instead of error because user_id is a numeric field and it shouldnt be able to accept chars. -Kyle

[BUGS] column check constraint

2001-06-11 Thread Michael Nguyen
POSTGRESQL BUG REPORT TEMPLATE Your name : Mike Nguyen Your email address : [EMAIL PR

[BUGS] Bug in PostgreSQL/Python (7.1.1/1.5) fetchone()

2001-06-11 Thread Kevin Cole
Hi again, It appears that the bug in pgdb occurs for both examples below. Both return the first row multiple times. (This is with PostgreSQL 7.1.1 and Python 1.5.2.) _ for hits in range(curse.rowcount): print curse.fetchone()

[BUGS] Syntax of stored procedures is not checked

2001-06-11 Thread Victor Wagner
In some languages used for stored procedures in PostgreSQL it is possible to catch some programming errors statically. At least Perl has this property (see -c in perldoc perlrun ) and it seems that PL/PGsql and SQL too allows to parse a function definition and catch errors in it without actual ex

[BUGS] REPOST: redefining location of the socket file /tmp/.s.PGSQL.5432

2001-06-11 Thread Arcady Genkin
I asked this in -general about ten days ago, but received no replies. Can I redefine location of the UNIX domain socket file to be other than /tmp/.s.PGSQL.5432? The problem is that there is a /tmp cleaning script on the Solaris system where Postgres is installed, which sweeps away anything olde

[BUGS] help - Installing

2001-06-11 Thread Ilan Fait
Title: help - Installing     Hi, I need help with finding some Documentation about how to install PostGerSQL on windows 2000 Step by step since I am trying to install PostGerSQL DB on Win2000 O/S. I have install the Cygwin but when I try create a database I get: $ createdb iweb psq

[BUGS] Problem with locale on Solaris 8.0 intel

2001-06-11 Thread Victor Wagner
On the the Solaris 8.0 platform, when database is build using Russian WIN encoding and initdb performed using LANG=ru_RU.ANSI1251, some russian letters for instance "small letter e" and "small letter che" according to unicode consortium naming, are considered equal. so I cannot insert into key

[BUGS] Information regarding foriegn key constraint.

2001-06-11 Thread meeta bhate
Dear Sir, I am a Graduate student at the University of Toledo.My Master's project involves creating a database  in PostgreSQL version 6.5.3.I was wondering if I can use SERIAL key along with a PRIMARY key as follows: create table ohiouniv (uid serial primary key,    uname varc

Re(2): [BUGS] REFERENCES fails on derived classes

2001-06-11 Thread Michael Caine
a month i was told that my possible bug submission was "sort of" a bug. the report and reply are below. now i write a follow up because i don't know how to establish a workroom. specifically, i know know that a unique constraint must be added to an inherited "id" field, even if it's a primary k