Nevermind. I figured it out, you just do this:
CREATE TYPE notification AS (UserId uuid, Data text);
CREATE FUNCTION Foo(_userid uuid)
RETURNS SETOF notification AS
$BODY$
BEGIN
RETURN QUERY
select n.UserId as UserId, n.data as Data from subscriptions s
inner
In response to Mike Christensen :
> Won't I still need a column definition list when I call that since it returns
> SETOF record?
You have to provide a column definition, either as OUT-parameter
definition or as column definition list in the select.
Please, don't top-posting.
Andreas
--
Andrea
Won't I still need a column definition list when I call that since it
returns SETOF record?
Asko Oja wrote:
CREATE FUNCTION func(
i_users text[],
OUT username text,
OUT update_time timestamp with time zone
) RETURNS SETOF record AS
$_$
select f.username , f.update_time
CREATE FUNCTION func(
i_users text[],
OUT username text,
OUT update_time timestamp with time zone
) RETURNS SETOF record AS
$_$
select f.username , f.update_time
from tbl f
where f.username = ANY ($1);
$_$
LANGUAGE sql SECURITY DEFINER;
On Fri, Feb 20, 2
I have the following function:
CREATE FUNCTION foo(_userid uuid)
RETURNS SETOF record AS
$BODY$
BEGIN
RETURN QUERY
select n.UserId, u.Alias, n.Date, n.Data
--Bunch of joins, etc
If I understand correctly, I have to return "SETOF record" since my
result set doesn't match a table and isn'
On Thu, Feb 19, 2009 at 10:17 PM, Mike Christensen wrote:
> I'd tell you, but I lost the database last night
>
> I'll go rebuild the test data but it'll take a while.
>
I assume the data was properly representative of the real data, and
that you were running analyze; before running any queries.
I'd tell you, but I lost the database last night
I'll go rebuild the test data but it'll take a while.
Scott Marlowe wrote:
On Thu, Feb 19, 2009 at 9:32 PM, Mike Christensen wrote:
Hi all -
I have a fairly simple query:
select * from subscriptions s
inner join notifications n on n.useri
On Thu, Feb 19, 2009 at 9:32 PM, Mike Christensen wrote:
> Hi all -
>
> I have a fairly simple query:
>
> select * from subscriptions s
> inner join notifications n on n.userid = s.userid
> inner join users u on u.userid = s.userid
> where s.subscriberid='affaa328-5b53-430e-991a-22674ede6faf'
> an
Hi all -
I have a fairly simple query:
select * from subscriptions s
inner join notifications n on n.userid = s.userid
inner join users u on u.userid = s.userid
where s.subscriberid='affaa328-5b53-430e-991a-22674ede6faf'
and n.date > (CURRENT_TIMESTAMP - INTERVAL '14 day')::date;
It runs fairly
On Feb 19, 2009, at 6:30 PM, R Smith wrote:
On Feb 19, 2009, at 11:07 AM, SHARMILA JOTHIRAJAH wrote:
Thanks all
-Sharmila
--- On Thu, 2/19/09, Erik Jones wrote:
From: Erik Jones
Subject: Re: [GENERAL] How to pipe the psql copy command to Unix
'Date' command
To: sharmi...@yahoo.com
C
On Feb 19, 2009, at 11:07 AM, SHARMILA JOTHIRAJAH wrote:
Thanks all
-Sharmila
--- On Thu, 2/19/09, Erik Jones wrote:
From: Erik Jones
Subject: Re: [GENERAL] How to pipe the psql copy command to Unix
'Date' command
To: sharmi...@yahoo.com
Cc: "Tom Lane" , "General postgres mailing list"
Read about the same error somewhere and he said he resolved it with sfc
/scannow.
Got a new error after I ran sfc /scannow and tried starting the postgresql
service:
Can not start the PostgreSQL Database 8.3-service on Local computer.
Error 1053: The service did not respond correctly to the start
I was just reading over a reply from David Fetter from a couple of days
ago; the thread is archived[1] but this question doesn't really relate
to it much. The a question about how to arrange tables and David make
the following comments:
On Tue, Feb 17, 2009 at 09:53:00AM -0800, David Fetter wrote
On Thu, Feb 19, 2009 at 7:08 PM, c k wrote:
> As
> all rows are rewritten(newly inserted with changed column value), the
> indices must be updated accordingly and this may take more time?
I'd think so, but I'm no expert.
If you have many and frequent updates, it might be worthwhile to
adjust the
Hey Richard,
I tried both things, both same results as before :(
Hope there is a solution for this! Thanks for the replies so far :)
Looking forward to hearing from you, FF.
On Thu, Feb 19, 2009 at 9:45 PM, Richard Huxton wrote:
First thing to do is to reduce the shared_buffers value that yo
Jack Orenstein writes:
> - How well does the CONCURRENTLY option work? The documentation on REINDEX
> says
> "An index build with the CONCURRENTLY option failed ..." I'm not sure if I'm
> supposed to read this as a comment on the reliability of the CONCURRENTLY
> option.
No, you aren't. The
I have a postgres application, with customers using version 7.4 and the next
version of the product being built on 8.3 (with HOT). We are having problems
with two bloated indexes. One index is on a field whose value never changes.
The other, which bloats more severely, is on a field whose value
I could finish the install without starting the service by closing down
msiexec with ctrl+alt+del.
I looked up the log from postgresql and it says this:
FATAL: could not reattach to shared memory (key=1804, addr=0170): 487
2009-02-19 15:51:01 CET LOG: database system was shut down at 2009-02
- "SHARMILA JOTHIRAJAH" wrote:
> Hi
> In Oracle I can use the NOVALIDATE for constraints... like this
> ALTER TABLE employee ADD
> CONSTRAINT emp_ck
> CHECK (married IN ('Y','N')) NO VALIDATE;
>
> When the table is already populated this will be faster. Can you do
> the same in Postgresql?
2009/2/19 SHARMILA JOTHIRAJAH :
> Hi
> In Oracle I can use the NOVALIDATE for constraints... like this
> ALTER TABLE employee ADD
> CONSTRAINT emp_ck
> CHECK (married IN ('Y','N')) NO VALIDATE;
>
> When the table is already populated this will be faster. Can you do the same
> in Postgresql?
>
>
Hi
In Oracle I can use the NOVALIDATE for constraints... like this
ALTER TABLE employee ADD
CONSTRAINT emp_ck
CHECK (married IN ('Y','N')) NO VALIDATE;
When the table is already populated this will be faster. Can you do the same in
Postgresql?
Thanks
Sharmila
--
Sent via pgsql-general
Thanks all
-Sharmila
--- On Thu, 2/19/09, Erik Jones wrote:
> From: Erik Jones
> Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date'
> command
> To: sharmi...@yahoo.com
> Cc: "Tom Lane" , "General postgres mailing list"
>
> Date: Thursday, February 19, 2009, 1:31 PM
> On
On Feb 19, 2009, at 3:30 AM, Jasen Betts wrote:
On 2009-02-18, Tom Lane wrote:
John R Pierce writes:
Tom Lane wrote:
"Brent Wood" writes:
Perhaps \o+ as a future fix for this?
I'd prefer "\o >>file" but maybe I'm too steeped in unix-isms.
\o+ is reasonably consistent with the other
Yea sorry good point.. It's probably at least safe to say the process
should not just hang though, and there should be more info in the log as
to what it's doing..
John R Pierce wrote:
Mike Christensen wrote:
First off, when Postgres starts and sees that your database was not
closed properly
On Feb 19, 2009, at 9:40 AM, SHARMILA JOTHIRAJAH wrote:
--- On Thu, 2/19/09, Tom Lane wrote:
From: Tom Lane
Subject: Re: [GENERAL] How to pipe the psql copy command to Unix
'Date' command
To: sharmi...@yahoo.com
Cc: "General postgres mailing list"
Date: Thursday, February 19, 2009, 12:3
On Thu, Feb 19, 2009 at 01:27:23PM -0500, Rob Richardson wrote:
> Thank you very much. It works, as I'm sure you knew.
>
> But I have a further question. I've never seen the "~*" operator
> before, and searching for it in the docs and on Google did not return
> any results I could find. What do
Thank you very much. It works, as I'm sure you knew.
But I have a further question. I've never seen the "~*" operator
before, and searching for it in the docs and on Google did not return
any results I could find. What does it mean?
Thanks again!
RobR
--
Sent via pgsql-general mailing list
On Thu, Feb 19, 2009 at 12:46:41PM -0500, Rob Richardson wrote:
> Can anyone suggest a query that will tell me the names of all functions
> (both trigger and normal) that contain a given string of text?
assuming you mean pl/* functions, you can simply use:
select proname from pg_proc where prosrc
Thanks to all replies.
The main thing is that there was no index on the said column when I am
updating and there are about 40+ other columns mostly of integer and
smallint types. Also in MySQL I am using InnoDB tables. For both there is a
single transaction when working, No other user is connected.
On Thu, Feb 19, 2009 at 02:58:02AM -0800, Mike Christensen wrote:
> I would assume if the account the service is running under has limited
> disk space, it won't really matter what OS you're running under.
> Postgres will throw an "out of disk space" error.
Similarly to Scott, every time I've c
Greetings!
Can anyone suggest a query that will tell me the names of all functions
(both trigger and normal) that contain a given string of text?
Here's what happened:
My company's database has a table named "charge" and a view named
"availcharges" that returns all charges that are available.
Kevin Murphy writes:
> Substitute the following pairs of values for X and Y in the query below,
> and all of them work (in PG 8.3.6, at least):
> X Y
> gg
> i g(i)
> gg(i)
> g.i g(i)
> create or replace function unnest(anyarray)
> returns setof anyelement as $$
> select $1[X] fro
--- On Thu, 2/19/09, Tom Lane wrote:
> From: Tom Lane
> Subject: Re: [GENERAL] How to pipe the psql copy command to Unix 'Date'
> command
> To: sharmi...@yahoo.com
> Cc: "General postgres mailing list"
> Date: Thursday, February 19, 2009, 12:31 PM
> SHARMILA JOTHIRAJAH writes:
> > Hi,
> >
SHARMILA JOTHIRAJAH writes:
> Hi,
> I want to find the time taken by this process ...retrieving data from oracle
> database using java and copying that to postgres using copy.
> So I need something like this
> Start_Time|java testCode ...|psql -c "copy dummy from stdin with delimiter
> ',' null
I've now seen the 'unnest' function defined in a few different ways with
regard to aliases.
Substitute the following pairs of values for X and Y in the query below,
and all of them work (in PG 8.3.6, at least):
X Y
gg
i g(i)
gg(i)
g.i g(i)
create or replace function unnest(any
Why not call a function that make an insert as "insert into dummy values
('Start',now())" ?
Mirko
On Thu, Feb 19, 2009 at 5:37 PM, SHARMILA JOTHIRAJAH wrote:
> Hi,
> I want to find the time taken by this process ...retrieving data from
> oracle database using java and copying that to postgres
Hi,
I want to find the time taken by this process ...retrieving data from oracle
database using java and copying that to postgres using copy.
So I need something like this
Start_Time|java testCode ...|psql -c "copy dummy from stdin with delimiter ','
null 'NULL'" test| End_time
so that the outp
--- On Thu, 19/2/09, Tom Lane wrote:
>
> Also, it'd be worth revisiting the question of whether
> you really still
> need enable_sort off ... personally, I'd think that
> reducing
> random_page_cost is a much saner way of nudging the planner
> in the
> direction of preferring indexscans.
>
We h
Hi,
Wondering who has any practical experience of open sourcing a software
product? I made a small internal database tool open source a while ago
and that worked quite well - www.gtportalbase.com/opensource. People
got involved in adding to the code and some people even paid a bit for
our
Chander Ganesan wrote:
Basically, if you try to use PostgreSQL as a local data store for a
desktop app, you'll likely want to use socket connections.
Unfortunately, if its a windows app, I'm not sure if there is much
benefit to using a socket over tcp/ip . I thought at one point there
was an
Craig Ringer writes:
> Tom Lane wrote:
>> This is not correct; PG *never* overwrites an existing record (at least
>> not in any user-accessible code paths).
> That's what I always thought, but I encountered some odd behaviour while
> trying to generate table bloat that made me think otherwise. I
Mike Christensen wrote:
First off, when Postgres starts and sees that your database was not
closed properly, it should tell you there's pending transactions and
ask if you want to dump them or try to process them (or maybe save
them for later). If you process them, there should be clear status
Tom Lane wrote:
> Craig Ringer writes:
>> AFAIK if you run the UPDATE while there are no other concurrent
>> transactions, Pg will write the new values in-place. It still updates
>> the WAL first, but it won't create whole new copies of each record as
>> well. That's the case at least if the field
C:\ham>chcp 65001
Aktive Codepage: 65001.
C:\ham>psql -U postgres
Passwort f�r Benutzer postgres:
psql (8.4devel)
WARNING: Console code page (65001) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users"
Gregory,
>> $COLUMNS was not set at all ... guess that is a usual >environment
>> variable on bash. Setting it to 80 works.
>
> COLUMNS wasn't set and \pset columns wasn't set? What environment were you
> running this psql command in? Was the output redirected anywhere with \o or
> with > on the c
Craig Ringer writes:
> AFAIK if you run the UPDATE while there are no other concurrent
> transactions, Pg will write the new values in-place. It still updates
> the WAL first, but it won't create whole new copies of each record as
> well. That's the case at least if the field you're updating isn't
I saw it,but it says:
"Use of many of these functions requires the installation to have been built
with configure --with-libxml"
When I installed postgreSQL I did not include this option, have I to
reinstall postgresql?
2009/2/19 Osvaldo Kussama
> 2009/2/19 Francisco :
> > Hi List,
> > I have i
c k wrote:
> CREATE TABLE accgroups
> (
> accgroupid serial NOT NULL,
> accgroupidname character varying(150) NOT NULL DEFAULT ''::character
> varying,
> accgroupname character varying,
> createdby integer DEFAULT 0,
> createdtimestamp timestamp without time zone DEFAULT
> ('now'::text):
c k wrote:
> I am using PG on windows for development. While testing some queries I
> found that updates are much slower as compared to other database
> systems. (On avarage MySQL updates 4-5 times faster than PG in a single
> unique index on primary key) Why?
Is your MySQL instance using MyISAM t
Harald Armin Massa wrote:
> Thanks!
>
> > What is your $COLUMNS set to? This should have wrapped to fit into the
> > screen with. Also look at \pset columns:
>
> $COLUMNS was not set at all ... guess that is a usual environment
> variable on bash. Setting it to 80 works.
Great. The wrapping m
Sameer Mahajan wrote:
> [Sameer Mahajan] I will investigate how the unix domain sockets help in
> my case. Why isn't it the default for postgres installations? Or it
> isn't believed to be generic enough / straight forward enough to
> configure?
It is the default. Just connect without a host para
Hi List,
I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron.
I want to use xpath functions (like xpath_table), but I can't. An error
appears "xpath_table does not exists".
How could I intregrate xpath funtions with my postgreSQL without
reinstalling it?
Any solution?
Thanks ;)
Harald Armin Massa writes:
> Thanks!
>
>> What is your $COLUMNS set to? This should have wrapped to fit into the
>> screen with. Also look at \pset columns:
>
> $COLUMNS was not set at all ... guess that is a usual environment
> variable on bash. Setting it to 80 works.
COLUMNS wasn't set and
Thomas Kellerer wrote:
Sameer Mahajan, 19.02.2009 07:38:
* Shared memory based connectivity: As such postgres has client
- server model. The TCP-IP nature of its connectivity further adds to
the latency of this communication. It will be nice to have a shared
memory based connectivity bet
2009/2/17 David Andersen :
> Hi,
>
> I am a real newbee and I hope this is the right place to post a feature
> request.
>
> I am receiving data from a csv file where one column has a strange data
> format. It would be nice if I could use Copy From with to_timestamp to
> transform the date. As far a
Thanks!
> What is your $COLUMNS set to? This should have wrapped to fit into the
> screen with. Also look at \pset columns:
$COLUMNS was not set at all ... guess that is a usual environment
variable on bash. Setting it to 80 works.
Thank you very much,
Harald
--
GHUM Harald Massa
persuadere
I didn't know you had time to look at these.. :)
Geoffrey wrote:
> Tom Lane wrote:
> > "Brent Wood" writes:
> >> Perhaps \o+ as a future fix for this?
> >
> > I'd prefer "\o >>file" but maybe I'm too steeped in unix-isms.
> >
> >regards, tom lane
>
> +1
>
>
> --
> Until later, Geoffrey
>
>
This is my first attempt at using libpq, and I'm running across a strange
problem. Here is my bare-bones program:
#include
#include "libpq-fe.h"
int main(int argc, char **argv) {
PGconn *conn;
fprintf(stderr, "connecting\n");
conn = PQconnectdb("dbname=postgres");
PQfinish(conn);
retur
I recently worked on rewriting a fairly complex Berkeley DB based system
using Postgres DB. Following is a wish list and a brief explanation for
each of those items for postgres. It is not necessarily a comparison of
postgres functionality with that of Berkeley DB but some required useful
function
Jerry Stuckle says...
> > The server would run Linux or one of the BSD variant
> You also missed DB2, SQL Server and several others.
> >>> Scrap MSSQL Server as a candidate given the above O/S requirement.
> >> The OS should be picked based on the requirements of the database and
> >> r
On Feb 16, 11:12 am, Paulie wrote:
> On Feb 16, 5:51 pm, joel garry wrote:
>
> > Check out Oracle XE and apex. No cost to you, and you can pay to
> > scale as appropriate.
>
> Before rushing to download Oracle XE, check out
>
> http://www.oracle.com/technology/pub/articles/cunningham-database-xe
Hi,
I am a real newbee and I hope this is the right place to post a feature
request.
I am receiving data from a csv file where one column has a strange data
format. It would be nice if I could use Copy From with to_timestamp to
transform the date. As far as I know this is not possible to do in on
Paulie wrote:
[snip]
>No CPU data, no disk array data - they haven't even chosen
>an OS and are not sure where to put their web server (and
>no mention of an app server tier!).
It might be a real project, but it has a feel of irreality. I
can not tell if it is wishful thinking or just a h
Geoff Muldoon wrote:
Jerry Stuckle says...
The server would run Linux or one of the BSD variant
You also missed DB2, SQL Server and several others.
Scrap MSSQL Server as a candidate given the above O/S requirement.
The OS should be picked based on the requirements of the database and
rest
Serge Rielau wrote:
Matthias Hoys wrote:
Should you choose an open-source, make sure your code AND your DDL
uses as much ANSI standards as possible so when you do need to move
to something else, it won't be as painful. (auto-incrementing columns
vs. sequences etc...).
I really wouldn't go fo
hpuxrac wrote:
On Feb 16, 1:09 am, pg wrote:
I am involved with a SQL server project. The server would be used in a
very heavy duty environment, with hundreds of thousands, if not
millions of database enquiries per minutes.
The server would run Linux or one of the BSD variant, with at least
32
"Geoff Muldoon" wrote in message
news:mpg.2404902b6db30900989...@news.x-privat.org...
Jerry Stuckle says...
pg wrote:
> The server would run Linux or one of the BSD variant
You also missed DB2, SQL Server and several others.
Scrap MSSQL Server as a candidate given the above O/S requir
In article , Jerry Stuckle says...
> Geoff Muldoon wrote:
> > Jerry Stuckle says...
> >> pg wrote:
> >
> >>> The server would run Linux or one of the BSD variant
> >
> >> You also missed DB2, SQL Server and several others.
> >
> > Scrap MSSQL Server as a candidate given the above O/S requirement
Geoff Muldoon wrote:
Jerry Stuckle says...
pg wrote:
The server would run Linux or one of the BSD variant
You also missed DB2, SQL Server and several others.
Scrap MSSQL Server as a candidate given the above O/S requirement.
Geoff M
Running 3 RHEL4 boxes in an Oracle RAC cluster, with
Matthias Hoys wrote on 16.02.2009 22:56:
Should you choose an open-source, make sure your code AND your DDL uses as
much ANSI standards as possible so when you do need to move to something
else, it won't be as painful. (auto-incrementing columns vs. sequences
etc...).
I really wouldn't go f
Matthias Hoys wrote:
Should you choose an open-source, make sure your code AND your DDL uses as
much ANSI standards as possible so when you do need to move to something
else, it won't be as painful. (auto-incrementing columns vs. sequences
etc...).
I really wouldn't go for database independen
On 16.02.2009 15:59, Walt wrote:
pg wrote:
I am involved with a SQL server project. The server would be used in a
very heavy duty environment, with hundreds of thousands, if not
millions of database enquiries per minutes.
The server would run Linux or one of the BSD variant, with at least
32GB
>
> Should you choose an open-source, make sure your code AND your DDL uses as
> much ANSI standards as possible so when you do need to move to something
> else, it won't be as painful. (auto-incrementing columns vs. sequences
> etc...).
I really wouldn't go for database independence ... Choos
Paulie wrote:
On Feb 16, 6:09 am, pg wrote:
I am involved with a SQL server project. The server would be used in a
very heavy duty environment, with hundreds of thousands, if not
millions of database enquiries per minutes.
Perhaps you should clarify here - what exactly do you mean by
milli
Jerry Stuckle says...
> pg wrote:
> > The server would run Linux or one of the BSD variant
> You also missed DB2, SQL Server and several others.
Scrap MSSQL Server as a candidate given the above O/S requirement.
Geoff M
Running 3 RHEL4 boxes in an Oracle RAC cluster, with web interfaces
(RHEL
On Feb 16, 6:09 am, pg wrote:
> I am involved with a SQL server project. The server would be used in a
> very heavy duty environment, with hundreds of thousands, if not
> millions of database enquiries per minutes.
Perhaps you should clarify here - what exactly do you mean by
millions of "dat
pg wrote:
PS. Although we prefer open-sourced programs, we definitely will pay
for it !!
No need to pay:
http://www.ibm.com/software/data/db2/express/
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Feb 15, 10:09 pm, pg wrote:
> I am involved with a SQL server project. The server would be used in a
> very heavy duty environment, with hundreds of thousands, if not
> millions of database enquiries per minutes.
>
> The server would run Linux or one of the BSD variant, with at least
> 32GB of
Mike Christensen wrote:
I have well over 50 gigs free on that drive.. I doubt it.
out of inodes.
Scott Marlowe wrote:
On Wed, Feb 18, 2009 at 1:39 PM, Mike Christensen wrote:
Hi all -
ERROR: could not extend relation 1663/41130/41177: No space left on device
HINT: Check free disk sp
1.5 GB RAM, Pentium dual core, single 80 GB disk, Windows XP sp3, PostgreSQL
8.3.6
a table is like following:
-- Table: accgroups
-- DROP TABLE accgroups;
CREATE TABLE accgroups
(
accgroupid serial NOT NULL,
accgroupidname character varying(150) NOT NULL DEFAULT ''::character
varying,
accgr
Tom Lane wrote:
"Brent Wood" writes:
Perhaps \o+ as a future fix for this?
I'd prefer "\o >>file" but maybe I'm too steeped in unix-isms.
regards, tom lane
+1
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safet
Harald Armin Massa wrote:
> postgres=# \pset format wrapped
> Ausgabeformat ist ?wrapped?.
> postgres=# \l
> Liste der Datenbanken
>Name| Eigent?mer | Kodierung |Collation| Ctype |
> Zug
> riffsrechte
> ---++
No difference at all. Line breaks are exactly as on screen (looks more
crazy in email with non-fixed-with font)
But really, linebreak betwwen "Zug" and "riffsrechte", and cutting
between "=c/pos" and "tgres"
postgres=# \l
Liste der Datenbanken
Name| Eige
I am using PG on windows for development. While testing some queries I found
that updates are much slower as compared to other database systems. (On
avarage MySQL updates 4-5 times faster than PG in a single unique index on
primary key) Why?
Another thing that I noticed is when any single column in
Harald Armin Massa wrote:
> Hello,
>
> testing / using PostgreSQL 8.4, I queried the list of databases via
>
> \l in psql
>
> I get information about name, owner, coding, Collation, Ctype and
> access rights. Which wraps right in the middle of "ctype", as
> collation and ctype both are "German,
Jasen Betts wrote:
On 2009-02-10, Jonathan Vanasco wrote:
does anyone know what to use in pg_hba.conf that will allow me to run cronjobs
with pg_dump?
i think i just need a METHOD for localhost only.
write a script that sets PGPASSWORD and then calls pg_dump,
use .pgconf,
or use trus
On 2009-02-12, SHARMILA JOTHIRAJAH wrote:
>
> Im not using this for loading postgres data to postgres.
> Im trying this method to load my Oracle data to postgresql tables
> just trying to migrate my data from oracle to postgresql
dump as CSV, properly implemented CSV isn't daunted by , " or
Hello,
testing / using PostgreSQL 8.4, I queried the list of databases via
\l in psql
I get information about name, owner, coding, Collation, Ctype and
access rights. Which wraps right in the middle of "ctype", as
collation and ctype both are "German, Germany"
As a result: this basic informati
On 2009-02-12, SHARMILA JOTHIRAJAH wrote:
> --0-1509090113-1234471898=:21817
> Content-Type: text/plain; charset=iso-8859-1
> Content-Transfer-Encoding: quoted-printable
>
> My data fields contains commas, tabs,'|'=A0 etc. So I cant use them as del=
> imiters..so I need a unique may be non-charact
On 2009-02-10, Jonathan Vanasco wrote:
> does anyone know what to use in pg_hba.conf that will allow me to run
> cronjobs
> with pg_dump?
> i think i just need a METHOD for localhost only.
write a script that sets PGPASSWORD and then calls pg_dump,
use .pgconf,
or use trust or ident authenticat
On 2009-02-10, Iñigo Barandiaran wrote:
>
> Thanks Raymon.
>
> I'm using Windows XP.
>
> What does "visible to the script" means?
means doing it right instead of wrong.
for a targeted explanation post example code.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On 2009-02-10, Inigo Barandiaran wrote:
>
> Hi.
>
> I would like to create an script that includes calls to createdb.exe and
> psql.exe. I would like to use them with a user but without asking or
> prompting for pasword. For example:
> createdb.exe -T template0 -U MyPosgresUser MyDataBaseName.
>
On Thu, 19 Feb 2009, Igor Katson wrote:
A. Kretschmer wrote:
In response to Igor Katson :
I think I need a built-in function to make a column from an array, like in
the backwards operation SELECT ARRAY(column)
By David Fetter:
CREATE OR REPLACE FUNCTION unnest(ANYARRAY) RETURNS SETOF ANY
On 2009-02-18, Tom Lane wrote:
> John R Pierce writes:
>> Tom Lane wrote:
>>> "Brent Wood" writes:
Perhaps \o+ as a future fix for this?
>
>>> I'd prefer "\o >>file" but maybe I'm too steeped in unix-isms.
>
>> \o+ is reasonably consistent with the other \ command usages...
>
> Not really;
A. Kretschmer wrote:
In response to Igor Katson :
I think I need a built-in function to make a column from an array, like
in the backwards operation SELECT ARRAY(column)
By David Fetter:
CREATE OR REPLACE FUNCTION unnest(ANYARRAY) RETURNS SETOF ANYELEMENT
LANGUAGE SQL AS $$SELECT $1[i
Top of my list would be:
1. Inability to do a PITR for a single database in a cluster.
2. Lack of support for Large Objects in master-slave replication.
3. Queries that I write are not corrected by postgres ;)
One last thing - it peeves me that many of the people on the forums are
so bloody cle
I would assume if the account the service is running under has limited
disk space, it won't really matter what OS you're running under.
Postgres will throw an "out of disk space" error.
The problem for me is I was in the middle of a transaction which
inserted about 50,000 rows into a table, a
In response to Igor Katson :
> I think I need a built-in function to make a column from an array, like
> in the backwards operation SELECT ARRAY(column)
By David Fetter:
CREATE OR REPLACE FUNCTION unnest(ANYARRAY) RETURNS SETOF ANYELEMENT
LANGUAGE SQL AS $$SELECT $1[i] FROM
generate_series(array
On Thu, Feb 19, 2009 at 3:11 AM, Mike Christensen wrote:
> Actually I'm writing emails on my Mac
>
> However, the Postgres service is running on my Windows 2003 machine..
>
> The disk space issue turned out to be a disk quota which was easy to solve.
> Unfortunately, the fact it crashed Postgres
For each element in the array, I need to make some operation with plpgsql.
I usually use the syntax:
DECLARE
array_len int;
BEGIN
array_len := array_upper(i_array, 1);
FOR i IN 1 .. array_len
LOOP
SOME OPERATION (i_array[i])
END LOOP;
But I don't like that. Is there any built-in way to
1 - 100 of 111 matches
Mail list logo
