In a security definer function current_user yelds the
name of the function definer rather than invoker.
Is it possible to fetch the invoker name instead ? How ?
Thanks in advance.
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html
--
Sent via pgsq
Josh Kupershmidt writes:
> On Wed, May 12, 2010 at 12:58 AM, David Fetter wrote:
>> If you've measured a performance issue for a table that tiny, it's a
>> bug that needs fixing in PostgreSQL. What measurements have you done
>> so far?
> Just for fun, I tried it out myself. Here are the times I
To whom it may concern,
this is to inform the PostgreSQL community of my retirement from my
PostgreSQL core team position.
Over the past years I have not been able to dedicate as much time to
PostgreSQL as everyone would have liked. The main reason for that was
that I was swamped with other work
On Wed, May 12, 2010 at 12:58 AM, David Fetter wrote:
> If you've measured a performance issue for a table that tiny, it's a
> bug that needs fixing in PostgreSQL. What measurements have you done
> so far?
Just for fun, I tried it out myself. Here are the times I got on my
modest laptop:
CHECK
On 12/05/10 17:11, Venkata Subrahmanyam Gurram wrote:
Hi,
We are running pgsql server with ssl support. When java client tries to
connected to the server with ssl is on, if there is no ip address entry
in pg_hba.conf file, pgsql
You mean PgJDBC? And by "ssl is on" you mean that you've added
"
Hi,
I was wondering if Postgresql (8.3 or later) had an equivalent function to the
MS-SQL function "unpivot"? I've spotted the user contributed crosstab which is
similar to the "pivot" function, but I can't find an equivalent "uncrosstab".
Essentially what I'm trying to do is take a table like
On 11/05/10 21:19, Mickaël DA ROCHA wrote:
Hello,
We have a document that contains a date (french date for example) :
28-04-2009 (28 April 2009)
In the to_tsvector function, it is noted as :
’-04’:2 ‘-2009’:3 ’28’:1
Is it possible to have something like that (a date) :
‘28-04-2009’:1
You'l
On 12 May 2010 20:18, Tom Lane wrote:
> Thom Brown writes:
> > On 12 May 2010 19:40, Joshua D. Drake wrote:
> >>> Am I to gather that there are possible incompatibilities?
> >>
> >> Definitely.
>
> > In that case, it might be an idea to clarify that on the documentation.
> I
> > couldn't find
On Wed, May 12, 2010 at 2:36 PM, Little, Douglas
wrote:
> Is there anything in the system that would aid tracking who/how often an
> object (table/column/function/view) is accessed? In Teradata we have an
> accesslog table that record attempted access to an object and if it’s
> granted or denied.
Hi,
Is there anything in the system that would aid tracking who/how often an object
(table/column/function/view) is accessed?
In Teradata we have an accesslog table that record attempted access to an
object and if it's granted or denied. Very important to our sox's folks.
Thanks
Doug Little
Thom Brown writes:
> On 12 May 2010 19:40, Joshua D. Drake wrote:
>>> Am I to gather that there are possible incompatibilities?
>>
>> Definitely.
> In that case, it might be an idea to clarify that on the documentation. I
> couldn't find this information.
If it were true, it would be in the d
On 12 May 2010 19:40, Joshua D. Drake wrote:
> On Wed, 2010-05-12 at 19:33 +0100, Thom Brown wrote:
> > On 12 May 2010 19:29, Joshua D. Drake wrote:
> >
> > On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote:
> > > Hi,
> > >
> > >
> > > Does anyone know i
On Wed, 2010-05-12 at 19:33 +0100, Thom Brown wrote:
> On 12 May 2010 19:29, Joshua D. Drake wrote:
>
> On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote:
> > Hi,
> >
> >
> > Does anyone know if there are issues with performing a
> pg_dump
On 12 May 2010 19:29, Joshua D. Drake wrote:
> On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote:
> > Hi,
> >
> >
> > Does anyone know if there are issues with performing a pg_dump in
> > custom format in one major version, and using pg_restore on it on a
> > higher version?
>
> You want to use
On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote:
> Hi,
>
>
> Does anyone know if there are issues with performing a pg_dump in
> custom format in one major version, and using pg_restore on it on a
> higher version?
You want to use the pg_dump from the higher version.
Joshua D. Drake
>
>
To yank this thread in yet another direction:
The question of 8.3 vs 8.4 brings up a very irritating issue we have
with one client. Originally, we had installed PostgreSQL 8.3 on his
system. There is a program we occasionally have to use that requires us
to use "mstsc /console" to connect to his
Hi,
Does anyone know if there are issues with performing a pg_dump in custom
format in one major version, and using pg_restore on it on a higher version?
Thanks
Thom
On Wed, May 12, 2010 at 10:55 AM, Thomas Kellerer wrote:
> Richard Broersma wrote on 12.05.2010 17:45:
>
>> I'm considering using the windows version PostgreSQL in the following
>> conditions:
>> at least 10 years of up time (with periodic power failures<= 1 a year)
>
> I don't think you can get 1
Richard Broersma wrote on 12.05.2010 17:45:
I'm considering using the windows version PostgreSQL in the following
conditions:
at least 10 years of up time (with periodic power failures<= 1 a year)
I don't think you can get 10 years of up time on a Windows Server.
Most of the security patches
On Wed, 2010-05-12 at 13:45 -0400, Rob Richardson wrote:
> I use both PostgreSQL and SQLite in my job. I have mixed feelings
> about SQLite. If you play by its rules, it works very well, but I
> think you have to understand its rules well. If you do not set up
> your indexes correctly and do not
I use both PostgreSQL and SQLite in my job. I have mixed feelings about
SQLite. If you play by its rules, it works very well, but I think you
have to understand its rules well. If you do not set up your indexes
correctly and do not use transactions correctly, performance can be
horrible, but if
On Wed, May 12, 2010 at 07:12:10PM +0200, I. B. wrote:
>
> That was my first guess. I used palloc everywhere.. But to be sure, after I
> made the type, I tried to do the something like:
>
> mytype * result;
> mytype * realResult;
> result = createType(...);
> realResult = (mytype *)palloc(mytype
That was my first guess. I used palloc everywhere.. But to be sure, after I
made the type, I tried to do the something like:
mytype * result;
mytype * realResult;
result = createType(...);
realResult = (mytype *)palloc(mytype->length);
mempcy (realResult, result, result->length);
It didn't help
On 12 May 2010, at 18:08, I. B. wrote:
> Hello.
>
> I have a problem. I've created several types and functions in C language and
> implemented them successfully. Or at least I thought so... When I insert,
> select, update data, everything works fine, but in that session only. As soon
> as I cl
On Wed, May 12, 2010 at 11:33 AM, Richard Broersma <
richard.broer...@gmail.com> wrote:
> On Wed, May 12, 2010 at 9:18 AM, Justin Graf wrote:
>
> > I would do a plain text file something like XML. Given this is for
> > industrial use 10 years is a good number for warranty and support, but
> > th
On 5/12/2010 12:33 PM, Richard Broersma wrote:
> On Wed, May 12, 2010 at 9:18 AM, Justin Graf wrote:
>
>
>> I would do a plain text file something like XML. Given this is for
>> industrial use 10 years is a good number for warranty and support, but
>> this stuff will hang around years later,
Thanks very much! I put that query into a script that puts the initial result
into a variable, sleeps for a minute, queries again into a second variable and
subtracts the difference.
Works fine.
Melvin Davidson
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
--- On Wed, 5/12/1
On Wed, May 12, 2010 at 9:18 AM, Justin Graf wrote:
> I would do a plain text file something like XML. Given this is for
> industrial use 10 years is a good number for warranty and support, but
> this stuff will hang around years later, think 20 to 30 years. How
> many people understand FLAT IS
On May 12, 2010, at 9:12 AM, Melvin Davidson wrote:
> Can anyone tell me how to measure _actual_ transactions per minute on a
> PostgreSQL server. I am not talking about using pgbench, as I am not
> interested in determining what is possible, but rather the actual count of
> queries / transacti
On Wed, May 12, 2010 at 09:12:43AM -0700, Melvin Davidson wrote:
> Can anyone tell me how to measure _actual_ transactions per minute on a
> PostgreSQL server. I am not talking about using pgbench, as I am not
> interested in determining what is possible, but rather the actual count of
> queries
On 12 May 2010 16:30, Andre Lopes wrote:
> Hi,
>
> I'am looking fo a shell script do Backup/Dump my PostgreSQL twice a day.
>
> I will need to do a full dump (schema + data), schema dump (only schema)
> and data (only data)
>
> There is something done on this subject? I'am very poor in shell scri
Hello.
I have a problem. I've created several types and functions in C language and
implemented them successfully. Or at least I thought so... When I insert,
select, update data, everything works fine, but in that session only. As soon
as I close psql and start it agan, the data is corrupted.
On 5/12/2010 11:45 AM, Richard Broersma wrote:
> Can anyone advise me if either PostgreSQL 8.3 or 8.4 is ready for
> special case of production use?
>
> I'm considering using the windows version PostgreSQL in the following
> conditions:
> at least 10 years of up time (with periodic power failur
pgsql-general@postgresql.org
Can anyone tell me how to measure _actual_ transactions per minute on a
PostgreSQL server. I am not talking about using pgbench, as I am not interested
in determining what is possible, but rather the actual count of queries /
transactions being sent to the server.
On 12 May 2010 17:02, Andre Lopes wrote:
> Thanks for the reply.
>
> I will test today.
>
> There are some good practices that I should do? For example, I have this
> database in a shared hosting, should I add the functionality of send the
> dumps by FTP to my PC once a week? Give some more ideia
Thanks for the reply.
I will test today.
There are some good practices that I should do? For example, I have this
database in a shared hosting, should I add the functionality of send the
dumps by FTP to my PC once a week? Give some more ideias to avoid data loss
in case of disaster.
Best Regards
On 12 May 2010 16:30, Andre Lopes wrote:
> Hi,
>
> I'am looking fo a shell script do Backup/Dump my PostgreSQL twice a day.
>
> I will need to do a full dump (schema + data), schema dump (only schema)
> and data (only data)
>
> There is something done on this subject? I'am very poor in shell scri
Can anyone advise me if either PostgreSQL 8.3 or 8.4 is ready for
special case of production use?
I'm considering using the windows version PostgreSQL in the following
conditions:
at least 10 years of up time (with periodic power failures <= 1 a year)
single table with less-than 50 record inserts
Le 12/05/2010 16:56, Igor Neyman a écrit :
> [...]
> I'm not sure why are you instisting that:
>
>> CREATE FUNCTION f1(arg1 table.column%TYPE ...
>>
>> Which, AFAICT, is not possible.
>
> It is definetily possible, i.e:
>
> CREATE OR REPLACE FUNCTION myMaxCycle(i_n_Cell_id GP_CELL.cell_id%TYPE
On Wed, May 12, 2010 at 4:12 PM, Igor Neyman wrote:
>
> Dave,
>
> Are there any plans to build 8.4... As 64 bit for Windows?
8.4 cannot be built for 64 bit Windows. Thats only supported with 9.0 and above.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Compan
Hi,
I'am looking fo a shell script do Backup/Dump my PostgreSQL twice a day.
I will need to do a full dump (schema + data), schema dump (only schema) and
data (only data)
There is something done on this subject? I'am very poor in shell script,
there are some scripts on the web ready to use?
Be
> -Original Message-
> From: Dave Page [mailto:dp...@pgadmin.org]
> Sent: Wednesday, May 12, 2010 3:47 AM
> To: Luis Guillermo Dangel
> Cc: pgsql-general@postgresql.org
> Subject: Re: Question about Beta for Windows 64 bits
>
> On Wed, May 12, 2010 at 1:41 AM, Luis Guillermo Dangel
>
> -Original Message-
> From: Mike Christensen [mailto:m...@kitchenpc.com]
> Sent: Wednesday, May 12, 2010 3:10 AM
> To: Thom Brown
> Cc: pgsql-general@postgresql.org
> Subject: Re: Weird unique constraint
>
> By golly you're right; maybe I should try this stuff before I
> email hundre
> -Original Message-
> From: Guillaume Lelarge [mailto:guilla...@lelarge.info]
> Sent: Tuesday, May 11, 2010 11:56 AM
> To: Tom Lane
> Cc: Dino Vliet; pgsql-general@postgresql.org
> Subject: Re: can function arguments have the type
> tablename.columnname%TYPE?
>
> Le 11/05/2010 16:16,
On Wed, May 12, 2010 at 3:11 AM, Venkata Subrahmanyam Gurram
wrote:
> Hi,
>
> We are running pgsql server with ssl support.When java client tries to
> connected to the server with ssl is on, if there is no ip address entry in
> pg_hba.conf file, pgsql first tries to connect with ssl and then tries
Hi,
We are running pgsql server with ssl support.When java client tries to
connected to the server with ssl is on, if there is no ip address entry in
pg_hba.conf file, pgsql first tries to connect with ssl and then tries to
connect with non ssl.We checked this one in log file. Why the server i
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> You think it is because slony is poking around pg_catalog.
>> schema, and it shouldn't , basically ?
> No, Slony 1.2.x pokes around in pg_catalog because in versions
> of postgres prior to 8.3 (which 1.2.x has to support) there was
> no bu
Yes it would. In fact, I have often wondered why this doesn't exist.
How can I do it?
John
On May 12, 2010, at 12:14 PM, Peter Eisentraut wrote:
On lör, 2010-05-08 at 11:06 +0200, John Gage wrote:
Is the documentation available anywhere as a single page text file?
This would be enormousl
If you think about it, NULL is not a value.
It makes sens that it allows multiple NULLs.
If you don't agree, than your SQL point of view doesn't match the
majority, and your designs won't fit in the SQL paradigm .
I think it is just a matter of experimenting, and experience to see
how useful it is
Not to mention teaching some of us something we didn't know.
RobR, who probably should know a lot more about PostgreSQL than he does
On 6 May 2010 21:15, Greg Smith wrote:
> Guillaume Lelarge wrote:
>
>> And rather than checking the database name, I usually prefer to filter
>> with datallowconn.
>> It'll save template1 and postgres, but the script won't give me an error
>> on template0.
>>
>>
>
> Template databases are labeled
2010/5/12 Glyn Astill :
> --- On Wed, 12/5/10, Grzegorz Jaśkiewicz wrote:
>
>> Alban Hertroys
>>
>> wrote:
>> > On 12 May 2010, at 12:01, Glyn Astill wrote:
>> >
>> >> Did you not mention that this server was a slony
>> slave at some point though?
>> >>
>> >> Just because you have removed slony,
--- On Wed, 12/5/10, Grzegorz Jaśkiewicz wrote:
> Alban Hertroys
>
> wrote:
> > On 12 May 2010, at 12:01, Glyn Astill wrote:
> >
> >> Did you not mention that this server was a slony
> slave at some point though?
> >>
> >> Just because you have removed slony, and the error
> comes from postgresq
It is an announcement that long-waited bug-fix of pg_lesslog is now
released. This includes the following.
1. Error in calculation of GiST-related WAL record length was fixed.
2. pg_compresslog now has an option to print WAL segment analysis.
3. New test script is added which analyzes what WAL r
On Wed, May 12, 2010 at 11:09 AM, Alban Hertroys
wrote:
> On 12 May 2010, at 12:01, Glyn Astill wrote:
>
>> Did you not mention that this server was a slony slave at some point though?
>>
>> Just because you have removed slony, and the error comes from postgresql
>> itself does not mean the corru
On lör, 2010-05-08 at 11:06 +0200, John Gage wrote:
> Is the documentation available anywhere as a single page text file?
> This would be enormously helpful for searching using regular
> expressions in Vim, for example, or excerpting pieces for future
> reference.
It would be pretty easy to
On 12 May 2010, at 12:01, Glyn Astill wrote:
> Did you not mention that this server was a slony slave at some point though?
>
> Just because you have removed slony, and the error comes from postgresql
> itself does not mean the corruption was not caused by misuse of slony.
Indeed. I wonder if "
--- On Wed, 12/5/10, Grzegorz Jaśkiewicz wrote:
> Glyn Astill
> wrote:
> > Hi Grzegorz,
> >
> > Is it always the same OID(s)?
> >
> > Usually this means something somewhere has a link to
> an OID that has been removed.
> >
> > You could try digging through pg_catalog lookng for an
> oid column th
Did you not mention that this server was a slony slave at some point though?
Just because you have removed slony, and the error comes from postgresql itself
does not mean the corruption was not caused by misuse of slony.
--- On Wed, 12/5/10, Grzegorz Jaśkiewicz wrote:
> From: Grzegorz Jaśkiewi
On Wed, May 12, 2010 at 10:57 AM, Glyn Astill wrote:
> Hi Grzegorz,
>
> Is it always the same OID(s)?
>
> Usually this means something somewhere has a link to an OID that has been
> removed.
>
> You could try digging through pg_catalog lookng for an oid column that refers
> to the OID in questio
no it is not slony related.
It is a postgresql problem.
my original post:
http://archives.postgresql.org/pgsql-general/2010-05/msg00402.php
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Grzegorz,
Is it always the same OID(s)?
Usually this means something somewhere has a link to an OID that has been
removed.
You could try digging through pg_catalog lookng for an oid column that refers
to the OID in question.
In my experience, when a slony 1.2.x slave is involved, this usua
On 11 May 2010, at 16:19, Grzegorz Jaśkiewicz wrote:
> Another thing that makes me think so, is what I've seen in pg_dump's output:
>
> CREATE TRIGGER _simreplic_denyaccess_208
>BEFORE INSERT OR DELETE OR UPDATE ON some_table
>FOR EACH ROW
>EXECUTE PROCEDURE 28799('_somereplic');
>
>
anyone please ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 12/05/2010 7:46 p.m., Dave Page wrote:
On Wed, May 12, 2010 at 1:41 AM, Luis Guillermo Dangel
wrote:
Hi guys.
I downloaded the windows installer for the Beta version, and noticed when
installing that it was installing in the 32 bits program files folder.
Is there an installer of P
Alvaro Herrera writes:
> There's a texinfo output that could perhaps be useful. Try
> "make postgres.info" in the doc/src/sgml directory; while it's tagged
> "experimental" and outputs a boatload of warnings, it does work for me and the
> text it produces is plain enough.
It's pretty good indeed
On 12 May 2010 08:09, Mike Christensen wrote:
> By golly you're right; maybe I should try this stuff before I email
> hundreds of people :)
>
>
>
Nah, gives us something to read :)
Thom
On Wed, May 12, 2010 at 1:41 AM, Luis Guillermo Dangel
wrote:
> Hi guys.
>
>
>
> I downloaded the windows installer for the Beta version, and noticed when
> installing that it was installing in the 32 bits program files folder.
>
>
>
> Is there an installer of PostgreSQL 64 bits for windows?
Not
By golly you're right; maybe I should try this stuff before I email
hundreds of people :)
On Wed, May 12, 2010 at 12:00 AM, Thom Brown wrote:
> On 12 May 2010 07:34, Mike Christensen wrote:
>>
>> I have the following constraint which almost works:
>>
>> ALTER TABLE ingredientforms ADD CONSTRAINT
In response to Mike Christensen :
> I have the following constraint which almost works:
>
> ALTER TABLE ingredientforms ADD CONSTRAINT
> ingredientforms_UniqueIngredientForm UNIQUE(IngredientId,
> FormDisplayName);
>
> However, I want to allow rows that have the same IngredientId
> FormDisplayNam
On 12 May 2010 07:34, Mike Christensen wrote:
> I have the following constraint which almost works:
>
> ALTER TABLE ingredientforms ADD CONSTRAINT
> ingredientforms_UniqueIngredientForm UNIQUE(IngredientId,
> FormDisplayName);
>
> However, I want to allow rows that have the same IngredientId
> Fo
On 12 May 2010 07:34, Mike Christensen wrote:
> I have the following constraint which almost works:
>
> ALTER TABLE ingredientforms ADD CONSTRAINT
> ingredientforms_UniqueIngredientForm UNIQUE(IngredientId,
> FormDisplayName);
>
> However, I want to allow rows that have the same IngredientId
> Fo
72 matches
Mail list logo
