[Removing pgsql-novice. Please don't cross-post. Choose one list or
another at a time. ]
On Jun 19, 2007, at 23:04 , Andrew Maclean wrote:
I got no answer so I am trying again.
In a nutshell, if I have a recrusive relationship as outlined
below, how do I implement a rule for the adjustment
I got no answer so I am trying again.
In a nutshell, if I have a recrusive relationship as outlined below, how do
I implement a rule for the adjustments table that prevents the entry of an
Id into the Ref column if the id exists in the Id column and vice versa?
If I have a payments table which h
It should work, but you could post your question on pgsql-odbc and get
an answer from someone who has more experience with Excel and PostgreSQL
via the ODBC driver.
Bob Pawley wrote:
Thanks
Does one version of ODBC work for all versions of Excel and Postgresql.
I am wanting to transfer one o
Thanks
Does one version of ODBC work for all versions of Excel and Postgresql.
I am wanting to transfer one or two tables from Excel and manipulate the
information in Postgresql then transfer the results back to Excel as a
single table.
I am using Excel 2000 and PostgreSql 8.1.
Bob
-
On 6/20/07, Henrik Zagerholm <[EMAIL PROTECTED]> wrote:
Hello,
I wonder how I can iterate over a sql array in a pl/perl function.
I want to pass in an text[] to a function and then iterate through
the values and run it through a perl sprintf but I can't seem to get
it to work.
Should I do a ge
Hi,
Can I get a PostgreSQL Installer for Windows x64(EM64T)?
That for 32bit Windows is available at http://www.postgresql.org/ftp/win32/ but
I need x64 native
version.
Any information would be appreciated.
Thanks,
ebi
---(end of broadcast)---
Agreed ODBC is the way to go, depending on what you are doing, Access
may be helpfull as an intermediate step.
Joshua D. Drake wrote:
Bob Pawley wrote:
Hi All
Is there a fast and easy method of transferring information between
MS Excel and PostgreSQL??
odbc?
Joshua D. Drake
Bob Pawl
"Rhys Stewart" <[EMAIL PROTECTED]> writes:
> Is regex searching not functioning (as i expect it to?)
~ expects the pattern on the right, not the left. So it's taking your
array entries as patterns, which don't match the data 'Trans'.
Since there's no "(array) ANY op scalar" syntax, the only way
Hi all,
have a column which is of type text[]. the following works:
select * from table where 'Transformer' = ANY (thiscol)
this also works
select * from table where 'Transformer' ~ ANY (thiscol)
however if i have a partial string like so
select * from table where 'Trans'
Hello,
I wonder how I can iterate over a sql array in a pl/perl function.
I want to pass in an text[] to a function and then iterate through
the values and run it through a perl sprintf but I can't seem to get
it to work.
Should I do a generate_series and make an internal perl array?
If so
Bob Pawley wrote:
Hi All
Is there a fast and easy method of transferring information between MS
Excel and PostgreSQL??
odbc?
Joshua D. Drake
Bob Pawley
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Pr
Hi All
Is there a fast and easy method of transferring information between MS Excel
and PostgreSQL??
Bob Pawley
On Tue, 19 Jun 2007, Jeff Davis wrote:
I have a table in my database that holds information on policies and this
table is linked to a number of other tables. I need to be able to keep a
history of all changes to a policy over time. The other tables that are
linked to policy also need to store hi
Hi,
I'm trying to recompile the SRPM with ldap support (maybe this should
be added as an option to the spec?) but it fails to check for ldap_r
due to problems finding my pthread flag in configure.
Snip from configure:
checking whether pthreads work with -pthread... no
...
checking for ldap_simpl
On Thu, 2007-06-14 at 10:57 -0700, Lza wrote:
> Can anyone help me with this problem?
>
> I have a table in my database that holds information on policies and
> this table is linked to a number of other tables. I need to be able to
> keep a history of all changes to a policy over time. The other t
On Mon, 2007-06-18 at 17:55 +0200, David Tokmatchi wrote:
> I am DBA for Oracle and beginner on Postgres. For an company in
> France, I must make a comparative study, between Postgres and Oracle.
> Can you send any useful document which can help me.
> Scalability ? Performance? Benchmark ? Availab
On Mon, 2007-06-18 at 16:06 +0930, Tom Lanyon wrote:
> Trying to do a PITR on postgres 8.1.8; I've restored the last full
> backup of the cluster dir and put the required WAL files into place.
This problem is fixed in 8.1.9. Seems it was inadvertently introduced in
8.1.7 (Jan 2007) and was not
John Smith wrote:
couldn't be more timely- could someone elaborate on this ("managing a
backup infrastructure")? is it for sysadmin types??
Yes it is explicitly for sysadmin types. The idea being, "Hey, I am a
sysadmin and somebody just shoved PostgreSQL down my throat. How do I
make sure eve
couldn't be more timely- could someone elaborate on this ("managing a
backup infrastructure")? is it for sysadmin types??
http://www.commandprompt.com/blogs/joshua_drake/2007/06/training_hot_seat_style/
"...
Most of our clients want short, specific classes on items such as
managing a backup infra
Joshua D. Drake wrote:
Hello,
We are looking to have new signage for the shows that PostgreSQL
attends. The signage that we have decided on is here:
http://www.displays2go.com/product.asp?ID=7371
We need artsy folk to help us design a sign that will make PostgreSQL
look like the big bad pla
Alvaro Herrera writes:
Can you send the program along? And the table definition (including
indexes, etc)?
I put the table definition and a Python program that reproduces the problem
at:
http://public.natserv.net/table-schema.sql
http://public.natserv.net/large_record.py
The program uses t
On 10:06 Tue 19 Jun , Jeffrey Webster wrote:
>On 6/17/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
>
>
>Hm. Why not just edit your .bash_profile, or .bashrc? (I won't go into
>the details of which to use)
>
>Add:
>export PGDATA=/usr/local/pgsql/data
>
>Add the
On 6/17/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
On 6/18/07, John K Masters <[EMAIL PROTECTED]> wrote:
> I feel somewhat embarrassed to post this but I can't get past the first
> post with Postgresql. I have installed onto a Debian testing system,
> created a space for the database clust
Tom Lane wrote:
Richard Huxton <[EMAIL PROTECTED]> writes:
Any developers care to comment?
plpgsql isn't very bright about tuple descriptors containing dropped
columns. The immediate problem is that compatible_tupdesc() doesn't
think a tupdesc containing one column matches one containing the
How can I do "OLD.columnName != NEW.columnName" if I don't know what the
columnNames are at Compile Time?
I have the columnName in a variable.
Are you trying to do this from a plpgsql function? If so then I think
you should try to do this from a C function.
With C functions you will get more
Richard Huxton <[EMAIL PROTECTED]> writes:
> Any developers care to comment?
plpgsql isn't very bright about tuple descriptors containing dropped
columns. The immediate problem is that compatible_tupdesc() doesn't
think a tupdesc containing one column matches one containing the same
column plus a
Bill Moran wrote:
> Have you tried altering the table, then disconnect and reconnect, then run
> your stored procedure?
>
> If that works, then the problem has to do with OID caching, which is known.
>
>
Yes, I even tried restarting postgres, but nothing helped.
Regards,
Rikard
---
Rikard Pavelic wrote:
create function sel_test() returns test as
$$
declare red record;
begin
select * into red from test limit 1;
return red;
end
$$ language plpgsql;
alter table test drop column tekst;
then select * from sel_test(); doesn't work anymore
Even if I recreate th
On 6/19/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
> sure!.
>
> SELECTcast(((sum(A.qty_employees_total)
>-(sum(A.qty_absence)
>-sum(A.qty_vacation)
>-sum(A.qty_diseased)
>-sum(A.qty_indirect)
>-sum(A.qty_transferred))
>
> And when was the message logged?
>
after the server was running with version 8.1.8 for about 2 month
(actually it was Jun 13 on one server and Apr 5 on the other) and no
similar log entries since then.
Gerhard
---(end of broadcast)---
TIP 2: Do
In response to Rikard Pavelic <[EMAIL PROTECTED]>:
>
> I noticed that some of the functions I created don't work anymore.
> So I tired to reproduce the problem and this is what I came up with.
>
> create table test(
> id serial primary key,
> tekst text);
>
> insert into test values(1,'1'),(2,'2
Alvaro Herrera writes:
The OS size is 1.6GB, but today I am going to try increasing kern.maxssiz.
Vivek recommended increasing it
kern.maxssiz is the maximum stack size.
Increased to 512MB. Didn't help.
The problem is probably the ulimit.
I did a shell script which continuously did ps aux
Original Message
Subject: Re:[GENERAL] Subquery problems
From: Merlin Moncure <[EMAIL PROTECTED]>
To: Ranieri Mazili <[EMAIL PROTECTED]>
Date: 19/6/2007 10:40
On 6/19/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
Hello,
I'm having another "problem", I have a function that
On 6/18/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
Hello,
I need to know why can't I do it?
CREATE OR REPLACE FUNCTION lost_hours_temp(date)
RETURNS text AS
$BODY$
DECLARE
START_DATE date;
END_DATE date;
QUERY text;
BEGIN
START_DATE := $1;
END_DATE := START_DATE - interva
On Sun, 17 Jun 2007, Sergei Shelukhin wrote:
Is there any way to speed up ANALYZE? Without it all the queries run
so slow that I want to cry after a couple of hours of operation and
with it system has to go down for hours per day and that is
unacceptable.
I've found I cry a lot less if I actua
On 6/16/07, Noah Heusser <[EMAIL PROTECTED]> wrote:
Hi
I want to implement a trigger-function witch can fill the following table.
Each data manipulation (INSERT, UPDATE or DELETE) gets logged.
The function should work as trigger on diffrent tables.
CREATE TABLE logtable (
operationCHA
Hi!
I noticed that some of the functions I created don't work anymore.
So I tired to reproduce the problem and this is what I came up with.
create table test(
id serial primary key,
tekst text);
insert into test values(1,'1'),(2,'2');
create function sel_test() returns test as
$$
declare red re
Francisco Reyes wrote:
> Tom Lane writes:
>
> >What's more, because the line and field buffers are StringInfos that are
> >intended for reuse across multiple lines/fields, they're not simply made
> >equal to the exact size of the big field. They're rounded up to the
> >next power-of-2, ie, if you
On 6/19/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
Hello,
I'm having another "problem", I have a function that declares 12 variable,
one per month and each them execute a select like bellow:
DIV_MES01 := (select count(distinct production_date) from production where
extract(month from prod
[EMAIL PROTECTED] wrote:
> On Jun 18, 10:44 pm, [EMAIL PROTECTED] (Alvaro Herrera)
> wrote:
>
> >
> > Please check "MultiXact" id consumption. Do you mean that your server
> > has crashed?
> >
> How do I check MilitXact id consumption ? Is it "Latest checkpoint's
> NextXID:" in the output of pg_c
Can we please trim this down to just advocacy?
On Jun 18, 2007, at 1:17 PM, Joshua D. Drake wrote:
Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer th
Andrew Kelly wrote:
On Mon, 2007-06-18 at 13:02 -0400, Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer this
type of anti-commercial-database flamewar-s
I don't want to add gas to the flamewar, but I gotta ask. What is in
the the 90 to 95% referred to in this email.
Carol
On Jun 18, 2007, at 1:17 PM, Joshua D. Drake wrote:
Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
As a cynic, I might ask, what Oracle is
Philippe Lang wrote:
Hi,
I have a database which can be simplified in the following way, with
three tables:
An "order" has multiple "order lines", and an "order line" has multiple
"line steps".
I'd like to prevent any kind of modification (insert, update, delete) in
a order (and its lines, and
Hello,
I'm having another "problem", I have a function that declares 12
variable, one per month and each them execute a select like bellow:
*DIV_MES01 := (select count(distinct production_date) from production
where extract(month from production_date) = '01' and extract(year from
production_da
Tom Lane writes:
What's more, because the line and field buffers are StringInfos that are
intended for reuse across multiple lines/fields, they're not simply made
equal to the exact size of the big field. They're rounded up to the
next power-of-2, ie, if you've read an 84MB field during the cur
In response to Sergei Shelukhin <[EMAIL PROTECTED]>:
> This is my first (and, by the love of the God, last) project w/pgsql
One has to ask, are you actually looking for help, or trolling?
If you honestly want help, I would suggest you work on your communication
skills first. If you're a troll,
am Tue, dem 19.06.2007, um 12:23:51 +0200 mailte Philippe Lang folgendes:
>
> I'd like to prevent any kind of modification (insert, update, delete) in
> a order (and its lines, and steps) if all the steps in the lines of the
> order are "checked". If that condition is not true, a modification is
Hi,
I have a database which can be simplified in the following way, with
three tables:
An "order" has multiple "order lines", and an "order line" has multiple
"line steps".
I'd like to prevent any kind of modification (insert, update, delete) in
a order (and its lines, and steps) if all the step
On Mon, 2007-06-18 at 13:02 -0400, Jonah H. Harris wrote:
> On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
> > As a cynic, I might ask, what Oracle is fearing?
>
> As a realist, I might ask, how many times do we have to answer this
> type of anti-commercial-database flamewar-starting ques
Jayakumar_Mukundaraju wrote:
>
> I am new to Postgresql Database. My setup is backend is postgresql
> database, frontend is Java(JDBC). I installed the postgres in windows
> platform. Now I want to setup server and client configuration. Kindly
> guide me how to set the configuration parameters, in
51 matches
Mail list logo
