Rob Shepherd wrote:
> I'm following the synatx
>
> COPY TO 'filename'
>
> .but i'm trying to use a variable as the filename.
>
[...]
>
> returns the error
>
> ERROR: syntax error at or near "$1" at character 21
> QUERY: COPY tt_archive TO $1
> CONTEXT: SQL statement in PL/PgSQL funct
Tom Lane pisze:
I'm wondering if you have an example that doesn't work well with the
gist page-splitting heuristic changes that Teodor put in awhile back.
Those are all in 8.2.5 already, though you might have to REINDEX to
really notice a change if the index was first built with an older
8.2.x re
On Wed, Oct 17, 2007 at 02:40:14AM -0400, Tom Lane wrote:
> "Magnus Hagander" <[EMAIL PROTECTED]> writes:
> >> - Max_connections is set to 500.
>
> > There's your problem. 500 is way above what the windows version can
> > handle. IIRC the hard max is somewhere around 200 depending on some OS
> > f
Hi,
In the mid 1990's I used the Progress Database which had a great feature
where the it was possible to set the software version in the
configuration file. For example, if you had a built a database and
application using version 3 and then upgraded the version 7, it was
possible to set the
I need a solution for the following: With all data stored in the same
schema, consumers may only retreive and update data that is relevant to
them. At the same time, users in our own company need to see all data.
Is a solution similar to Oracle's Virtual Private Database possible with
PostgreS
On Tue, 2007-10-16 at 15:51 -0700, Ben wrote:
> You could take a look at pg_statio_user_indexes and/or
> pg_stat_user_indexes, if you have stats enabled
>
> On Tue, 16 Oct 2007, Bryan Murphy wrote:
If your intention is to eliminate the unused indexes rows you should run
'vaccum' and/or 'vacu
On Fri, 2007-10-12 at 19:59 +0100, Richard Huxton wrote:
> You could use WAL archiving, but you'll want a fairly regular
> full-backup of PG's files otherwise the recovery could take a long time.
> See Ch 23 of the manuals for details.
Restartable recovery avoids the need to re-sync from the pr
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of
>Russell Aspinwall
>Sent: woensdag 17 oktober 2007 9:34
>To: pgsql-general@postgresql.org
>Subject: [GENERAL] newbie question
>
>Hi,
>
>[snip] For example, if you had a
>built a database and application
On Wed, Oct 17, 2007 at 08:29:58AM +0200, Stefan Schwarzer wrote:
> Hmmm Actually, my intention was to get a more "excel" like output, that
> is the formatting into year-columns. This eases a lot the PHP/HTML
> display/loop. Otherwise I would have to start to do some joggling inside
> PHP to
Hi All,
The ls and rls commands are used to list files and directories in the
repository, but we should be logged in to the repository for getting the
listing of the same.
I use the command "cvs login" to connect to the repository but instead of
connecting to the local repository it is conne
On Tue, Oct 16, 2007 at 03:37:46PM -0400, Tom Hart wrote:
> I'm trying to migrate our data mine from a MS Access backend to a
> postgresql backend, and I'm bumping into problems with the conversion.
When I've had to do this before, I've tended to create a table with the
same columns but all of te
Hi list,
Whenever I try dropping a view using DROP VIEW myschema.myview the
query runs forever. The last time I tried was ten minutes ago and the
query is still running even though the view queries just data of one
single table with around 5 fields.
What could be the reason?
By the way, I'm using
Nevermind, by mistake I tried dropping it as a different user. But, just
a question, wouldn't it make more sense to issue an error message or
something instead of letting the query run indefinitely?
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Univer
2007/10/3, Alvaro Herrera <[EMAIL PROTECTED]>:
> Sergey Konoplev escribió:
>
> > > AFAIK, pl/pgsql does listen for SIGINT during execution, but I don't nkow
> > > abuot plpython.
> >
> > How can we find it out?
>
> Let's see one of the functions to find out if anyone else can reproduce
> the proble
2007/10/3, Erik Jones <[EMAIL PROTECTED]>:
> On Oct 3, 2007, at 6:47 AM, Richard Huxton wrote:
>
> > Sergey Konoplev wrote:
> >>> Don't forget to cc: the list.
> >>> Try not to top-post replies, it's easier to read if you reply
> >>> below the
> >>> text you're replying to.
> >> Thanx for your advi
Hi list!
I am using DBLink on a Win32 system running PostgreSQL 8.2 to query a table on
another similar system (Win32 / PostgreSQL 8.2).
If I query the server with dblink('hostaddr=ip_address ...', ...), it works
fine, but if I try to use the hostname instead
(dblink('hostaddr=myserver.mydomai
Hello again,
Sorry for the deal with my answer it was realy hectic week so I
couldn't even check my mail.
2007/10/3, Richard Huxton <[EMAIL PROTECTED]>:
> Sergey Konoplev wrote:
> >> Don't forget to cc: the list.
> >> Try not to top-post replies, it's easier to read if you reply below the
> >> te
am Wed, dem 17.10.2007, um 13:01:25 +0200 mailte Christian Rengstl folgendes:
> Hi list,
>
> Whenever I try dropping a view using DROP VIEW myschema.myview the
> query runs forever. The last time I tried was ten minutes ago and the
> query is still running even though the view queries just data o
my understanding was it used more resources than read committed
because it keeps track of the version id of rows selected
so far in a transaction, "transaction-level consistency",
so it has the potential to do the xmin co-selecting , and checking,
if it were a transaction isolation level in post
In response to Uden van Hout <[EMAIL PROTECTED]>:
> I need a solution for the following: With all data stored in the same
> schema, consumers may only retreive and update data that is relevant to
> them. At the same time, users in our own company need to see all data.
>
> Is a solution similar
On 10/17/07, Joao Miguel Ferreira <[EMAIL PROTECTED]> wrote:
> If your intention is to eliminate the unused indexes rows you should run
> 'vaccum' and/or 'vacuum full' and/or 'reindex'.
>
> This also has the consequence of freing filesystem space and returning
> it back to the OS.
>
> Check it out
>-Original Message-
>From: Russell Aspinwall [mailto:[EMAIL PROTECTED]
>Sent: woensdag 17 oktober 2007 11:37
>To: Joris Dobbelsteen
>Subject: Re: [GENERAL] newbie question
>
>Joris Dobbelsteen wrote:
>>> -Original Message-
>>> From: [EMAIL PROTECTED]
>>> [mailto:[EMAIL PROTECTED] O
>>> On Wed, Oct 17, 2007 at 1:40 AM, in message
<[EMAIL PROTECTED]>,
"Kuriakose, Cinu Cheriyamoozhiyil" <[EMAIL PROTECTED]> wrote:
>
> I am trying to configure CVS through Eclipse, infact i was able to do that
> but when I map the postgreSQL code into CVS through Eclipse, it is displaying
> th
Can someone point me to an example of creating a prepared statement for
a query with an 'IN' clause?
The query looks like this:
select value from table where
state = $1 and city = $2 and zip = $3 and
date in ( $4 );
For the prepared statement, I have tried:
prepare st1(text, text, text, text[
Peter Eisentraut escribió:
> novnov wrote:
> > My project is currently SQL_ASCII encoded. I will need to accomodate
> > both French and Spanish in addition to English. I don't anticipate
> > needing Far East languages. Reading here on the forums I come up with
> > Latin9 as perhaps adequate. But ot
Hi,
Is it possible to find the intersection of two array values?
a = '{1,2,3}'
b = '{2,3,4}'
a intersect b = '{2,3}'
Assume I need to write a pl/pgsql function to do this.
Josh
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Wed, Oct 17, 2007 at 07:37:15AM -0700, Jason L. Buberel wrote:
> Can someone point me to an example of creating a prepared statement for a
> query with an 'IN' clause?
>
> The query looks like this:
>
> select value from table where
> state = $1 and city = $2 and zip = $3 and
> date in ( $4 );
On Wed, 17 Oct 2007 10:19:43 -0500
Josh Trutwin <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to find the intersection of two array values?
>
> a = '{1,2,3}'
> b = '{2,3,4}'
>
> a intersect b = '{2,3}'
>
> Assume I need to write a pl/pgsql function to do this.
nm - I just wrote a functi
Jason L. Buberel wrote:
> Can someone point me to an example of creating a prepared
> statement for a query with an 'IN' clause?
>
> The query looks like this:
>
> select value from table where
> state = $1 and city = $2 and zip = $3 and
> date in ( $4 );
>
> For the prepared statement, I have
[EMAIL PROTECTED] ("Christian Rengstl") writes:
> Whenever I try dropping a view using DROP VIEW myschema.myview the
> query runs forever. The last time I tried was ten minutes ago and the
> query is still running even though the view queries just data of one
> single table with around 5 fields.
>
On Wed, Oct 17, 2007 at 10:37:23AM -0500, Josh Trutwin wrote:
> On Wed, 17 Oct 2007 10:19:43 -0500
> Josh Trutwin <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > Is it possible to find the intersection of two array values?
> >
> > a = '{1,2,3}'
> > b = '{2,3,4}'
> >
> > a intersect b = '{2,3}'
> >
On 10/17/07, Josh Trutwin <[EMAIL PROTECTED]> wrote:
> nm - I just wrote a function - though curious if this is the most
> effecient way:
If you only want TRUE or FALSE, you can use '&&':
t=# SELECT '{1,2}'::INT[] && '{2,3}'::INT[];
?column?
--
t
(1 row)
---(end
On Wed, 17 Oct 2007 11:12:27 -0500
"Rodrigo De León" <[EMAIL PROTECTED]> wrote:
> On 10/17/07, Josh Trutwin <[EMAIL PROTECTED]> wrote:
> > nm - I just wrote a function - though curious if this is the most
> > effecient way:
>
> If you only want TRUE or FALSE, you can use '&&':
>
> t=# SELECT '{1
On Mon, Oct 15, 2007 at 03:23:59PM -0400, Carlo Stonebanks wrote:
> Would someone be kind enough to tell me if there is somethign wrong with
> this apporach:
Can't see anything obviously wrong, but if you want more help you'll
need to provide the EXPLAIN output.
Have a nice day,
--
Martijn van
> This is only going to work for one-dimensional arrays (I'm not sure
> how you would ever fix that with the support postgres has for
> arrays) but the (computational) complexity of having an embedded
> FOR loops looks bad for performance. As you can already use '=ANY'
> syntax to search inside
On 10/17/07, Josh Trutwin <[EMAIL PROTECTED]> wrote:
> On Wed, 17 Oct 2007 11:12:27 -0500
> "Rodrigo De León" <[EMAIL PROTECTED]> wrote:
>
> > On 10/17/07, Josh Trutwin <[EMAIL PROTECTED]> wrote:
> > > nm - I just wrote a function - though curious if this is the most
> > > effecient way:
> >
> > If
On Wed, 17 Oct 2007 12:33:13 -0400
"Merlin Moncure" <[EMAIL PROTECTED]> wrote:
> On 10/17/07, Josh Trutwin <[EMAIL PROTECTED]> wrote:
> > On Wed, 17 Oct 2007 11:12:27 -0500
> > "Rodrigo De León" <[EMAIL PROTECTED]> wrote:
> >
> > > On 10/17/07, Josh Trutwin <[EMAIL PROTECTED]> wrote:
> > > > nm -
On Wed, Oct 17, 2007 at 11:28:31AM -0500, Josh Trutwin wrote:
> It's inelegant, but I just did this:
> IF return_empty THEN
> RETURN '{}';
> END IF;
humm, why didn't that seem to work for me... ah well. Next version
fixes a problem that I didn't test of the inputs being NULL
On Wed, Oct 17, 2007 at 11:31:51AM -0500, Josh Trutwin wrote:
> Is the =ANY specific to PG 8.2 or higher? On 8.1.10:
It appears (according to [1] and [2]) that you may be able to just
remove the '=' to get it working with 8.1.x. i.e.
v ANY ('{1,2}')
is correct in 8.1.x but in 8.2.x it's
v
On Wed, 17 Oct 2007 17:08:06 +0100
Sam Mason <[EMAIL PROTECTED]> wrote:
> CREATE OR REPLACE FUNCTION array_intersect (array1
> INTEGER[],array2 INTEGER[]) RETURNS INTEGER[] AS $$
> DECLARE
>out INTEGER[];
> BEGIN
> IF array1 IS NULL OR array2 IS NULL THEN
>R
On Wed, Oct 17, 2007 at 10:19:43AM -0500, Josh Trutwin wrote:
> Hi,
>
> Is it possible to find the intersection of two array values?
>
> a = '{1,2,3}'
> b = '{2,3,4}'
>
> a intersect b = '{2,3}'
>
> Assume I need to write a pl/pgsql function to do this.
You can use an SQL function, which has t
On Wed, 17 Oct 2007 17:49:01 +0100
Sam Mason <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 17, 2007 at 11:31:51AM -0500, Josh Trutwin wrote:
> > Is the =ANY specific to PG 8.2 or higher? On 8.1.10:
>
> It appears (according to [1] and [2]) that you may be able to just
> remove the '=' to get it worki
On Wed, 17 Oct 2007 17:42:21 +0100
Sam Mason <[EMAIL PROTECTED]> wrote:
> CREATE OR REPLACE FUNCTION array_intersect (array1
> INTEGER[],array2 INTEGER[]) RETURNS INTEGER[] AS $$
> DECLARE
>out INTEGER[];
> BEGIN
> out := '{}'::INTEGER[];
> IF array1 IS NUL
On Wed, 17 Oct 2007 10:04:21 -0700
David Fetter <[EMAIL PROTECTED]> wrote:
> CREATE OR REPLACE FUNCTION array_intersect(ANYARRAY, ANYARRAY)
> RETURNS ANYARRAY
> LANGUAGE SQL
> AS $$
> SELECT ARRAY(
> SELECT $1[i] AS "the_intersection"
> FROM generate_series(
> array_lower($1,1),
On Wed, Oct 17, 2007 at 01:06:35PM -0500, Josh Trutwin wrote:
> On Wed, 17 Oct 2007 10:04:21 -0700
> David Fetter <[EMAIL PROTECTED]> wrote:
>
>
>
> > CREATE OR REPLACE FUNCTION array_intersect(ANYARRAY, ANYARRAY)
> > RETURNS ANYARRAY
> > LANGUAGE SQL
> > AS $$
> > SELECT ARRAY(
> > SELECT $
On Wed, 17 Oct 2007 11:26:05 -0700
David Fetter <[EMAIL PROTECTED]> wrote:
> > Doesn't appear to work on 8.1:
> >
> > psql=> select array_intersect('{1,2,3}', '{2,3,4}');
> > ERROR: could not determine anyarray/anyelement type because input
> > has type "unknown"
>
> As mentioned in the "releas
Ow Mun Heng wrote:
Query2 is way faster mainly because the plan does not choose a seq scan
on a table w/ >20million rows.
The only difference between Query 1 and query 2 is that the
audio_key_dtime is chosen from a table rather than provided on the
query.
I'm not sure why this is the case and wh
> >
> >
> > > CREATE OR REPLACE FUNCTION array_intersect(ANYARRAY, ANYARRAY)
> > > RETURNS ANYARRAY
> > > LANGUAGE SQL
> > > AS $$
> > > SELECT ARRAY(
> > > SELECT $1[i] AS "the_intersection"
> > > FROM generate_series(
> > > array_lower($1,1),
> > > array_upper($1,1)
> > >
Hi,
I do convert an UML XMI model to a database script to create the
database schema.
To enable multiple iterations I need conditional alter table add
column like syntax.
Is there any way to do this ?
Tanks, Lothar
---(end of broadcast)---
TIP 2:
On 10/17/07, Syan Tan <[EMAIL PROTECTED]> wrote:
> my understanding was it used more resources than read committed
> because it keeps track of the version id of rows selected
> so far in a transaction, "transaction-level consistency",
Transaction-level consistency covers all the data in aggregate
Im installing the latest software (
postgresql-8.2.5-1-binaries-no-installer.) on windows xp but i dont know
what file to click to install - this seems very ambiguous. Can anyone
help?
--
Ken
On Wed, Oct 17, 2007 at 01:00:48PM -0500, Josh Trutwin wrote:
> Works like a champ on 8.1.
>
> Thanks!
That's OK, it was a good learning experience.
> Did you see David Fetter's reply to the original post? He has
> an interesting alternative.
I did, it's much more elegant. I've never seen gen
Ken Johansson wrote:
Im installing the latest software (
postgresql-8.2.5-1-binaries-no-installer.) on windows xp but i dont know
what file to click to install - this seems very ambiguous. Can anyone
help?
You don't mention platform, but Win32 is the only one with a
no-installer binary,
On 10/17/07, Ken Johansson <[EMAIL PROTECTED]> wrote:
> Im installing the latest software
> (postgresql-8.2.5-1-binaries-no-installer.) on windows
> xp but i dont know what file to click to install - this seems very
> ambiguous. Can anyone help?
You want to get postgresql-8.2.5-1.zip instea
Great, thanks.
Is this the appropriate place to ask those types of support questions?
Well, any type of support questions?
thanks
Ken
On 17/10/2007, Guy Rouillier <[EMAIL PROTECTED]> wrote:
>
> Ken Johansson wrote:
> > Im installing the latest software (
> > postgresql-8.2.5-1-binaries-no-inst
On Oct 17, 2007, at 4:28 PM, Ken Johansson wrote:
On 17/10/2007, Guy Rouillier <[EMAIL PROTECTED]> wrote: Ken
Johansson wrote:
> Im installing the latest software (
> postgresql-8.2.5-1-binaries-no-installer .) on windows xp but
i dont know
> what file to click to install - this seems
Fernando De Pedro wrote:
> Estimados...tengo un problema con la zona horaria de (GMT-06:00) Guadalajara,
> Ciudad de México, Monterrey - Nuevo.
>
> Cuando me conecto desde una aplicacion java a un servidor postgres todo en
> la misma maquina a el momento de insertar registros me cambia las
On Wed, 2007-10-17 at 20:37 +0100, Richard Huxton wrote:
> Ow Mun Heng wrote:
> > Query2 is way faster mainly because the plan does not choose a seq scan
> > on a table w/ >20million rows.
> > The only difference between Query 1 and query 2 is that the
> > audio_key_dtime is chosen from a table ra
Ow Mun Heng wrote:
> Index Cond: ((audit_key_dtime >= $0) AND (audit_key_dtime < $1))
>
>
> Index Cond: ((audit_key_dtime >= '2007-08-08 18:00:00'::timestamp without
> time zone)
> AND (audit_key_dtime < '2007-08-08 18:01:00'::timestamp without
> time zone))
>
> This is _the_ only
On Wed, 2007-10-17 at 22:47 -0300, Alvaro Herrera wrote:
> Ow Mun Heng wrote:
>
> > Index Cond: ((audit_key_dtime >= $0) AND (audit_key_dtime < $1))
> >
> >
> > Index Cond: ((audit_key_dtime >= '2007-08-08 18:00:00'::timestamp without
> > time zone)
> > AND (audit_key_dtime < '2007-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What's the best way to invoke a process on another server from a PG
trigger or procedure? I was thinking of using pl/java to invoke a web
service on the other box... Can pl/tcl run Expect scripts? That'd be
an option, too. Or I could use XMLBlaste
Bret,
I had quick and robust success using pl/python and pyro. Pyro is
Python Remote object.
All mentioned modules are BSD-like in license.
Harald
> What's the best way to invoke a process on another server from a PG
> trigger or procedure? I was thinking of using pl/java to invoke a web
> ser
Bret Schuhmacher <[EMAIL PROTECTED]> writes:
> What's the best way to invoke a process on another server from a PG
> trigger or procedure? I was thinking of using pl/java to invoke a web
> service on the other box... Can pl/tcl run Expect scripts?
No, but pl/tclu could.
> Or I could use XMLBlas
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
>
>
> You've almost figured out the big problem with anything like this;
> the trouble spot is the other way around. What if you launch some
> remote operation, and it succeeds, and then later your own transaction
> rolls back for som
am Wed, dem 17.10.2007, um 22:30:26 -0400 mailte Bret Schuhmacher folgendes:
> Does anyone else invoke a process on a remote server? How do you do it?
You can use any untrusted programming language like pl/perlU or plsh.
Other solution: use LISTEN/NOTIFY, see
http://www.postgresql.org/docs/8.2/i
> What's the best way to invoke a process on another server from a PG
> trigger or procedure? I was thinking of using pl/java to invoke a web
> service on the other box... Can pl/tcl run Expect scripts? That'd be
> an option, too. Or I could use XMLBlaster to send a message to the
> other box t
Hi all,
Initially i installed postgresql 8.2.5 for my Dspace software..everything was
fine.. but all of sudden yeterday while connecting an error popped out sayin
server could'nt listen i have uninstalled it and reinstalled many a times
with different ports and diffferent accounts.. but its
Ow Mun Heng wrote:
On Wed, 2007-10-17 at 20:37 +0100, Richard Huxton wrote:
Your query plans don't seem to match your queries. That makes it
difficult to provide meaningful advice.
Well, then that makes both you and me(both) stumped. because the 2
queries are exactly the same except for the da
roopal oswal wrote:
Hi all, Initially i installed postgresql 8.2.5 for my Dspace
software..everything was fine.. but all of sudden yeterday while
connecting an error popped out sayin server could'nt listen i
have uninstalled it and reinstalled many a times with different ports
and diffferent
On Thu, 2007-10-18 at 07:28 +0100, Richard Huxton wrote:
> Ow Mun Heng wrote:
> > On Wed, 2007-10-17 at 20:37 +0100, Richard Huxton wrote:
> >> Your query plans don't seem to match your queries. That makes it
> >> difficult to provide meaningful advice.
> >
> > Well, then that makes both you and
70 matches
Mail list logo
