| [GENERAL] SQL Path in psql |
general
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 th....Read more
|
|
 |
| Data from this post |
| Posted on |
on Saturday, May 21, 2011 |
 |
| Approval: |
Post not yet rated!
|
|
| Your vote: |
|
|
| Views from on Saturday, May 21, 2011: |
33 |
|
| Views of the last 30 days: |
0 |
|
| Views Yesterday: |
0 |
|
|
|
|
| Related posts from the same author |
|
|
|
on Thursday, May 19, 2011
[GENERAL] Unexpected protocol character='j' during authentication..
general
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 vari...
39 views
|
|
on Friday, May 20, 2011
[GENERAL] implementing check-in/check-out of an items table
general
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....
35 views
|
|
on Friday, May 20, 2011
[GENERAL] Views permessions
general
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 relatio...
37 views
|
|
on Friday, May 20, 2011
[GENERAL] Error compiling sepgsql in PG9.1
general
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-s...
37 views
|
|
on Saturday, May 21, 2011
[GENERAL] length of return value of to_char()
general
Hi, I thought this should be equal to 4: # SELECT length(to_char(11, '0999')); length but the string returned by the to_char() call is 0011 (length 4). What am I missing? Thanks,
38 views
|
|
|
|
|
Blog
