[GENERAL] Upgrading to 9.0 on Mac OS X

er of times on different machines. Had to change the password via the passwd utility. Anyone else seen this? Maximilian Tyrtania Software-Entwicklung Dessauer Str. 6-7 10969 Berlin http://www.contactking.de -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Upgrading to 9.0 on Mac OS X

computer and (2) >> to create a special Unix user account named (by default) 'postgres'. Yes. What confused me is: The installer seems to change the passsword of an already existing postgres user on that machine to "". Did i understand that correctly? Should it r

[GENERAL] invalid byte sequence

er encoding is UTF8. No special client encoding is set. Any help would be appreciated, Max Maximilian Tyrtania Software-Entwicklung Dessauer Str. 6-7 10969 Berlin http://www.contactking.de -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] invalid byte sequence

Am 04.03.2011 um 11:01 schrieb Craig Ringer: > On 04/03/11 00:02, Maximilian Tyrtania wrote: >> After upgrading to pg 9.0.3 (from 8.4.2) on my Mac OS 10.6.2 machine i find >> this in my log file (a lot): >> >> STATEMENT: SELECT >> pg_file_read('pg_log/pos

[GENERAL] anonymous record as an in parameter

9.0.3 doesn't like that: ERROR: SQL functions cannot have arguments of type record. It also doesn't work with plpgsql. Is there a way? Best wishes from Berlin, Maximilian Tyrtania Maximilian Tyrtania Software-Entwicklung 10969 Berlin http://www.contactking.de -- Sent via pgsql-gener

[GENERAL] bytea question

for type bytea LINE 1: SELECT E'\\008'::bytea; As far as I can see i followed the escaping rules given in http://www.postgresql.org/docs/current/static/datatype-binary.html Thanks, Maximilian Tyrtania -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan

Re: [GENERAL] Collation in ORDER BY not lexicographical

reate an index like this: create index idx_personen_nachname_orderByFriendly on personen (f_getorderbyfriendlyversion(nachname)) Now you can do: select * from personen order by f_getorderbyfriendlyversion(p.nachname) Seems pretty fast. Best, Maximilian Tyrtania -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] can't compile twitter_fdw

le format not recognized collect2: ld gab 1 als Ende-Status zurück make: *** [twitter_fdw.so] Fehler 1 root@contactkingserver:/usr/local/pgsql/bin/twitter_fdw-1.1.1# Looks like some problem with libjson-0.8 but the directory is there. The readme says: The source of libjson is included this module pack

[GENERAL] Odd query result

166300 | t| Microsoft Deutschland GmbH (1 row) What might be up there? Maximilian Tyrtania http://www.contactking.de -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Odd query result

> On Mon, Aug 27, 2012 at 12:55 PM, Maximilian Tyrtania > wrote: >> What might be up there? > > It might be a broken index issue. Please show the EXPLAIN for these queries. It was. I had an index like this: CREATE INDEX idx_firmen_iskunde_index ON firmen USING btree (f_fir

Re: [GENERAL] Odd query result

> On Mon, Aug 27, 2012 at 12:55 PM, Maximilian Tyrtania > wrote: >> What might be up there? > > It might be a broken index issue. Please show the EXPLAIN for these queries. It was. I had an index like this: CREATE INDEX idx_firmen_iskunde_index ON firmen USING btree

Re: [GENERAL] Odd query result

Am 27.08.2012 um 16:18 schrieb Tom Lane : > Maximilian Tyrtania writes: > >> Sorry, should have mentioned that…Dropping and recreating it fixed it. > > Hm, had you changed the behavior of that function since creating the > index? To be honest - I don't know f

[GENERAL] return query execute SQL-problem

; ERROR: column "alias" does not exist LINE 1: select alias from f_aliastest(); Is there a way that I can make my function return the field aliases? Best wishes from Berlin, Maximilian Tyrtania http://www.contactking.de -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] return query execute SQL-problem

Am 16.10.2012 um 11:37 schrieb hubert depesz lubaczewski : > create or replace function f_aliastest(OUT alias TEXT) returns setof record > AS … Ah, yes, I forgot about the OUT parameters, thanks for the reminder! Maximilian Tyrtania Contact King Software Entwicklung Maximilian Tyrtani

Re: [GENERAL] return query execute SQL-problem

query in general. Maximilian Tyrtania http://www.contactking.de -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Dynamic SQL with pgsql, how to?

sql.org/pgdocs/postgres/plpgsql-statements.html Max Maximilian Tyrtania Software-Entwicklung Dessauer Str. 6-7 10969 Berlin Tel.:++49/30/48827-952 Mobil: 0152/292 707 36 email: maximilian.tyrta...@byte-employer.de -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make c

Re: [GENERAL] Collate order on Mac OS X, text with diacritics in UTF-8

t)); Select * from mytable order by f_getorderbyfriendlyversion(myfield); Not an ideal solution, but it seems to perform quite well. Best wishes from Berlin, Maximilian Tyrtania -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] compilation info without pg_config

Hi there, i'd like to figure out if my pg server (9.0.2) running on OpenSuse has been compiled with gssapi support. The PG OpenSuse package seems to not ship pg_config for some reason. Is there another way to determine that? Maximilian Tyrtania http://www.contactking.de -- Sent via

Re: [GENERAL] compilation info without pg_config

Am 26.03.2012 um 11:34 schrieb John R Pierce: > On 03/26/12 2:22 AM, Maximilian Tyrtania wrote: >> i'd like to figure out if my pg server (9.0.2) running on OpenSuse has been >> compiled with gssapi support. The PG OpenSuse package seems to not ship >> pg_config for so

Re: [GENERAL] compilation info without pg_config

Am 26.03.2012 um 15:09 schrieb Adrian Klaver: > On 03/26/2012 03:01 AM, Maximilian Tyrtania wrote: >> Am 26.03.2012 um 11:34 schrieb John R Pierce: >> >>> On 03/26/12 2:22 AM, Maximilian Tyrtania wrote: >>>> i'd like to figure out if my pg server (

[GENERAL] tcp_keepalives_idle setting

rameters from userspace, and if so, how i can change the systems settings as root. Maximilian Tyrtania | IT-Entwickler [EMAIL PROTECTED] fischerAppelt Kommunikation GmbH -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] tcp_keepalives_idle setting

;t >> allow adjustment of the TCP keepalive parameters from userspace, and if so, >> how i can change the systems settings as root. > > Do you use TCP/IP socket when you execute SHOW ALL? Those parameters > are ignored via Unix-domain socket. Yes, i am using a tcp/ip socket. Sorry