Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-17 Thread Mike Mascari
dressing... Could be wrong, though... Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-18 Thread Mike Mascari
/0309/4.JHdbcourseS03.pdf How about extra credit for PITR? Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-19 Thread Mike Mascari
as a sequential device rather than a random access device. Isn't a TID-List-Fetch implementation a crucial first step in the right direction? Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [HACKERS] initdb should create a warning message [was Re: [ADMIN]

2003-12-01 Thread Mike Mascari
to wal, I guess. That might actually be clearer. xlog could become xstatus or xactstatus or just xact. active_xdata active_cdata Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

Re: [HACKERS] IEEE 754

2003-12-29 Thread Mike Mascari
://www.ecommercetax.com/official_docs/SSTP%20-%20Rounding.pdf Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Preventing stack-overflow crashes (improving on max_expr_depth)

2003-12-30 Thread Mike Mascari
? Mike Mascari [EMAIL PROTECTED] Tom Lane wrote: It occurred to me today that it would not be difficult to implement a direct check on the physical size of the execution stack. ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] CTTAS w/ DISTINCT ON crashes backend

2004-01-21 Thread Mike Mascari
is in adding OIDs to rows that initially did not have 'em when returned from the SELECT DISTINCT plan. Okay. So your best immediate workaround is to create the first temp table with oids, or create the second one without. Thanks! Mike Mascari ---(end of broadcast

Re: [HACKERS] returning PGresult as xml

2004-01-25 Thread Mike Mascari
last time this subject was dicussed, I believe it was Mike Mascari who proposed and implemented another solution which is more client-side oriented. I humbly confess it wasn't me. We use CORBA Mike Mascari ---(end of broadcast)--- TIP 1

Re: [HACKERS] lock related issues...

2004-01-28 Thread Mike Mascari
, a message should be output to read it: http://conferences.oreillynet.com/presentations/os2002/lane_tom.tar.gz Mike Mascari ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Summary of Changes since last release (7.4.1)

2004-02-10 Thread Mike Mascari
Simon Riggs wrote: - All operations on TEMP relations are no longer logged in WAL, nor are they involved in checkpoints, thus improving performance. (Tom) That is great news! Looking forward to 7.5 already, Mike Mascari ---(end of broadcast

Re: [HACKERS] Summary of Changes since last release (7.4.1)

2004-02-10 Thread Mike Mascari
-server/src/backend/storage/smgr/smgr.c?rev=1.58content-type=text/x-cvsweb-markup Mike Mascari ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Summary of Changes since last release (7.4.1)

2004-02-10 Thread Mike Mascari
://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/storage/smgr/smgr.c?rev=1.58content-type=text/x-cvsweb-markup Actually, that was an Aug 6, 2002 commit, not 2003 which would make it 7.3, right? So Simon, my I humbly ask from where you culled this change in CVS tip? Mike Mascari

Re: [HACKERS] Is indexing broken for bigint columns?

2004-02-24 Thread Mike Mascari
assuming 32-bit quantities that will break once ~4.2 billion is reached and I get index scans without quoting or casting free. But IIRC there's a change in the development tree to jettison the requirement for quoting/casting... Mike Mascari ---(end of broadcast

Re: [HACKERS] Is indexing broken for bigint columns?

2004-02-24 Thread Mike Mascari
: == ... select * from foo where bar = 1 ... This is Oracle syntax: == SQL select * from foo where bar = 1; ... mysql select * from foo where bar = 1; Mike Mascari ---(end of broadcast

Re: [HACKERS] COMMENT ON [GROUP/USER]

2004-03-08 Thread Mike Mascari
pg_description; count --- 1542 (1 row) [EMAIL PROTECTED] select count(*) from pg_description; count --- 1541 (1 row) Mike Mascari ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] COMMENT ON [GROUP/USER]

2004-03-08 Thread Mike Mascari
to COMMENT ON non-local databases to an ERROR in 7.5 or not. It was my fault from the beginning - but once I'd implemented COMMENT ON for tables and columns I just couldn't stop... :-) Mike Mascari Mike Mascari wrote: .. The comments are stored only in the database's pg_description where

