Re: [HACKERS] Python 3.1 support

Am 19.11.2009 18:01, schrieb James Pye: On Nov 19, 2009, at 3:12 AM, Peter Eisentraut wrote: The other approach, which is what James Pye's new implementation proposes (as I understand it), is to convert PostgreSQL types into specially made Python objects, such as Postgres.types.record or Postgre

Re: [HACKERS] MySQL Compatibility WAS: 8.5 release timetable, again

Tom Lane wrote: Greg Stark writes: Actually it always bothered me that we don't have implicit casts from integer->boolean. I can't see any ambiguity or unintentional effects this would cause problems with. Am I missing something? Personally, as an old Pascal-lover, I always thought that C's f

Re: [HACKERS] [GENERAL] Performance of full outer join in 8.3

Tom Lane wrote: Greg Stark writes: ... I suppose if we had explain-to-a-table then we could run explain and then run an sql query to verify the specific properties we were looking for. A similar thing could be done with xml if we had powerful enough xml predicates but we have a lot more sql

Re: [HACKERS] [GENERAL] string_to_array with empty input

Robert Haas wrote: On Wed, Apr 1, 2009 at 3:49 PM, Sam Mason wrote: On Wed, Apr 01, 2009 at 03:19:23PM -0400, Robert Haas wrote: On Wed, Apr 1, 2009 at 12:52 PM, David E. Wheeler wrote: Well, I'd just point out that the return value of string_to_array() is text[]. Thus, this is not a problem

Re: [HACKERS] cross-compiling plpython

Nikhil Sontakke wrote: So, I realized that there does not seem to be an easy way for cross compiling plpython. The configure checks for the locally installed python include locations and eventually the plpython makefile ends up picking all the local includes too. Does anyone have any experien

Re: [HACKERS] Simple postgresql.conf wizard

Greg Smith wrote: One of the long-terms goals I'm working toward is wrapping a "wizard" interface around the tuning guidelines described by http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server now that those have gone through a fair amount of peer review. Attached is a first simple v

Re: [HACKERS] Keeping creation time of objects

Hi, Devrim GÜNDÜZ wrote: On Tue, 2008-09-09 at 15:36 -0400, Tom Lane wrote: why would creation time (as opposed to any other time, eg last schema modification, last data modification, yadda yadda) be especially significant? Hmm, those would be cool, too. maybe except last data modification.

Re: [HACKERS] XML / XSL rendering in PostgreSQL server?

Hi, Peter Sampson wrote: Hi, I would like to use one of the XML rendering functions like table_to_xml_and_xmlschema OR table_to_xml and render the output via XSL, preferably in one query. What do you think would be the benefit of doing that? I've searched the mailing lists,site, docs and G

Re: [HACKERS] PL/PythonU

Hannu Krosing wrote: On Mon, 2008-08-04 at 13:08 -0400, David Blewett wrote: Hi All: This is an off-shoot of the "Do we really want to migrate plproxy and citext into PG core distribution?" thread. On the way home from PyOhio, I had a conversation with a few people that use Zope a lot. I happe

Re: [HACKERS] Identifier case folding notes

Hi, Peter Eisentraut wrote: ... 4. Compare the "name" data type in a case-insensitive manner. This would probably address most problem cases. Again, you can't have objects with names different in case only. One condition to implementing this would be that this behavior would have be tied do

Re: [HACKERS] Posting to hackers and patches lists

Bruce Momjian wrote: Tom Lane wrote: ... * no permanent archive of the submitted patch * reviewer won't know if the submitter changes the patch after he downloads a copy, and in fact nobody will ever know unless the submitter takes the time to compare the eventual commit to what he thinks the

Re: [HACKERS] Git Repository for WITH RECURSIVE and others

David Fetter wrote: Folks, With lots of help from Greg Sabino Mullane, I've set up a git repository for the WITH RECURSIVE patches on . What other patches would people like to try maintaining this way until commitfest? It looks like gitosis is a good way to grant wr

Re: [HACKERS] Case-Insensitve Text Comparison

