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,
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
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
Greg Stark schrieb:
On Tue, Jul 28, 2009 at 1:41 PM, Andreas
Wenka.w...@netzmeister-st-pauli.de 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
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
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
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 video 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
Bill Moran schrieb:
Scott Marlowe scott.marl...@gmail.com wrote:
On Fri, Jul 24, 2009 at 5:02 PM, Brian A.
Sekleckilaval...@spiritual-machines.org 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
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
Greg Stark schrieb:
On Sat, Jul 25, 2009 at 2:53 PM, Andreas
Wenka.w...@netzmeister-st-pauli.de 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
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
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
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
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
msgstr
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
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+
: 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
a.w...@netzmeister-st-pauli.de mailto:a.w...@netzmeister-st-pauli.de
wrote:
Robert James wrote:
Thank you, Tom. I guess I'm a bit confused about things
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 think the + option
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
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
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
Arndt Lehmann schrieb:
On Jul 16, 8:05 am, t...@sss.pgh.pa.us (Tom Lane) wrote:
CG cgg...@yahoo.com 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
Pavel Stehule schrieb:
2009/7/16 dipesh mistry (Imap) dipesh.mis...@mobilefundas.com:
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,
Pavel Stehule schrieb:
2009/7/16 Andreas Wenk a.w...@netzmeister-st-pauli.de:
Pavel Stehule schrieb:
2009/7/16 dipesh mistry (Imap) dipesh.mis...@mobilefundas.com:
Hello,
In my function i had defined addnewuser(integer,character,..), and i
call this function by Java code.
I had created
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,
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
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
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 source
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
Ms swati chande schrieb:
--- On *Wed, 7/8/09, Andreas Wenk /a.w...@netzmeister-st-pauli.de/* wrote:
From: Andreas Wenk a.w...@netzmeister-st-pauli.de
Subject: Re: [GENERAL] Password?
To: Ms swati chande swat...@yahoo.com, PG-General Mailing List
pgsql-general@postgresql.org
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 my
Jasen Betts schrieb:
On 2009-07-08, Andreas Wenk a.w...@netzmeister-st-pauli.de 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
Steve Atkins schrieb:
On Jul 8, 2009, at 6:19 AM, Andreas Wenk wrote:
Jasen Betts schrieb:
On 2009-07-08, Andreas Wenk a.w...@netzmeister-st-pauli.de wrote:
Serge Fonville schrieb:
*argh* - more detailed to avoid confusion. The auth method
'password' in
pg_hba.conf means, that you
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\bininitdb -D
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
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
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 Designer
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
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
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
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:
- 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
and sorry for annoying if I am too blind ...
Cheers
Andy
--
Netzmeister St.Pauli
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
Tom Lane wrote:
Andreas Wenk a.w...@netzmeister-st-pauli.de writes:
EXECUTE 'INSERT INTO produkte
(art_nr,bezeichnung,beschreibung,preis,steuersatz,aktionspreis,stichworte,vector)
VALUES
('''||art_nr||''','''||bezeichnung||''','''||beschreibung||''','||preis
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 make
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
Ivan Sergio Borgonovo schrieb:
On Tue, 10 Mar 2009 14:31:56 +0100
Andreas Wenk a.w...@netzmeister-st-pauli.de 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
Tom Lane schrieb:
Ivan Sergio Borgonovo m...@webthatworks.it 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
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 bye.
--
Sent via pgsql-general mailing list (pgsql
;
Or, 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
;
Cheers
Andy
2009/2/25 Andreas Wenk a.w...@netzmeister-st-pauli.de:
Hi,
short question. Why is this not possible:
CREATE OR REPLACE FUNCTION user_cursor_open(text) RETURNS refcursor AS $$
DECLARE
curs1 CURSOR FOR SELECT * FROM $1;
BEGIN
OPEN curs1;
RETURN curs1;
END
-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_timeout
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Phoenix Kiula schrieb:
On Tue, Feb 3, 2009 at 9:09 PM, Andreas Wenk
a.w...@netzmeister-st-pauli.de wrote:
-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
Jasen Betts schrieb:
On 2009-01-31, Andreas Wenk a.w...@netzmeister-st-pauli.de 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
Richard Broersma schrieb:
On Sat, Jan 31, 2009 at 3:16 PM, Andreas Wenk
a.w...@netzmeister-st-pauli.de 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
Scott Marlowe schrieb:
On Sat, Jan 31, 2009 at 9:04 PM, Richard Broersma
richard.broer...@gmail.com wrote:
On Sat, Jan 31, 2009 at 3:16 PM, Andreas Wenk
a.w...@netzmeister-st-pauli.de wrote:
Why does this not work:
postgres=# ALTER TABLE tab1 ALTER COLUMN nr TYPE serial;
ERROR: type
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-general@postgresql.org)
To make changes
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
iD8DBQFJfum6Va7znmSP9AwRAlN4AJ9odanCrD3R+gMzb7yzJjXWEKfCUACeN1Tv
-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 opposed
';
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
iD8DBQFJdzk6Va7znmSP9AwRAk2nAJ9eeGtXGZbyMoPFZwukmg0T/4sWtgCg28iN
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
Dennis C schrieb
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
vqOqVcx0ns26Nf8esi4xp/A=
=zDAD
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 importing the dump. But as far as I
-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 shell script is the following:
1. all
-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 *.sql.
Until now there is no onboard
(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 - Hamburg - Germany
Andreas Wenk
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
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 Tom,
Tom Lane schrieb:
Andreas Wenk a.w...@netzmeister-st-pauli.de writes:
In pg_hba.conf we have:
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
# local is for Unix domain socket connections only
local all all ident sameuser
70 matches
Mail list logo