Re: [HACKERS] Fuzzy cost comparison to eliminate redundant planning

2004-03-28 Thread Mike Mascari
. With your new fuzzy comparison patch is twelve still the appropriate number? Or does the fuzzy comparison scale all planning time down and therefore the default threshold should remain where it is? Mike Mascari ---(end of broadcast)--- TIP 6: Have you

Re: [HACKERS] Function to kill backend

2004-04-03 Thread Mike Mascari
on Oracle is only a necessity if the DBA hasn't made use of resource limits - PROFILEs. ;-) Mike Mascari ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] SPI and bytea columns

2004-05-11 Thread Mike Mascari
to read the image file from disk? PostgreSQL really needs a maintained type library as a single project where people can contribute types, functions, operators, and aggregates, such as the recently discussed email type. Mike Mascari joke Just be sure not to actually compress/decompress the JPEG

Re: [HACKERS] The features I'm waiting for.

2004-05-04 Thread Mike Mascari
% of the bits in the postgres binary you'd not find it to be more buggy than the Postgres95/early 6.x series... Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] PITR Phase 2 - Design Planning

2004-04-29 Thread Mike Mascari
with the comment. Example: COMMIT WORK COMMENT 'A complex distributed Tx'; Perhaps there is some common ground between the 2PC implementation and PITR? Mike Mascari ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Mike Mascari
the advocacy group performed any polling in this area that might shed some light as to what users and potential users might want? Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Mike Mascari
important features like the IN optimization and a quick 7.5 would have Win32 and PITR. It's almost as if a cron job reposts this thread every 6 - 12 months. For those of us that are desirous of PITR, it's a 6 month reposting that is becoming painful to read... Mike Mascari

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Mike Mascari
Marc G. Fournier wrote: On Mon, 17 May 2004, Mike Mascari wrote: A quick google of 7.4 Win32 release will reveal that the above was precisely what was said about 7.4: it would be released to not hold up important features like the IN optimization and a quick 7.5 would have Win32 and PITR. It's

Re: [HACKERS] (Fwd) Re: Any Oracle 9 users? A test please...

2002-09-30 Thread Mike Mascari
is implementation dependent. Therefore PostgreSQL is in compliance, but its compliance is not very popular. Mike Mascari [EMAIL PROTECTED] Dan Langille wrote: DECLARE time1 TIMESTAMP; time2 TIMESTAMP; sleeptime NUMBER; BEGIN sleeptime := 5; SELECT CURRENT_TIMESTAMP INTO time1 FROM DUAL

Re: [HACKERS] (Fwd) Re: Any Oracle 9 users? A test please...

2002-09-30 Thread Mike Mascari
for the life of the invocation, while stored procedures don't. It is PostgreSQL, after all, that has merged the two concepts into one. Maybe someone could test version 9 with a FUNCTION that executes the same PL/SQL code and returns the difference between the two times. Mike Mascari [EMAIL

Re: [HACKERS] (Fwd) Re: Any Oracle 9 users? A test please...

2002-10-02 Thread Mike Mascari
successfully completed. SQL select * from rbr_foo; Oracle isn't processing those statements interactively. SQL*Plus is waiting on the / to send the PL/SQL block to the database. I suspect its not going to take Oracle more than a second to insert a row... Mike Mascari [EMAIL PROTECTED

Re: [HACKERS] (Fwd) Re: Any Oracle 9 users? A test please...

2002-10-02 Thread Mike Mascari
Bruce Momjian wrote: Mike Mascari wrote: Oracle isn't processing those statements interactively. SQL*Plus is waiting on the / to send the PL/SQL block to the database. I suspect its not going to take Oracle more than a second to insert a row... Oh, I understand now. He delayed when

Re: [HACKERS] (Fwd) Re: Any Oracle 9 users? A test please...

2002-10-02 Thread Mike Mascari
SELECT SYSDATE 15 INTO time2 16 FROM DUAL; 17 RETURN (time2 - time1); 18 END; 19 / Function created. SQL select mydiff FROM dual; MYDIFF -- .34722 I can't test the use of CURRENT_TIMESTAMP because I have Oracle 8, not 9. Mike Mascari [EMAIL PROTECTED

