I'm doing a db layout in Logic Works' Erwin. It can generate SQL
statements to create the database. Of course it doesn't include support
for PostgreSQL (yet) but I wondered which syntax was closest of the
supported ones.
These are supported:
DB2
SQL Server
Rdb
Oracle
SQLBase
Watcom/SQL Anywhere
I
Anybody that knows anything about Dome ( http://www.htc.honeywell.com/dome/
) ?
It seems to be a quite extensive CASE tool. Can I use it to build a
Database layout and let it generate sql statements to create the database??
Please help
- Original Message -
From: Safa Pilavcı <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 06 Ağustos 1999 Cuma 14:48
Subject: [GENERAL] uppercase of char16
> hello ,
> My problem is with SQL statement,
> I have a field like,
> my_fieldchar16
>
> this field conta
--Referential integrity:
--1. Don't allow to add a detail without header
--2. Delete all details in cascade if one decide to delete the
header
--3. Update details' key in cascade if header's key is changed
DROP TABLE header;
CREATE TABLE header (
year
INTEGER NOT NULL,
At 14:30 +0300 on 10/08/1999, =?iso-8859-9?Q?Safa_Pilavc=FD?= wrote:
> Please help
Char16 has little support. Any possibility of changing the definition to
char(16)?
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
Hmm, char16 is not a currently recognized type - what version of
postgresql are you using? In 6.5, upper(foo) works for all the char and
text types of foo I can find.
Ross
On Tue, Aug 10, 1999 at 02:30:54PM +0300, Safa Pilavcý wrote:
> Please help
>
>
> - Original Message -
> From
You need to increase your max backends. The default for 6.4.2 was 64. I
believe it is a configure option (or it's in config.h).
You might also need to increase your semaphore limits (that's a kernel
option).
> -Original Message-
> From: Yin-So Chen [SMTP:[EMAIL PROTECTED]]
> Sent: Sunda
Hello there,
Could anybody advise me how can I create composite index for table when
one of key fields is of boolean type?
Schema is as follows:
create table test (indoor bool, pos int, name varchar(64) NOT NULL,
check (pos >= 0 and pos <=32000));
create unique index test_pkey on test (indoor
On Mon, 9 Aug 1999, Jonathan R. Karlen wrote:
JRK> Is there a way to drop a field from a table? ALTER TABLE seems to only
JRK> allow the adding and modification of fields.
Try to select all content to temporary table, then drop old table, create
new with unneeded column(s) removed, and them res
Hi,
I am creating a script that sends out reminders to subscribers to a site who
have not paid. I can't figure out the math that will add 7 days to a date.
I want something like this:
select * from company where created
is between (lastpaid + 14 days) and (created + 28 days);
I can't figure
I've searched the list archives and read the FAQ, neither of which seem to
describe my current situation:
I'm running Linux 2.2.10 on a production webserver, along with PostgreSQL
6.5.1 (in RPM format from ftp.postgresql.org). My main database is a set
of names/addresses/etc. tables for our memb
hi wim..
>select * from company where created
>is between (lastpaid + 14 days) and (created + 28 days);
assuming that lastpaid and created are dates, pgsql will handle the
addition quite nicely for you... as examples:
test=> select '4-1-1999'::date + 7;
?column?
--
04-08-1999
(1 row)
Thanks Aaron,
That is exactly what I wanted. Much more simple then what I was thinking.
On 10-Aug-99 Aaron Seigo wrote:
> hi wim..
>
>>select * from company where created
>>is between (lastpaid + 14 days) and (created + 28 days);
>
> assuming that lastpaid and created are dates, pgsql will
Could you please post the schema and query?
Also, I'm assuming you VACUUM on a regular basis?
Mike M.
--- Bill Garrett <[EMAIL PROTECTED]> wrote:
> I've searched the list archives and read the FAQ,
> neither of which seem to
> describe my current situation:
>
> I'm running Linux 2.2.10 on a pro
14 matches
Mail list logo
