On Sat, 2011-05-21 at 02:50 +0100, Kohei Kaigai wrote:
> As documentation said, it needs libselinux 2.0.93 or higher.
> This version supports selabel_lookup(3) for database object classes.
AFAICS, we are not checking it during configure. It might be worth to
add libselinux version check in the co
On May 21, 2011, at 2:00, Seb wrote:
> Hi,
>
> I thought this should be equal to 4:
>
> # SELECT length(to_char(11, '0999'));
> length
>
> 5
> (1 row)
>
> but the string returned by the to_char() call is 0011 (length 4). What
> am I missing?
There's a preceeding space:
postgr
Hi,
I thought this should be equal to 4:
# SELECT length(to_char(11, '0999'));
length
5
(1 row)
but the string returned by the to_char() call is 0011 (length 4). What
am I missing?
Thanks,
--
Seb
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
Forwarded message
From: Wei
Date: May 20, 2011
Subject: [GENERAL] Unable to Install - "unable to write inside TEMP environment
variable path"
To: pgsql-general@postgresql.org
When I install the 9.0.x version on my Window Visita Laptop, I get the error.
The "Windows
When I install the 9.0.x version on my Window Visita Laptop, I get the error. The "Windows Scripting Host" is up. So it is not the topic of this article: http://1stopit.blogspot.com/2011/01/postgresql-83-and-84-fails-to-install.html
How to resolve this problem?
Thanks.
- w
As documentation said, it needs libselinux 2.0.93 or higher.
This version supports selabel_lookup(3) for database object classes.
Thanks,
--
NEC Europe Ltd, SAP Global Competence Center
KaiGai Kohei
> -Original Message-
> From: Devrim GÜNDÜZ [mailto:dev...@gunduz.org]
> Sent: 20. Mai 201
I come from an Oracle background and I am fairly new to Postgres. Oracle's
command line utility (SQL*Plus) uses an environment variable called SQLPATH to
search the given directories for SQL scripts that the user calls to execute
using a method similar to the \i meta-command in psql. This allo
On Fri, 20 May 2011 11:37:36 -0500,
Jack Christensen wrote:
[...]
> In a similar project I worked on start time for a loan was always the
> current time so overlaps weren't an issue. I don't have any firsthand
> experience with them, but it sounds like what you want are exclusion
> constraints.
On Fri, 2011-05-20 at 11:02 +0200, Emanuel Calvo wrote:
> I had the following error during compile of sepgsqk contrib:
Apparently we need to specify the minimum SELinux version that we can
compile sepgsql against. It builds fine on my Fedora 14 box, where I
have libselinux 2.0.96.
Regards,
--
De
On Fri, 20 May 2011 12:08:34 -0400,
Andrew Sullivan wrote:
[...]
> It could be that your analogy there is a little too simple (library
> management systems' circulation modules are often incredibly
> complicated, because of the different classes of restriction on
> circulation). Nevertheless, t
On 5/20/2011 10:15 AM, Seb wrote:
On Fri, 20 May 2011 09:48:45 -0500,
Jack Christensen wrote:
Use a loans table with unique partial index to ensure that only one
unreturned loan per item can exist at a time.
[...]
Thanks, this certainly avoids loaning an item before it's returned, but
it does
On Fri, May 20, 2011 at 08:41:06AM -0500, Seb wrote:
> Hi,
>
> I'm trying to implementing the checking in and checking out of items in
> a table, whereby an item cannot be checked out if it's not checked-in.
> I've searched for schemas for public libraries where this is a key
> requirement, but ha
On Fri, 20 May 2011 09:48:45 -0500,
Jack Christensen wrote:
> On 5/20/2011 8:41 AM, Seb wrote:
>> Hi,
>> I'm trying to implementing the checking in and checking out of items
>> in a table, whereby an item cannot be checked out if it's not
>> checked-in. I've searched for schemas for public libr
On 5/20/2011 8:41 AM, Seb wrote:
Hi,
I'm trying to implementing the checking in and checking out of items in
a table, whereby an item cannot be checked out if it's not checked-in.
I've searched for schemas for public libraries where this is a key
requirement, but haven't managed to hit the right
- Original Message -
From: Geoffrey Becker
I'm relatively new to postgres. I've got a Visual Basic (VB)
application that i would like to connect to a Postgres database using
ODBC . Both the VB application and postgres are on my laptop and both
work beautifully independent of each ot
- Forwarded Message -
From: salah jubeh
To: Tom Lane
Cc: pgsql
Sent: Friday, May 20, 2011 3:54 PM
Subject: Re: [GENERAL] Views permessions
I have found the table where views are roles- permissions are stored and I
checked it automatically and still permissions are identical i.e. t
I have found the table where views are roles- permissions are stored and I
checked it automatically and still permissions are identical i.e. the
following query returns 0 rows
SELECT grantor, grantee, table_catalog, table_schema, is_grantable,
with_hierarchy
FROM information_schema.role_table
salah jubeh writes:
> There is a problem confusing me. I have two views 'VIEW1' and 'VIEW2'
> 1. VIEW2 depends on VIEW1
> 2. VIEW2 and VIEW1 have the exact permissions
> 3. I can execute SELECT * from VIEW1 ; without problem
> 4. When I execute SELECT * from VIEW2; I get
> ERROR: permissio
Hi,
I'm trying to implementing the checking in and checking out of items in
a table, whereby an item cannot be checked out if it's not checked-in.
I've searched for schemas for public libraries where this is a key
requirement, but haven't managed to hit the right keywords to get
relevant results.
Eric,
The posts in this forum must be done in english.
Entiendo que los posts a este foro deben ser en inglés.
May be you already did some of the next:
- Test if it works connecting with same credentials from the server itself and
other machine.
- Raise log/debug level on server and examine the
Hello Guys,
There is a problem confusing me. I have two views 'VIEW1' and 'VIEW2'
1. VIEW2 depends on VIEW1
2. VIEW2 and VIEW1 have the exact permissions
3. I can execute SELECT * from VIEW1 ; without problem
4. When I execute SELECT * from VIEW2; I get
ERROR: permission denied for rel
Saludos al foro.
Este error que describe el asunto del post, lo he buscado y no he encontrado
una solucion.
Describo el ambiente de mi servidor BD.
PostgreSql 8.3
Windows 2003 Server
Tengo una base de datos a la que se conectan varios vendedores y sincronizan
los datos de ventas.
Desde hace v
Emanuel Calvo wrote:
2011/5/19 Adarsh Sharma :
Dear all,
I am not able to insert data into a table in horizontal form.
The data is in below form :
A show a small set of data :-
c_id f_name f_value
2 k1 v1
2
2011/5/19 Adarsh Sharma :
> Dear all,
>
> I am not able to insert data into a table in horizontal form.
>
> The data is in below form :
>
> A show a small set of data :-
>
> c_id f_name f_value
> 2 k1 v1
> 2 k2
Hi Adarsh
You say you need this to be done dynamically.
I assume that by this you're looking for a way to have 1 query produce
an increasing number of columns as you increase the number of rows in
your table.
This really isn't possible and doesn't fit with the model SQL was designed for.
The conc
I had the following error during compile of sepgsqk contrib:
root@postgresql:~/postgresql-9.1beta1/contrib/sepgsql# make
sed 's,MODULE_PATHNAME,$libdir/sepgsql,g' sepgsql.sql.in >sepgsql.sql
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wformat-se
Mahmoud wrote:
> I am trying to create a database by passing arguments to createdb.exe
> but createdb always asks me about the password although I passed -W 123
> to it.
>
> How can I override password request?
>
> PS
> This my test for creating the database
> createdb.exe -U postgres -W 123 -O ad
Eric McKeeth wrote:
>>> I wander what is taking up my space on disk ...
>>>
>>> btv=# SELECT pg_size_pretty(pg_database_size('btv_good'));
>>> pg_size_pretty
>>>
>>> 10 GB
>>> (1 row)
[SELECT total size of all non-system tables]
>>> The sum of biggest tables is not even close t
Please reply to the list, not directly to me.
My reply follows.
On 20/05/11 14:47, Adarsh Sharma wrote:
> But Sometimes when I got stucked , I have no other option. Like I
> stucked from the past 4 days to solve the attached problem.
Sure. Sometimes you get stuck, and that's what mailing lists
29 matches
Mail list logo