Re: [HACKERS] (Fwd) Re: Any Oracle 9 users? A test please...

2002-10-02 Thread Mike Mascari
/a90125/functions2.htm#80856 Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] [GENERAL] Postgres-based system to run .org registry?

2002-10-16 Thread Mike Mascari
the /. or the Oracle statement? Here's the Oracle statement: http://forum.icann.org/org-eval/gartner-report/msg0.html Hope that helps, Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] autocommit vs TRUNCATE et al

2002-10-18 Thread Mike Mascari
. Even though TRUNCATE was modeled after Oracle's TRUNCATE and Oracle's TRUNCATE commits the running tx, truncates the relation, and starts a new tx, regardless of whether or not TRUNCATE is the first statement of the tx? Mike Mascari [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] idle connection timeout ...

2002-10-25 Thread Mike Mascari
, such as PL/SQL recursion depth, a new attribute would be added to pg_profile to handle the limitation... Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] MySQL vs PostgreSQL.

2002-10-11 Thread Mike Mascari
, that's a joke...) Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Transactions through dblink_exec()

2002-10-13 Thread Mike Mascari
when the remote server issues the COMMIT and then the local server crashes? Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] idle connection timeout ...

2002-10-29 Thread Mike Mascari
Karel Zak wrote: On Fri, Oct 25, 2002 at 03:31:22PM -0400, Mike Mascari wrote: Bruce Momjian wrote: Added to TODO: * Allow limits on per-db/user connections Could I suggest that such a feature falls under the category of resource limits, and that the TODO should read something like

Re: [HACKERS] protocol change in 7.4

2002-11-04 Thread Mike Mascari
anything or if there is something you think we should add, please let me know. Is there any thought about changing the protocol to support two-phase commit? Not that 2PC and distributed transactions would be implemented in 7.4, but to prevent another protocol change in the future? Mike Mascari

Re: [HACKERS] protocol change in 7.4

2002-11-04 Thread Mike Mascari
Neil Conway wrote: Mike Mascari [EMAIL PROTECTED] writes: Is there any thought about changing the protocol to support two-phase commit? Not that 2PC and distributed transactions would be implemented in 7.4, but to prevent another protocol change in the future? My understanding is that 2PC

Re: [HACKERS] performance regression, 7.2.3 - 7.3b5 w/ VIEW

2002-11-12 Thread Mike Mascari
: Oracle functions invoked in DML statements can't record any changes to the database. So if the above is the cause, I wouldn't have any problems with the patch being reversed. Maybe separate privileges for read-only vs. read-write functions are in order at some point in the future though... Mike

Re: [HACKERS] Planning for improved versions of IN/NOT IN

2002-11-29 Thread Mike Mascari
/iexist.htm Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Planning for improved versions of IN/NOT IN

2002-11-30 Thread Mike Mascari
Tom Lane wrote: Mike Mascari [EMAIL PROTECTED] writes: I curious if any of the rewriting of EXISTS and NOT EXISTS would address the problem described by Date: That should read I'm curious... http://www.firstsql.com/iexist.htm We are not here to redefine the SQL spec ... and especially

Re: [HACKERS] 7.4 Wishlist

2002-12-02 Thread Mike Mascari
administration is supposed to work under such a scenario though... Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL

Re: [HACKERS] Big 7.4 items

2002-12-13 Thread Mike Mascari
=enlr=ie=UTF-8oe=UTF-8threadm=20021106111554.69ae1dcd.pgsql%40snaga.orgrnum=2prev=/groups%3Fq%3DNAGAYASU%2BSatoshi%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Big 7.4 items

2002-12-13 Thread Mike Mascari
Tom referenced earlier, but I'd guess there might be an assumption of 2PC support in the implementation. In other words, I think we still need 2PC, regardless of the method of replication. And if Satoshi Nagayasu has an implementation ready, why not investigate its possibilities? Mike Mascari

