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.
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
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
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
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
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
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,
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
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
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
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)--
Hi,
How to get the time at which the previous REINDEX command was run?
With Thanks in advance,
AnooS
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
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
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, 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
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
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
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
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 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 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
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 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
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 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
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
"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
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
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
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
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
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
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
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
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
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,
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
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 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
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 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:
> > > > "
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: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
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 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)
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 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
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
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, 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
-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
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
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
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
-
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.
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
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
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
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--
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
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
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
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
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
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
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
\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
Hello All,
Can anybody please point me to Advantages and Disadvantages of using view
With Regards
Ashish...
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
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
> 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
> 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
74 matches
Mail list logo
