rr04 wrote:
I am an MIT student doing a project on schema-less database usage and would
greatly appreciate if you guys can fill out a quick survey on this (should
take < 5 mins)
http://bit.ly/nosqldb
Hi,
even when I think that most of the people on this list will answer the
same way to your
David Fetter schrieb:
Just a quick question. Wouldn't it be better to provide the videos in flv
format in a player in this page. Since I have a MAC, I have no problems
viewing the videos. But with my Linux box and FF 3.5 I can't.
You can use xine on your Linux box :)
Cheers,
David.
David, t
Christophe Pettus schrieb:
On Jul 28, 2009, at 8:35 AM, Andreas Wenk wrote:
uh - HTML 5 is supported by the browser when?
Currently, the tag is supported by Firefox 3.5, Safari 3 and 4,
Chrome 3 (in alpha, I believe), iPhone 3.
That being said, we can do a fallback to Quicktime, then to
Christophe Pettus schrieb:
Historically, MOV has been the least-bad container format; Flash support
on anything besides Windows has, traditionally, been very spotty. The
files themselves are pretty much the same size; FLV is (as noted) a
container format, not a codec, and the video is H.264
Jennifer Trey schrieb:
I am in the process of switching to Ubuntu, and I have a couple of
question to get started. I installed pgadmin and postgre through the
Synaptic Package Manager. I am unfamiliar with the console so I prefer
to use pgAdmin to set things up.
congratulations for switching
Greg Stark schrieb:
On Tue, Jul 28, 2009 at 1:41 PM, Andreas
Wenk wrote:
Why not use a standardized openly documented container format like
mpeg4 with mpeg4 part 2 compression instead of one controlled by a
single company like flv or quicktime? That would let people play it
using any of various
Bill Moran schrieb:
> While I've no objection to someone helping out by converting files, I
find it odd that flv is suggested. I've yet to find anything that can
play flv files on my FreeBSD desktop machine. I'm pretty sure mplayer
can play mov files ... I guess I'll find out this evening when
Christophe Pettus schrieb:
Greetings,
The video recordings of the sessions for PG Day SJC '09 are now available:
[snip]
Many thanks to Steve Crawford for the audio system and assistance with
setup, tear-down, and coordination during the event.
--
-- Christophe Pettus
x...@thebuild.com
H
Greg Stark schrieb:
On Sat, Jul 25, 2009 at 2:53 PM, Andreas
Wenk wrote:
I mean, didn't Apple just kill someone for letting their new iPhone
design leak?
this is now going off topic - but what do you mean with your last sentence?
Please don't quote an entire message if y
Jan-Erik schrieb:
On 24 Juli, 23:22, a.w...@netzmeister-st-pauli.de (Andreas Wenk)
wrote:
Hi,
I was thinking about that and in my opinion the approach to let the
database do that is the wrong direction. Sure you can do a lot with
regexp_split_to_table or regexp_split_to_array but they are kind
Bill Moran schrieb:
Scott Marlowe wrote:
On Fri, Jul 24, 2009 at 5:02 PM, Brian A.
Seklecki wrote:
All:
Any suggestions on how-to, or comments on a potential NFR, to disable
non-superuser's from viewing the database list via \l?
So, is this a misguided attempt at security through obscurity
Jan-Erik wrote:
I wonder if you could please help me out to extract a character string
to an array or better yet, a table.
I'd like to split strings of text up into words and delimiters (but
not delete the delimiters). The delimiters are defined as comma,
space, dot, singe/double quotation mark,
Stefano Nichele schrieb:
Hi All,
I have some questions for you about the best way to handle permission on
a database in a production system.
The final goal is to have a web application connected to the db using a
single user that must run select/delete/insert/update (and maybe truncate)
In m
Pavel Stehule schrieb:
Hello
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
regards
Pavel Stehule
Pavel, this trick-list is awesome ;-) Thanks for the tip!
Cheers
Andy
P.S.: a link to that would be nice ;-)
--
Sent via pgsql-
Andreas Wenk wrote:
Robert James wrote:
Thanks - I don't show any locale:
rbt_development=> \l
List of databases
Name | Owner | Encoding
+-+--
rbt_development | rbt | UTF8
...
ahm - you are running pg 8.2. There I t
LC_CTYPE: de_DE.UTF-8
I hope this helps a little ...
Cheers
Andy
P.S.: top posting is ugly ;-)
On Wed, Jul 22, 2009 at 6:45 PM, Andreas Wenk
mailto:a.w...@netzmeister-st-pauli.de>>
wrote:
Robert James wrote:
Thank you, Tom. I guess I'm a bit confused about things here.
Robert James wrote:
Thank you, Tom. I guess I'm a bit confused about things here. How can
I find the locale of my database? (I wasn't able to find this in the docs).
If I do have the locale set to 'C', do I loose anything by using utf8
for all text fields?
use psql:
postgres=# \l+
Alvaro Herrera wrote:
Tom Lane wrote:
We've never before expected patch submitters to patch the .po files,
and in fact I would have thought it would be useless to do so. The
masters are not in our CVS. Why is Andreas being told to worry about
this?
I must admit I don't know :-)
hm - I don'
Alvaro Herrera wrote:
Andreas Wenk wrote:
here is the patch for help.c . I think updating some translations is not
neccessary because there is no change. Am I right?
Not really. For example the spanish translation file has this:
msgid " \\du [PATTERN] list roles (users)\n&qu
Hello,
I recently upgraded to version 8.4 and now full text search with russian
configuration is not working:
template1=# create database test encoding='win1251';
test=# create table test ("test" varchar(255));
test=# insert into test values ('ัะตัั');
test=# select * from test where to_ts
Peter Eisentraut schrieb:
On Thursday 16 July 2009 02:12:05 ANdreas Wenk wrote:
Hi,
I recognized in psql using the internal help (\?) that the *+* sign is
missing for the shortcut \du:
# \du
List of roles
Role name | Attributes | Member of
Pavel Stehule schrieb:
2009/7/16 Andreas Wenk :
Pavel Stehule schrieb:
2009/7/16 dipesh mistry (Imap) :
Hello,
In my function i had defined addnewuser(integer,character,..), and i
call this function by Java code.
I had created function with integer datatype but database always gives me
Pavel Stehule schrieb:
2009/7/16 dipesh mistry (Imap) :
Hello,
In my function i had defined addnewuser(integer,character,..), and i
call this function by Java code.
I had created function with integer datatype but database always gives me
error,
org.postgresql.util.PSQLException: ERROR: fu
Arndt Lehmann schrieb:
On Jul 16, 8:05 am, t...@sss.pgh.pa.us (Tom Lane) wrote:
CG writes:
While transitioning from 8.1 to 8.4, I need to transition to the internal UUID
type in place of the contrib/uniqueidentifier module. I've built the database
around uniqueidentifier, so nearly every tab
Peter Eisentraut schrieb:
On Thursday 16 July 2009 02:12:05 ANdreas Wenk wrote:
Hi,
I recognized in psql using the internal help (\?) that the *+* sign is
missing for the shortcut \du:
# \du
List of roles
Role name | Attributes | Member of
Hi,
I recognized in psql using the internal help (\?) that the *+* sign is
missing for the shortcut \du:
# \du
List of roles
Role name | Attributes | Member of
--+--+---
# \du+
List of roles
Role name | Attributes
dipesh mistry (Imap) wrote:
Hello,
I have create my own function name "*addnewuser(integer,varchar.)*",
and when I call this function it gives me below error,
org.postgresql.util.PSQLException: ERROR: function addnewuser(bigint,
character varying, character varying, character varying, char
Ms swati chande schrieb:
Hi,
I started everything again from scratch.
1. Created a new user("Swati"), with limited/ restricted rights.
Ensured that no password is set anywhere.
2. Ran initdb from the new user.
c:\postgresql\bin>initdb -D c:\po
Steve Atkins schrieb:
On Jul 8, 2009, at 6:19 AM, Andreas Wenk wrote:
Jasen Betts schrieb:
On 2009-07-08, Andreas Wenk wrote:
Serge Fonville schrieb:
*argh* - more detailed to avoid confusion. The auth method
'password' in
pg_hba.conf means, that you will be asked for a passwo
Jasen Betts schrieb:
On 2009-07-08, Andreas Wenk wrote:
Serge Fonville schrieb:
*argh* - more detailed to avoid confusion. The auth method 'password' in
pg_hba.conf means, that you will be asked for a password for the user you
try to create a db with. If no user is given (with c
Ms swati chande schrieb:
Thanks Andy,
I am working on Windows XP. Have built from source using Visual Studio 2005.
I have made a change in pg_hba.conf to include the ipconfig of my system.
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
*hostall all
Ms swati chande schrieb:
--- On *Wed, 7/8/09, Andreas Wenk //* wrote:
From: Andreas Wenk
Subject: Re: [GENERAL] Password?
To: "Ms swati chande" , "PG-General Mailing List"
Date: Wednesday, July 8, 2009, 3:47 PM
Ms swati chande schrieb:
>
Serge Fonville schrieb:
*argh* - more detailed to avoid confusion. The auth method 'password' in
pg_hba.conf means, that you will be asked for a password for the user you
try to create a db with. If no user is given (with createdb -U [username]),
this user is postgres ...
Wasn't it that it uses
Andreas Wenk schrieb:
Ms swati chande schrieb:
Hi
When I write the following commands at the prompt,
>createuser -S -d -R user1
> createdb sample
I am asked to enter a password. I have not set any password anywhere.
Which password is it asking for?
Please help.
I have built from
Ms swati chande schrieb:
Hi
When I write the following commands at the prompt,
>createuser -S -d -R user1
> createdb sample
I am asked to enter a password. I have not set any password anywhere.
Which password is it asking for?
Please help.
I have built from source on Windows XP.
Thanks
Thomas Kellerer schrieb:
Andreas Wenk wrote on 07.07.2009 09:33:
originally posted at BUGS list - now answering at GENERAL list
Pavel Golub schrieb:
Hello, Oscar.
First of all you shouldn't post such messages here since this is not a
bug for sure.
Take a look on MicroOLAP Database Des
USTID: DE 238093396
Pavel Golub schrieb:
Hello, Andreas.
You wrote:
AW> originally posted at BUGS list - now answering at GENERAL list
AW> Pavel Golub schrieb:
Hello, Oscar.
First of all you shouldn't post such messages here since this is not a
bug for sure.
Take a look on MicroOLAP Databa
originally posted at BUGS list - now answering at GENERAL list
Pavel Golub schrieb:
Hello, Oscar.
First of all you shouldn't post such messages here since this is not a
bug for sure.
Take a look on MicroOLAP Database Designer for PostgreSQL at
http://microolap.com/products/database/postgresql-
Stuart McGraw schrieb:
> First, thanks to everyone who contributed
> to 8.4 -- the new features list looks great!
>
> In the past I have always installed the
> Windows binary installer from postgresql.org.
> For pg-8.4 I see that the download directory
> now has a pointer to the EnterpriseDB "one
James B. Byrne wrote:
Hi,
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 4; 2615 2200 SCHEMA
public postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
drop
schema public because other objects depend on it
HINT:
Joost Kraaijeveld wrote:
Hi,
Hi,
Is it possible to get an overview/the contents of the stopwords list,
dictionary, synonyms or thesaurus using an SQL query, e.g. "SELECT *
from stopwords"?
if I understand correctly, you want to see the content of the
dictionarys. No - you can't see the ent
John Cheng schrieb:
---
For some reason, I am seeing a big difference in our real database. I
don't want to just rewrite all of our queries yet. I'm guessing the
data makes a big difference. What would be a good way to examine the
data to figure out what's the best way to write our queri
Pauli - Hamburg - Germany
Andreas Wenk
http://www.netzmeister-st-pauli.de
http://blog.netzmeister-st-pauli.de
mailto:a.w...@netzmeister-st-pauli.de
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Tom Lane wrote:
Andreas Wenk writes:
EXECUTE 'INSERT INTO produkte
(art_nr,bezeichnung,beschreibung,preis,steuersatz,aktionspreis,stichworte,vector)
VALUES
('''||art_nr||''','''||bezeichnung||''','
x27;,'adfvb','adfvb',15.5,
25.50,2,'alpha,beta,cesar','beta':2A 'adfvb':4B 'alpha':1A
'cesar':3A)
CONTEXT: PL/pgSQL function "user_insert_vector_data" line 14 at EXECUTE
statement
vector i
eady mentioned, you should use group roles and then grant
the privileges for the schema to the group role if you have more
different users ...
Cheers
Andy
--
St.Pauli - Hamburg - Germany
Andreas Wenk
Jack
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
Tom Lane schrieb:
Ivan Sergio Borgonovo writes:
I get a
Query failed: ERROR: permission denied for schema user_test CONTEXT:
SQL statement "UPDATE ONLY "user_test"."shop_commerce_baskets" SET
"sid" = NULL WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=)
"sid"::pg_catalog.text
This query is
Ivan Sergio Borgonovo schrieb:
On Tue, 10 Mar 2009 14:31:56 +0100
Andreas Wenk wrote:
which rights does the actual user have for the schema user_test?
> Query failed: ERROR: permission denied for schema user_test
> CONTEXT:
I think the user does not have the rights for the schema .
test CONTEXT:
I think the user does not have the rights for the schema ...
Cheers
Andy
--
St.Pauli - Hamburg - Germany
Andreas Wenk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ident sameuser
I inserted the "" to allow to everyone to access to the db.
But if I try to access, from another host, I receive an error. What is
the error in that line?
just leave it blank ... no "" signs ...
Cheers
Andy
--
Andreas Wenk
Hamburg - Germany
Thanks, bye by
' || $2;
RETURN $1;
END; $$ LANGUAGE plpgsql;
Cheers
Andy
> 2009/2/25 Andreas Wenk :
> Hi,
>
> short question. Why is this not possible:
>
> CREATE OR REPLACE FUNCTION user_cursor_open(text) RETURNS refcursor AS $$
> DECLARE
>curs1 CURSOR FOR SE
, how do I set a parameter when using cursor?
Thanks in advance
- --
St.Pauli - Hamburg - Germany
Andreas Wenk
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJpWlyVa7znmSP9AwRAv2MAJ9jHICtLeIEv
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Phoenix Kiula schrieb:
> On Tue, Feb 3, 2009 at 9:09 PM, Andreas Wenk
> wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Phoenix Kiula schrieb:
>>> In my conf_pg, the autovacuum is on, so t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Phoenix Kiula schrieb:
> In my conf_pg, the autovacuum is on, so the DB should be (or I hope is
> being) regularly vacuumed.
>
> These are my settings:
>
>
> work_mem = 20MB
> temp_buffers = 4096
> authentication_
Scott Marlowe schrieb:
On Sat, Jan 31, 2009 at 9:04 PM, Richard Broersma
wrote:
On Sat, Jan 31, 2009 at 3:16 PM, Andreas Wenk
wrote:
Why does this not work:
postgres=# ALTER TABLE tab1 ALTER COLUMN nr TYPE serial;
ERROR: type "serial" does not exist
serial is really just &
Richard Broersma schrieb:
On Sat, Jan 31, 2009 at 3:16 PM, Andreas Wenk
wrote:
Why does this not work:
postgres=# ALTER TABLE tab1 ALTER COLUMN nr TYPE serial;
ERROR: type "serial" does not exist
serial is really just "short-hand" for making an integer column use
Jasen Betts schrieb:
On 2009-01-31, Andreas Wenk wrote:
Hi List,
I have a short question to psql.
Why does this not work:
postgres=# ALTER TABLE tab1 ALTER COLUMN nr TYPE serial;
ERROR: type "serial" does not exist
but this:
postgres=# ALTER TABLE tab1 DROP COLUMN nr;
A
CE: ALTER TABLE will create implicit sequence "tab1_nr_seq" for
serial column "tab1.nr"
ALTER TABLE
Sitting in front of a MAC OS X Leo with pg 8.2
Thanks a lot!
Cheers
Andy
--
St.Pauli - Hamburg - Germany
Andreas Wenk
--
Sent via pgsql-general mailing list (pgsql-g
8.3. The behaviour for implementing in earlier versions is
therefore
different ...
Cheers
Andy
- --
St.Pauli - Hamburg - Germany
Andreas Wenk
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJfum6Va7znm
'autovacuum';
Cheers
Andy
- -- Andreas Wenk St.Pauli - Hamburg - Germany
> Regards,
> Avdul Rehman.
>
>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJdzk6Va7znmSP9AwRAk2nAJ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dennis C schrieb:
> OK that was it! Wow, thank you so very much! Nice to know it was just
> plpython tracking such an obsolete version of postgresql much to my
> dismay now (especially even going backwards, which didn't even occur to
> me), as oppose
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Adrian Klaver schrieb:
> On Tuesday 20 January 2009 7:05:23 am Andreas Wenk wrote:
>
>> Adrian,
>>
>> no lack of coffee but my fault. You are totally right - that was a copy and
>> paste error. For sure the dump is *.sq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Adrian Klaver schrieb:
> On Tuesday 20 January 2009 2:15:08 am Andreas Wenk wrote:
>> Hi everybody,
>>
>> I have an automated mechanism to restore a demo database each night with an
>> SQL dump. What I do inbetween a sh
asap ;-)
- --
St.Pauli - Hamburg - Germany
Andreas Wenk
hubert depesz lubaczewski schrieb:
> On Tue, Jan 20, 2009 at 11:15:08AM +0100, Andreas Wenk wrote:
>> Where can I prevent bulding the language again? My idea was to do that while
>> creating the
>> dump or while impor
garfield > sys_language.tar
Thanks for any advice
Andy
- --
Andreas Wenk
St.Pauli - Hamburg - Germany
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJdaQsVa7znmSP9AwRAlE0AKCVTqsD9X8nMtGHcTsfzHVElK5ePQCeMC3c
res version you
want to
restore to? I am not sure, but maybe there are occuring some problems ...
$ less test.toc | grep "^;"
[...]
; Dumped from database version: 8.3.5
; Dumped by pg_dump version: 8.3.5
[...]
Cheers
Andy
- --
St.Pauli - Hamburg - Germany
Andreas Wenk
Den
Hi Tom,
Tom Lane schrieb:
Andreas Wenk writes:
In pg_hba.conf we have:
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connect
Alvaro Herrera schrieb:
Andreas Wenk wrote:
Yes thats correct with the IP address range. Maybe I did not understand
the auth concept yet. I thought, that with METHOD set to md5, a md5
hashed password is required. The password is submitted with the PHP 5
pg_connect function - as plain
Hi Joshua
Joshua D. Drake schrieb:
On Thu, 2009-01-15 at 18:05 +0100, Andreas Wenk wrote:
postgres=# SELECT rolname,rolpassword from pg_authid;
rolname | rolpassword
- ---+-
postgres |
pgadmin | plaintext
odie
result in
pg_authid (if this makes sense or not is another question ;-) ).
Now the question: why is the user pgadmin able to connect to the database using
pgAdmin
III from 192.168.97.30? That sould not be possible ... or am I wrong?
Thanks for any advice
Cheers
Andy
- --
St.Pauli - Hambur
70 matches
Mail list logo
