On 01/06/13 13:01, Gavin Flower wrote:
On 01/06/13 12:29, John R Pierce wrote:
On 5/31/2013 4:29 PM, Gerald Luger wrote:
Shouldn't I expect all results to be 000...0001?
Otherwise it would be
1 != 1?
SQL's BIT type is big endian, a hangover from its IBM mainframe
heritage.
On 01/06/13 12:29, John R Pierce wrote:
On 5/31/2013 4:29 PM, Gerald Luger wrote:
Shouldn't I expect all results to be 000...0001?
Otherwise it would be
1 != 1?
SQL's BIT type is big endian, a hangover from its IBM mainframe heritage.
I don't think it has anything to do with byte sex (I
On 09/05/13 01:07, andras.va...@zalando.de wrote:
The following bug has been logged on the website:
Bug reference: 8141
Logged by: Andras Vaczi
Email address: andras.va...@zalando.de
PostgreSQL version: 9.1.9
Operating system: linux/Ubuntu 12.10
Description:
Consider the fo
On 26/03/13 22:06, webad...@aldar.com wrote:
The following bug has been logged on the website:
Bug reference: 7998
Logged by: Web Admin
Email address: webad...@aldar.com
PostgreSQL version: Unsupported/Unknown
Operating system: Linux
Description:
Dear Support,
We have host
On 05/12/12 19:49, JEHAD GHAREEB wrote:
Hi all,
I want to install "PG 7.3.4" on Linux 6 . So please send all
instructions to complete installation .
Your prompt response is highly appreciated .
Regards,
Jehad G.
Requesting information is not a bug. If you need further help, then you
migh
On 18/11/12 17:10, Phil Sorber wrote:
On Nov 17, 2012 11:06 PM, "Gavin Flower"
mailto:gavinflo...@archidevsys.co.nz>>
wrote:
>
> On 18/11/12 16:49, Greg Sabino Mullane wrote:
>>
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash:
On 18/11/12 16:49, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
NOTICE: identifier
"this_is_a_really_long_identifier_for_a_prepared_statement_name_ok"
will be truncated to
"this_is_a_really_long_identifier_for_a_prepared_statement_name_"
PREPARE
...
The ORM
On 18/11/12 15:46, Stephen Frost wrote:
* Phil Sorber (p...@omniti.com) wrote:
In addition it actually works!
Only until the ORM tries to create two tables that are identical except
for the last few characters..
So I am sharing this with the list to see what people think. Is this a
configurat
On 01/09/12 18:40, Simon Riggs wrote:
On 4 October 2011 02:42, Seiko Ishida wrote:
The following bug has been logged online:
Bug reference: 6239
Logged by: Seiko Ishida
Email address: v-sei...@microsoft.com
PostgreSQL version: 8.2.4
Operating system: Windows 8
Description
On 22/04/12 05:49, Tom Lane wrote:
eshkin...@gmail.com writes:
set timezone to 'W-SU'; select '2011-03-27 23:00:00'::timestamptz;
SET
timestamptz
2011-03-28 02:59:54+04
Bizarre. On my Fedora 16 box, I see a different misbehavior:
regression=# set timezone to
On 29/03/12 12:36, Kasper Sandberg wrote:
Yeah I will try provide a patch.
I am not entirely certain how the wording should be, but I only
understood that the cube based aproach is by default in meters after
testing it out, though now of course it occurs to me that of course it
is, given the
On 28/12/11 10:43, Phil Sorber wrote:
On Tue, Dec 27, 2011 at 1:00 PM, Tom Lane wrote:
Phil Sorber writes:
My search foo failed me. Someone just pointed me to a similar
conversation from some months ago:
http://archives.postgresql.org/pgsql-hackers/2011-07/msg00677.php
I would propose that si
On 28/10/11 08:53, Tom Lane wrote:
Gavin Flower writes:
Actually, a minute is not always 60 seconds, as you can legally have 62
seconds in a minute!
There never have been, and will never be, two leap seconds declared in
the same minute --- the need for such would require that the
On 28/10/11 02:13, Heikki Linnakangas wrote:
On 27.10.2011 15:57, Robert Young wrote:
But,I think insistence of hard-coding should be even worse than broken
configuration.
And hard-coding should never be a good work ethics of a professional
programmer.
You're exaggerating. There's nothing wro
On 23/09/11 10:43, Gavin Flower wrote:
On a LInux 64 biut system:
$ psql
psql (9.1.0)
Type "help" for help.
gavin=> DROP TYPE raindow;
ERROR: type "raindow" does not exist
gavin=> CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow&#x
On a LInux 64 biut system:
$ psql
psql (9.1.0)
Type "help" for help.
gavin=> DROP TYPE raindow;
ERROR: type "raindow" does not exist
gavin=> CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green',
'blue', 'purple');
ERROR: type "rainbow" already exists
gavin=>
--
Sent via pgsql-bu
On 16/07/11 05:21, Tom Lane wrote:
Gavin Flower writes:
On 15/07/11 11:25, Gavin Flower wrote:
I think it should be possible to put a constraint on the master table
to prevent rows being inserted.
Of course, minutes after I sent the above - I realized these constraints
are inherited, so the
On 15/07/11 11:25, Gavin Flower wrote:
On 15/07/11 08:00, Gavin Flower wrote:
On 15/07/11 07:14, Tom Lane wrote:
Alvaro Herrera writes:
Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400
2011:
Using pg 9.1beta3, I was found that running a function generated an
error rel
On 15/07/11 08:00, Gavin Flower wrote:
On 15/07/11 07:14, Tom Lane wrote:
Alvaro Herrera writes:
Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400 2011:
Using pg 9.1beta3, I was found that running a function generated an
error relating to escaped single quotes, yet
On 15/07/11 07:14, Tom Lane wrote:
Alvaro Herrera writes:
Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400 2011:
Using pg 9.1beta3, I was found that running a function generated an
error relating to escaped single quotes, yet still produced the answer I
expected!
The errors a
Hi,
Using pg 9.1beta3, I was found that running a function generated an
error relating to escaped single quotes, yet still produced the answer I
expected!
/// part000.sql script ///
DROP TABLE IF EXISTS measurement CASCADE;
CREATE TABLE measurement
(
city_id int not null
The following bug has been logged online:
Bug reference: 6095
Logged by: Gavin Flower
Email address: gavin.flo...@archidevsys.co.nz
PostgreSQL version: 9.1beta2
Operating system: x86_64 Linux
Description:Misleading error message: INSERT has more expressions
than
On 09/04/11 02:42, Tom Lane wrote:
Gavin Flower writes:
I found were RETURNING is defined, so I was confused...
...
However, may be it would still be good to mention it on the SELECT page?
It is mentioned --- the subsection on the WITH clause points out that
you typically want to use
On 08/04/11 14:57, Tom Lane wrote:
"Gavin Flower" writes:
I think the documentation of SELECT should include the keyword 'RETURNING'
in its synopsis.
Huh? There's no SELECT RETURNING.
regards, tom lane
The 'WITH' clause is described
On 08/04/11 21:22, Gavin Flower wrote:
On 08/04/11 14:57, Tom Lane wrote:
"Gavin Flower" writes:
I think the documentation of SELECT should include the keyword 'RETURNING'
in its synopsis.
Huh? There's no SELECT RETURNING.
regards, tom
The following bug has been logged online:
Bug reference: 5968
Logged by: Gavin Flower
Email address: gavin.flo...@archidevsys.co.nz
PostgreSQL version: 9.1aplha5
Operating system: x86_64 Linux
Description:DOCUMENTATION: SELECT synopsis omits RETURNING keyword
Details
The following bug has been logged online:
Bug reference: 5963
Logged by: Gavin Flower
Email address: gavin.flo...@archidevsys.co.nz
PostgreSQL version: 9.1alpha5
Operating system: x86_64 Linux
Description:make -j4 check fails
Details:
After executing
time -j4
27 matches
Mail list logo