Andrew Sullivan wrote: ... I think if you want some special treatment of text for some users, it should be explicit. Yes. Also, not just text. Think of currency, numeric separators, &c. Which imho, should not really be the business of the type interface but instead something to_char() and

Re: [HACKERS] Setting a pre-existing index as a primary key

Joshua D. Drake wrote: Tom Lane wrote: Well it should be optional but it would be nice if we had the option to have it renamed per the default... meaning the same output if I were to do this: If you want that, you can rename the index (either before or afterwards). I don't see any reason to

Re: [HACKERS] Auto-updated fields

David Fetter wrote: Folks, A co-worker pointed out to me that MySQL has a feature that, properly implemented and maybe extended, could be handy, namely what MySQL calls a "timestamp" field, so here's a proposal: 1. Create a generic (possibly overloaded) trigger function, bundled with PostgreSQ

Re: [HACKERS] Protection from SQL injection

Andrew Dunstan wrote: Tino Wildenhain wrote: Hi, In C the best practice is to use #define for constants. In C++ you have 'const', in Java 'static final'. Unfortunately the 'named constant' concept doesn't exist in SQL. I think that's a mistake. I sugg

Re: [HACKERS] Protection from SQL injection

Hi, In C the best practice is to use #define for constants. In C++ you have 'const', in Java 'static final'. Unfortunately the 'named constant' concept doesn't exist in SQL. I think that's a mistake. I suggest to support CREATE CONSTANT ... VALUE ... and DROP CONSTANT ..., example: CREATE CONSTA

Re: [HACKERS] TODO, FAQs to Wiki?

Joshua D. Drake wrote: On Mon, 21 Apr 2008 19:06:53 +0200 Tino Wildenhain <[EMAIL PROTECTED]> wrote: Well... or reStructuredText which has the advantage of beeing human editable? (without specialized editor that is) Huh? How is XML not human editable... didn't you ever create web

Re: [HACKERS] TODO, FAQs to Wiki?

Greg Smith wrote: On Mon, 21 Apr 2008, Tino Wildenhain wrote: Alvaro Herrera wrote: I suggest we start an experiment with the FAQ in XML Docbook, which is amenable to automatic processing, and move from there. Well... or reStructuredText which has the advantage of beeing human editable

Re: [HACKERS] TODO, FAQs to Wiki?

Alvaro Herrera wrote: Bruce Momjian wrote: Alvaro Herrera wrote: As far as I know, what the doc translators do is translate the SGML files directly, which is as difficult and cumbersome as you can possibly get. I am in no way suggesting we do that for the FAQ. What can we do to help people

Re: [HACKERS] modules

Hi, D'Arcy J.M. Cain wrote: ... Yes but what I am suggesting goes beyond that. My idea is that there is a modules directory that contains a file for each installable module. This file would contain all the information about the module such as name, version, where to get the actual package, an

Re: [HACKERS] Surfacing qualifiers

Tom Lane wrote: David Fetter <[EMAIL PROTECTED]> writes: You mentioned in an earlier mail that the information exposed was inadequate. Could you sketch out what information would really be needed and where to find it? The main problem with what you suggest is that it'll fail utterly on join q

Re: [HACKERS] Permanent settings

Hi, Magnus Hagander wrote: ... Can you explain why this wouldn't be usable? Because you will end up with an ever-growing file, that will be a PITA to deal with. Consider it after 10k+ changes. (yes, I can see that happening. You know how some people use GUIs) Or 100k. The problem does not happ

Re: [HACKERS] PostgreSQL 8.4 development plan

Tom Lane wrote: Dimitri Fontaine <[EMAIL PROTECTED]> writes: Le Wednesday 06 February 2008 21:35:54 Peter Eisentraut, vous avez écrit : Yes, I feel we could use a group writeable patch queue of some sort. Perhaps an IMAP server setup could do the job. I've read some developers appreciating t

Re: [HACKERS] plperl vs. bytea

Andrew Dunstan schrieb: Tino Wildenhain wrote: Martijn van Oosterhout schrieb: ... > I do have one problem though: for bytea/integers/floats Perl has > appropriate internel representations. But what about other user-defined > types? Say the user-defined UUID type, it should prob

