Re: [HACKERS] Threads

2003-01-03 Thread [EMAIL PROTECTED]
I am sure, many of you would like to delete this message before reading, hold on. :-) I'm afraid most posters did not read the message. Those who replied Why bother? did not address your challenge: I think threads are useful in difference situations namely parallelising blocking

Re: Windows Build System was: [HACKERS] Win32 port patches

2003-01-22 Thread [EMAIL PROTECTED]
Firebird uses a set of Borland command line tools and Borland's make, which they give away as a free download. Even if you're compiling for Windows, the build process uses Borland's command line make. A batch build script copies makefiles from a single source directory and spreads them

[HACKERS] mV database tools

2002-05-01 Thread [EMAIL PROTECTED]
Dear Team, I have been monitoring this list for quite some time now and have been studying PostGreSQL for a while. I also did some internet research on the subject of "multi valued" database theory. I know that this is the basis for the "Pick" database system, FileMaker Pro, "D3", and a

[HACKERS] mV database tools

2002-05-02 Thread [EMAIL PROTECTED]
Dear Team, I've read your comments. No, I don't think that MVD's are the best thing since sliced breadbut they do have a certain "simplicity" that seems to hold the key to high speed analysis of large volumes of streaming data from the "eyes" of a robot. This stream of data must be

[HACKERS] mV database tools

2002-05-02 Thread [EMAIL PROTECTED]
Dear Team, I'm wide open to other ideas for the support of robotic vision through tools already built into PostGreSQL. But you've already admitted to certain speed limitations...and robotic vision is going to require much more intense processing power. An MVD might allow the data stream to

Re: [HACKERS] pg_access

2002-07-09 Thread [EMAIL PROTECTED]
I'm pleased to see some renewed interest in pg_access. It seems obvious to me that MS Access is not currently...and probably never will be able to handle data in a robust and reliable fashion. MS Access' apparent success is due to the user interface quality and "ease of use" for

Re: [HACKERS] pg_access

2002-07-09 Thread [EMAIL PROTECTED]
ows users are far less forgiving. If, what you are talking about, is truly wide spread use for PC’s and small-time web-servers then a Windows interface is damn near necessary. Eric -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]Sent: T

[HACKERS] urgent needed

2002-07-12 Thread [EMAIL PROTECTED]
banca, più interessi. Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=657d=12-7 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] Re: OID wraparound (was Re: pg_depend)

2001-07-23 Thread [EMAIL PROTECTED]
[EMAIL PROTECTED] (Lamar Owen) wrote in message news:[EMAIL PROTECTED]... [trimmed cc:list] On Wednesday 18 July 2001 17:09, Bruce Momjian wrote: OK, we need to vote on whether Oid's are optional, and whether we can have them not created by default. [All the below IMHO] OID's

[HACKERS] Can't subscribe or get CVS

2001-09-27 Thread [EMAIL PROTECTED]
I just tried to get PostgreSQL from CVS , but it rejected the password 'postgresql' for user 'anoncvs': $ export CVSROOT=:pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot $ cvs login (Logging in to [EMAIL PROTECTED]) CVS password: cvs login: authorization failed

Re: [HACKERS] Re: We have got a serious problem with pg_clog/WAL synchronization

2004-08-13 Thread [EMAIL PROTECTED]
On Thu, Aug 12, 2004 at 01:13:46PM -0400, Tom Lane wrote: Kenneth Marshall [EMAIL PROTECTED] writes: On Thu, Aug 12, 2004 at 09:58:56AM -0400, Tom Lane wrote: How would a read-only action work to block out the checkpoint? The latch+version number is use by the checkpoint process

[HACKERS] Development Schedule Page

2004-08-13 Thread [EMAIL PROTECTED]
Please could we have a development schedule page on the web site...? The information it should contain would be like this (and others) Current Development Release: (Coordinator: Bruce Momjian) 8.0:Beta1, released 2 August 2004 Beta2, deadline 2 September 2004

Re: [HACKERS] Development Schedule Page

2004-08-13 Thread [EMAIL PROTECTED]
Tom Lane [EMAIL PROTECTED] [EMAIL PROTECTED] writes: Please could we have a development schedule page on the web site...? You haven't been around here long, have you? Gee, Tom, you noticed? What gave it away? :) (I wasn't in a legal position to contribute before late 2003 - binding IP

Re: [HACKERS] Re: We have got a serious problem with pg_clog/WAL synchronization

