> Sic Transit Gloria Mundi writes:
>> I would like to use Perl, DBI, and DBD::Pg on AIX. As I
>> understand it, I need a shared lib version of the client libs
>> for this.
>>
>> When building on AIX5.3 ML04 (powerpc_power5, 64 bit), it
>> seems only the static libraries are built. This seems
> Jasbinder Singh Bali <[EMAIL PROTECTED]> schrieb:
>> I'm writing a function in plpgsql and i need to do the following:
>>
>> I have a string in the following format.
>>
>> mail.yahoo.com
>>
>> In this string, i need to figure out the number of dots in it and
split the
>> string into two on las
On 5/9/07, Ashish Karalkar <[EMAIL PROTECTED]> wrote:
Hello All,
Hi,
Can anybody please point me to Advantages and Disadvantages
of using view
The most obvious advantage (for me, anyway) is to restrict which
columns a user can see in a table.
I'm sure there are others.
With Regards
Ashi
Kirk Wythers wrote:
>>> I am struggling to get a CASE WHEN statement to work within another
>>> CASE WHEN. Here is my original code:
>>>
>>> SELECT CASE WHEN w.station_id = site_near.station_id THEN w.obs_id
ELSE
>>> s.obs_id END AS obs_id, site_near.station_id, site_near.longname,
>>> w.year, w.d
Hello All,
Can anybody please point me to Advantages and Disadvantages of using view
With Regards
Ashish...
\echo will print contents of whatever follows
http://www.postgresql.org/docs/8.1/static/app-psql.html
M--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email
you can use
RAISE NOTICE 'i want to print % and %', var1,var2;
then run your function and click the MESSAGE tab at the bottom of your query
analyzer screen and you'll see sometime like
NOTICE: i want to print and wrote:
Hi,
I have a pl/pgsql in which i have to print various variable value
Hi,
I have a pl/pgsql in which i have to print various variable values during
the execution of the function to see
what values are getting populated inside those variables with due course of
time.
PRINT
doesn't work.
Can anyone tell me how to print these values??
Thanks,
~Harpreet
Hi,
I have a pl/pgsql in which i have to print various variable values during
the execution of the function to see
what values are getting populated inside those variables with due course of
time.
PRINT
doesn't work.
Can anyone tell me how to print these values??
Thanks,
~Harpreet
On Tue, 2007-05-08 at 17:35, Sean Murphy wrote:
> Scott Marlowe wrote:
> > Well, you could set it on individual workstations instead of on the
> > server. I.e. if you set tcp_keepalive on your workstation to 500, but
> > leave Wally and Dilbert set at the default 7200 then they'd still
> > timeou
Sean Murphy wrote:
Scott Marlowe wrote:
On Tue, 2007-05-08 at 15:59, Sean Murphy wrote:
Scott Marlowe wrote:
On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
Tom Lane wrote:
Sean Murphy <[EMAIL PROTECTED]> writes:
I'm WAY out of my depth here, but my impression, based on the
circumstances, i
Scott Marlowe wrote:
> On Tue, 2007-05-08 at 15:59, Sean Murphy wrote:
>> Scott Marlowe wrote:
>>> On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
Tom Lane wrote:
> Sean Murphy <[EMAIL PROTECTED]> writes:
>> I'm WAY out of my depth here, but my impression, based on the
>> circumsta
On Tue, 2007-05-08 at 15:59, Sean Murphy wrote:
> Scott Marlowe wrote:
> > On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
> >> Tom Lane wrote:
> >>> Sean Murphy <[EMAIL PROTECTED]> writes:
> I'm WAY out of my depth here, but my impression, based on the
> circumstances, is that there is s
Andreas wrote:
Hi,
I compiled the latest and greatest PG server on SUSE systems until now.
Now I want to stay with the "official" binaries of the Debian project
because I plan to evaluate if it is really that good for a server as
everybody is telling me.
It should get a server with only the m
Porell, Chris wrote:
Thanks for the info.
What, then, is the best way to achieve my goal of having a "standby" DB that
can be kept within 15 minutes or so in sync with the primary? periodic
pg_dump/restore? Unfortunately, I can't upgrade right now.
www.slony.info
-Original Message--
Thanks for the info.
What, then, is the best way to achieve my goal of having a "standby" DB that
can be kept within 15 minutes or so in sync with the primary? periodic
pg_dump/restore? Unfortunately, I can't upgrade right now.
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL P
Scott Marlowe wrote:
> On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
>> Tom Lane wrote:
>>> Sean Murphy <[EMAIL PROTECTED]> writes:
I'm WAY out of my depth here, but my impression, based on the
circumstances, is that there is some sort of an idle session timeout
kicking in (most li
So, I have a customer who just had their "pg_dump?
what's that?" moment after some broken software
managed to delete everything in a table.
But they do have filesystem level backups. It's running
on 7.4.something, and the tables contain just varchar,
text, integer and timestamp data. I'm going to
Porell, Chris wrote:
I am trying to bring up a disaster recovery database using a cold-copy of
the datafiles on a different machine. I've got all WAL files since this
copy was made. Is it possible to make a 7.4 DB apply the WALs to the DB
when I bring it up?
No, you need to be running >8.x.
I am trying to bring up a disaster recovery database using a cold-copy of
the datafiles on a different machine. I've got all WAL files since this
copy was made. Is it possible to make a 7.4 DB apply the WALs to the DB
when I bring it up?
Thanks!
Chris
-
On Tue, 2007-05-08 at 14:25, Scott Marlowe wrote:
> On Tue, 2007-05-08 at 14:04, MaRCeLO PeReiRA wrote:
> > Hi there,
> >
> > Actually my PostgreSQL server is running on a Athlon
> > XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard.
> >
> > I would like to buy a new server, could you please
> > giv
8 maj 2007 kl. 21.07 skrev Rich Shepard:
On Tue, 8 May 2007, Scott Marlowe wrote:
Is there a version of PostgreSql that can be embedded with an
application?
Nope, and it's not real likely to happen. Take a look at sqllite.
Yes, SQLite (http://www.sqlite.org/) is the way to go for
em
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/08/07 14:04, MaRCeLO PeReiRA wrote:
> Hi there,
>
> Actually my PostgreSQL server is running on a Athlon
> XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard.
>
> I would like to buy a new server, could you please
> give me some information about t
On Tue, 2007-05-08 at 14:04, MaRCeLO PeReiRA wrote:
> Hi there,
>
> Actually my PostgreSQL server is running on a Athlon
> XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard.
>
> I would like to buy a new server, could you please
> give me some information about the specs??
>
> Is it important to ha
Hi there,
Actually my PostgreSQL server is running on a Athlon
XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard.
I would like to buy a new server, could you please
give me some information about the specs??
Is it important to have a Dual (or even Quad)
processor??? Will PostgreSQL use them??
What
On Tue, 8 May 2007, Scott Marlowe wrote:
Is there a version of PostgreSql that can be embedded with an
application?
Nope, and it's not real likely to happen. Take a look at sqllite.
Yes, SQLite (http://www.sqlite.org/) is the way to go for embedded RDBMS.
Syntax is close to that of postg
On Tue, 2007-05-08 at 13:26, Austin Winstanley wrote:
> Is there a version of PostgreSql that can be embedded with an
> application?
>
> I have a Mono application and when I deploy it, I would like to deploy
> a postgresql database with it, but embedded, so the end user doesn't
> have to install p
Austin Winstanley schrieb:
Is there a version of PostgreSql that can be embedded with an application?
I have a Mono application and when I deploy it, I would like to deploy a
postgresql database with it, but embedded, so the end user doesn't have
to install postgresql seperately. Is this possi
On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
> Tom Lane wrote:
> > Sean Murphy <[EMAIL PROTECTED]> writes:
> >> I'm WAY out of my depth here, but my impression, based on the
> >> circumstances, is that there is some sort of an idle session timeout
> >> kicking in (most likely on the client side)
Is there a version of PostgreSql that can be embedded with an application?
I have a Mono application and when I deploy it, I would like to deploy a
postgresql database with it, but embedded, so the end user doesn't have to
install postgresql seperately. Is this possible?
--
Thanks,
Austin Winsta
On Tue, 2007-05-08 at 13:21 +0100, Anoo Pillai wrote:
> Hi,
>
> How to get the time at which the previous REINDEX command was run?
>
I don't think that information is explicitly stored. You can log
statements like that and that might help in the future.
If you really need to know, a REINDEX
On Tue, 2007-05-08 at 18:09 +0200, Andreas wrote:
> Hi,
>
> I compiled the latest and greatest PG server on SUSE systems until now.
>
> Now I want to stay with the "official" binaries of the Debian project
> because I plan to evaluate if it is really that good for a server as
> everybody is tel
On Tue, 2007-05-08 at 13:24 -0400, Merlin Moncure wrote:
> On 5/8/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
> > On Tue, 2007-05-08 at 08:47 +0200, Albe Laurenz wrote:
> > > > The docs recommend using tar to perform a base backup for PITR.
> > > >
> > > > Usually, tar reports notices like:
> > > > "
Tom Lane wrote:
> Sean Murphy <[EMAIL PROTECTED]> writes:
>> I'm WAY out of my depth here, but my impression, based on the
>> circumstances, is that there is some sort of an idle session timeout
>> kicking in (most likely on the client side) and dropping the connection.
>
> There's no such timeout
On 5/8/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
On Tue, 2007-05-08 at 08:47 +0200, Albe Laurenz wrote:
> > The docs recommend using tar to perform a base backup for PITR.
> >
> > Usually, tar reports notices like:
> > "tar: Truncated write; file may have grown while being archived."
>
> Did you
On Tue, 2007-05-08 at 08:47 +0200, Albe Laurenz wrote:
> > The docs recommend using tar to perform a base backup for PITR.
> >
> > Usually, tar reports notices like:
> > "tar: Truncated write; file may have grown while being archived."
>
> Did you call pg_start_backup(text) before you started to
On Tue, 2007-05-08 at 10:25 -0500, Jim Nasby wrote:
> On May 7, 2007, at 1:58 PM, Jeff Davis wrote:
> > Second, it seems that it can cause a bad backup to occur if you
> > pass the
> > "z" option to tar. Instead, piping the output of tar through the
> > compression program seems to avoid that pro
Sean Murphy <[EMAIL PROTECTED]> writes:
> I'm WAY out of my depth here, but my impression, based on the
> circumstances, is that there is some sort of an idle session timeout
> kicking in (most likely on the client side) and dropping the connection.
There's no such timeout in the Postgres server,
Jasbinder Singh Bali <[EMAIL PROTECTED]> schrieb:
> Hi,
> I'm writing a function in plpgsql and i need to do the following:
>
> I have a string in the following format.
>
> _m_a_i_l_._y_a_h_o_o_._c_o_m
>
> In this string, i need to figure out the number of dots in it and split the
I've got a bunch of users on VB applications connecting to PG 8.2.3 via
psqlodbc with SSL. For a variety of reasons, some good, some probably
bad, I have the app open a connection and leave it open, using it as
needed to run queries back and forth.
If I look in my logs, I see loans of little clust
Hi,
I'm writing a function in plpgsql and i need to do the following:
I have a string in the following format.
mail.yahoo.com
In this string, i need to figure out the number of dots in it and split the
string into two
on last but one dot.
Is there any way to accomplish this.
Please let me know
Sic Transit Gloria Mundi <[EMAIL PROTECTED]> writes:
> I would like to use Perl, DBI, and DBD::Pg on AIX. As I understand it, I
> need a shared lib version of the client libs for this.
> When building on AIX5.3 ML04 (powerpc_power5, 64 bit), it seems only the
> static libraries are built. This
I use npgsql 1.0 to access a PostgreSql 8.2.3 database. Recently, I
decided to test with standard_conforming_strings = on and I noticed that
npgsql still sends double-backslashes, which corrupts the data.
This is especially bad with byte arrays: if I insert N bytes I get back
4*N bytes becaus
I would like to use Perl, DBI, and DBD::Pg on AIX. As I understand it, I need
a shared lib version of the client libs for this.
When building on AIX5.3 ML04 (powerpc_power5, 64 bit), it seems only the static
libraries are built. This seems true with either xlc (8.x) or gcc (3.3.2).
Everythi
Simon Riggs wrote:
then I updated the master with a batch of inserts, but after a while the
slave stopped with
these messages:
LOG: restored log file "00010021" from archive
LOG: record with zero length at 0/2148
LOG: invalid primary checkpoint record
LOG: restored log
Hi,
I compiled the latest and greatest PG server on SUSE systems until now.
Now I want to stay with the "official" binaries of the Debian project
because I plan to evaluate if it is really that good for a server as
everybody is telling me.
It should get a server with only the minimum of progra
"Andreas Schultz" <[EMAIL PROTECTED]> writes:
> MST is UTC-07, so i would expect that i can replace MST with UTC-07, but:
> # SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05' AT TIME
> ZONE 'UTC-07';
> timezone
> -
> 2001-02-17 08:38:40
> The time returned is at
On Mon, 2007-05-07 at 15:10 -0500, Thomas F. O'Connell wrote:
> I'm attempting to design a postgres system whereby an authoritative
> primary server simultaneously feeds continuous archives to a number of
> warm standby servers that live both on the local network and on remote
> networks.
> The s
On May 7, 2007, at 11:01 AM, Karsten Hilbert wrote:
On Mon, May 07, 2007 at 10:47:24AM -0500, Jim Nasby wrote:
GiST can also be useful if you have to query in multiple dimensions,
which can occur outside the normal case of geometry. Best example I
know of is a table containing duration informati
There are other ways to influence the selection of a seqscan, notably
effective_cache_size and random_page_cost.
First, you need to find out at what point a seqscan is actually
faster than an index scan. That's going to be a trial and error
search, but eventually if you're going back far en
On May 8, 2007, at 3:29 AM, PFC wrote:
Create a table which contains your list of loggers (since it's good
normalization anyway, you probably have it already) and have your
data table's logger_id REFERENCE it
BTW, you could do that dynamically with a subselect: (SELECT DISTINCT
logger_id F
Hi,
From the documentation:
# SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05' AT TIME ZONE 'MST';
timezone
-
2001-02-16 18:38:40
MST is UTC-07, so i would expect that i can replace MST with UTC-07, but:
# SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-
On May 8, 2007, at 2:02 AM, Albe Laurenz wrote:
Kirk Wythers wrote:
I am struggling to get a CASE WHEN statement to work within another
CASE WHEN. Here is my original code:
SELECT CASE WHEN w.station_id = site_near.station_id THEN w.obs_id
ELSE
s.obs_id END AS obs_id, site_near.station_id
On May 7, 2007, at 3:10 PM, Thomas F. O'Connell wrote:
I'm attempting to design a postgres system whereby an authoritative
primary server simultaneously feeds continuous archives to a number
of warm standby servers that live both on the local network and on
remote networks.
The sticking po
On May 7, 2007, at 1:58 PM, Jeff Davis wrote:
Second, it seems that it can cause a bad backup to occur if you
pass the
"z" option to tar. Instead, piping the output of tar through the
compression program seems to avoid that problem (i.e. "tar cf - ... |
gzip > ..."). I am using FreeBSD's tar, o
On Fri, May 04, 2007 at 08:54:10AM -0600, Joel Dice wrote:
>
> My next question is this: what are the dangers of turning fsync off in the
> context of a high-availablilty cluster using asynchronous replication?
My real question is why you want to turn it off. If you're using a
battery-backed ca
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> On Tue, May 08, 2007 at 02:14:54PM +0200, Felix Kater wrote:
>> There is *no complete* substitute for foreign keys by using *indexes*
>> since I'd loose the referencial integrity (whereas for unique contraints
>> there *is* a full replacement usi
Felix Kater <[EMAIL PROTECTED]> writes:
> where are the 'action code' (type char) of foreign keys defined for ON
> DELETE resp. ON UPDATE for the actions NO ACTION, RESTRICT, CASCADE, SET
> NULL, SET DEFAULT in pg_contraint?
Per the comment in pg_constraint.h:
/*
* Valid values for confupdtype a
On Tue, May 08, 2007 at 02:14:54PM +0200, Felix Kater wrote:
> If I get you right:
>
> There is *no complete* substitute for foreign keys by using *indexes*
> since I'd loose the referencial integrity (whereas for unique contraints
> there *is* a full replacement using indexes)?
A unique index is
Hi,
where are the 'action code' (type char) of foreign keys defined for ON
DELETE resp. ON UPDATE for the actions NO ACTION, RESTRICT, CASCADE, SET
NULL, SET DEFAULT in pg_contraint?
In the manual (8.2) it is mentioned but not explained.
Thank You
Felix
---(end of broadc
On Tue, 8 May 2007 14:19:12 +0200
Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> > I like to keep my pg interface small: Can I replace foreign keys by
> > using indexes somehow?
>
> Not while preserving the semantics.
I am not bound to indexes, however, wonder if foreign keys itself are
non-atomi
On 08/05/2007 13:14, Felix Kater wrote:
There is *no complete* substitute for foreign keys by using *indexes*
since I'd loose the referencial integrity (whereas for unique contraints
there *is* a full replacement using indexes)?
Here's my understandingan index is just that (an index) and n
Hi,
How to get the time at which the previous REINDEX command was run?
With Thanks in advance,
AnooS
Am Dienstag, 8. Mai 2007 13:32 schrieb Felix Kater:
> I like to keep my pg interface small: Can I replace foreign keys by
> using indexes somehow?
Not while preserving the semantics.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)--
On Tue, 08 May 2007 12:48:30 +0100
Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> You can do that, but you'll lose the enforcement of referential
> integrity, which is what foreign keys give you.
If I get you right:
There is *no complete* substitute for foreign keys by using *indexes*
since I'd
On 08/05/2007 12:32, Felix Kater wrote:
I like to keep my pg interface small: Can I replace foreign keys by
using indexes somehow? (This is at least possible for primary key
columns which can be replaced by suitable indexes.)
You can do that, but you'll lose the enforcement of referential
int
Hi,
I like to keep my pg interface small: Can I replace foreign keys by
using indexes somehow? (This is at least possible for primary key
columns which can be replaced by suitable indexes.)
Thank You
Felix
---(end of broadcast)---
TIP 1: if posting
Your a life saver :D
Thank you for the super fast anser
Manuel
On 5/8/07, Zoltan Boszormenyi <[EMAIL PROTECTED]> wrote:
Hi,
Manuel Preliteiro írta:
> Hello, i have installed postgresql version 8.1.4-1.1 in Fedora 6
I have the same system.
> Since I'm very Linux unexperienced I used yum for
Hi,
Manuel Preliteiro írta:
Hello, i have installed postgresql version 8.1.4-1.1 in Fedora 6
I have the same system.
Since I'm very Linux unexperienced I used yum for this purpose.
I have all the commands installed, liek createdb (under
/usr/bin/createdb witch is not the location specified
Just a final note:
Changing shmall did fix the problem. Thanks to everyone for the help.
the final working settings i used are:
kern.sysv.shmmax=4194304
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv.shmseg=8
kern.sysv.shmall=4194304
I'm wondering how I managed to get it to work before, witho
Hello, i have installed postgresql version 8.1.4-1.1 in Fedora 6
Since I'm very Linux unexperienced I used yum for this purpose.
I have all the commands installed, liek createdb (under /usr/bin/createdb
witch is not the location specified in the online manual), i also have the
psql "shell/interf
Thanks for a good answer, I'll try to find a workaround. The number of
data_loggers will change, but not to frequently. I was actually hoping
to make a view showing the latest data for each logger, maybe I can
manage that with a stored procedure thingy...
- Create a table which contains your
On Mon, May 07, 2007 at 05:31:02PM -0700, Ottavio Campana wrote:
> Hi, I'm trying to use tsearch2 for the first time and I'm having a
> problem setting up a query
>
> If I execute
>
> SELECT * from test_table where ts_desc @@ to_tsquery ('hello&world');
>
> it works, but I'm having the problem t
Kirk Wythers wrote:
> I am struggling to get a CASE WHEN statement to work within another
> CASE WHEN. Here is my original code:
>
> SELECT CASE WHEN w.station_id = site_near.station_id THEN w.obs_id
ELSE
> s.obs_id END AS obs_id, site_near.station_id, site_near.longname,
> w.year, w.doy, w.
74 matches
Mail list logo
