Re: [GENERAL] Set DATESTYLE='ISO' (Postgres 6.3.2)

1998-08-26 Thread Aleksey Dashevsky
On Mon, 24 Aug 1998, Sangeeta Rao wrote: > > Hi, > > I am using Postgresql 6.3.2 and would like to set the datestyle to be ISO. > > Here is what I did: > > - issued "set datestyle='ISO' " using PQexec() after opening a connection > with the database. (no errors) > - Then checked the datestyl

Re: [GENERAL] column name length

1998-08-20 Thread Aleksey Dashevsky
Neither 16, nor 32, but 31 ! This is also true for table name. Al. On Thu, 20 Aug 1998, Rostislav Matl wrote: > > I'm not sure if column name length limit is 16 or 32, > can somebody tell me ? > > +-+ > | ROSTISLAV M

[GENERAL] Re: [MIRRORS] Revamp'd Web Site...

1998-07-22 Thread Aleksey Dashevsky
hi! Did you rename start page of PostgreSQL site from index.shtml to index.html by an accident or with some special purpose? It is very important to maintainers of mirrors,'cause we used to begin mirroring from www.postgresql.org/index.shtml -- URL www.postgresql.org automatically throws to your n

[GENERAL] Removing user-defined types & functions

1998-07-20 Thread Aleksey Dashevsky
hi! I was playing with creating my own types and C-functions and have notised that after one of my own types was removed functions that use it became unexistent(i can't call them any more) . But still there are all tuples in pr_proc that describes all that functions. So, my question is: can I (

Re: [GENERAL] How to rename a database?

1998-07-09 Thread Aleksey Dashevsky
Use following syntax: alter table rename to Al. On Wed, 8 Jul 1998, Farzad FARID wrote: > > How do I rename an existing database? Is it enough to just rename the > directory? If that's the only way to do it do I have to first shut the > server down? > > -- > Farzad FARID > Administrateur Re

Re: [GENERAL] datatype questions

1998-06-24 Thread Aleksey Dashevsky
On Mon, 22 Jun 1998, Brian wrote: > I am trying to convert a table into PostgresSQL from MySQL, and had a few > questions: > > CREATE TABLE forum ( > id int(11) DEFAULT '0' NOT NULL auto_increment, > name varchar(30), > email varchar(100), > topic varchar(50), > body blob, > host v