Can someone assists with the issue posted on StackOverflow?
https://stackoverflow.com/questions/46540537/postgresql-9-3-creation-of-group-role-causes-permission-problems
Creation of new Group Role causes postgresql to think that Login roles does not exist. I think it's a bug? or at least a wr
The operator <> seems to not work properly comparing citext types in triggers function.
https://stackoverflow.com/questions/45441840/posgresql-9-3-operator-doesnt-give-logical-result
Can someone figure out what is the problem? This seems like a bug.
Hi,
I should say that I'm haviing this issue since 9.3.2 I though it would be resolved when I upgrade to 9.3.17 but this still appear.
This is a very wierd issue.
I upload backups using pg_restore and
psql -h SERVER -U USERNAME -f backup.sql -q -d databasename -pPORT 2>errors.txt >output.txt
W
On Wed, Oct 22, 2014 at 3:19 AM, Kevin Grittner wrote:
>
> It doesn't seem like this analysis considers all of the available ON
> DELETE and ON UPDATE behaviors available. Besides RESTRICT there is
> CASCADE, SET NULL, SET DEFAULT, and NO ACTION. Some of those
> require updating the referencing
like a net win.
Not to mention the possibility of a deadlock, if the other transaction
updates our PK or adds another reference to it.
Thanks again,
Nick Barnes
One of the queries in ri_triggers.c has be a little baffled.
For (relatively) obvious reasons, a FK insert triggers a SELECT 1 FROM
pk_rel ... FOR KEY SHARE.
For not-so-obvious reasons, a PK delete triggers a SELECT 1 FROM fk_rel ...
FOR KEY SHARE.
I can't see what the lock on fk_rel achieves. Bo
the patch.
Thanks,
Nick Roosevelt
to taken the stable execution time (19-21 ms).
3. Average down these four execution time.
Which option will be true?
Thanks
Nick
2011/6/2 Teodor Sigaev
> Can we figure out some information about index i.e. whet is the height
>> of index tree, how many values are placed in one leaf node and one non
>> leaf level node?
>>
>
> http://www.sigaev.ru/cvsweb/cvsweb.cgi/gevel/
For improving space utilization, When node is split
ex i.e. whet is the height of
index tree, how many values are placed in one leaf node and one non leaf
level node?
Regards,
Nick
Can some one tell me why index is becoming so large?
How to compress or reduce its size?
Thanks
Nick
Can some one tell me why index is becoming so large?
How to compress or reduce its size?
Thanks
Nick
sorry, actually becuase of one printf statement(i have added) because of
that, these has been occured. My mistake
On Mon, May 23, 2011 at 9:06 AM, Robert Haas wrote:
> On Sun, May 22, 2011 at 6:42 AM, Nick Raj wrote:
> > I am using contrib/cube code. I am building GIST index on cube
postgres to logged so much data in
case of cube?
Thanks
Nick
On Mon, May 16, 2011 at 7:52 PM, Tom Lane wrote:
> Robert Haas writes:
> > On Mon, May 16, 2011 at 3:41 AM, Nick Raj wrote:
> >> "How to get arguments toastable??" and even my table
> pg_class.reltoastrelid
> >> entry is zero.
>
> > It's
Hi,
I have defined some function and also used NDBOX structure that having
variable length.
typedef struct NDBOX
{
int32vl_len_;/* varlena length */
unsigned int dim;
doublex[1];
} NDBOX;
When i called my function, it gives NDBOX to be null
On debugging, i foun
Sorry i don't know about AFAICS.
Yes, i want to modify cube code for this i want to go in detail by
debugging.
Can you throw some light on how to debug contrib/cube code?
On Fri, May 6, 2011 at 9:59 PM, Euler Taveira de Oliveira wrote:
> Em 06-05-2011 02:14, Nick Raj escreveu:
>
&g
Hi,
I am using postgresql-8.4.6. I want to debug the contrib/cube code. Can we
able to debug that cube code? Because there is no .configure file to
enable debug. Is there is any way to change make file to enable debug?
Thanks
makes pointer from
integer without a cast
../../../include/utils/timestamp.h:205: note: expected
‘FunctionCallInfo’ but argument is of type ‘unsigned int’
Can anybody figure out what kind of mistake i am doing?
Also, why it got related to 'FunctionCallInfo' ?
Thanks
Nick
Hi,
Can anyone know how to define global variable in plpgsql?
Thanks
Regards,
Raj
Raj
On Mon, Mar 7, 2011 at 12:33 PM, Heikki Linnakangas <
heikki.linnakan...@enterprisedb.com> wrote:
> On 07.03.2011 08:07, Nick Raj wrote:
>
>> I want to construct an "Composite Index Structure" i.e. a combination of
>> gist and btree.
>> What i am
Hi all,
I want to construct an "Composite Index Structure" i.e. a combination of
gist and btree.
What i am thinking is that first creating a Rtree structure that is pointing
to another Btree structure.
For example, Suppose i want to find vehicles between 2 to 4 pm on 14/2/2011
on X road.
I am thi
Hi,
I am writing some spatio-temporal function in postgis.
Like, ST_Enters( obj_geom, boundary_geom, time t1,time t2)
For example- Does vehicle enters in ABC between time t1 to t2?
Let us suppose, i take only one object geometry at a time and do compare
then i could not produce the output because
aks backwards compatibility.
completely d'accord...
Otherwise, the striking lack of academical initiatives in the area of OO
and rule inference on top of PostgreSQL appears to me as a demand to
Hmmm. I don't know about that; I've never seen that academics *cared*
whether or not their
these will be small projects.
Cheers, Nick
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
this professor to try to fill the
gap... ;-) In this case, regarding method semantics extensions, avoiding
conflicts with existent language constructs certainly will be
preferable, as these will be small projects.
Cheers, Nick
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresq
Hi Kevin,
this example was for teaching AI students (with limited PostgreSQL
knowledge) in a very basic lecture -- I did not want to tweak the SQL
semantics too much; just demonstrate why SQL is rightfully called a 4GL
language. ;-)
Cheers, Nick
On 02/01/2011 10:08 PM, Kevin Grittner wrote
able -- I was afraid I did not know enough
about the internals to predict a convincing outcome.
All the best,
Nick
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Hi Pavel,
I guess this represents most exactly what this professor is thinking
about -- being able to create methods and types with methods which can
be nested -- but syntactical details are of secondary importance.
All the best, Nick
On 02/01/2011 05:43 AM, Pavel Stehule wrote:
Hello
it
On 02/01/2011 03:36 AM, Robert Haas wrote:
On Mon, Jan 31, 2011 at 5:40 PM, Nick Rudnick wrote:
* In this regard it is of interest in how far there are principal efficiency
problems with the support of (deeply nested) object like structure by the
backend, or if the backend may be expected to
overhead
for students.
Cheers,
Nick
On 01/31/2011 03:22 PM, Robert Haas wrote:
On Mon, Jan 31, 2011 at 3:32 AM, Jörg Roman Rudnick
wrote:
* are there any people / projects known which are interested in ORDBMS /
OODBMS usage of PostgreSQL? Strict SQL standard conformance is less
straightforward way?
Thank you in advance,
Nick
On 01/31/2011 03:19 PM, Robert Haas wrote:
On Mon, Jan 31, 2011 at 4:34 AM, Pavel Stehule wrote:
What I know no body is working on SQL/OLB ISO/IEC 9075-10 now.
I proposed a 3 years ago a support of methods, but without success.
This propose was
eems quite simple and easy enough... if reliable. -
Nick
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Nope, im not ordering by the POINT column. Heres an example...
CREATE TABLE table1 (
title character varying,
sorter integer,
xy point
);
CREATE TABLE table2 (
title character varying,
sorter integer,
xy point
);
INSERT INTO table1 VALUES ('one', 1, '(1,1)');
INSERT INTO
I have a VIEW that consists of two tables, of which contain a POINT
column. When trying to select from the view I get an error...
ERROR: could not identify an ordering operator for type point
HINT: Use an explicit ordering operator or modify the query.
Any suggestions??? -Nick
--
Sent via
to user;
revoke all [privileges] on [table] bla from user;
If everyone is too busy at the moment with the 8.3 release, let me know
and I will resubmit this stuff in a couple of months when things have
calmed down.
Ta
Nick
---(end of broadcast)-
attract new
> > viewers, just that the existing viewers think that.
Perhaps more compelling is this survey, which shows that 21% of the users
are on actually the win32/cygwin platform now & hence are not enjoying the
performance or ease of installation that the other 79% of us get.
http
scott.marlowe wrote:
On Mon, 17 Mar 2003, Nick Piggin wrote:
Dear PostgreSQL hackers,
I am developing a disk IO scheduler for Linux and am aiming to
have it included in the stable 2.6 release. Due to its design,
performance regressions do appear, and are often more specific
to the workload in
Gavin Sherry wrote:
Hi,
I would appreciate it if you could give me a suggestion
for a not-too-difficult to set up or interpret PostgreSQL
benchmark with a reasonable running time (< an hour or so)
which I can add to my performance regression tests.
Check out `make check', a regression tes
on
this can agree on.
Thank you all for your time.
Best regards,
Nick Piggin
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I'm not sure if the pretty print option does anything for the SQL, but it
didn't hurt.
The results appear on /var/log/postgresql.log using the Debian Linux
distribution. Not sure of the location in others.
-Nick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
<
1. I can't see anything obviously wrong with the script, but something very
odd is going.
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Nick Fankhauser
> Sent: Monday, September 09, 2002 11:25 AM
> To: Bruce Momjian;
but
the values are in line with the results that others have been getting.
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian
> Sent: Monday, September 09, 2002 1:14 AM
> To: PostgreSQL-development
> Subject: Re: [
nning under a driver manager though...
I will check of FreeBSD, it certainly will on Linux ELF.
--
Nick Gorham
When I die, I want to go like my grandfather did, gently while sleeping,
and not like his passangers, screaming in a panic, looking for the
inflatable raft. -- Seen on ./
the problem, and it connects. I will continue testing, with some
apps and see how it gets on
--
Nick Gorham
Easysoft Ltd
. localhost is a valid host name.
Ok, but don't you think it is worth having some way to get it to use UNIX domain
sockets instead of TCP ones, for instance if postmaster isn't
started with a -i ?
> We have a general approach to non-standard socket names now.
Great, thats a non
[EMAIL PROTECTED] wrote:
> Nick Gorham writes:
>
> > Well because the driver does not know where to get the config info
> > from,
>
> Then the driver should be fixed to do that, with or without unixODBC.
Well yes, but again, using the Windows situation as a model (n
ple is too big: size 9148,
max size 8140
still persists.
My question is that is there a way to reflect the
chages to config.h in the database without
re-istalling postgresql. I have a large database
running on 7.03 and do not want to reinstall.
PLEASE HELP !!!
T
nt to install PL/Perl on my
version postgresql-7.0.2,but when I try to make the
Perl interpreter It just makes the Dummy Makefile
which says "Cannot build plperl because libperl is not
a shared library; skipping it."
I know this is a very basic thing but can someone
please hel
49 matches
Mail list logo