Re: [HACKERS] Big 7.4 items

2002-12-13 Thread Mike Mascari
- Original Message - From: Bruce Momjian [EMAIL PROTECTED] Mike Mascari wrote: Okay. But please keep in mind that a 2-phase commit implementation is used for more than just replication. This is a good point. I don't want to push Postgres-R as our solution. Rather, I have

Re: [HACKERS] Big 7.4 items

2002-12-13 Thread Mike Mascari
=%25N%13_446_START_RESTART_N%25 The standard is 2PC based. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-18 Thread Mike Mascari
in a Berkeley DB? ;-) Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] help with PL/PgSQL bug

2003-01-10 Thread Mike Mascari
) - 0 Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] help with PL/PgSQL bug

2003-01-11 Thread Mike Mascari
- Original Message - From: Tom Lane [EMAIL PROTECTED] Mike Mascari [EMAIL PROTECTED] writes: Does Oracle's PL/SQL have a concept of record variables? If so, what do they do in this situation? In Oracle 8, a row of NULLs: 1 CREATE OR REPLACE FUNCTION foo(t IN NUMBER) 2

Re: [HACKERS] help with PL/PgSQL bug

2003-01-12 Thread Mike Mascari
- Original Message - From: Tom Lane [EMAIL PROTECTED] Mike Mascari [EMAIL PROTECTED] writes: From: Tom Lane [EMAIL PROTECTED] That's a rowtype variable, though, not a record variable. I believe our code will work the same as Oracle for that case. 4 TYPE EmpRec IS RECORD

Re: [HACKERS] copying perms to another user

2003-01-14 Thread Mike Mascari
of an object to be a group (role) rather than strictly a user. Also, at least in Oracle, one can grant ROLEs to other ROLEs. I don't know if that is what the SQL standard says though: GRANT role1 TO role2; Mike Mascari [EMAIL PROTECTED] ---(end of broadcast

[HACKERS] Odd subselect in target list behavior WRT aggregates

2003-01-23 Thread Mike Mascari
appreciated. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Odd subselect in target list behavior WRT aggregates

2003-01-24 Thread Mike Mascari
Tom Lane wrote: Mike Mascari [EMAIL PROTECTED] writes: Hello. I have some code which generates subselects in the target list of a query and then aggregates the results. The code allows the user to determine the attributes of the aggregation. If the user chooses to aggregate on the same value

Re: [HACKERS] Roadmap for FE/BE protocol redesign

2003-03-12 Thread Mike Mascari
would be to replace the postmaster with a CORBA-based server process with a well defined interface. At a minimum, if a binary protocol is the ultimate destination, perhaps some of the mapping of various types could be borrowed from the specs. Mike Mascari [EMAIL PROTECTED

Re: [HACKERS] Vote totals for SET in aborted transaction

2002-04-25 Thread Mike Mascari
feature Oracle doesn't have, and to remain consistent, I agree with all of those that have voted for #1. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [HACKERS] Operator Comments

2002-05-13 Thread Mike Mascari
) ;-) Peter E. was rewriting psql and wanted the COMMENT on operators to reflect a COMMENT on the underlying function I submitted a patch to do that - I just do what I'm told ;-) Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] Feature request: Truncate table

2002-06-13 Thread Mike Mascari
in the same transaction, but that's about it. People have argued that if there are *RI* triggers on a table, that TRUNCATE should be disallowed, as in Oracle. But TRUNCATE from inception to date has never dropped triggers... Mike Mascari [EMAIL PROTECTED] ---(end

[HACKERS] Non-standard feature request

