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 Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[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. I have no problem with PostgresSQL 7.03 nor with MySQL. When I attempt to connect to the database using ZDE (a windows database client) I have no problem; probably because ZDE does not use the windows DSN. At lease, that is what I am assuming. I have attempted this with two separate 7.1 databases on two separate machines, one set up by me on a debian linux box the other set up by our network administrator so I don't _think_ it's a setup issue with PostgresSQL 7.1 Is there a URL for the latest driver for PostgresSQL 7.1 (I've downloaded a new driver but I'm not certain it's the most recent)? Is there some known issue with PostgresSQL 7.1 and windows ODBC (windows NT that is)? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[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 ODBC drivers for the mac? I couldn't find any. Michelle ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
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 http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[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 thrown out of math class in high school... All these dark secrets which are coming out now... I don't want code I want the logic so that I can try to write the code for myself. TIA Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[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 changing a compile-time option and compiling from source)? Frank ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[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 table users and a child table hobbies...one of my users exists only in the users table but now I want to add his hobbies...is it possible to change him over to the hobbies table without deleting him in the user table, then inserting him into the hobbies table from scratch? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[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| descrip ---+---+--++-++-+--+--++- 17 | 328 | 08X2 | 0 | 0 || |1 | IDC16W | Header-8x2 | 11 | 323 | 08X2 | 0 | 0 || |1 | IDC16W | Header-8x2 | ...while the very same query (substituting LIKE for the '=' sign) gets nothing!? dbname=# select * from partdef where shpname LIKE 'IDC16W'; pn_id | class | num | mt | ver | loc_id | unit_id | subptcnt | shpname | value | descrip ---+---+-++-++-+--+-+---+- (0 rows) Creating a new table, and populating it with trial values shows no problem -- it all works as expected (both '=' and 'LIKE' returning the same results). If selects are done on other columns (same table) they seem to work correctly, whether one or more rows are returned. Can someone please tell me the really stupid thing that I'm doing wrong? Thanks -frank ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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 some way to get this functionality back (hopefully without changing a compile-time option and compiling from source)? Did you install GNU readline on one and not the other? Does OpenBSD 2.8 come with /usr/include/readline/readline.h and /usr/lib/libedit.* ? Cheers, Patrick ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
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 | subptcnt | shpname | value| descrip ---+---+--++-++-+--+--- ---++- 17 | 328 | 08X2 | 0 | 0 || |1 | IDC16W | Header-8x2 | 11 | 323 | 08X2 | 0 | 0 || |1 | IDC16W | Header-8x2 | ...while the very same query (substituting LIKE for the '=' sign) gets nothing!? dbname=# select * from partdef where shpname LIKE 'IDC16W'; pn_id | class | num | mt | ver | loc_id | unit_id | subptcnt | shpname | value | descrip ---+---+-++-++-+--+-+-- -+- (0 rows) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
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 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 some way to get this functionality back (hopefully without changing a compile-time option and compiling from source)? Frank -- Denis A. Doroshenko [GPRS/IN/WAP, VAS group engineer] .-._|_ | [Omnitel Ltd., T.Sevcenkos st. 25, Vilnius, Lithuania] | | _ _ _ .| _ | [Phone: +370 9863486 E-mail: [EMAIL PROTECTED]] |_|| | || |||(/_|_ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[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 looks like it is possible to make several databases using different locations, but as I can see it It is not possible to use databases together. It would be --- Hmmm, funny to be able to fx. enherit a table from one database to another, as this could help. I hope I'm not too much off track. Regards /BL ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[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 thing that I'm doing wrong? Just a guess here... is shpname a CHAR field (which would be padded with spaces)? If so you'd have to do LIKE 'IDC16W%' Greg ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
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 commands go to [EMAIL PROTECTED]
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 message}.
Bingo. '=' for char(N) fields is not sensitive to trailing spaces, per
SQL specs. But LIKE does not have a variant for char(N), it's purely
a text operation; so it thinks spaces are significant.
As near as I can tell, the SQL spec does not have any provision that
requires ignoring trailing blanks in a LIKE comparison on char(N),
which seems rather an oversight on their part.
I tend to think that char(N) is evil and should be avoided in favor of
varchar or text. Those trailing spaces are just too likely to cause
confusion; and when do they buy you anything?
regards, tom lane
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
[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 is not an option. The application which needs to be able to do this is a cross-database-application (MSSQL, Oracle, Sybase) and I have almost no room for doing major changes to the SQL which this application uses. But the lack of this feature in Postgres makes it almost impossible to make a structured database design for huge application. I know this question have been asked before in another postgres forum as early as 1998, and what Bruce Momjian said then was that most commercial databases couldn't do it, which was probably right for 1998, but today even MySQL can do this! Sybase, Oracle and MSSQL can also do this. I think even DB2 and Informix can. I was really suprised when I discovered that this was even an issue with Postgres, because everything else in this wonderful DBM is on an enterprise level of quality and functionality. I'm stuck in the same cleft in the tree - database application originally written for Oracle and Sybase, that still needs to work in Oracle, and the SQL and database structure etched in stone. The problem isn't about a client with multiple connections, its about executing the following query: SELECT A.*, B.* FROM FOO.USERS A, BAR.FAVORITE_BEERS B WHERE A.USER = B.GUZZLER Putting 200+ tables in a database certainly isn't a big deal, as I think Tom Lane points out in another post in this thread. I am poking at the parser in my copious free time just to see how easy it would be to just strip a schema name off the items in the FROM clause before anything happens, but one doesn't pick up the internals of the parser in 10-15 minutes a day...hints anyone? Anyway, this way I COULD put all the tables in one database, keep the schema-based queries, and no one would ever know. I would twitch on the floor in utter extasy if I could hose Oracle...while their licensing is more flexible than in the past, it still doesn't sit right, and despite all their claims to the contrary their java support is a joke. And maybe their pinheaded sales reps WOULD STOP CALLING ME EVERY WEEK. If I ever come up with said schema-dropping patch, and anyone else wants it, let me know. -- Regards, Andrew Rawnsley Ravensfield Geographic Resources, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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 could span databases in a single request. Are there theoretical problems with spanning databases in a single query? Is it a feature of bad database design implementation? Thanks Ciao Zak -- Zak McGregor http://www.carfolio.com - Specifications of cars online. Over 7000! Of course my password is the same as my pet's name. My macaw's name was Q47pY!3, but I change it every 90 days. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
