On Fri, Jan 13, 2012 at 5:27 PM, Craig Ringer wrote:
> Oooh, that's clever. Nice!
>
> People say function overloading is no good
They do??
I wrote a similar set of functions to simplify a particular piece of
UI code. Three functions called 'str2int'; one takes varchar and
returns int, one t
seems similar to this problem:
http://stackoverflow.com/questions/5198380/improving-postgres-psycopg2-query-performance-for-python-to-the-same-level-of-ja
but no solution yet.
On Thu, Jan 12, 2012 at 5:00 PM, Yan Chunlu wrote:
> I also tried explain but found nothing special:
>
> explain select
On 12/01/2012 05:16, debian nick wrote:
> I have postgresql 8.4.9 installed now, my problem is that from time to
> time my postgresql let psql version 8.4.9 access the database without
> asking for password (psql -d mydatabase -h myhost -U myuser), and the
> connection attempts from psql 8.3 are no
Hello!
I'm using PostgreSQL 8.4.9 on CentOS 6.2 and with bash.
The following cronjob works well for me
(trying to send a mail to myself - for moderation):
6 6 * * * psql -c "select
'http://mysite/user.php?id=' ||id, about from pref_rep where
length(about) > 1 and la
> Date: Fri, 13 Jan 2012 14:44:24 +0800
> From: ring...@ringerc.id.au
> To: listas_quij...@hotmail.com; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Compiling C function with VC++ for Windows version
>
> On 13/01/2012 1:55 AM, Edwin Quijada wrote:
> >
> > Ok.
> > This is the way that
On 01/13/2012 05:11 AM, Alexander Farber wrote:
Hello!
I'm using PostgreSQL 8.4.9 on CentOS 6.2 and with bash.
The following cronjob works well for me
(trying to send a mail to myself - for moderation):
6 6 * * * psql -c "select
'http://mysite/user.php?id=' ||id,
... || id || E'\n' ...
To enable the backslash escape you prefix the literal with the letter E
David J.
On Jan 13, 2012, at 7:11, Alexander Farber wrote:
> Hello!
>
> I'm using PostgreSQL 8.4.9 on CentOS 6.2 and with bash.
>
> The following cronjob works well for me
> (trying to send a mail
Hi everybody,
I'm located in Hong Kong, UTC+8 time zone. When I
select current_timestamp;
gives
now
---
2012-01-13 23:56:16.825558+08
However, when I
select current_timestamp at time zone 'UTC+8';
I expect the result is the same as the above one. But
I have no problem loading a table using bulkloader. Eg.
OUTPUT = schema.tablename#
[.]table_name
INPUT = /filelocation/table.csv # Input data
location (absolute path)
TYPE = CSV
Hi,
OS: SUSE LINUX
I am writing a logfile (batch process) with the ORAFCE utilities of
UTL_FILE.
I recently observed that the logfile is not refreshed after every new entry
written. It appears to me that the every 4096 bytes of data are written at
the same time.
Can anyone explain me this please
> Since you were running with fsync off, you must have had good backups or
> replication configured, because the documentation warns you that running
> with fsync=off will probably destroy your data and is only for expert users.
Yes, i know, i have a replica and slow disk.
> In case you don't hav
Cefull Lo writes:
> I'm located in Hong Kong, UTC+8 time zone. When I
> select current_timestamp;
> 2012-01-13 23:56:16.825558+08
> However, when I
> select current_timestamp at time zone 'UTC+8';
> I expect the result is the same as the above one.
Sorry, but it isn't. A time zone name spelled
On 01/12/2012 01:21 PM, Tom Lane wrote:
Matt Dew writes:
On 01/11/2012 04:29 PM, Tom Lane wrote:
What exactly is your definition of a "clean shutdown"?
Is a reboot command considered a clean shutdown? It's a redhat box
which called /etc/init.d/postgresql stop, which does: pg_ctl stop -D
'$P
On 01/13/2012 08:18 AM, Tom Lane wrote:
Cefull Lo writes:
I'm located in Hong Kong, UTC+8 time zone. When I
select current_timestamp;
2012-01-13 23:56:16.825558+08
However, when I
select current_timestamp at time zone 'UTC+8';
I expect the result is the same as the above one.
Sorry, but it i
What I really intend to do is slightly more complicate than the original code.
I need to iterate RECORD variable in PL/pgSQL. By combining both ideas from
Pavel and Merlin, I get the following working function.
CREATE FUNCTION test() RETURNS VOID AS $$
DECLARE
rec RECORD;
BEGIN
C
Hello
2012/1/13 bj77 :
> Hi,
>
> OS: SUSE LINUX
>
> I am writing a logfile (batch process) with the ORAFCE utilities of
> UTL_FILE.
> I recently observed that the logfile is not refreshed after every new entry
> written. It appears to me that the every 4096 bytes of data are written at
> the same
Looking for some quidance or suggestions.
PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.5
20110214 (Red Hat 4.4.5-6), 64-bit
$ uname -a
Linux db1.hw.ateb.com 2.6.32-131.21.1.el6.x86_64 #1 SMP Tue Nov 22 19:48:09 GMT
2011 x86_64 x86_64 x86_64 GNU/Linux
datid| d
Thanks raymond, you were right, i never think that psql was using .pgpass
file. When a delete it psql ask me for the password.
THANKS I’ll never figure that out.
2012/1/13 Raymond O'Donnell
> On 12/01/2012 05:16, debian nick wrote:
> > I have postgresql 8.4.9 installed now, my problem is that fr
On 01/13/2012 09:10 AM, debian nick wrote:
Thanks raymond, you were right, i never think that psql was using
.pgpass file. When a delete it psql ask me for the password.
THANKS I’ll never figure that out.
You still should check your pg_hba.conf file for trust and ident
connection rules. .pgpas
On 01/12/2012 01:21 PM, Tom Lane wrote:
Matt Dew writes:
On 01/11/2012 04:29 PM, Tom Lane wrote:
What exactly is your definition of a "clean shutdown"?
Is a reboot command considered a clean shutdown? It's a redhat box
which called /etc/init.d/postgresql stop, which does: pg_ctl stop -D
'$P
Matt Dew writes:
> An interesting sidenote we realized. the nice system shutdown script
> /etc/init.d/postgres doesn't actually wait for the db to be down, it
> just waits for pg_ctl to return.
By default, "pg_ctl stop" does wait for the server to shut down ...
regards
Hi all,
the schedule for the PostgreSQL devroom at FOSDEM 2012 is now available:
http://www.fosdem.org/2012/schedule/track/postgresql_devroom
We will have 8 talks on Saturday, February 4th.
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European Postgr
On 13.1.2012 22:20, Tom Lane wrote:
> Matt Dew writes:
>> An interesting sidenote we realized. the nice system shutdown script
>> /etc/init.d/postgres doesn't actually wait for the db to be down, it
>> just waits for pg_ctl to return.
>
> By default, "pg_ctl stop" does wait for the server to s
23 matches
Mail list logo