Re: [HACKERS] plperl vs. bytea

Martijn van Oosterhout schrieb: ... > I do have one problem though: for bytea/integers/floats Perl has > appropriate internel representations. But what about other user-defined > types? Say the user-defined UUID type, it should probably also passed > by a byte string, yet how could Perl know that.

Re: [HACKERS] XML export

Peter Eisentraut schrieb: The issue of XML export has been discussed a few times throughout history. Right now you've got the HTML output in psql. A few people have proposed "real" XML output formats in psql or elsewhere. I dug out some old code today that implements what SQL/XML has to say on

Re: [HACKERS] "May", "can", "might"

Bruce Momjian schrieb: I have made these adjustments to the documentation. Do people want the error message strings also updated? It will probably make the translation easier/clearer in the future, but it does involve some error message wording churn. CVS HEAD only, of course. I still think

Re: [HACKERS] pgsql: Fix for plpython functions; return true/false for boolean,

Bruce Momjian schrieb: Hannu Krosing wrote: Officially by who ? 2.3 was the first version to introduce bool as a subtype of int, in 2.2.3 True and False were introduced as two variables pointing to integers 1 and 0. So to make your patch ok on all python versions, just make it conditional on p

Re: [HACKERS] STOP all user access except for admin for a few minutes?

[EMAIL PROTECTED] schrieb: Thx Russel, I want to control it from software, changing network access via pg_hba with software doesnt feel right. possible case Say I have a Group called Normal_Rights and one called Zero_Rights. So dB runs as... Normal_Rights(User

Re: [HACKERS] -f option for pg_dumpall

Tom Lane schrieb: Dave Page <[EMAIL PROTECTED]> writes: As far as I can see, adding a -f option to pg_dumpall should be straight forward, the only issue being that we'd need to pass pg_dump an additional (undocumented?) option to tell it to append to the output file instead of writing it as norm

Re: [HACKERS] ideas for auto-processing patches

[EMAIL PROTECTED] schrieb: On 1/4/07, Gavin Sherry <[EMAIL PROTECTED]> wrote: On Thu, 4 Jan 2007, Andrew Dunstan wrote: ... Pulling branches from anonvcvs regularly might be burdensome bandwidth-wise. So, like you say, a local mirror would be beneficial for patch testing. Right some sort o

Re: BugTracker (Was: Re: [HACKERS] 8.2 features status)

Josh Berkus schrieb: Greg, In short, it's just a tool to solve a problem we actually have (having a convenient archive of data about current and past bugs) without inventing problems to solve with extra process that we aren't already doing anyways. RT can be set up similarly but I'm not sure

Re: [HACKERS] plpython sets

some more finish (docs and so on) maybe if more people using it it can get better. SRF - even lazy ones (e.g. generators) work nicely there. Regards Tino Wildenhain ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] COPY (query) TO file

Mark Woodward wrote: >> Mark Woodward wrote: ... >>> This runs completely in the background and can serve as a running >>> backup. >> And you are sure it would be much faster then a server local running >> psql just dumping the result of a query? > > No I can't be sure of that at all, but Th

Re: [HACKERS] COPY (query) TO file

Mark Woodward wrote: ... >>> pg_dump -t mytable | psql -h target -c "COPY mytable FROM STDIN" >>> >>> With a more selective copy, you can use pretty much this mechanism to >>> limit a copy to a sumset of the records in a table. >> Ok, but why not just implement this into pg_dump or psql? >> Why bo

Re: [HACKERS] COPY (query) TO file

Tom Lane wrote: > Tino Wildenhain <[EMAIL PROTECTED]> writes: >> Ok, but why not just implement this into pg_dump or psql? >> Why bother the backend with that functionality? > > You're not seriously suggesting we reimplement evaluation of WHERE clauses > on t

Re: [HACKERS] COPY (query) TO file