2002-06-13 Thread Mike Mascari
: ... ON COMMIT { DROP | { DELETE | PRESERVE } ROWS }; I suppose I could just change the code to query the catalogue for those temporary tables created during the transaction and issue DROP TABLEs by hand. But I thought it might be an idea of value to others. Mike Mascari [EMAIL PROTECTED

Re: [HACKERS] Non-standard feature request

2002-06-14 Thread Mike Mascari
Bruce Momjian wrote: Tom Lane wrote: Mike Mascari [EMAIL PROTECTED] writes: ... Would it be possible to have either a GUC setting or a grammar change to allow TEMPORARY tables to be dropped at transaction commit? This seems like a not unreasonable idea; but the lack of other

Re: [HACKERS] Non-standard feature request

2002-06-15 Thread Mike Mascari
Rocco Altier wrote: On Fri, 14 Jun 2002, Mike Mascari wrote: That is what I want to do, except by extending the grammar. I must admit to actually being surprised that a TEMP table created inside a transaction lived after the transaction completed. That's when I looked at the standard

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Mike Mascari
be nice to also have it fire up under Windows CE as well ;-) Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Non-standard feature request

2002-06-27 Thread Mike Mascari
is against 7.2.1 source. The grammar introduced is of the form: CREATE TEMP TABLE ... ON COMMIT DROP; Is this a desirable feature? Seems pretty useful to me. Great! I'm give this a try. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] [PATCHES] prepareable statements

2002-07-23 Thread Mike Mascari
command: EXECUTE my_procedure(); The Oracle call interface defines a function to call stored procedures: OCIStmtExecute(); Likewise, the privilege necessary to execute a stored procedure is 'EXECUTE' as in: GRANT EXECUTE ON my_procedure TO mascarm; Again, FWIW. Mike Mascari [EMAIL PROTECTED

Re: [HACKERS] Why is MySQL more chosen over PostgreSQL?

2002-07-29 Thread Mike Mascari
at a fast rate, perhaps faster than MySQL at this point. Its all due to sort-order. If Oracle was open source MySQL would still be more popular. ;-) Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] [SECURITY] DoS attack on backend possible (was: Re:

2002-08-12 Thread Mike Mascari
://www.cert.org/advisories/CA-2002-08.html I'd still think it would be a good policy to make a security release. However, without user resource limits in PostgreSQL, anyone can make a machine useless with a query like: SELECT * FROM pg_class a, pg_class b, pg_class c, pg_class d, pg_class e, ... ; Mike

Re: [HACKERS] Open 7.3 items

2002-08-15 Thread Mike Mascari
in the org.postgresql.text schema. How about them apples? If this is an insane idea, its 3:32 A.M. my time ;-) Mike Mascari [EMAIL PROTECTED] Joe ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

Re: [HACKERS] PGXLOG variable worthwhile?

2002-09-12 Thread Mike Mascari
CreateHardLink() if on 2K/XP 2. Will try to use the BackupWrite() method 3. Failing #2 will just copy the file See how fun Microsoft makes things? Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

Re: [HACKERS] PGXLOG variable worthwhile?

