Re: [GENERAL] Re: Which Front End for Postgresql

Hi, Does anybody know of any issues with Mac OS 9.x and either AppleWorks or Excel and ODBC access to a Postgres backend? I have a client who needs to print labels and who has AppleWorks. Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html

[GENERAL] PostgresSQL 7.1 and ODBC/MSAccess

I have a problem with PostgresSQL 7.1 and Micro$oft Windoze ODBC and MS Access 2000 which I am hoping someone here might be able to help me with. When I try to link MS Access to a PostgresSQL 7.1 table, Access is unable to see any of the tables in the database so I cannot select a table to link.

[GENERAL] Re: Re: Which Front End for Postgresql

Tony Grant wrote: Hi, Does anybody know of any issues with Mac OS 9.x and either AppleWorks or Excel and ODBC access to a Postgres backend? I have a client who needs to print labels and who has AppleWorks. Actually, I was going to investigate this for FileMaker - are their postgresql

Re: [GENERAL] Re: Re: Which Front End for Postgresql

On 21 May 2001 13:02:21 +, Michelle Murrain wrote: Actually, I was going to investigate this for FileMaker - are their postgresql ODBC drivers for the mac? I couldn't find any. M$ ones should work. There is one for 4D ($$$) Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S

[GENERAL] need some help with a SELECT

Monday... I can't get my brain around this one. Get the top three replies from a quizz. I want to select from a table all records which have a value of 1.00, 2.00 and 3.00. Then I want to class the records by the column which has the most 1 followed by the most 2... Yes I was

[GENERAL] psql shell problem

I have a machine with OpenBSD 2.6 and PSQL 6.5.3 that allows the use of up-arrow to retreive/edit previous commands. I recently built a new machine with OpenBSD 2.8 and PSQL 7.0.2 (from package) and this feature is GONE! Is there some way to get this functionality back (hopefully without

[GENERAL] Inheritance clarification please

Greets, I'm trying to get my head around what the benefits to inheritance are. Is the data duplicated or just referenced in the parent table? If it's duplicated then the database size and bloat are an issue for me. Another question I have is that say I have a parent

[GENERAL] LIKE erratic? or unseen DB corruption?

Running 7.1(.0) on a PC running Debian Linux (potato), I have a strange situation in psql: A direct query gets appropriate rows of data: dbname=# select * from partdef where shpname = 'IDC16W'; pn_id | class | num | mt | ver | loc_id | unit_id | subptcnt | shpname | value|

Re: [GENERAL] psql shell problem

On Mon, May 21, 2001 at 10:32:37AM -0400, Frank Bax wrote: I have a machine with OpenBSD 2.6 and PSQL 6.5.3 that allows the use of up-arrow to retreive/edit previous commands. I recently built a new machine with OpenBSD 2.8 and PSQL 7.0.2 (from package) and this feature is GONE! Is there

Re: [GENERAL] LIKE erratic? or unseen DB corruption?

Is it possible that there are spaces after the 'IDC16W' in the field? Try: LIKE 'IDC16W%' and see if that makes a difference. len A direct query gets appropriate rows of data: dbname=# select * from partdef where shpname = 'IDC16W'; pn_id | class | num | mt | ver | loc_id | unit_id |

Re: [GENERAL] psql shell problem

this is logical flaw in PostgreSQL's psql include file (input.h). I wrote, but have been told it was ok, and nobody wanted to change it. Personally i patch every version of PostgreSQL by hand to get readline edit mode working. Yeah, that sucks... On Mon, May 21, 2001 at 10:32:37AM -0400, Frank

[GENERAL] Spliting a table/databases between several disks ?

Hi ... I have been planning using the PostgreSQL database using a somhow large database (and therefor some large tables). While doing this i really like to know if it is possible to split data in a database og even a table between several disks ? I have tried to look into this problem, and it

[GENERAL] Re: LIKE erratic? or unseen DB corruption?

A direct query gets appropriate rows of data: dbname=# select * from partdef where shpname = 'IDC16W'; ...while the very same query (substituting LIKE for the '=' sign) gets nothing!? dbname=# select * from partdef where shpname LIKE 'IDC16W'; Can someone please tell me the really stupid

RE: [GENERAL] psql shell problem

Does postgresql has any windows clients(like there is psql for unix environment) ?if there, where can i download from? Regards, Abhi http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [GENERAL] LIKE erratic? or unseen DB corruption?

Frank Miles [EMAIL PROTECTED] writes: Seq scan for '=' and for 'LIKE'; no locale support enabling. As Len Morgan suggested, it appears to be a matter of LIKE being sensitive to trailing spaces, and '=' NOT being sensitive to them. The field data type is char(16) {not stated in my original

[GENERAL] Queries across multiple databases  (was: SELECT from a table in another database).

I don't know what you are using those database for, but nothing prevents you from letting your clients connect to the different databases the same time. But that requires me to make a new database connection for each database I need to access. And putting 200+ tables in one single database

Re: [GENERAL] Queries across multiple databases  (was: SELECT from a table in another database).

On Mon, 21 May 2001 07:55:13 -0400 Andrew Rawnsley [EMAIL PROTECTED] wrote: If I ever come up with said schema-dropping patch, and anyone else wants it, let me know. I'd dance a happy jig ;-) I'm not sure whether it is quite the way to do it, but I'd have a better time with things if I