Mark Woodward wrote: ... create table as select ...; followed by a copy of that table if it really is faster then just the usual select & fetch? >>> Why "create table?" >> Just to simulate and time the proposal. >> SELECT ... already works over the network and if COPY from a >> select (wh

Re: [HACKERS] COPY (query) TO file

Mark Woodward wrote: >> Mark Woodward wrote: >>> Tom had posted a question about file compression with copy. I thought >>> about it, and I want to through this out and see if anyone things it is >>> a >>> good idea. >>> >>> Currently, the COPY command only copies a table, what if it could >>> opera

Re: [HACKERS] COPY (query) TO file

Mark Woodward wrote: > Tom had posted a question about file compression with copy. I thought > about it, and I want to through this out and see if anyone things it is a > good idea. > > Currently, the COPY command only copies a table, what if it could operate > with a query, as: > > COPY (select

Re: [HACKERS] [OT] MySQL is bad, but THIS bad?

iends to their unix servers :-) So whatever is in "complete" should depend on the target platform. I think the naming schema of the debian packages go in the right direction - maybe this can be harmonized along the distributions? Regards Tino Wildenhain ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Regrading TODO item alerting pg_hba.conf from SQL

... >> 2. What do we think about the SQL command to be. Would it be like the >> following or another syntax. >> >> GRANT >> CONNECTION [LOCAL | HOST | HOSTSSL | HOSTNOSSL ] >> ON [ ALL | mydatabase1 ] >> TO [ ALL | user1,user2,user3 ] >> FROM 127.0.0.1/32 >> METHOD [ TRU

Re: [HACKERS] About pg_hba.conf

Gevik Babakhani schrieb: Hello Folks, This may be a dumb question but please bear a moment with me. About the TODO item “%Allow pg_hba.conf settings to be controlled via SQL“: If in the future we could configure the settings by SQL commands, assuming the settings are saved in an internal table,

Re: [HACKERS] control pg_hba.conf via SQL

Andrew Dunstan wrote: Tino Wildenhain wrote: ... I dont think it has to be ordered preliminary. Since we are dealing with subnets and stuff - the ordering already lays in the data - just like routing tables work: most specific matches first. I could think of a solution where pg_hba.conf just

Re: [HACKERS] control pg_hba.conf via SQL

Andrew Dunstan wrote: > > ISTM that the first requirement is for a sane API that will handle the > fact that HBA lines are ordered. Persistence in itself shouldn't be a > big problem - we already do that with some shared tables, iirc. > > so we might have some functions like: > > insert_hba_rul

Re: [HACKERS] [SQL] Interval subtracting

Hannu Krosing schrieb: > Ühel kenal päeval, K, 2006-03-01 kell 14:36, kirjutas Scott Marlowe: > ... > But we do say both "quarter past three" (3 hours 15 min) and "quarter to > four" (4 hours -15 min) when talking about time. > but luckily we dont write it ;) Some people say (like ) this: quarter

Re: [HACKERS] Pl/Python -- current maintainer?

James William Pye schrieb: > On Sat, Feb 25, 2006 at 01:21:34PM -0700, I wrote: > >>From what I have seen of zope's restricted python, it does, or can, force its >>restrictions by checking bytecode. I imagine a simple PL sitting on top of the >>untrusted varient that merely implements a custom val

Re: [HACKERS] Pl/Python -- current maintainer?

James Robinson schrieb: > I see neilc has hacked on it very recently to reduce memory leaks. I > take that as both good and bad signs. > > We're a [ small ] python shop, and would be most interested in being > able to simplify our life through doing some things in plpython instead > of pl/pgsql

Re: [HACKERS] Updated email signature

Joshua D. Drake schrieb: > >>> >>> >>> Anyone able to beat that? >> >> >> Sorry, I was still in Junior High in '82 :( Man, you are *old* :) >> > > At Marc hands himself a foot gun... I was 9 years old in 82. cool. You too? :-) 1973 must have been a great year .-) Tino

Re: [HACKERS] pg_hba.conf alternative

Q Beukes schrieb: how? is there some kernel patch to completely to enable you to deny access to root? Tino Wildenhain pointed out SELinux has a feature like that. I still dont get your problem (apart from that you can always google for SELinux) Why arent the other "admins" not t

Re: [HACKERS] pg_hba.conf alternative

Q Beukes schrieb: Well, I am not looking for 100% security. I know that full access if full access, and that even if you were to encrypt the system through Postgre the determined person WILL always be able to get it out if they have system level access. All I wanted to do was to prevent the bas

Re: [HACKERS] Multiple logical databases

ke to type -p otherport, you can either create aliases with all the arguments or use something like pgadmin3 which enables you to easy switch from database to database, from host to host as you like. Now is there any usecase I have missed which you still would like to have a

Re: [HACKERS] Passing arguments to views

Chris Campbell schrieb: ... > That was a very simplistic example and didn't illustrate my point -- I > apologize. I was trying to think of something succinct and illustrative > for a quick mailing list post but came up short. > > Maybe a better example would be a situation where you want to do

Re: [HACKERS] New project launched : PostgreSQL GUI Installer for

Dave Page schrieb: ... Well, strictly spoken a gui text editor is a gui... but I rather had in mind something guided with buttons, select boxes and stuff and references to documentation, calculations and the like. :-) Err, yes. pgAdmin? It's somewhat more than a simple text editor. Ah, ri

