[GENERAL] entity relationship diagram free software

? Thanks, Sarah Officer [EMAIL PROTECTED]

[GENERAL] index on an int8 column

fault 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] views containing agregates questions

ect will be. I 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]

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 bee

[GENERAL] triggers & functions

e of a trigger which calls a sql procedure would be much appreciated! I'd like the function to be able to access the rows which are being removed. Thanks, Sarah Officer [EMAIL PROTECTED]

[GENERAL] psql problem describing tables

d: Invalid type - oid = 0 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]

Re: [GENERAL] psql problem describing tables

Let me clarify. The reason there is not data in my table is because I haven't inserted any yet. I inserted a row of data. It gets selected correctly, but I still can't describe the table. So the problem doesn't seem to be related to having an empty table. Sarah Sarah Office

[GENERAL] Trigger problem

ID2|Another Image|/usr/local/bar.gif|A2 (2 rows) > delete from istatus where status_code = 'A1'; ERROR: fmgr_info: function 18848: cache lookup failed What is the problem with the cache lookup? Any suggestions would be appreciated. Sarah Officer [EMAIL PROTECTED]

[GENERAL] Creating Triggers

Thanks to Ed Loehr and others on the group, I finally was able to create triggers in my database. This is a summary of what I learned in the process. For the most part, I didn't find this in the documentation. If anything here is incorrect, please let me know. If not, can it be put in document

[GENERAL] < and > for datetime

Hi all, I'm trying to find less than and greater than functions for datetime types. It doesn't look the the time interval operators would be appropriate, but I haven't found anything else in the docs. Here's my snippet of plpgsql which fails: select count(*) into rescount from current

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

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 se

[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

uld have to? I hope 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

[GENERAL] psql parsing and variable problems

What is the alternative? What I really want to do is use the 'psql --set' option so 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]