[GENERAL] unique constraint on more than one tables

2006-12-28 Thread Akbar
Hi, Imagine I have two tables, like this: create table bla_a ( id serial primary key, name varchar(31) not null, comment varchar(31) ); create table bla_b ( id serial primary key, name varchar(31) not null, blabla int ); I want to make sure that both tables could not have the same value

[GENERAL] select union with table name

2006-12-28 Thread Akbar
Hi, I have two tables. create table blue ( id serial primary key, name text not null, kill text not null ); create table red ( id serial primary key, name text not null, kiss text not null ); select blue.name from blue union select red.name from red; give me this: name 'blabla' 'bubu'

Re: [GENERAL] Installation problem with the version 8.0.2

2005-04-25 Thread Akbar
http://www.microsoft.com/downloads/details.aspx?FamilyID=4b6140f9-2d36-4977-8fa1-6f8a0f5dca8fDisplayLang=en On Mon, 2005-04-25 at 15:37 +0530, K.RajaSekar wrote: Hi I am trying to install the 8.0.2 version in windows 2000 server. After opening the installer, I have got the welcome screen. I

[GENERAL] installation as service failed on windows xp

2005-04-25 Thread Akbar
. Regards, Akbar ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[GENERAL] weird error on installing postgresql in Windows XP

2005-03-20 Thread Akbar
Hi, I have installed previous version of postgresql. 8.x. I uninstalled it. Then remove the superuser in My Computer ( right click ) -- Properties -- in tab Advanced -- Settings button. I try to install postgresql 8.0.1. In service configuration, I checked the install as service checkbox. Filled