"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> ALTER TABLE tablename ADD COLUMN columnname INT CONSTRAIN cntrname
> REFERENCES tablename2(col)
> adds the column But it does not add the foreign key constrain.
This was fixed as of 7.3.3.
regards, tom lane
--
ECPG preprocessor for PostgreSQL 7.4.1, 7.4.2 doubles const,
volatile, static, and register keywords before variables,
declared as VARCHAR.
I attach to this mail example for this, and patch for PostgreSQL
7.4.1, that solves this problem (this patch also applicable to
PostgreSQL 7.4.2 too)
--
Ser
On Wed, 2004-05-26 at 14:38, Bruno Wolff III wrote:
> On Wed, May 26, 2004 at 13:57:37 -0400,
> Vic Ricker <[EMAIL PROTECTED]> wrote:
> > Am I doing something wrong or is this a bug?
>
> Are there any nulls in iasusers.user_name?
There was a null in iasusers. I removed it and that fixed the pr
On Wed, May 26, 2004 at 13:57:37 -0400,
Vic Ricker <[EMAIL PROTECTED]> wrote:
> Hi. I'm using PostgreSQL 7.4.2 under Fedora Core 1.
>
> I have two tables with a single varchar(32) column in each. I'm trying
> to find all the rows from one table that don't exist in the other
> table. The query
Hi. I'm using PostgreSQL 7.4.2 under Fedora Core 1.
I have two tables with a single varchar(32) column in each. I'm trying
to find all the rows from one table that don't exist in the other
table. The query that I am using is:
select u.user_name from users u where u.user_name not in (select
use
Please cc: the pgsql-bugs mailing list as well as myself
Mr sangameswar m wrote:
Hello sir,
Whenever i attempt to login
with already created database by entering the command
./psql student then it showing the error as i had
specifed in my earlier mail. Even it is not getting
login when i e
PostgreSQL Bugs List wrote:
The following bug has been logged online:
Bug reference: 1156
Logged by: Sangameswar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.2.3
Operating system: Redhat linux
Description:Database is not initializing
Details:
psql: FATAL 1:
The following bug has been logged online:
Bug reference: 1157
Logged by: Sangameswar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.2.3
Operating system: Redhat linux
Description:Database is not initializing
Details:
psql: connectDBStart() -- connect()
The following bug has been logged online:
Bug reference: 1156
Logged by: Sangameswar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.2.3
Operating system: Redhat linux
Description:Database is not initializing
Details:
psql: FATAL 1: Missing or erroneous