2002-09-12 Thread Mike Mascari
file notepad dir2.lnk - Displays link contents That means for a native port with a different PGXLOG directory running on NT4, the only choice *using links* is to make the native port shell short-cut aware. I could be wrong but I don't think so. Mike Mascari [EMAIL PROTECTED

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-18 Thread Mike Mascari
to simulate traditional unlink() behavior. Hope that helps, Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-18 Thread Mike Mascari
and the MOVEFILE_DELAY_UNTIL_REBOOT flag will add the appropriate entries into the system registry so that the next time the machine reboots it will remove the files specified. Its a real pain and a real hack of an OS. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-19 Thread Mike Mascari
Bruce Momjian wrote: Mike Mascari wrote: I will do some testing with concurrency and let you know. But don't get your hopes up. This is one of the many advantages that TABLESPACEs have when more than one relation is stored in a single DATAFILE. There was Oracle for MS-DOS, after all

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-19 Thread Mike Mascari
Mike Mascari wrote: Bruce Momjian wrote: Mike Mascari wrote: I will do some testing with concurrency and let you know. But don't get your hopes up. This is one of the many advantages that TABLESPACEs have when more than one relation is stored in a single DATAFILE. There was Oracle

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-19 Thread Mike Mascari
Bruce Momjian wrote: Mike Mascari wrote: Actually, looking at the pg_pwd code, you want to determine a way for: 1. Process 1 opens foo 2. Process 2 opens foo 3. Process 1 creates bar 4. Process 1 renames bar to foo 5. Process 2 can continue to read data from the open file handle and get

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-19 Thread Mike Mascari
Stephan Szabo wrote: On Fri, 20 Sep 2002, Mike Mascari wrote: Bruce Momjian wrote: Mike Mascari wrote: Actually, looking at the pg_pwd code, you want to determine a way for: 1. Process 1 opens foo 2. Process 2 opens foo 3. Process 1 creates bar 4. Process 1 renames bar to foo 5. Process 2 can

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-19 Thread Mike Mascari
that TABLESPACEs have when more than one relation is stored in a single DATAFILE. There was Oracle for MS-DOS, after all.. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-20 Thread Mike Mascari
Stephan Szabo wrote: On Fri, 20 Sep 2002, Mike Mascari wrote: Yes! Indeed that does work. Thinking back, I think that may still fail on Win95 (using MoveFile). Once in the past I had to work on (un)installers for Win* and I vaguely remember Win95 being more strict than Win98 but that may

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-20 Thread Mike Mascari
CreateFile() with FILE_SHARE_DELETE, then any subsequent CreateFile() calls will fail unless they too have FILE_SHARE_DELETE. In other words, if one of us can delete this file while its open, any of us can. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-20 Thread Mike Mascari
Stephan Szabo wrote: On Fri, 20 Sep 2002, Mike Mascari wrote: I think that's a rather poor description. I think it just means that if the file is opened once via CreateFile() with FILE_SHARE_DELETE, then any subsequent CreateFile() calls will fail unless they too have FILE_SHARE_DELETE

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-20 Thread Mike Mascari
be Access Denied. Are the places in the backend that use rename() and unlink() renaming and unlinking files that are only opened for a brief moment by other backends? Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our

[HACKERS] Temp tables and LRU-K caching

2002-09-23 Thread Mike Mascari
that the SQL standard defines temporary relations as surviving across transactions? If so, I'd bet those of us who use transaction-local temporary tables could get few drops more of performance from an ON COMMIT drop patch w/o fsync. Any thoughts? Mike Mascari [EMAIL PROTECTED

Re: [HACKERS] Temp tables and LRU-K caching

2002-09-23 Thread Mike Mascari
Tom Lane wrote: Mike Mascari [EMAIL PROTECTED] writes: Bruce wrote: Yes, someone from India has a project to test LRU-K and MRU for large table scans and report back the results. He will implement whichever is best. Did this make it into 7.3? No, we never heard back from that guy

RE: [HACKERS] Truncation of char, varchar types

2001-04-10 Thread Mike Mascari
This is what I get in Oracle 8: SQL CREATE TABLE test (value VARCHAR (10)); Table created. SQL INSERT INTO test VALUES ('Mike Mascari'); INSERT INTO test VALUES ('Mike Mascari') * ERROR at line 1: ORA-01401: inserted value too large for column SQL quit Of course, if the standard

RE: [HACKERS] Truncation of object names

2001-04-16 Thread Mike Mascari
ow, anyone can query this table as: SELECT * FROM employees; Its a namespace thing, basically. Hope that helps, Mike Mascari [EMAIL PROTECTED] -Original Message- From: Christopher Kings-Lynne [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 10:17 PM To: [EMAIL PROTECTED] Subject:

Re: [HACKERS] System catalog representation of access privileges

2001-04-19 Thread Mike Mascari
that each new feature added to PostgreSQL opens up a very large can of worms. Schemas are such a feature and the security system should be prepared for it. FWIW, Mike Mascari [EMAIL PROTECTED] Peter Eisentraut wrote: It would make sense to split privileges on tables from privileges on schemas

[HACKERS] Any optimizations to the join code in 7.1?

2001-04-25 Thread Mike Mascari
as possible, but I looked through the change log and didn't see anything specific WRT large joins. I was wondering if any work had been done in that area for 7.1. I realize you can only squeeze so much blood from stone, but Thanks for any info, Mike Mascari [EMAIL PROTECTED

RE: [HACKERS] Any optimizations to the join code in 7.1?

2001-04-27 Thread Mike Mascari
impressive improvement in planning speeduntil I actually used the explicit JOIN syntax described in 11.2. Instanteous results! Instantaneous. Thanks a bunch, (still in shock) Mike Mascari [EMAIL PROTECTED] -Original Message- From: Tom Lane [SMTP:[EMAIL PROTECTED]] Sent

RE: [HACKERS] Re: Any optimizations to the join code in 7.1?

2001-04-27 Thread Mike Mascari
. With the explicit join syntax, it allows me to design the database 'the right way'. I basically used EXPLAIN SELECT... to determine the explicit join order, so as the data changes, its something I'll have to do on occassion to ensure good performance, but at least its now possible. :-) Mike Mascari

[HACKERS] Possible feature?

2001-07-11 Thread Mike Mascari
, much like pg_description and COMMENT ON. This is obviously an informal suggestion to determine if the idea should be rejected out-of-hand. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] Is there a way to drop and restore an index?

