[GENERAL] inet and cidr type problems

i have been playing with the inet and cidr types, and i have noticed a couple problems, and would entertain suggestions as to how to fix them without necessarily breaking how other people might be using them. - a table with an element of type inet, will show "0.0.0.0/0" as "00/0" i suspect this

Re: [GENERAL] Postgre superuser?? (fwd)

Forgive me if this is a double post my previous attempt bounced > > 2. Create the Postgres superuser account... > The owner of the Postgres files can be any unprivileged user account... Basically, create a normal user acount on the unix box. Don't make the superuser of the box (root) the

[GENERAL] Postgre superuser??

I am just about to install Postgre. I have ordered the CD but I can't wait, too much excitement. At any rate the manual (Administrator's Guide, Chapter 4) states: 2. Create the Postgres superuser account... The owner of the Postgres files can be any unprivileged user account... 3. Log in to

[GENERAL] Questions about functions and loops

1) When I run the function below I get an error at "select". If I put the select statement in single quotes, I get an error at "loop". Any suggestions how to fix this? 2) When I install the following function: CREATE FUNCTION InstallPermissions(varchar, varchar) RETURNS int2 AS '

[GENERAL] sort of anser to "what on earth does this mean?!?"

Hi all. Recently I wrote: >I have just started getting the following message, by the ton, in my >postgres log: > > ERROR: RelationCatalogInformation: Relation 21400 not found > >I've traced it to the point that I know exactly what statement is producing >it, namely: > > select attribute_id

Re: [GENERAL] what on earth does this mean?!?

Thanks KT Vacuum sadly does not help. Is there anyone out there who actually knows what this message *means*? Not necessarily specifically for 21400 of course, but in general? ERROR: RelationCatalogInformation: Relation 21400 not found Regards, K. --- ~~

[GENERAL] Addendum: Vacuum seems to be halting on very large table

Before anyone asks...I tried shutting down Postgres and restarting it to disconnect any connections and I made all of my CGI scripts (the only users) "000" so the database could not be accessed. -Original Message- From: K.T. <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Da

Re: [GENERAL] selects on datetime

Title: selects on datetime Ugg more HTMLized email...   If your fields are defined separately as Year, Month, Day, then index on those fields and your query should use the index to find the records matching where clause.   If you want a single date field...compose the date field as a string

[GENERAL] shared tables

Hi! I'm wonder if I could produce shared tables like pg_database or pg_shadow by myself. I've found in pg_class a field called relisshared and suppose, that setting its value to true could do the trick, but it seems that I need more than only this. Anybody knows what is it? TIA Rem

[GENERAL] Vacuum seems to be halting on very large table

Vacuum cammand seems to hang (I waited 1-2 hours) on a table that is empty, but is still using over 66 MB of disk space. This is due to deletes because this table is completely reloaded from text files. The command I am using is "vacuum verbose analyze" from the psql prompt. Anyone experience th

Re: [GENERAL] what on earth does this mean?!?

I think this is another one that falls under the general fix all: run the "vacuum" command. -Original Message- From: Karl Auer <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday, March 03, 1999 3:56 AM Subject: [GENERAL] what on earth does this mean?!? >Hi all

[GENERAL] what on earth does this mean?!?

Hi all. Apologies to those who have seen this in the novice list already, someone suggested here might be a better spot for my question. Here 'tis. I have just started getting the following message, by the ton, in my postgres log: ERROR: RelationCatalogInformation: Relation 21400 not found