Re: [HACKERS] New project launched : PostgreSQL GUI Installer for

Dave Page schrieb: ... As was said, a gui to produce postgresql.conf files (off host) can be of value. pgAdmin? Well, strictly spoken a gui text editor is a gui... but I rather had in mind something guided with buttons, select boxes and stuff and references to documentation, calculations

Re: [HACKERS] New project launched : PostgreSQL GUI Installer for

Rick Gigger schrieb: I don't see why anyone has a problem with this. I am certainly never going to use it but if it helps someone who isn't a linux person to use it on a project when they would have used something else (like mysql) or if it convinces someone to run postgres on linux instead

Re: [HACKERS] New project launched : PostgreSQL GUI Installer for

Joshua D. Drake schrieb: ... As more and more people come on board people are going to want to download a .exe (a metaphor), double click and have it open an installer, they will then want to click next, next, continue, finish. You don't get that with apt-get install. Well you can use a fron

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

Jonah H. Harris schrieb: I had to deal with an installer written in python and several in Java... IMHO, Java would be a better language for this and you could build off some nice OSS installers that already exist (such as IzPack). Just my 2 cents :) Yes! Use Java for ultimate suckiness of th

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI Installer for

Devrim GUNDUZ schrieb: Hi, ... Are you going to work with the underlying system's package manager, or put everything in /usr/local? We'll work with the package manager -- I'm an RPM guy ;) RPM isnt the only packaging system out there ;) ---(end of broadcast)--

Re: [HACKERS] New project launched : PostgreSQL GUI Installer for

Devrim GUNDUZ schrieb: Hi, As you know, many databases that run on Linux / Unix systems have a GUI installer which make installation easier and more attractive for some people. If you think of the *racle-GUI-Installer, most people find it very s*cking ;) Our Windows Installer is very attracti

Re: [HACKERS] Offer for PG Developers/Hackers

