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
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
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
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
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
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
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
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
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
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
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.
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
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
- 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
- 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
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
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 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 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, 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 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 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.
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
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
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
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
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
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
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
29 matches
Mail list logo
