[GENERAL] RE: FIXED: Cannot INDEX an Access97 ODBC export?

Thanks for the info: Appears, unbeknownst to me, that UPPER case field names can't be addressed via the CREATE INDEX statement in psql mode. Renamed all my Access97 table field names to "Lower Case" and exported them to the PostgreSQL 7.0 database. Now they "can" be indexed just fine. H. So,

Re: [GENERAL] Ah, yet another cause for not binding the right port....

> I tried this and got what I thought was a fairly reasonable error > message: > > FATAL: StreamServerPort: bind() failed: Permission denied > Is another postmaster already running on that port? > If not, remove socket node (/tmp/.s.PGSQL.5432) and retry. > postmaster: cannot creat

Re: [GENERAL] Ah, yet another cause for not binding the right port....

"Steve Wolfe" <[EMAIL PROTECTED]> writes: >When postgres binds to any port, it likes to write a file in /tmp, along > the lines of ".s.PGSQL.5432". If /tmp is not writeable by the postgres > process, it will not be able to bind to any port. However, it doesn't give > you an intelligent error

[GENERAL] Ah, yet another cause for not binding the right port....

I've run across yet another cause that can make Postgres not be able to bind to the port it desires (or any other port, for that matter). I don't recall it being discussed before, so I'll throw it out. When postgres binds to any port, it likes to write a file in /tmp, along the lines of "

Re: [GENERAL] Cannot INDEX an Access97 ODBC

<[EMAIL PROTECTED]> writes: > The psql CREATE INDEX statement can't see the imported column > (name/attribute)... wierd? I still think that Bryan's got the right idea --- Access probably created the column name with some embedded blanks and/or upper-case characters, which'd mean that you have to

Re: [GENERAL] Cannot INDEX an Access97 ODBC

Thanks for the response: The column exists in the table structure and can be accessed/queried via psql with SELECT statements or via ODBC SELECT statements form Access97. The data intergrity (content) for the table and columns is fine and intact. The psql CREATE INDEX statement can't see the im

Re: [GENERAL] to pass a parameter

Sorry, but i made a mistake here ! the function dept or is equivalente coud not solve this problem (pass a table name as a parameter) In Oracle exist Dynamic SQL, is there something like that in postgres ? Is it possible to execute a query built in a plpgsql function or do we need to use Perl an

Re: [GENERAL] Re: PHP and inet data type

mikeo wrote: > > just a curiosity question...is the pg_FieldType() function > something you wrote yourself? It's a PHP function. -Ron-

Re: [GENERAL] Cannot INDEX an Access97 ODBC export?

> Error return is that it is not able to find the attribute "any_column_name" in the table. This maybe obvious but have you looked at the table layout to see if the column exists. You may have a problem with spaces in the name or upper case letters in the name. In either case you must quote th

[GENERAL] Data type

A logical field (Yes/No) in MS Access was exported as bpchar in Postgres. I failed to find this data type in the User's Manual. Only bool is mentioned there. Please advise. Thanks, Mihai