Tony Caduto schrieb: Hi, I want to give something back(I would give a donation but sales are poor :-( ,so I am offering to any verified Postgresql developer(by verified I mean your name shows up on this list a LOT ) a free copy of PG Lightning Admin. Does this mean postgres developer who de

Re: [HACKERS] Commands per transaction

Rod Taylor schrieb: > On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote: > >>Rod Taylor wrote: >> >>>Is there any way of bumping this limit or am I stuck breaking up the >>>transaction? >> >>Wow, I never heard of anyone reaching the limit :-( Sorry, you are >>stuck (short of changing Comman

Re: [HACKERS] psql & readline & win32

John DeSoi schrieb: On Jan 2, 2006, at 4:00 AM, Magnus Hagander wrote: Me, I'm not fully happy with psql on win32. I want my tab completion! (which the gui tools don't do either, from what I can tell. At least pgadmin doesn't. Yet.) Mine has tab completion adapted from psql :). There are al

Re: [HACKERS] Why don't we allow DNS names in pg_hba.conf?

Tom Lane schrieb: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > >>One thing that bothers me slightly is that we would need to look up each >>name (at least until we found a match) for each connection. If you had >>lots of names in your pg_hba.conf that could be quite a hit. > > > A possible a

Re: [HACKERS] Different length lines in COPY CSV

Am Montag, den 12.12.2005, 15:08 -0500 schrieb Andrew Dunstan: > > Tom Lane wrote: ... > > You are probably right. The biggest wrinkle will be dealing with various > encodings, I suspect. That at least is one thing that doing CSV within > the backend bought us fairly painlessly. Perl's Text::CS

Re: [HACKERS] Please Help: PostgreSQL Query Optimizer

Not sure if this will ever be included in the core, since not many people need these advanced hash functions. HTH Tino Wildenhain ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] SERIAL type feature request

Am Sonntag, den 04.12.2005, 08:52 +0100 schrieb Zoltan Boszormenyi: > OK, I admit I haven't read the SQL standards on this matter. > > Tino Wildenhain írta: > ... > A SERIAL type has the assumption that its value starts at a low value > (1) and > is increasing. O

Re: [HACKERS] SERIAL type feature request

Am Samstag, den 03.12.2005, 22:23 +0100 schrieb Zoltan Boszormenyi: > Hi! > > I would like to add an entry to PostgreSQL 8.2 TODO: > - Extend SERIAL to a full-featured auto-incrementer type. > > To achieve this, the following three requirements should be fulfilled: > > 1. The statement parser sh

Re: [HACKERS] BIN()

Am Mittwoch, den 30.11.2005, 00:03 -0700 schrieb Michael Fuhr: > On Wed, Nov 30, 2005 at 07:42:36AM +0100, Tino Wildenhain wrote: > > In python, I usually go like this: > > In Ruby (and therefore in PL/Ruby) you could do this: > > 10.to_s(2) > => "1010" >

Re: [HACKERS] BIN()

Am Mittwoch, den 30.11.2005, 10:15 +0800 schrieb Christopher Kings-Lynne: > Hi guys, > > How would I go about implementing MySQL's BIN() function easily in PL/SQL. > > mysql> SELECT BIN(12); > -> '1100' > > Basically it converts a bigint to a string containing 1's and 0's. > > I've tri

Re: [HACKERS] plpython and bytea

Am Montag, den 21.11.2005, 09:08 -0700 schrieb James William Pye: > On Mon, 2005-11-21 at 15:18 +0200, Hannu Krosing wrote: > > The project seems quite interesting, will surely take a deeper look > > ... > > The 'layout' package needs to be installed first. > > See this quick start section: > ht

Re: [HACKERS] Tablespace on ramdisk

[EMAIL PROTECTED] schrieb: I'd like to mimic MySQL's in-memory tables (engine=memory), which structure survives a server restart (data lost of course). I suspected that a server restart would be a problem in this case. Thank you anyway. you could use temp tables... but usually it isnt worth the

Re: [HACKERS] plpython and bytea

Hannu Krosing schrieb: On Mon, 2005-11-21 at 08:37 +0100, Tino Wildenhain wrote: Am Montag, den 21.11.2005, 02:11 +0200 schrieb Hannu Krosing: Hi It seems that plpython is unable to return bytea string when it contains NUL bytes: ... Did you also try: http

Re: [HACKERS] Tablespace on ramdisk

[EMAIL PROTECTED] schrieb: Hi, does anyone have experiences about putting a tablespace on ramdisk? Does it work (and keep working after a restart of the server)? Thanks in advance for any insight. Yes it does work as long as you dont restart your server. Postgres does not appreciate disappearin

Re: [HACKERS] plpython and bytea

Am Montag, den 21.11.2005, 02:11 +0200 schrieb Hannu Krosing: > Hi > > It seems that plpython is unable to return bytea string when it contains > NUL bytes: > > hannu=# CREATE OR REPLACE FUNCTION get_bytea_with_nul() RETURNS bytea AS > ' > return ''aa\\0bb'' > ' LANGUAGE plpythonu SECURITY DEFINE

Re: [HACKERS] Improving count(*)

Zeugswetter Andreas DCP SD schrieb: Since that costs, I guess I would make it optional and combine it with materialized views that are automatically used at runtime, and can at the same time answer other aggregates or aggregates for groups. create materialized view xx_agg enable query r

Re: [HACKERS] Improving count(*)

Zeugswetter Andreas DCP SD schrieb: The instant someone touches a block it would no longer be marked as frozen (vacuum or analyze or other is not required) and count(*) would visit the tuples in the block making the correct decision at that time. Hmm, so the idea would be that if a block

Re: [HACKERS] question about count(b) where b is a custom type

Pollard, Mike schrieb: If count() convert to a string (an assumption that Martijn has cast into doubt, or perhaps shredded), then rather than convert all non-nulls that are not a string into a string, I was proposing converting the values into an int with the values 0 or 1 (0 means that row was

Re: [HACKERS] question about count(b) where b is a custom type

Pollard, Mike schrieb: Richard Huxton wrote: Pollard, Mike wrote: Firstly, if you just want a count, what's wrong with count(1) or count(*). Because unless the column does not allow nulls, they will not return the same value. Ah, but in the example given the column was being matched

Re: [HACKERS] functions marked STABLE not allowed to do INSERT

Am Montag, den 14.11.2005, 15:06 -0500 schrieb Tom Lane: > Tino Wildenhain <[EMAIL PROTECTED]> writes: > > Now this is really a bug: > > That's in the eye of the beholder (and one who wasn't paying attention > to previous discussion of this point, evidently).

Re: [HACKERS] functions marked STABLE not allowed to do INSERT

Am Montag, den 14.11.2005, 14:45 -0500 schrieb Jaime Casanova: > On 11/14/05, Tino Wildenhain <[EMAIL PROTECTED]> wrote: > > Am Montag, den 14.11.2005, 13:29 -0500 schrieb Robert Treat: > > > On Monday 14 November 2005 10:02, Tino Wildenhain wrote: > > > >

Re: [HACKERS] functions marked STABLE not allowed to do INSERT

Am Montag, den 14.11.2005, 13:29 -0500 schrieb Robert Treat: > On Monday 14 November 2005 10:02, Tino Wildenhain wrote: > > New in 8.1 it seems functions marked STABLE are > > not allowed to have any INSERT statement in them. > > > > Try hiding your inserts in seperat

[HACKERS] functions marked STABLE not allowed to do INSERT

New in 8.1 it seems functions marked STABLE are not allowed to have any INSERT statement in them. However in this particular case, the insert does not violate the rule: "STABLE indicates that within a single table scan the function will consistently return the same result for the same argument

Re: [HACKERS] Getting table name/tuple from OID

Paresh Bafna schrieb: Is there any way to retrieve table name and/or tuple values from OID of table/tuple? Yes. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [HACKERS] 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL]

Am Mittwoch, den 19.10.2005, 22:04 +0200 schrieb Tino Wildenhain: > Am Mittwoch, den 19.10.2005, 16:29 -0300 schrieb Marc G. Fournier: > > I'm CC'ng this over to -hackers ... Tom? Comments? > > > ... > > >> Then we are broken too :) > > >

Re: [HACKERS] 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL] Oracle buys

