Re: [HACKERS] Updateable views

2004-12-26 Thread Jaime Casanova
--- Greg Stark [EMAIL PROTECTED] escribió: - What if we cannot create one of the three rules? Make the rule not updateable at all? Or create the rules we can? (i think this is the correct) I seem to be in the minority here. But I think creating complex rules to

Re: [HACKERS] Where do pg_hba.conf include files live?

2004-12-26 Thread Bruce Momjian
Tom Lane wrote: The SGML docs state that include files referenced by @foo constructs in pg_hba.conf must be in the same directory as pg_hba.conf. The actual implementation, however, assumes they must be in DataDir. This is no longer the same thing after the introduction of the data_directory

[HACKERS] More on Order by

2004-12-26 Thread lsunley
Hi All I have discovered that when I use a table like this create table whois (acol name); and insert a few rows, the order by clause works correctly. I dug into the database init stuff to find that the table pg_class column relname is where the pg_tables column tablename comes from. That

Re: [HACKERS] More on Order by

2004-12-26 Thread Michael Fuhr
On Sun, Dec 26, 2004 at 02:57:08PM -0500, [EMAIL PROTECTED] wrote: So what is difference between a name and a char(10)??? See the Character Types section in the Data Types chapter of the documentation. The name type exists _only_ for storage of identifiers in the internal system catalogs and

[HACKERS] Problem with ORDER BY

2004-12-26 Thread lsunley
The previous one of these seems to being blocked because of the big attachments. Short stuff is embedded in this e-mail. Hi all, I have a problem in my os/2 port of postgreSQL v8.0 and I am hoping someone can help me with it. When I create a database and use the commands shown below the

Re: [HACKERS] More on Order by

2004-12-26 Thread lsunley
OK I believe that.. But why does order by work on a name column but not a char(10) column. See my earlier (posted later because of problems) e-mail. Lorne In [EMAIL PROTECTED], on 12/26/04 at 02:16 PM, Michael Fuhr [EMAIL PROTECTED] said: On Sun, Dec 26, 2004 at 02:57:08PM -0500, [EMAIL

[HACKERS] more on character fields

2004-12-26 Thread lsunley
Hi all, It would appear that none of the comparision functions work on my OS/2 port for columns defined as char or varchar. With a table smalvar of two columns, one varchar and the other name acol nn -- AA AA CC a select * from smalvar where acol = '' will return

[HACKERS] order by problems FIXED

2004-12-26 Thread lsunley
Hi all It was a setlocale problem Thanks Lorne -- --- [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 3: if posting/reading

[HACKERS] Help Needed

2004-12-26 Thread Ameya S. Sakhalkar
For my project (main memory DBMS), I hv written a main memory filesystem. Idea is, the primary copy of data will reside in main memory. (Workable only for small size data, at most 2GB). Now, I want to plug this filesystem with Postgres, so that, instead of Unix filesystem, this main memory