[ADMIN] Re: ODBC vs win2k and access

At 17:29 18.01.2001 -0700, Hal Lynch wrote: >I want to use the ODBC interface to Postgres so I can query my >databasefrom a win2k machine using Micro $oft access. What driver should >I use on the Win2k machine?hal the latest odbc driver on any of the postgres ftp-mirrotrs will do that. clemens

[ADMIN] ODBC vs win2k and access

I want to use the ODBC interface to Postgres so I can query my database from a win2k machine using Micro $oft access. What driver should I use on the Win2k machine? hal

[ADMIN] ODBC vs win2k and access

I want to use the ODBC interface to Postgres so I can query my database from a win2k machine using Micro $oft access. What driver should I use on the Win2k machine? hal

Re: [ADMIN] Problems in creating table while migrating fromFoxpro to Postgress using JDBC

> I am migrating the databases from Foxpro to Postgress using JDBC. > > I am extracting all the field values,type and width from the > Foxpro database and putting that as a string . > > Ex: String stru > > Name varchar(20),id int4(4) int4 doesn't need a size...it's always 4 bytes, AFAIK. S

Re: [ADMIN] Deadlocks

Gena Gurchonok <[EMAIL PROTECTED]> writes: > CREATE INDEX "logs_id_key" on "logs" using hash ( "id" "int4_ops" ); > CREATE INDEX "logs_type_key" on "logs" using hash ( "type" "int4_ops" ); > CREATE INDEX "logs_dt_key" on "logs" using hash ( "dt" "timestamp_ops" ); > Sometimes it writes error m

[ADMIN] Re: [GENERAL] Re: date/time

On Tue, Jan 16, 2001 at 07:24:15PM -0800, Ian Harding wrote: > snef wrote: > > > Hi, > > I have read the man's with Postgres. > > But I can't seem to get Postgres use European time notation (dd/mm/). > > > > Where can I adjust this? (in which file?) > > > > Snef > > Actually, I think you may

[ADMIN] Pictures again

I understand now that one must store the pictures on the filesystem and just specify the path and filename on the database, how is this done? Thanks, Richie = Richie Duggan Computer Science IV University College Cork email : [EMAIL PROTECTED] [EMAIL PROTECTED] Homepage : htt

[ADMIN] Pictures(.gif)

Hi I am currently creating tables in PostgreSQL but would like to have a picture(.gif) as a data type, is this possibe Thanks Richie = Richie Duggan Computer Science IV University College Cork email : [EMAIL PROTECTED] [EMAIL PROTECTED] Homepage : http://student.cs.ucc

[ADMIN] Problems in creating table while migrating from Foxpro to Postgress using JDBC

Hi all, I am migrating the databases from Foxpro to Postgress using JDBC. I am extracting all the field values,type and width from the Foxpro database and putting that as a string . Ex: String stru Name varchar(20),id int4(4) And then I have another string 'Query'which

[ADMIN] Deadlocks

Hello. It seems to me that I discovered strange PSQL behaviour I have table logs: - CREATE TABLE "logs" ( "id" int4 NOT NULL, "type" int4 NOT NULL, "dt" timestamp NOT NULL, "addr" character varying(20) ); - with indexes: - CREAT

Re[2]: [ADMIN] table creation

Hello again. >> Not owner can create tables in my database. >> How can I set datebase to allow not-owner to create only TEMP tables? > We currently have no way to do that, but I can see it would be very > helpful to have that feature. Please add this issue to the TODO list if possible. Thanks fo

Re: Re[2]: [ADMIN] table creation

> Hello again. > > >> Not owner can create tables in my database. > >> How can I set datebase to allow not-owner to create only TEMP tables? > > We currently have no way to do that, but I can see it would be very > > helpful to have that feature. > Please add this issue to the TODO list if possib

Re: [ADMIN] table creation

We currently have no way to do that, but I can see it would be very helpful to have that feature. > Hello. > > I encountered one small problem: > > Not owner can create tables in my database. > How can I set datebase to allow not-owner to create only TEMP tables? > > > Gena > > > -- B

Re: [ADMIN] 7.1 initdb error

"mike" <[EMAIL PROTECTED]> writes: > things proced as usual then I get an error while initdb is creatting templa= > te1. > ERROR: Error: unknowen type 'ame'=20 This was just discovered a day or two ago --- there's been an extraneous backslash in genbki.sh since, oh, about 1996. Curious how a bu

Re: [ADMIN] VACUUM warning/error (?)

Nicolas Kowalski <[EMAIL PROTECTED]> writes: > NOTICE: FlushRelationBuffers(trace_sql, 162): block 239 is referenced > (private > 0, global 1) > FATAL 1: VACUUM (vc_repair_frag): FlushRelationBuffers returned -2 > pqReadData() -- backend closed the channel unexpectedly. > This probably m

Re: [ADMIN] row size limitation

Jim Hines wrote: > > We too just got bit by the row size limit, having installed from the > rpms, 7.03. > > A news story wouldn't fit, and had to be drastically trimmed before it > was > accepted. > > Is there a way to reset this to say 32k, after the install, or is this > a compile > time opt

[ADMIN] table creation

Hello. I encountered one small problem: Not owner can create tables in my database. How can I set datebase to allow not-owner to create only TEMP tables? Gena

[ADMIN] row size limitation

We too just got bit by the row size limit, having installed from the rpms, 7.03. A news story wouldn't fit, and had to be drastically trimmed before it was accepted. Is there a way to reset this to say 32k, after the install, or is this a compile time option? We've now spent lots of time rtfm

[ADMIN] 7.1 initdb error

I'm getting a peculiar error when I try to run the initdb program so I can start using postgres.   things proced as usual then I get an error while initdb is creatting template1.  ERROR: Error: unknowen type 'ame'   initdb then continues on its merry little way on creating global relations

[ADMIN] VACUUM warning/error (?)

Hello. We are running a small Intranet database, using PostgreSQL 7.0.2 on a Debian GNU/Linux 2.2 server. All works fine. Great job PostgreSQL guys ! However, I used to backup our database every night (pg_dumpall), and now, I want to clean up it just before the dump, when nobody uses it. The co