2001-08-01 Thread Mike Mascari
to automatically reindex your entire DB. Just a thought, Mike Mascari [EMAIL PROTECTED] Tony Reina wrote: I recall seeing a message by Tom Lane stating that dropping and re-creating a primary index may speed up db performance. Is there a SQL command that will do this? My current method

Re: [HACKERS] Planned change in initdb-time OID allocation

2001-08-06 Thread Mike Mascari
to the language in which the database is installed, but it wouldn't care what OIDs were assigned (if any) to the various objects being documented. Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] [GENERAL] To Postgres Devs : Wouldn't changing the select

2001-10-22 Thread Mike Mascari
for users to use. Just my 2 cents, of course, Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

2001-10-24 Thread Mike Mascari
salaries; no rows selected So it seems to me that the major reason is to preserve GRANT/REVOKE privileges issues against the object in question. FWIW, Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

2001-10-09 Thread Mike Mascari
statistics collector, Oracle's profiles must be enabled in the initSID.ora configuration file since it takes a few cycles to actually account for user activity. Mike Mascari [EMAIL PROTECTED] Tom Lane writes: I believe the primary reason why PL languages aren't installed by default

Re: [HACKERS] Setting Password

2001-10-10 Thread Mike Mascari
You need to change the pg_hba.conf file in your PostgreSQL installation so that password authentication is used. Check out: http://www.postgresql.org/idocs/index.php?client-authentication.html for details. Hope that helps, Mike Mascari [EMAIL PROTECTED] Balaji Venkatesan wrote: Hi List

Re: [HACKERS] Win32, PITR, nested transactions, tablespaces

2004-05-28 Thread Mike Mascari
: http://www.us-cert.gov/cas/techalerts/TA04-147A.html For what it's worth, Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] I just got it: PostgreSQL Application Server -- a new

2004-06-12 Thread Mike Mascari
leading a secret life... Mike Mascari ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] placeholder syntax

2004-06-21 Thread Mike Mascari
- who knows where) changed its behavior and never performed similarly... Mike Mascari ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] warning missing

2004-06-25 Thread Mike Mascari
Inheritance: No I think it'd be a fair statement that Date Darwen would have the relvar inheritance ripped out of PostgreSQL as an experiment gone bad... Mike Mascari P.S.: D is the language of the future: http://www.digitalmars.com/d Ha! ---(end of broadcast

Re: [HACKERS] Nested Transactions, Abort All

2004-07-02 Thread Mike Mascari
::= savepoint name | simple target specification savepoint name ::= identifier and rollback statement ::= ROLLBACK [ WORK ] [ AND[ NO ] CHAIN ] [ savepoint clause ] savepoint clause ::= TO SAVEPOINT savepoint specifier Mike Mascari ---(end of broadcast

Re: [HACKERS] LinuxTag wrapup

2004-07-03 Thread Mike Mascari
they'll look like a fool pronouncing the name aloud. I remember back in '94 being corrected when talking about Linux in the enterprise - and I was corrected in the wrong direction. Someone needs to poke the propaganda minister with a stick. Mike Mascari ---(end of broadcast

  1   2   >