Re: [GENERAL] how to use pg-connect ?

escription of these options in one of the other documents? Sarah Officer [EMAIL PROTECTED] Cécile DESNOYERS wrote: Hello, I'd like to know if there is a way to use pg_connect() with a different host than « localhost ». I tried to put an IP address or a server name but it didn't

[GENERAL] psql bug?

I am running postgres 6.5.3 on an IRIX6.5. In psql, I can't describe any table I create. I am able to select contents. Is this a bug? psql mydb mydb= \d Database= bcams +--+--+--+ | Owner | Relation

Re: [GENERAL] parser

this helps. Sarah Officer officers Jeff MacDonald wrote: hi, got this question from a user, anyone up for some discussion on it 1) I have been using 6.3 and recently tried to move to 6.5. I found

[GENERAL] psql parsing and variable problems

I can pass the path to the plpgsql library from the command line. CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS :plpgsqlpath LANGUAGE 'C'; Any help is appreciated, Sarah Officer [EMAIL PROTECTED]

[GENERAL] psql problem describing tables

I can select from the table, but there's no data in it. I have the same problem with all my tables, and I can't describe indexes either. Any suggestions? Thanks, Sarah Officer [EMAIL PROTECTED]

[GENERAL] Trigger problem

? Any suggestions would be appreciated. Sarah Officer [EMAIL PROTECTED]

Re: [GENERAL] Simulating an outer join

Can somebody comment on using EXISTS vs. IN in a subselect? I have some statements with subselects, and I'd like to understand the ramifications of choosing EXISTS or IN. Sarah Officer [EMAIL PROTECTED] Mike Mascari wrote: Bruce Momjian wrote: I have been thinking about how to simulate

[GENERAL] triggers functions

to access the rows which are being removed. Thanks, Sarah Officer [EMAIL PROTECTED]

[GENERAL] views containing agregates questions

tried to search the archives on the postgres page, but when I enter a keyword such as 'view', I get the message "Can't open template file 'views '!". Any information on the views/aggregate functions problem would be appreciated. Sarah Officer [EMAIL PROTECTED]

[GENERAL] index on an int8 column

comparison functions. Also, if I am not posting to the appropriate mailing list, please let me know. Thanks in advance, Sarah Officer [EMAIL PROTECTED]

[GENERAL] joins between databases

Can I do a select joining tables of one database with tables in another database? Both databases would be managed by the same postmaster. Thanks, Sarah Officer [EMAIL PROTECTED]

[GENERAL] entity relationship diagram free software

? Thanks, Sarah Officer [EMAIL PROTECTED]