Joel Richard <[EMAIL PROTECTED]> writes:
> ... we occasionally get the following message in our apache log
> file. I'm looking for information on what it means:
>DBD::Pg::db selectrow_array failed: FATAL: Socket command type I
> unknown
This looks to me like a protocol-level incompatibil
Good evening,
I hope that I am posting this to the right place. If not, please
direct me to the appropriate mailing list and I will send to that one
instead.
Background Info:
Debian Linux (Sarge)
Server A -- Apache 2.0.54 + mod_perl + DBD::Pg
Server B -- PostgreSQL 7.3.4, Compiled,
I've been wondering, does anybody know which is more likely to be
installed on a postgresql server? Which is faster? I'm writting an
application in perl that is going to need to get broad information about
heiarchial data (how many parents, settings common on parents, etc), and I'd
like to
Philippe Ferreira <[EMAIL PROTECTED]> writes:
> If a new sequence is created, its creation is propagated via WAL.
> However, instead of getting the property 'is_called'=false (the correct
> value before its first use),
> we get 'is_called'=true after a PITR recovery.
> Is it a bug, or a normal b
Read the FAQ.
---
Claire McLister wrote:
> Hi,
>
> I'm using a pgsql function that begins by creating a temporary
> table, does some processing, and then drops the temporary table just
> before exiting. It has been w
Hi,
I'm using a pgsql function that begins by creating a temporary
table, does some processing, and then drops the temporary table just
before exiting. It has been working fine for a while now, but
suddenly complains for some calls that "Relation with OID" does not
exist, at the point w
Stéphane SCHILDKNECHT wrote:
> select to_char(1485.12, '9G999D99');
> But, surprinsingly, I got 1,1485,12.
The fr_FR locale is broken. You should report this to glibc.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
"Andrus Moor" <[EMAIL PROTECTED]> writes:
> I have a table of vacations
>
> create table vacation (
> id integer primary key,
> dstart date,
> dend date );
>
>
> I need to find first non-vacation day before given date.
>
> This can be done using the following procedural vfp code
>
> function nonva
[EMAIL PROTECTED] (Philip Hallstrom) writes:
>>> I have a table of vacations
>>> create table vacation (
>>> id integer primary key,
>>> dstart date,
>>> dend date );
>>> I need to find first non-vacation day before given date.
>>> This can be done using the following procedural vfp code
>>> funct
Hi,
If a new sequence is created, its creation is propagated via WAL.
However, instead of getting the property 'is_called'=false (the correct
value before its first use),
we get 'is_called'=true after a PITR recovery.
Is it a bug, or a normal behaviour ?
(version of PostgreSQL : 8.0.4)
Thank
I have a table of vacations
create table vacation (
id integer primary key,
dstart date,
dend date );
I need to find first non-vacation day before given date.
This can be done using the following procedural vfp code
function nonvacation( dbefore )
for i=dbefore to date(1960,1,1) step -1
se
I have a table of vacations
create table vacation (
id integer primary key,
dstart date,
dend date );
I need to find first non-vacation day before given date.
This can be done using the following procedural vfp code
function nonvacation( dbefore )
for i=dbefore to date(1960,1,1) step -1
se
I have a table of vacations
create table vacation (
id integer primary key,
dstart date,
dend date );
I need to find first non-vacation day before given date.
This can be done using the following procedural vfp code
function nonvacation( dbefore )
for i=dbefore to date(1960,1,1) step -1
se
Tom Lane wrote:
Is there any way to group functions logically?
Put them in different schemas, perhaps?
I thought of that, but that is not what I want.
I want function to be in more that one group, so
this would cause even more mess.
Best regards,
Rikard
Rikard Pavelic <[EMAIL PROTECTED]> writes:
> Is there any way to group functions logically?
Put them in different schemas, perhaps?
regards, tom lane
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
> 2006-01-27 10:37:29 FATAL could not read from statistics collector
>pipe: No error
> 2006-01-27 10:37:30 LOGstatistics collector process (PID 5940)
>was terminated by signal 1
>
try turning row level statistics off (or, during bulk ins
Hi!
Is there any way to group functions logically?
It's get pretty frustrating to locate some function when
you have 500+ functions :(
And if there isn't is there any plan to add this functionality?
Thanks,
Rikard
---(end of broadcast)---
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> > where we can check the execution of our program or we can dry run our code,
> > is
> > there aby option or feature with PGSQL for the same purpose that we can
> > check
> > our PGSQL statements?
>
> No, unfortunately not. What I do i
I bet donations to support the project are appreciated.
Other than that, the postgreSQL license is BSD - which basically means you can
do whatever you want, you just can't sue anyone if it's not working.
This has been answered a thousand times, so checking mailing list archives and
the FAQ shou
On Fri, Feb 03, 2006 at 09:07:48AM -0500, Jeff Trout wrote:
> On Feb 2, 2006, at 7:17 PM, Michael Fuhr wrote:
> >If you declare the function with "RETURNS bytea" then the function
> >must return something; if zero-length data and NULL aren't suitable
> >for indicating no data then you could raise a
> I definitely agree with you here, Merlin. Mutability is not the issue
> at hand. May I ask what strategies you use for determining uniqueness
> for people?
Well, that depends on the particular problem at hand. If you had two
john smiths in your system, how would you distinguish them? If you
ass
OK - spent some more time profiling what was going on on both the client
and server machine. It began ti look more like a connector problem (I
was seeing low CPU usage on both client & server and could see very slow
BIND/INSERT/COMMIT commands being sent to the db).
Upgraded to Npgsql 1.0beta
Hello,
I have a question about the performance of trigger/trigger functions.
For example, I had a trigger setup as :
*CREATE TRIGGER track_tableOperation AFTER INSERT OR UPDATE OR DELETE **ON tableName FOR EACH ROW** EXECUTE PROCEDURE tracking_info();
A track table as:
( table_name, username
Tom Lane wrote:
Did you remember to VACUUM ANALYZE after loading the data? It sounds
to me like bad choices of plans ...
Yes - although I have autovacuum off, partly to make an apples to apples
comparison with 7.3 and partly due to the nature of the app.
On the application side I'm con
Tom Lane wrote:
I think you're getting bit by a standard beginner gotcha: commenting out
an entry in postgresql.conf will not change the state of a running
postmaster. (A comment is a no-op, eh?) You need to put in a
non-comment entry that sets the desired state.
This was indeed the case. I
Did you analyze after you imported the dump?
Woody
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Brain
Sent: Friday, February 03, 2006 10:03 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgres 7.3.2 -> 8.1.2 upgrade performance issue
David Brain <[EMAIL PROTECTED]> writes:
> Recently tried an upgrade from 7.3.2 to 8.1.2. The actual upgrade went
> pretty well. However my application is now getting >10 times slower
> INSERT times than it was under 7.3.2. As far as possible I mirrored the
> settings in postgresql.conf (obvio
Hi,
There seems to be some tricky behaviour with number formating and french
locale.
I tried the following request:
select to_char(1485.12, '9G999D99');
I was expecting to get: 1 485,12
But, surprinsingly, I got 1,1485,12.
My postgresql server is an 8.1.2 version. The same problem occurs unde
indu ss <[EMAIL PROTECTED]> writes:
> On executing the update statement i get error
> CONTEXT: compile of PL/pgSQL function "pgmail" near
> line 1
> PL/pgSQL function "test" line 10 at assignment
Uh, you didn't show us the actual error, nor the problematic line
within pgmail. (The reference to
Hi,
Recently tried an upgrade from 7.3.2 to 8.1.2. The actual upgrade went
pretty well. However my application is now getting >10 times slower
INSERT times than it was under 7.3.2. As far as possible I mirrored the
settings in postgresql.conf (obviously I couldn't just drop in the old
conf
Hi,
There seems to be some tricky behaviour with number formating ant french
locale.
i tried the following request:
select to_char(1485.12, '9G999D99');
I was expecting to get: 1 485,12
But, surprinsingly, I got 1,1485,12.
My postgresql server is an 8.1.2 version. The same problem occurs un
On Feb 2, 2006, at 7:17 PM, Michael Fuhr wrote:
On Wed, Feb 01, 2006 at 12:56:30PM -0500, [EMAIL PROTECTED] wrote:
From a C stored procedure, how can I tell Postgres to pass on to
the Java client that there is No Data? A zero length byte array or
a null value is not the same as No Data.
If y
> > PgAdmin III is available on Debian. Its package name is
> pgadmin3. Try doing:
> >
> > apt-cache show pgadmin3
>
> I am running Sarge and have found only pgaccess.
> So it is in Testing or Unstable...
You need to add one of the pgsql mirrors to get it. See
http://www.pgadmin.org/download/de
Am 2006-02-02 14:19:42, schrieb Juan Jose Comellas:
> PgAdmin III is available on Debian. Its package name is pgadmin3. Try doing:
>
> apt-cache show pgadmin3
I am running Sarge and have found only pgaccess.
So it is in Testing or Unstable...
Will look for it tomorrow.
Greetings
Michelle Ko
Read our FAQ.
---
Arun Kannapiran wrote:
> Dear Sir/Madam,
>
> I would appreciate it if you could answer the below queries.
>
> What are the licencing requirements for PgSQL ?
>
> The company I work for is building a clie
Dear Sir/Madam,
I would appreciate it if you could answer the below queries.
What are the licencing requirements for PgSQL ?
The company I work for is building a client-server application with a
PgSQL backend to be sold commercially on the market, are there any
licencing or other payments that n
Hello,
I want to send mail on update of a field in a table.
I'm using pgmail() function (from sourceforge) . I'm
calling this function from another function which is
called by trigger on update of the field.
On executing the update statement i get error
CONTEXT: compile of PL/pgSQL function "p
Richard Sydney-Smith <[EMAIL PROTECTED]> writes:
> pch := pchar('pg_dump -C -h '+host+' -U '+usr+' -p '+pswd+ ' -f
> '+bckup_path+' '+dbase);
>
> to postgres.
>
> as the operator is obviously logged in how do I
> (1) trap their user id
> (2) Send the call to pg_dump without knowing their pas
On Fri, 3 Feb 2006, Nicolay A Vasiliev wrote:
> Hello there!
>
> http://news.zdnet.co.uk/software/0,39020381,39249666,00.htm
>
> What do you think about this?
>
> Nicolay
>
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
>
39 matches
Mail list logo
