Sam Mason wrote:
I've just realized another case where it's not consistent; why does the
following return true:
SELECT row(null) IS NULL;
and yet the following false:
SELECT row(row(null)) IS NULL;
You're intentionally assuming that row(null) IS NULL evaluating to true
Hi all,
A school wants to offer a number of short courses on a number of different
dates. Students apply online for a single course at a time and choose one or
more dates (from a list) which would suit them. Once the application period is
over which course is taught when is decided soley on the
Hi
This is probably more like linux question but strictly related to
PG so I hope somebody can help me.
I need to have 8.3 8.4 installed on the same machine (for
pg_migrator). As I'm not Linux guru I used to install/update Postgres
using yum from PGDG.
Is there any clever way to
wstrzalka wrote:
Hi
This is probably more like linux question but strictly related to
PG so I hope somebody can help me.
I need to have 8.3 8.4 installed on the same machine (for
pg_migrator). As I'm not Linux guru I used to install/update Postgres
using yum from PGDG.
Is there any
On 2009-08-17, Bob Gobeille bob.gobei...@hp.com wrote:
I use PSQL to set my editor to vi. This works as expected in psql, \e
brings up vi and I edit away.
Is there any way to set my psql command line editor to also use vi
(just like I do with set -o vi in bash)?
I can't find this in the
On Mon, 17 Aug 2009 12:48:21 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
Hello
I am not sure, if it's possible for you. PostgreSQL 8.4 has EXECUTE
USING clause, it is 100% safe.
Sorry I don't get it.
How can I use USING safely when the substitution involves a table
name?
The
Greetings:
Is there a way to get hold of an environment variable such that it can be
referenced in postgresql.conf? In particular, I'd like to be able to point
dynamic_library_path to an environment variable defined at the system level
as in dynamic_library_path = '$SOURCE:$libdir'.
master=#
2009/8/18 Ivan Sergio Borgonovo m...@webthatworks.it:
On Mon, 17 Aug 2009 12:48:21 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
Hello
I am not sure, if it's possible for you. PostgreSQL 8.4 has EXECUTE
USING clause, it is 100% safe.
Sorry I don't get it.
How can I use USING safely
On Tue, Aug 18, 2009 at 10:32:35AM +0200, Daniel Verite wrote:
Sam Mason wrote:
I've just realized another case where it's not consistent; why does the
following return true:
SELECT row(null) IS NULL;
and yet the following false:
SELECT row(row(null)) IS NULL;
You're
On Tue, Aug 18, 2009 at 02:16:20AM -0700, wstrzalka wrote:
I need to have 8.3 8.4 installed on the same machine (for
pg_migrator). As I'm not Linux guru I used to install/update Postgres
using yum from PGDG.
If you could use Debian or something based on it (e.g. Ubuntu) then this
is how it
On Tue, 18 Aug 2009 12:38:49 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
some unsafe function:
I suspected something similar.
I think many would appreciate if you put these examples here
http://www.okbob.blogspot.com/2008/06/execute-using-feature-in-postgresql-84.html
and substitute the
On Tue, Aug 18, 2009 at 08:58:12AM +, Sebastian Tennant wrote:
Perhaps the simplest model is a database table 'application_forms' which
includes two text columns; 'course' and 'preferred_dates' with entries that
look like this:
course: Drama
prefered_dates: Sat_22Aug09,
On 18 Aug 2009, at 6:51, Sim Zacks wrote:
That would be true if all units were always convertible to mm, but we
have volume also, we also have feet etc.. So that the easiest and
How did you plan on solving that in your multiple-argument aggregate?
Fake their value by adding 0? That's no
Hi,
I have some functions developed in postgres to work as a procedure. But now
I see in the Postgres Studio that we have the option to create a
procedure... So my question? there are procedures in Postgres 8.3? If yes,
what the correct syntax to write procedures in Postgres 8.3?
Best Regards,
Sam Mason wrote:
SELECT course, date, COUNT(*)
FROM application_preferred_date
GROUP BY course, date;
Hope that gives you some ideas!
the problem as stated is more complex than that. A student could, in
theory, pick several different courses on the same dates on the
assumption
Hard disk containing PostgreSql 8.1 database on Windows crashes and there
was no new
backup copy.
I installed 8.1.9 to new computer and copied data directory from crashed
disk to it.
data directory contains a lot of files with a lot of data.
Trying to connect to template0 or any other
2009/8/18 Andre Lopes lopes80an...@gmail.com:
Hi,
I have some functions developed in postgres to work as a procedure. But now
I see in the Postgres Studio that we have the option to create a
procedure... So my question? there are procedures in Postgres 8.3? If yes,
what the correct syntax to
On Tue, Aug 18, 2009 at 05:24:52AM -0700, John R Pierce wrote:
Sam Mason wrote:
SELECT course, date, COUNT(*)
FROM application_preferred_date
GROUP BY course, date;
the problem as stated is more complex than that. A student could, in
theory, pick several different courses on the
2009/8/18 Ivan Sergio Borgonovo m...@webthatworks.it:
On Tue, 18 Aug 2009 12:38:49 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
some unsafe function:
I suspected something similar.
I think many would appreciate if you put these examples here
On Monday 17 August 2009 8:50:09 pm Andrew Bartley wrote:
So the information i have thus far is that, I am not easily able to log the
statements from a function.
Does anyone know why it was removed... that is it 7.2 logged this
information.
Thanks Again
Andrew Bartley
You are going to
v8.3 FAQ_Solaris
To point it to the right location, set the
LD_LIBRARY_PATH environment variable, e.g.,
LD_LIBRARY_PATH=/usr/sfw/lib:/opt/sfw/lib:/usr/local/lib
export LD_LIBRARY_PATH
and restart configure. You will also have to keep this setting whenever
you run any of the installed
On Tuesday 18 August 2009 09:28, Martin Gainty wrote:
v8.3 FAQ_Solaris
To point it to the right location, set the
LD_LIBRARY_PATH environment variable, e.g.,
LD_LIBRARY_PATH=/usr/sfw/lib:/opt/sfw/lib:/usr/local/lib
export LD_LIBRARY_PATH
and restart configure. You will also have
Terry Lee Tucker te...@chosen-ones.org writes:
Is there a way to get hold of an environment variable such that it can be
referenced in postgresql.conf?
No, but you could perhaps set that GUC on the postmaster command line
instead.
postmaster ... --dynamic_library_path=$SOURCE:$$libdir
Sam Mason wrote:
You're intentionally assuming that row(null) IS NULL evaluating to true
implies that row(null) can be replaced by NULL. As discussed upthread, this
is not the case.
But you've still not said how is this useful!
To me, IS NULL applied to rows, as a test of
Hi,
I'm developing a function with some checks, for example... to check if the
e-mail is valid or not.
If the e-mail is not valid I put a line with RAISE NOTICE 'E-mail not
valid'.
I need to know if it is possible to show this RAISE NOTICE when I run this
function from PHP.
Best Regards,
On Tue, 2009-08-18 at 02:16 -0700, wstrzalka wrote:
Is there any clever way to install parallel version of PG using yum
or other way (without compilation please :D )
There is no way to do it with RPMS :( Install one of the versions using
yum, and compile the other please.
--
Devrim GÜNDÜZ,
Andre == Andre Lopes lopes80an...@gmail.com writes:
Andre I'm developing a function with some checks, for example... to check if
the
Andre e-mail is valid or not.
How are you hoping to do this? The regex to validate an email
address syntactically is pretty large:
This thread was originally posted (incorrectly by me) to the hackers
mailing list. Moving the discussion to the gerenal.
Hi Greg,
That is what Pierre pointed out, and you are both right. I am using the
text mode.
But it seems pretty crazy that a 140meg bit of data goes to 1.3 gigs. Does
that
On Tue, Aug 18, 2009 at 6:39 PM, Michael Clarkcodingni...@gmail.com wrote:
But it seems pretty crazy that a 140meg bit of data goes to 1.3 gigs. Does
that seem a bit excessive?
From what you posted earlier it looked like it was turning into about
500M which sounds about right. Presumably
Hello all,
Inspired by the original discussion on aggregating quantities of
different units I made a start at a unit conversion database and the
result is here: http://solfertje.student.utwente.nl/documents/units.sql
This is not a complete implementation, I just thought I'd show you
what
On Tue, Aug 18, 2009 at 1:48 PM, Greg Stark gsst...@mit.edu wrote:
On Tue, Aug 18, 2009 at 6:39 PM, Michael Clarkcodingni...@gmail.com
wrote:
But it seems pretty crazy that a 140meg bit of data goes to 1.3 gigs.
Does
that seem a bit excessive?
From what you posted earlier it looked like
I just stumbled across this table in a database
developed by a collegue:
field_name | next_value | lock
+-+
id_alert| 500010 | FREE
id_page | 500087 | FREE
id_group| 500021 | FREE
These id_ fields correspond to the primary keys
on
On 08/18/2009 01:14 PM, Doug Gorley wrote:
I just stumbled across this table in a database
developed by a collegue:
field_name | next_value | lock
+-+
id_alert| 500010 | FREE
id_page | 500087 | FREE
id_group| 500021 | FREE
These
Doug Gorley doug.gor...@gmail.com wrote:
I just stumbled across this table in a database
developed by a collegue:
field_name | next_value | lock
+-+
id_alert| 500010 | FREE
id_page | 500087 | FREE
id_group| 500021 | FREE
On Tue, Aug 18, 2009 at 10:57 AM, Andre Lopeslopes80an...@gmail.com wrote:
Hi,
I'm developing a function with some checks, for example... to check if the
e-mail is valid or not.
If the e-mail is not valid I put a line with RAISE NOTICE 'E-mail not
valid'.
I need to know if it is possible
Hi,
I need to implement a Access Control System, but I don't have any clue of
what it is the ideal system... I will try to explain my problem...
I have 4 levels of users in my web application, Super Administrator,
Administrator, Manager and Worker.
The database have data from more than one
Hi list,
I'm having trouble with - believe me! - the IF operator on a PL/PGSQL
function used by a trigger.
I'm using one unique function to process the three triggers events
(delete, update and insert), but when I reference OLD or NEW on a IF
CONDITION, I get an error even when testing
Suporte PK fkno...@gmail.com writes:
IF TG_OP = 'UPDATE' AND OLD.field != NEW.field THEN
...
The question is: if the trigger was not fired by an UPDATE event,
shouldn't it make the first test and then ignore the rest of the condition?
No. This is a very very common error. The behavior is
Bill Moran wmo...@potentialtech.com writes:
And yes, it's pretty much guaranteed to be slower than built in sequences,
with
blocking when multiple threads want a sequence all at the same time.
It's also going to create a vacuum bottleneck unless the insert rate is
quite low, because each ID
Andrus Moor wrote:
Hard disk containing PostgreSql 8.1 database on Windows crashes and
there was no new
backup copy.
I installed 8.1.9 to new computer and copied data directory from
crashed disk to it.
data directory contains a lot of files with a lot of data.
Trying to connect to
CREATE INDEX ufile_name_search ON public.uploadtree USING GIN
(ufile_name);
ERROR: data type text has no default operator class for access method
gin
HINT: You must specify an operator class for the index or define a
default operator class for the data type.
This is on a new 8.3
Andre Lopes wrote:
Hi,
I need to implement a Access Control System, but I don't have any
clue of what it is the ideal system... I will try to explain my problem...
I have 4 levels of users in my web application, Super Administrator,
Administrator, Manager and Worker.
The database have
On Aug 18, 2009, at 3:46 PM, Gobeille, Robert wrote:
CREATE INDEX ufile_name_search ON public.uploadtree USING GIN
(ufile_name);
ERROR: data type text has no default operator class for access method
gin
HINT: You must specify an operator class for the index or define a
default operator
Andre,
See this PHP page:
http://www.php.net/manual/en/function.pg-last-notice.php
Andre Lopes wrote:
Hi,
I'm developing a function with some checks, for example... to check if
the e-mail is valid or not.
If the e-mail is not valid I put a line with RAISE NOTICE 'E-mail not
valid'.
I
On Tue, Aug 18, 2009 at 03:50:47PM -0600, Bob Gobeille wrote:
On Aug 18, 2009, at 3:46 PM, Gobeille, Robert wrote:
CREATE INDEX ufile_name_search ON public.uploadtree USING GIN
(ufile_name);
ERROR: data type text has no default operator class for access method
gin
HINT: You must specify
Sam Mason s...@samason.me.uk writes:
On Tue, Aug 18, 2009 at 03:50:47PM -0600, Bob Gobeille wrote:
CREATE INDEX ufile_name_search ON public.uploadtree USING GIN
(ufile_name);
ERROR: data type text has no default operator class for access method
gin
Not sure if understand very well myself,
On 18/08/2009 9:26 PM, Adrian Klaver wrote:
On Monday 17 August 2009 8:50:09 pm Andrew Bartley wrote:
So the information i have thus far is that, I am not easily able to log the
statements from a function.
Does anyone know why it was removed... that is it 7.2 logged this
information.
Thanks
On 08/18/2009 10:34 PM, Devrim GÜNDÜZ wrote:
On Tue, 2009-08-18 at 02:16 -0700, wstrzalka wrote:
Is there any clever way to install parallel version of PG using yum
or other way (without compilation please :D )
There is no way to do it with RPMS :( Install one of the versions
Hi Craig/Tom,
I've managed to trap the full stack trace this time - 2 processes chewing up
25% each (1 core each on a quad core server), while SELECT * FROM
pg_stat_activity revealed they were IDLE. I also confirmed that the two
runaway processes were started by a developer remotely connecting
On 19/08/2009 12:31 PM, Brendan Hill wrote:
Hi Craig/Tom,
I've managed to trap the full stack trace this time
The common part of those traces is:
ntdll.dll!KiFastSystemCallRet
WS2_32.dll!WSARecv+0x65
WSOCK32.dll!recv+0x31
LIBEAY32.dll!BIO_sock_should_retry+0x57
Hi Craig, thanks for the analysis. If I attach a debugger on the runaway
child process, will this halt execution for all the other child processes
(ie. freeze the server)? And, can I attach Visual Studio C++ 2008, or is
there a recommended debugger for Windows debugging?
Given the reliability of
51 matches
Mail list logo