Re: [GENERAL] ER diagrams

2001-05-10 Thread martin . chantler
w about it! Martin Chantler UK Marc SCHAEFER <[EMAIL PROTECTED]>@postgresql.org on 10/05/2001 09:05:07 Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: [GENERAL] ER diagrams Hi, do you know of a tool which could be used to easily generate entity-relationship diagrams

Re: [GENERAL] Yet another Performance Question

2001-04-18 Thread martin . chantler
Have you tried running PostGres with the -F option so that disk flushes are not performed every time. Maybe this will make a difference to insert performance. NB In 7.1 this is replaced by WAL which I don't know much about MC -- NOTICE: The information contained in this electronic mail tran

Re: [GENERAL] Migrating from a DB2/400 to Postgres.

2001-03-28 Thread martin . chantler
its basic but can run quickly MC. Adam Huuva <[EMAIL PROTECTED]> on 28/03/2001 10:56:30 To: [EMAIL PROTECTED] cc: (bcc: Martin Chantler/CIMG/CVG) Subject: [GENERAL] Migrating from a DB2/400 to Postgres. Hello, I have no experience of AS400 but I might be finding myself migr

Re: [GENERAL] Re: Anyone can create tables!

2001-03-12 Thread martin . chantler
I have not been following the start of this thread but I was myself wondering about the security of DB access over the web I have been playing with JSP and servlets with JDBC access to PG (I guess the principal is the same as using other scripting languages.) I noticed that it appears impossible

[GENERAL] Does PostGresSQL have this feature?

2001-02-27 Thread martin . chantler
I am wondering if a very useful feature of some DB's is available in postgres For example in DB2 you can execute SQL from the command line (via terminal emulator) It will perform it entirely then display the results, but only one page at a time You can then page down and page up within the result

Re: [GENERAL] Migrate from MS SQL 6.5 to postgres??

2001-02-27 Thread martin . chantler
s, MC "Steve O'Hagan" <[EMAIL PROTECTED]> on 26/02/2001 08:46:14 To: [EMAIL PROTECTED] cc:(bcc: Martin Chantler/CIMG/CVG) Subject: [GENERAL] Migrate from MS SQL 6.5 to postgres?? Any utilities around which would ease the pain involved in migrating an m$ sql6.5 databa

Re: [GENERAL] Re: numeric type and odbc from access 2000

2001-02-13 Thread martin . chantler
I also use the ODBC driver and have noticed some things that could be improved and some bugs Since it's open source I was thinking of getting the source code and making some changes myself Has anyone done this? My knowledge of C is passable so maybe I could do this? The ODBC driver

Re: [GENERAL] tuples too big

2001-02-08 Thread martin . chantler
OMER ACNO NAME 1Smith CUSTOMER_M ACNO SEQ TEXT 11lots of text 12more text MC. Michelle Murrain <[EMAIL PROTECTED]> on 08/02/2001 14:46:12 Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Martin Chantler/CIMG/CVG) Subject: [GENERAL] tuples

Re: [GENERAL] postgresql-server-7.0.3-2.i386.rpm error DOH

2000-12-12 Thread martin . chantler
Sorry, I see you are logged in as root, very strange error! MC

Re: [GENERAL] postgresql-server-7.0.3-2.i386.rpm error

2000-12-12 Thread martin . chantler
I also had a problem installing the 7.0.3 RPM - it was conflicting with an old version of postgresql I had to uninstall the old RPM's first before it would work, I also found Kpackage sorts some problems out NB Are you logged in as root? MC

[GENERAL] Which character data type to use?

2000-12-12 Thread martin . chantler
Hello everyone, For storing character data such as surname, email address which is the best data type to use? This is my guess: Char - For small columns, fixed length in record VarChar - Is this fixed length in record? If not then is it stored in an 'overflow' area which will effect performanc

[GENERAL] Index question

2000-12-08 Thread martin . chantler
Is there any reason an index would not be used in optimising a query? I have an SQL which does a join and correctly picks up an index on a numeric column but fails to use another index that is on a character column (char I think) Maybe its because its character column - as most joins are done on

Re: [GENERAL] Modify Column

2000-12-01 Thread martin . chantler
] on 01/12/2000 15:23:03 Please respond to [EMAIL PROTECTED] To: PostgreSQL General <[EMAIL PROTECTED]> cc: (bcc: Martin Chantler/CIMG/CVG) Subject: [GENERAL] Modify Column This seems like a simple enough thing, and I'm sure it's been answered, but I couldn't f