Am Mittwoch, den 19.10.2005, 16:29 -0300 schrieb Marc G. Fournier: > I'm CC'ng this over to -hackers ... Tom? Comments? > > On Wed, 19 Oct 2005, Dann Corbit wrote: > > > Yes, clearly that is the wrong result according to the SQL standard. > > > > Here is a SQL*Server query: > > select 1 where 'a

Re: [HACKERS] pg_dump option to dump only functions

Am Samstag, den 08.10.2005, 18:03 -0400 schrieb Tom Lane: > Josh Berkus writes: > >> I was wonderring, because I create a lot of server side utility functions, > >> whether adding an option to pg_dump to just dump functions has been > >> considered. I did a quick perusal of the code, and noted tha

Re: [HACKERS] postgresql clustering

Jonah H. Harris schrieb: On 9/29/05, *Tino Wildenhain* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Well, I dont know why many people believe parallel execution automatically means high performance. Actually most of the time the performance is much worser this

Re: [HACKERS] postgresql clustering

Daniel Duvall schrieb: While "clustering" in some circles may be an open-ended buzzword -- mainly the commercial DB marketing crowd -- there are concepts beneath the bull that are even inherent in the name. However, I understand your point. From what I've researched, the concepts and practices

Re: [HACKERS] Materialized Views in PostgreSQL

Jean-Michel Pouré schrieb: Dear friends and all, Johnathan Gardner did a wonderful job on materialized views: http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Are there any plans to integrate materialized views written in plain C in the future. This can help gain a lot of

Re: [HACKERS] FAQ/HTML standard?

Am Samstag, den 10.09.2005, 12:59 -0500 schrieb Bruno Wolff III: > On Sat, Sep 10, 2005 at 12:10:19 -0400, > Andrew Dunstan <[EMAIL PROTECTED]> wrote: > > > > Is there an HTML standard that we try to follow in our HTML docs such as > > FAQs? > > > > If there isn't an explicit standard, may I s

Re: [HACKERS] typo? was: Version number in psql banner

Am Donnerstag, den 01.09.2005, 23:34 -0500 schrieb Jim C. Nasby: > On Thu, Sep 01, 2005 at 11:18:25PM +0100, Simon Riggs wrote: > As a side note, there's a typo in \?: > > \c[onnect] [DBNAME|- [USER]] > > Note the | where there should be a ]. No ;) The | stands for the alternative. The whole

Re: [HACKERS] [ANNOUNCE] Welcome Core Team member Dave Page

Gavin M. Roy schrieb: Congrats Dave! Yes, congrats! ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] How to secure PostgreSQL Data for distribute?

Am Donnerstag, den 18.08.2005, 09:56 +0700 schrieb Premsun Choltanwanich: > Dear All, > > I need to distribute my application that use PostgreSQL as > database to my customer. But I still have some questions in my mind on > database security. I understand that everybody who get my applicati

Re: [HACKERS] pl/Ruby, deprecating plPython and Core

Josh Berkus schrieb: People: How about we draft some criteria for inclusion of a PL in the main distro? Suggestions: 1) The PL must be "stable" (that is, not capable of crashing the backend) 2) The PL must be buildable only using --with-{lang} and createlang (assuming that the user has the co

Re: [HACKERS] Testing of MVCC

Tom Lane schrieb: Tino Wildenhain <[EMAIL PROTECTED]> writes: Tom Lane schrieb: The bit that I think is missing in DBI is "issue a command and don't wait for the result just yet". ... I might be wrong though, not being exactly a DBI guru ... can this sort of thing be don

Re: [HACKERS] Testing of MVCC

Tom Lane schrieb: Greg Stark <[EMAIL PROTECTED]> writes: So why bother with driving multiple invocations of psql under Expect. Just use DBD::Pg to open as many connections as you want and issue whatever queries you want. The bit that I think is missing in DBI is "issue a command and don't wa

Re: [HACKERS] pl/Ruby, deprecating plPython and Core

Am Montag, den 15.08.2005, 10:30 -0700 schrieb Joshua D. Drake: > Hello, > > I have negotiated with the author of pl/Ruby to release plRuby under the > PostgreSQL license. The reason I did this is the following: > > 1. I felt we needed a truly OO language in core. > 2. plPython isn't really movi

Re: [HACKERS] pg_dump -- data and schema only?

store -l, edit (for example via sed) > > and use it with -L to only generate SQL for these objects. > > > > Actually, there isn't a setting to just dump the able definitions and the > data. When you dump the schema, it includes all the tablespaces, > namespaces, owners,

Re: [HACKERS] pg_dump -- data and schema only?

estore from this binary dump. You can then use pg_restore -l, edit (for example via sed) and use it with -L to only generate SQL for these objects. -- Tino Wildenhain <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1: if posting/reading t

  1   2   >