2004-08-13 Thread [EMAIL PROTECTED]
Tom Lane [EMAIL PROTECTED] [EMAIL PROTECTED] writes: This is not a provably correct state machine I think the discussion ends right there. Yes... Negative results are worth documenting too, IMHO. Best Regards, Simon Riggs ---(end of broadcast

[HACKERS] PITR on Windows?

2004-08-13 Thread [EMAIL PROTECTED]
I notice that PITR doesn't function correctly on Windows. Has that been reported elsewhere? The archive_command parameter %p resolves to a full path containing slashes rather than backslashes. This is not a Windows file, so any attempt to copy it fails. There isn't any way to avoid that. I'm

Re: [HACKERS] NOT LOGGED options (was Point in Time Recovery )

2004-08-14 Thread [EMAIL PROTECTED]
Tom Lane wrote [EMAIL PROTECTED] [EMAIL PROTECTED] writes: It would be my intention (in 8.1) to make those available via switches e.g. NOT LOGGED options on CREATE INDEX and COPY, to allow users to take advantage of the no logging optimization without turning off PITR system wide. (Just

Re: [HACKERS] will PITR in 8.0 be usable for hot spare/log shipping type of replication

2004-08-14 Thread [EMAIL PROTECTED]
Tom Lane Eric Kerin [EMAIL PROTECTED] writes: The issues I've seen are: 1. Knowing when the master has finished the file transfer transfer to the backup. The standard solution to this is you write to a temporary file name (generated off your process PID, or some other convenient

Re: [HACKERS] Opinions on Usenet ...

2004-11-29 Thread [EMAIL PROTECTED]
[EMAIL PROTECTED] (Gevik Babakhani) writes: Maybe it is me but, I am trying to send a posting regarding a solution proposal for a TODO item. My posting has a .tgz attachment but it seems that it never arives at hackers list! This is very frustrating. I even ask Bruce for help. how big

[HACKERS]

2005-05-07 Thread [EMAIL PROTECTED]
unsubscribe ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] postgres questions (semi-joins, algebraic space)

2005-12-02 Thread [EMAIL PROTECTED]
Good Morning, I'm an italian student and I'm working on a project involving postgres. I'm sorry for my very bad english. I've some questions: 1)Does postgres upport semi-joins? 2)What about projections or selections in query tree writing? Does Postgres support algebraic space (in other word

[HACKERS]

2005-12-02 Thread [EMAIL PROTECTED]
Good Morning, I'm an italian student and I'm working on a project involving postgres. I'm sorry for my very bad english. I've some questions: 1)Does postgres upport semi-joins? 2)What about projections or selections in query tree writing? Does Postgres support algebraic space (in other word

[HACKERS] how can i get the binary format of timestamp?

2006-04-17 Thread [EMAIL PROTECTED]
Hello: I find that the real timestamp format(got from the file which is produced by copying binary to ) is different from what i find in timestamp_send func. i do think that the binary format of a timestamp 2006-04-18 11:20:20 should be 44 2B B0 6A 00 00 00 00 standing for secs:1143713898,

Re: [HACKERS] how can i get the binary format of timestamp?

2006-04-19 Thread [EMAIL PROTECTED]
the binary format of timestamp /*/ so ,what switch should i turn on? === 2006-04-18 21:47:42 You Wrote:=== [EMAIL PROTECTED] [EMAIL PROTECTED] writes: timestamp is defined as int64

[HACKERS] Statement-level Triggers

2003-08-14 Thread [EMAIL PROTECTED]
Hello everybody, how far have you got with statement-level triggers development? Regards, Claudio. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] pgscripts improvement

2003-10-09 Thread [EMAIL PROTECTED]
Fixed up alignment problems and improved some translations. Regards, Fabrizio Mazzoni # SOME DESCRIPTIVE TITLE. # FIRST AUTHOR [EMAIL PROTECTED], YEAR. # msgid msgstr Project-Id-Version: PostgreSQL v7.4\n POT-Creation-Date: 2003-10-05 13:26-0300\n PO-Revision-Date: 2003-10-09 23:58+0100\n

[HACKERS] pg_resetxlog fixed

2003-10-09 Thread [EMAIL PROTECTED]
Changed a couple of lines and traslated them in a better way. Regards, Fabrizio Mazzoni # SOME DESCRIPTIVE TITLE. # FIRST AUTHOR [EMAIL PROTECTED], YEAR. # msgid msgstr Project-Id-Version: PostgreSQL v7.4\n POT-Creation-Date: 2003-10-05 13:25-0300\n PO-Revision-Date: 2003-10-09 23:35+0100\n

Re: [HACKERS] Possible explanation for Win32 stats regression test

2006-07-29 Thread [EMAIL PROTECTED]
Is anyone working on this? Tom Lane wrote: korry [EMAIL PROTECTED] writes: The problem is that, each time you go through pgwin32_waitforsinglesocket(), you tie the *same* kernel object (waitevent is static) to each socket. The fix is pretty simple - just call WSAEventSelect( s

Re: [PATCHES] [HACKERS] Possible explanation for Win32 stats

2006-07-29 Thread [EMAIL PROTECTED]
. -- Korry Korry Douglas [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] pg_terminate_backend

2006-08-03 Thread [EMAIL PROTECTED]
I am not sure how you prove the non-existance of a bug. Ideas? I do that by deleting all of my code (usually by accident :-) No code, no bugs! -- Korry

Re: [HACKERS] [PATCHES] PL instrumentation plugin support (i.e. PL/pgSQL

2006-08-08 Thread [EMAIL PROTECTED]
be great. Can you point me to the patch you're referring to? I can convert my patch if you prefer. -- Korry -- Korry Douglas [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] 8.2 features status

2006-08-09 Thread [EMAIL PROTECTED]
easier for new hackers to get started. A developers' wiki with links into the list archives would be great. My thoughts exactly... -- Korry Douglas [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] proposal for PL packages for 8.3.

2006-08-09 Thread [EMAIL PROTECTED]
? Looking at this: http://thinkoracle.blogspot.com/2005/10/oracle-packages.html it seems varaiable are per-session. Package variables are per-session. Don't forget package initializers too... -- Korry Douglas [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] Plugins redux (was Re: [PATCHES] PL instrumentation plugin

2006-08-09 Thread [EMAIL PROTECTED]
with backend_load_libraries, and so perhaps clearer about which does what Makes sense to me, of course that breaks existing postgresql.conf files. Do you want me to do any of this coding? -- Korry Douglas [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] Plugins redux (was Re: [PATCHES] PL instrumentation

2006-08-09 Thread [EMAIL PROTECTED]
of this coding? Up to you --- I can do it if you don't want to. I'll take a stab at it... thanks for your help so far. -- Korry -- Korry Douglas [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] Plugins redux (was Re: [PATCHES] PL instrumentation plugin

2006-08-10 Thread [EMAIL PROTECTED]
to BeginReportingGUCOptions() - by that time, we know whether we are a superuser and we have processed all GUC options. Also, should we create an on_proc_exit() handler that would unload all dynamic libraries (specifically to call the _PG_fini() functions)? -- Korry -- Korry Douglas [EMAIL PROTECTED

Re: [HACKERS] Plugins redux (was Re: [PATCHES] PL instrumentation

2006-08-10 Thread [EMAIL PROTECTED]
you don't feel the need to unload old shared libraries if the user (a superuser) removes an entry from backend_load_libraries, right? In fact, it looks _PG_fini() is only called if you *reload* a library, unless I'm missing something somwhere. -- Korry Douglas [EMAIL PROTECTED] EnterpriseDB

Re: [HACKERS] [PATCHES] PL instrumentation plugin and Rendezvous variable

2006-08-15 Thread [EMAIL PROTECTED]
. -- Korry -- Korry Douglas [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] find the template of a database in SQL

2006-08-18 Thread [EMAIL PROTECTED]
-- Korry Douglas [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com

[HACKERS] Synchronization Primitives

2008-11-13 Thread [EMAIL PROTECTED]
Hi all: I am a fresh men in PostgreSQL. And i work on benchmark study these days using PostgreSQL. Now i have a question: Is there some way to show the lock contention of PostgreSQL? As I know, you can use *show mutex status* in MySQL to find which mutex is hot. But i don't know in

[HACKERS] status of PlPython

2007-05-29 Thread [EMAIL PROTECTED]
I wonder if I should use PlPython in my projects or not. Browsing on the Python list it seems that nobody is using it. Browsing on Google Groups I find worrysome threads talking about removing support from it in future versions of PostgreSQL. So, I would like to know what's the current status of

[HACKERS] Oprofile with postgresql

2008-08-08 Thread [EMAIL PROTECTED]
Hi all: Recently i do a test of postgresql. To get more information of the functions in PostgreSQL, i use opgprof and opannotate, which are two tools in Oprofile. But i can't work with the tools correctly. PostgreSQL is compiled with -g option and the errors are like this: opgprof

[HACKERS] data access automatic filter

2007-11-09 Thread [EMAIL PROTECTED]
FINO A PRIMAVERA 2008! http://abbonati.tiscali.it/adsl/prodotti/tc/tandemfree_tel_cc/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[HACKERS] Pl/Java broken since Postgresql 8.3-rc1

2008-01-14 Thread [EMAIL PROTECTED]
Hi there, as you now is plJava broken with the actual security releases. There is a pljava.dll at http://www.ejurka.com/pgsql/pljava/83rc1/ to fix it for version 8.3RC1. Is a pljava.dll for version 8.2.6 out? It's very important for me, need it for my office. Juergen

Re: [HACKERS] hstore isexists

2006-10-11 Thread [EMAIL PROTECTED]
'exists' isn't a good name for function :(. Yeah, that isn't going to work. Perhaps ifexists? Or just leave well enough alone. Darn. Can't have been thinking clearly this morning. How about exist (no s)? Maybe 'found', 'present', or 'contains'? (no, I haven't checked

[HACKERS] Problem in buidind Postgres with mingw

2006-11-14 Thread [EMAIL PROTECTED]
: $make the outcome is the following: Paolo [EMAIL PROTECTED] /d/msys/1.0/home/src/postgresql-8.1.4 $ make make -C doc all make[1]: Entering directory `/d/msys/1.0/home/src/postgresql-8.1.4/doc' gzip -d -c man.tar.gz | /bin/tar xf - for file in man1/*.1; do \ mv $file $file.bak \ sed -e 's/\\fR(l

[HACKERS] return varchar from C function

2007-02-18 Thread [EMAIL PROTECTED]
Hi, just for fun, I wrote a little postgresql contrib, who has a C function called myfun inside it. The function myfun returns a value , now I return a cstring type value, and it works fine if I run from psql shell: select value from myfun(paramteres); but I can't do an insert like: insert

[HACKERS] ECPG, threading and pooling

2003-01-23 Thread Shridhar Daithankar[EMAIL PROTECTED]
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Benchmarks

2003-02-11 Thread Shridhar Daithankar[EMAIL PROTECTED]
of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Changing the default configuration (was Re: [pgsql-advocacy]

2003-02-11 Thread Shridhar Daithankar[EMAIL PROTECTED]
On Tuesday 11 Feb 2003 10:56 pm, you wrote: Josh Berkus [EMAIL PROTECTED] writes: What if we supplied several sample .conf files, and let the user choose which to copy into the database directory? We could have a high read performance profile, and a transaction database profile

Re: [HACKERS] location of the configuration files

2003-02-14 Thread Shridhar Daithankar[EMAIL PROTECTED]
On Friday 14 Feb 2003 9:05 pm, you wrote: Martin Coxall [EMAIL PROTECTED] writes: Here's a pretty topic for a flamewar: should it be /etc/postgres/ or /etc/postgresql/ ? I vote for /etc/pgsql. Keeping in line of unix philosophy of cryptic and short names. Who wants a descriptive names anyway

[HACKERS] Thread safe ecpg

2003-02-24 Thread Shridhar Daithankar[EMAIL PROTECTED]
Hi all, I was just wondering.The patches for making ecpg thread safe that were floating around few days back, are they going to make in any near future releases? I am badly bitten by libpq as code i my multithreaded app. is growing steadily. I find myself making stupid mistakes every now and

[HACKERS] Primary key and references

2003-03-18 Thread Shridhar Daithankar[EMAIL PROTECTED]
Hi, Today I discovered that if there is a compund primary key on a table, I can not create a reference from another table to one of the fields in the primary key.. Look at this.. phd=# create table tmp1(a integer,b integer,primary key(a,b)); NOTICE: CREATE TABLE / PRIMARY KEY will create

[HACKERS] Another naive question, inheritance and foreign key

2003-03-19 Thread Shridhar Daithankar[EMAIL PROTECTED]
Hi, Just stumbled upon this. Is it correct to conclude that foreign keys are not inherited from this text? phd=# create table perbookings(type smallint) inherits (bookings); CREATE TABLE phd=# \d perbookings; Table public.perbookings Column |

Fwd: Re: [HACKERS] [GENERAL] Extracting time from timestamp

2003-03-20 Thread Shridhar Daithankar[EMAIL PROTECTED]
almost a day on it.. Shridhar P.S. Sorry, I didn't realized that I handn' CC hackers.. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: Fwd: Re: [HACKERS] [GENERAL] Extracting time from timestamp

2003-03-20 Thread Shridhar Daithankar[EMAIL PROTECTED]
On Friday 21 Mar 2003 12:25 pm, Tom Lane wrote: Shridhar Daithankar[EMAIL PROTECTED] [EMAIL PROTECTED] writes: And What's so holy about if it is a function? The problem is that TIME(n) is a datatype name, not a function call, according to the SQL spec. Likewise for TIMESTAMP(n), INTERVAL

Re: [HACKERS] Script binaries renaming

2008-03-26 Thread k Kotala [EMAIL PROTECTED]
Bruce Momjian napsal(a): Where are we on this? Tom thinks we don't want this. TODO has: I plan to send survey on general list about it today. Zdenek -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: