On Thu, 2013-10-10 at 19:14 -0400, Bruce Momjian wrote:
> > The changes shown below are incorrect, I think.
> >
> >
> > On 10/2/13 12:00 PM, Bruce Momjian wrote:
> > > *** gen_salt(type text [, iter_count integer
> > > *** 353,359
> > > 12 years
> > >
> > >
The changes shown below are incorrect, I think.
On 10/2/13 12:00 PM, Bruce Momjian wrote:
> *** gen_salt(type text [, iter_count integer
> *** 353,359
> 12 years
>
>
> !md5
> 2345086
> 1 day
> 3 years
> --- 358,364 ---
On Sun, 2013-08-25 at 12:01 -0700, Nick Carenza wrote:
> on os x 10.8.4
>
> installing with homebrew
This is not a problem. Homebrew has the appropriate patches.
There is more discussion about this issue in the mailing list archives.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgre
On Mon, 2013-07-01 at 19:27 -0400, Tom Lane wrote:
> I think probably we'd have just not compiled the dependent code, and
> would have found out about it only when somebody complained that peer
> auth didn't work on OpenBSD. Not sure that's really a more attractive
> behavior :-(
That might be t
On 7/1/13 9:19 AM, Tom Lane wrote:
> AFAICT, the result in this case would be that the script comes to the
> wrong conclusion about whether ucred.h is available. Wouldn't that
> result in a build failure, or at least missing features? IOW, don't
> we need to fix this test anyway?
The test needs
On 6/30/13 11:26 AM, Andres Freund wrote:
> If we would treat that warning as an error unconditionally - and I am
> not sure how easy that is given the way it's emitted - users
> encountering them, which usually will be on less common platforms, will
> have to patch configure.in to make things work
On 5/9/13 5:40 PM, Dave Page wrote:
> Whilst working on a build issue with pl/python, I noticed an
> inconsistency in the way the server reacts to attempts to use PLs for
> which the interpreter doesn't exist. Not sure how feasible it would be
> to fix this, but the Python case doesn't seem ideal:
On 5/21/13 6:25 PM, pol...@yahoo.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8174
> Logged by: David Johnston
> Email address: pol...@yahoo.com
> PostgreSQL version: 9.0.13
> Operating system: Ubuntu Linux 10.04
> Description:
>
>
On 5/21/13 3:41 AM, tudorbara...@yahoo.com wrote:
> In pg_hba.conf I have the following setup:
> hostall all laptop md5
>
> Although the hostname gets resolved by the system (LAN DNS server) I still
> get the no pg_hba.conf entry error.
Check that the following works:
$ host
On 5/21/13 2:54 AM, Andrzej Cedro wrote:
> I use PostgeSQL 9.1 32-bit on Windows 7 Professional with Active Directory as
> LDAP.
> I have following configration in pg_hba.conf:
>
> host all all all ldapldapserver=192.168.155.157
> ldapbinddn="CN=aa,OU=b,DC=,DC=" l
On Sun, 2013-03-03 at 10:42 -0500, Tom Lane wrote:
> I think the use of str_toupper() is appropriate when processing the
> locale-specific string for a TMDAY specification; but plain DAY is not
> supposed to be locale-dependent, so we probably should use an
> ASCII-only upcasing rule in the non-TM
On Sun, 2013-02-17 at 15:51 +0100, Christian Hammers wrote:
> The postmaster command does not list "--config-file" in its help
It is included under
--NAME=VALUE set run-time parameter
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription
On 2/25/13 7:59 PM, adam.tomj...@zuerchertech.com wrote:
> I have a database that uses a user-defined datatype. If the .so file
> implementing that type is missing, pg_dump will fail when dumping a table
> which uses that type, but it will still exit with status 0. The dump file
> will be truncat
On 2/23/13 2:10 PM, Peter Geoghegan wrote:
> But then, contrib/isn also sanitises both ISBN
> ranges and EAN country codes using its own internal database, which
> ought to be kept in lockstep with an external database whose
> maintenance is highly decentralised - regional authorities make
> certai
On 1/6/13 11:17 PM, funnybon...@yahoo.com wrote:
> Hello, my engish is not so good, but i try to describe what seems not to
> work. Could it be, that the LC_MESSANGES for months and days like
>
> Months
> --
> Janary=Januar
> February=Februar
>
> Days
>
> monday=Montag
> Thursdat=Dienst
On 1/25/13 1:35 AM, Kevin Grittner wrote:
> Peter, do you have a version that works with 9.3?
I don't, but it shouldn't be hard for someone more up to date with the
internal WAL addressing changes.
> Given that we're past the start of the last CF, do we still want to
> consider including it? If y
On 9/20/12 11:06 AM, Tom Lane wrote:
> Well, I would have no objection to changing pg_ctl so that it redirects
> the postmaster's stdout/stderr when a -l switch is given (actually,
> I thought it did that already...). I do object to changing the logger's
> behavior as you suggest, because that wil
On Mon, 2012-09-17 at 16:53 +, m...@suse.de wrote:
> It looks like the attempt to remove pg_upgrade's dependency on pg_config
> (http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=2815574) was
> incomplete, since contrib/pg_upgrade/exec.c still contains the line
>
> validate_exec(c
On 9/4/12 2:22 PM, Murray Cumming wrote:
> On Tue, 2012-09-04 at 10:31 -0400, Tom Lane wrote:
>> murr...@murrayc.com writes:
>>> At some point, probably in 9.1.5, the -k option to Postgres ("Unix-domain
>>> socket location" in --help), stopped accepting paths that contain spaces.
>>
>>> For instanc
On Thu, 2012-08-09 at 16:26 -0500, Merlin Moncure wrote:
> Follow up on this. It is pl/sh and it is a newline issue: one of the
> developers is using a tool (I think pgadmin?) that is sticking \r
> characters at the end of every line which is throwing off pl/sh's
> shebang parsing. The issuing qu
On ons, 2012-07-25 at 10:08 +, jez.w...@bull.net wrote:
> When faced with a flag it doesn't recognize, xlc prints the man page.
> Thus the --version, -v, -V tests result in a particularly large
> config.log file
And is this an actual problem?
The code you are referring to is automatically ge
On tor, 2012-07-12 at 15:25 +, ch...@chrullrich.net wrote:
> The PostgreSQL configure script indiscriminately enables the --as-needed
> option to the linker if the linker supports it, which GNU ld 2.17.50 in
> FreeBSD 9 does. It does not, however, use it in its own library checks. The
> configu
On ons, 2012-07-11 at 11:32 +0200, Christian Ullrich wrote:
> 61 #: pg_basebackup.c:127
>62 #, c-format
>63 msgid " -F, --format=p|t output format (plain, tar)\n"
>64 msgstr " -F, --format=c|t|p Ausgabeformat (plain, tar)\n"
>
> pg_basebackup does not support "c" format
On fre, 2012-06-01 at 21:26 -0700, Josh Kupershmidt wrote:
> It's too bad the clang
> doesn't understand our ereport(ERROR, ...) calls don't return to the
> caller, as those seem to account for a fair bit of the spurious
> warnings. I haven't seen anything which I'd call an outright bug,
> though t
On ons, 2012-05-30 at 23:43 +0200, Tomas Vondra wrote:
> On 30.5.2012 23:19, Tom Lane wrote:
> > I suspect it depends on how you install the new version of the library,
> > too. I would somewhat expect it to work as you're thinking if the
> > install consists of "rename old file out of the way, co
On ons, 2012-05-16 at 19:55 -0500, Tulio J Carrasco wrote:
> "León", "leon", "leOn" has identical order values: none of them
> weights more for Spanish collation and PG is not working according it
> if PG makes a "second pass" that ignores collation and reorders by its
> character value.
PostgreSQ
On fre, 2012-05-18 at 19:57 +, erlko...@talisman.org wrote:
> The macaddr type does not allow for MACs of greater length (or less than)
> than six bytes, only capturing a particular variety of ethernet address
> (Xerox's original version) instead of the broader use of MACs where
> addresses of
On tis, 2012-05-08 at 11:33 -0400, Clay McClure wrote:
> "The gist of it is to grab python-config --prefix and store it in a
> variable, say py_prefix. If the file $py_prefix/Python exists, you are
> dealing with a Framework build and -framework Python is the
> appropriate method of linking. Otherw
On tor, 2012-04-19 at 15:00 -0400, Tom Lane wrote:
> i+pgb...@avdd.tk writes:
> > A concurrent psql session will overwrite the history of the first. This
> > does not look good: a database tool causing me to lose my data!
>
> Works okay for me. I suspect you need to take this up with whoever
> p
On lör, 2012-04-14 at 08:23 -0400, Robert Haas wrote:
> On Sat, Apr 14, 2012 at 3:27 AM, Pavel Stehule
> wrote:
> >> It has a lot of sense. Without it, it's very difficult to do logical
> >> replication on a table with no primary key.
> >>
> >> (Whether or not people should create such tables in
On ons, 2012-02-22 at 22:37 +0400, Sergey Burladyan wrote:
> eshkin...@gmail.com writes:
>
> > The following bug has been logged on the website:
> >
> > Bug reference: 6480
> > Logged by: Sergey Burladyan
> > Email address: eshkin...@gmail.com
> > PostgreSQL version: 9.1.2
> > O
On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote:
> lenka.piy...@gmail.com writes:
> > when i restore a particular table using pg_restore (using option "-t") it
> > doesn't restore my primary key...
>
> This is not a bug. -t selects the table only, not associated indexes.
But from a user's per
On fre, 2011-12-30 at 12:02 -0300, Alvaro Herrera wrote:
> Excerpts from thangalin's message of vie dic 30 11:30:47 -0300 2011:
> > The following bug has been logged on the website:
> >
> > Bug reference: 6368
> > Logged by: D J
> > Email address: thanga...@gmail.com
> > Postgre
On ons, 2011-11-23 at 12:07 +0100, Marco Bernasocchi wrote:
> Hi all, porting QGIS to android I ported libpq as well, I had to modify
> two files to successfully compile it without-readline. I attach the two
> needed minor patches. further informations can be found at android.qgis.org.
The Postg
On tor, 2011-11-24 at 11:14 -0500, Robert Haas wrote:
> So I would propose to steer clear of the word "internal", because the
> really scary errors typically are not internal to PostgreSQL at all.
> What I think we want to distinguish between is things that are
> PEBKAC/GIGO, and everything else.
On tor, 2011-11-10 at 19:30 -0500, Tom Lane wrote:
> I think psql only pays attention to its locale when stdout is a tty.
> Now *why* it acts like that, I'll leave for Peter to defend.
We would have to review the original discussion about that. I can see
arguments for doing it that way and for no
On ons, 2011-10-26 at 04:08 +, Shannon wrote:
> The following bug has been logged online:
>
> Bug reference: 6271
> Logged by: Shannon
> Email address: shan...@arc.net.au
> PostgreSQL version: 8.4.9
> Operating system: Gentoo Linux 64bit
> Description:psql -f repor
On ons, 2011-09-28 at 22:42 -0400, Tom Lane wrote:
> "Pierre Ducroquet" writes:
> > [ the "hstore ? text" operator no longer matches an hstore GIST index ]
>
> Hmm ... this doesn't seem to be specific to either hstore or GIST; it's
> a collation problem. The index is marked as having no collatio
On tis, 2011-09-20 at 00:32 -0400, Tom Lane wrote:
> =?Big5?B?pHCoqA==?= writes:
> > Use ALTER TABLE item ALTER COLUMN title TYPE character varying(2000)
> > COLLATE pg_catalog."zh_TW.euctw";
> > but, SQL state: 42704 "UTF8" "pg_catalog.zh_TW.euctw" not found
>
> I hope that's not the exact p
On tis, 2011-09-06 at 17:12 +0200, hubert depesz lubaczewski wrote:
> On Mon, Sep 05, 2011 at 02:27:23PM -0400, Tom Lane wrote:
> > It's not just the port, it's all the connection parameters ---
> > do_connect relies on the PGconn object to remember those, and in this
> > case there no longer is a
On mån, 2011-04-25 at 11:03 -0400, Robert Haas wrote:
> >> but executing
> >>time make -j4 check
> >> fails (I don't see any obvious problem in the log file):
> >> [...]
> >> == creating temporary installation
> ==
> >>
> >> pg_regress: installation failed
> >> Examine
On ons, 2011-08-03 at 21:02 +, Matthias Kurz wrote:
> SELECT
> a.companyname AS a_companyname,
> a.street,
> a.zip,
> a.city,
> a.country
> FROM
> myAddress a
> ORDER BY
> a_companyName COLLATE "C" DESC,
> a.street COLLATE "C" ASC,
> a.zip
On fre, 2011-06-17 at 13:10 +0200, Christoph Berg wrote:
> Re: To pgsql-bugs@postgresql.org 2011-06-17
> <20110617091114.gc4...@msgid.df7cb.de>
> > Unfortunately that doesn't help in this case, as the bad string isn't
> > tagged as "#, c-format", but still gets used as such. This seems to be
> > t
On fre, 2011-06-17 at 10:22 +0200, Bernd Helmle wrote:
>
> --On 17. Juni 2011 08:18:03 + Christoph Berg wrote:
>
> > In German locale, the follow statement causes vsnprintf() to segfault when
> > printing the hint:
> >
> > SELECT TO_DATE('30.12.2011', 'MMDD') AS datum;
> >
> > Fix tested
On tor, 2011-06-09 at 13:30 -0400, Bruce Momjian wrote:
> Column numbers in ORDER BY is ANSI syntax so I don't think calling
> them "legacy" is accurate. "limited functionality"?
It was in SQL 92, but removed in 99, so it's technically no longer part
of the standard.
--
Sent via pgsql-bugs mai
On ons, 2011-06-08 at 11:09 -0400, Tom Lane wrote:
> As far as I can tell from the spec, dtd_identifier
> ought to be the identifier of the element type, while
> collection_type_identifier should be a made-up identifier for the
> array type. That would make the sample query given in the docs
> cor
On ons, 2011-06-08 at 20:38 +0300, Peter Eisentraut wrote:
> On ons, 2011-06-08 at 11:09 -0400, Tom Lane wrote:
> > The omission of collection_type_identifier from the docs is clearly a
> > doc bug. However, it looks to me like you've identified an error in the
> > view
On ons, 2011-06-08 at 11:09 -0400, Tom Lane wrote:
> The omission of collection_type_identifier from the docs is clearly a
> doc bug. However, it looks to me like you've identified an error in the
> view definition, not only a doc bug. I think the values of the
> dtd_identifier and collection_typ
On lör, 2011-06-04 at 07:09 +, dinesh wrote:
> I have a table which is used during data uploads, a so-called staging table.
> This table has a fixed number of columns that [must] match the input CSV
> file. This CSV file is uploaded using COPY command. Following the COPY, a
> new column (meant
On ons, 2011-05-11 at 14:58 -0400, Tom Lane wrote:
> Marc Cousin writes:
> > I've been starting to work on a 'what's new in 9.1' like i did last
> > year, and am faced with what I feel is a bug, while building a demo case
> > for collation.
>
> > Here it is:
>
> > SELECT * from (values ('llegar'
On Tue, 2011-04-19 at 12:52 +, Daniel Migowski wrote:
> I would love to give pg_dump an option to produce ordered output. This would
> make it much easier to create dump files that are comparable with a textual
> diff tools.
>
> The following orderings are required:
>
> * Dump objects ordered
On tis, 2011-03-22 at 06:34 +, Vincent Chan wrote:
> when saving a bytes array,
> for example a bytes array which length is 2,
> but after saving,
> it's length will be change to 3.
> but in postgres 8.4, the array length is still 2.
Please show an actual example of what you are observing.
On ons, 2011-03-02 at 21:59 +0200, Peter Eisentraut wrote:
> On ons, 2011-03-02 at 18:00 +0200, Heikki Linnakangas wrote:
> > Hmm, regardless of what's causing this, I wonder if we should check
> > that the locale works at CREATE COLLATION time, rather than fail when
> >
On ons, 2011-03-02 at 18:00 +0200, Heikki Linnakangas wrote:
> Hmm, regardless of what's causing this, I wonder if we should check
> that the locale works at CREATE COLLATION time, rather than fail when
> you try to use it. Ie. add a call to pg_newlocale_from_collation() at
> the end of DefineColla
On ons, 2011-02-16 at 17:15 +, Khadtare, Sharad wrote:
> I want to configure Bidirectional replication in postgres 9 ( streaming ).
>
> any one knows solution for Bidirectional replication in postgres.
This is not a bug, and is hence inappropriate for this forum. But what
you are looking for
On sön, 2011-02-06 at 11:06 -0500, Tom Lane wrote:
> I don't know the state of affairs on FreeBSD for sure, but I do know
> that the UTF-8 locales are fairly broken on Mac OS X, which is a BSD
> derived platform too. It looks like nobody in BSD-land has bothered
> to put in the work to make multib
On fre, 2011-01-21 at 17:31 +0100, Giacomo Petillo wrote:
> Hi,
> in the help of "pg_dumpall" pops up this error:
>
> Opzioni di connessione:
> -h, --host=NOMEHOST host server di database o directory socket
> -l, --database=NOMEDBpreimpostazione database alternativo
> *p, --port=POR
CREATE TYPE zzz_enum AS ENUM ('A', 'B', 'C');
CREATE TABLE zzz_test1 (z zzz_enum);
SELECT * FROM zzz_test1 WHERE z = 'A';
That works. But:
CREATE DOMAIN zzz AS zzz_enum DEFAULT 'A';
CREATE TABLE zzz_test2 (z zzz);
SELECT * FROM zzz_test2 WHERE z = 'A';
ERROR: 42883: operator does not exist: zzz
On tis, 2010-12-28 at 18:30 -0500, Gurjeet Singh wrote:
> What is the difference between this and how libreadline or zlib are checked
> by configure? I am referring to the configure error that pronpts us to use
> --without-readline.
Sure, it's inconsistent. It's just a matter of how much code you
On tis, 2010-12-28 at 15:29 -0800, John R Pierce wrote:
> I believe he's suggesting that configure should be confirming the
> availability and location of these prerequisites, just as it locates
> and validates the perl install and many other prerequisite tools.
Sure, but that's just extra code t
On tis, 2010-12-28 at 12:19 +, Mario Ohnewald wrote:
> However, during the make, postgres requires perl devel. Should this
> not be covered in the configure script?
No, it's not configure's job to do the job of make or the compiler.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql
On mån, 2010-12-20 at 02:39 +, Leslie Satenstein wrote:
> The insert examples in section 2.4 do not function if a cut and paste
> from
> pdf to psql is done
>
> This is the problem
> INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25,
> ’1994-11-27’);
> The fields city and date should
On sön, 2010-12-05 at 00:25 +, Adrian Klaver wrote:
> Seems there was a change in behavior for plpythonu with regards to
> boolean fields from 8.4 to 9.0. Previously, setting a field inside a
> plpythonu function to "f" would work, now that returns a 't' in the
> database field. To get the 'f'
On sön, 2010-11-28 at 07:56 -0500, Robert Haas wrote:
> I guess it's not a bug if we did it that way on purpose, but it seems
> like testing for actual group membership would be less surprising.
I agree this is pretty confusing and would consider changing it.
--
Sent via pgsql-bugs mailing list
On mån, 2010-10-11 at 00:13 -0400, Tom Lane wrote:
> It looks to me like this used to work and got broken by this patch:
> http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3ab8b7fa6f9ac2fb04096f8860261dc42d59a570
>
> which lobotomized plpython to not care about passing the right ty
On fre, 2010-10-08 at 16:13 -0700, Bryson Holland wrote:
> what other information do you need from me to make this useful?
Platform, version, command line
> configure: WARNING: uuid.h: present but cannot be compiled
> configure: WARNING: uuid.h: check for missing prerequisite headers?
> confi
On fre, 2010-09-24 at 09:50 +0200, Magnus Hagander wrote:
> > I'm thinking, libpq could really use a global (and, for that matter, a
> > per-user) configuration file, where you could set defaults for some of
> > the things that you currently have to use environment variables for,
> > e.g., sslmode.
On fre, 2010-09-24 at 16:10 +0100, Dave Page wrote:
> The download page states exactly what distros we consider supported.
Sorry, I was actually looking at the Postgres Plus download page.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http
On fre, 2010-09-24 at 11:38 +0100, Dave Page wrote:
> I didn't know that existed - thanks. Unfortunately the first box I
> tried it on didn't have it, but that's quite old and not a supported
> platform anyway. if it does exist on everything we support, then that
> could work.
It's tempting, but I
On fre, 2010-09-24 at 09:01 +0100, Dave Page wrote:
> How else would you suggest we find out what may go wrong on an
> unsupported platform?
Well, some amount of robust and defensive programming can probably
create better error messages in even the most unknown environment.
Especially since the pr
On tor, 2010-09-23 at 23:56 +0100, Dave Page wrote:
> > Surely the error message can be polished, though?
>
> Well we don't know what errors we might get on unsupported platforms
> until we test them, and we certainly don't have the resources to test
> every unsupported platform. It's hard enough
On tor, 2010-09-23 at 16:45 +0100, Dave Page wrote:
> On Thu, Sep 23, 2010 at 3:19 PM, Samuel Rettore wrote:
> > Hi,
> >
> > I'm having problems installing the database, see:
> >
> > anfitrite:/opt# ./postgresql-9.0.0-1-linux.bin
> >
> > Error: Error running /tmp/postgresql_installer/getlocales :
On tor, 2010-09-23 at 08:36 +0200, Magnus Hagander wrote:
> I wonder if we want to have a default value for this rather than
> disabling it when it's not specified by configure. But is there any
> kind of reasonable default that's not going to be
> platform/distribution specific?
I would like for
On sön, 2010-09-19 at 14:28 -0400, Tom Lane wrote:
> What about inventing a function to extract a sequence's parameters?
> Perhaps something like
>
> pg_sequence_parameter(seq regclass, colname text) returns
> bigint
>
> which would do an appropriate permissions check and then fetch the
>
On mån, 2010-09-20 at 20:53 +0100, Graham Swallow wrote:
> The file is in the wrong directory (probably).
> How it got there - is beyond my pay grade.
> I can only tell you that it is fixed here, by moving it,
>
> I should have told you that the problem occurs when compiling
> src/backend/utils/ca
On sön, 2010-09-19 at 09:41 +, saer...@hotmail.com wrote:
> The Sequence view in the information schema is incomplete. It does not
> return a Sequence's maximum_value, minimum_value or increment. Please
> complete the view.
This is known and documented:
http://www.postgresql.org/docs/8.4/stati
On tis, 2010-09-14 at 12:34 -0400, Tom Lane wrote:
> Heikki Linnakangas writes:
> > On 14/09/10 17:08, thommy wrote:
> >> -[ RECORD 2 ]+---
> >> feature_id | B032
> >> feature_name | Extended dynamic SQL
> >> sub_feature_id | 01
> >> sub_feature_name |
> >>
On mån, 2010-09-13 at 13:51 -0400, Tom Lane wrote:
> Peter Eisentraut writes:
> > The correct way to do what he wants to do is
> > configure PYTHON=/usr/local/bin/python3.1 ... other options ...
>
> Hm, maybe this isn't adequately documented? Or at least should be
&
The correct way to do what he wants to do is
configure PYTHON=/usr/local/bin/python3.1 ... other options ...
On lör, 2010-09-11 at 17:22 -0700, Josh Berkus wrote:
> I discussed this report with James Pye already, and he beleives it's a
> configure script bug which should be fixed before release
On fre, 2010-09-03 at 13:53 -0400, Tom Lane wrote:
> Alvaro Herrera writes:
> > Excerpts from Fabien COELHO's message of vie sep 03 13:39:19 -0400 2010:
> >> I tried to explained that I'm analyzing other people's schemas. I cannot
> >> ask all other people on the planet to rewrite their schemas,
On tor, 2010-09-02 at 07:54 +0200, Fabien COELHO wrote:
> > We cannot change it.
>
> Yes we can! It, it is 100% postgresql:
>
> \d information_schema.referential_constraints
>View "information_schema.referential_constraints"
>...
> FROM pg_namespace ncon
> JOIN pg_constraint co
On ons, 2010-09-01 at 16:22 +0200, Fabien COELHO wrote:
> I'm suggesting uniqueness in the "information_schema", which can be
> provided independently by some tweaking in the view construction, I
> think, for instance by adding the oid of the constraint or maybe the
> table_name.
The view is defi
On tor, 2010-08-26 at 14:06 -0400, Tom Lane wrote:
> Peter Eisentraut writes:
> > We could fix this in several ways. Either hardcode exceptions for the
> > 'html' directory in prep_buildtree, or only create directories that
> > contain a makefile, which could al
On tis, 2010-08-03 at 14:36 +, Dmtiriy Igrishin wrote:
> When 'configure' executed in a directory outside the source tree the
> documentation is not installs later nevertheless the "gmake
> install-docs" or
> "gmake install-world" (I tried to build with "gmake world" also) typed
> to
> install
On tor, 2010-08-05 at 14:38 -0400, Tom Lane wrote:
> Huh? The functionality proposed for removal is only that of omitting
> an explicit delimiter argument for string_agg(). Since the default
> value (an empty string) doesn't seem to be the right thing all that
> often anyway, I'm not following wh
On ons, 2010-08-04 at 18:19 -0400, Tom Lane wrote:
>
> This policy also implies that we are never going to allow default
> arguments for aggregates, or at least never have any built-in ones
> that use such a feature.
>
> By my count the following people had offered an opinion on making
> this cha
On mån, 2010-07-19 at 13:32 +0100, Dave Page wrote:
> I'm working on setting up a new buildfarm member as we don't seem to
> have any active Solaris ones :-(
>
> cc -Xa -m64 -mt -mt -D_REENTRANT -D_THREAD_SAFE
> -D_POSIX_PTHREAD_SEMANTICS -KPIC -DFRONTEND -DUNSAFE_STAT_OK -I.
> -I../../../src/in
On mån, 2010-07-19 at 13:32 +0100, Dave Page wrote:
> I'm working on setting up a new buildfarm member as we don't seem to
> have any active Solaris ones :-(
>
> cc -Xa -m64 -mt -mt -D_REENTRANT -D_THREAD_SAFE
> -D_POSIX_PTHREAD_SEMANTICS -KPIC -DFRONTEND -DUNSAFE_STAT_OK -I.
> -I../../../src/in
On tis, 2010-07-13 at 02:11 +, Rafael Almeida wrote:
> The following bug has been logged online:
>
> Bug reference: 5558
> Logged by: Rafael Almeida
> Email address: raf...@rafaeldeveloper.com
> PostgreSQL version: 9.0
> Operating system: Windows XP
> Description:P
On mån, 2010-07-12 at 19:08 +0200, Antonio Rivas Valle wrote:
> Hi
>
> I downloaded PostgreSQL-8.4.4 for Windows (french version) a few days
> ago. Starting psql, I got a warning related to a possible
> malfunction because of the page code of the console. Every
> character with acc
On fre, 2010-07-02 at 14:01 +0100, Mike Fowler wrote:
>
> The attached patch is a very small patch that changes parse_expr.c
> to
> not convert everything to xml. This now means that when passed
> malformed XML it will return false instead of throwing an exception.
> In my mind this acceptab
On tor, 2010-05-27 at 22:41 +0100, Thom Brown wrote:
> This probably isn't a legitimate bug, but as a precaution
>
> I'm running the following command against PostgreSQL 9.0 beta 1:
>
> psql -U postgres -d test -c "select tablename,
> pg_size_pretty(pg_table_size(tablename::regclass)) from pg
On mån, 2010-05-17 at 16:43 +0800, 毅 黄 wrote:
> [r...@centos-jht postgresql-8.4.1]# ./configure
> --prefix=/home/eps/pgsql-8.4 --host=arm-linux --without-readline
> --disable-spinlocks --enable-depend
> --without-zlib CC="/usr/local/arm/4.3.2/bin/arm-linux-gcc"
> [r...@centos-jht postgresql-8.4.1
On tis, 2010-05-04 at 22:46 +0300, Peter Eisentraut wrote:
> On tis, 2010-05-04 at 10:49 -0400, Tom Lane wrote:
> > Alvaro Herrera writes:
> > > Graham wrote:
> > >> Build with VPATH works well upto installing
> > >> postgresql-9.0beta1/src/backend/c
On ons, 2010-05-12 at 12:44 +0100, Greg Stark wrote:
> Well you could imagine doing this for all our types by doing:
>
> search and replace int4 -> pgint4 etc.
> add #ifndef int4 #define int4 pgint4 at the end of postgres.h
>
> That way third-party apps which define their own int4 would be
> requ
On tis, 2010-05-11 at 14:42 -0400, Robert Haas wrote:
> I guess the question that comes to mind for me is how many other
> things fall into this category. We define a lot of symbols like int4
> and int32 that other people could also have defined, and I don't
> really want to s/^/pg/ all of them.
On mån, 2010-05-10 at 15:55 +, Bryan Henderson wrote:
> >>> I don't know how concrete you want.
> >
> >Something one can download and compile.
>
> That wouldn't be worth anyone's effort, since the problem is esaily
> enough elucidated with a few words of explanation. I.e. I'm sure you
> can i
On mån, 2010-05-10 at 02:02 +0100, Greg Stark wrote:
> I don't see any other conflicts offhand that would create problems
> using a c99 compiler to build server modules. It's quite annoying and
> sad that they added "bool" to c99 since otherwise it would just be a
> drop-in replacement with extra f
On sön, 2010-05-09 at 17:37 +, Bryan Henderson wrote:
> >it would be
> >better if Bryan could show us a concrete example that is causing
> >problems.
>
> I don't know how concrete you want.
Something one can download and compile.
> A user defined function server extension
> #includes a heade
On sön, 2010-05-09 at 11:35 -0400, Tom Lane wrote:
> bry...@giraffe-data.com (Bryan Henderson) writes:
> > The interface header files for Postgres server extensions define "bool",
> > but that name is commonly used by other parts of user code, including
> > by standards (C99, C++). That causes, at
1 - 100 of 657 matches
Mail list logo
