On Wednesday 29 July 2009, Tim Uckun wrote:
>
> What is the issue here? Some sort of a timezone problem? How do I tell
> it what time zone to use?
>
> Thanks.
cron runs programs in a very limited environment. Things like TZ etc. are
usually not set. To see what your cron sets, just run a shell
On Friday 19 June 2009, Scott Marlowe wrote:
> On Fri, Jun 19, 2009 at 8:43 PM, Miguel
>
> Miranda wrote:
> > Well, i just didnt explain in detail, what i have is just the 16897
> > directory where i was storing the database, i tried just copying the
> > files but it didnt work,
> > should it be p
On Saturday 29 November 2008, Andrus wrote:
> How to create automated backup script in Gentoo which in every night 3:00
> PM backups one database and sends backup
> with ftp using unique file name?
>
> In windows I can use scheduler and script
>
> set FILENAME=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%MyDb
On Saturday 08 November 2008, Michelle Konzack wrote:
> Am 2008-11-08 19:07:35, schrieb Scott Marlowe:
> > No, your histrionics aside, it's the way this list works by default,
> > and for good reason. If you need it to work differently, there's a
> > setting which has been pointed out to you at t
> I have been testing it a bit performance-wise, and the numbers are
> worrying. In my test, MySQL (using InnoDB) had a 40% lead in
> performance, but I'm unsure whether this is indicative for PostgreSQL
> performance in general or perhaps a misconfiguration on my part.
In my experience the "numbe
On Sunday 07 September 2008, Gregory Stark wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> > I want to get a list looking like
> >
> > forum idthread_id post_id
> > 1 6 443
> > 2 9 123
> >
or maybe not and I'm just not getting it.
So here's the scenario:
I have 3 tables
forum: with primary key "id"
forum_thread: again primary key "id" and a foreign key "forum_id" referencing
th primary key of the forum table
forum_post: again primary key "id" with a forign key "thread_id" referen
On Sunday 31 August 2008, Christophe wrote:
> On Aug 31, 2008, at 7:44 PM, Guy Rouillier wrote:
> > CTOs/CIOs like to sleep at night.
>
> If you buy Oracle, and there's a problem, the conversation with the
> CEO is that "Oracle broke." With PG, even if you have exactly the
> same level of support
On Tuesday 26 February 2008, Kynn Jones wrote:
> Is there a simple way to copy a table from one database to another without
> generating an intermediate dump file?
> TIA!
>
> Kynn
pg_dump -t [table] [database] | psql -U [remoteuser] -h [remotehost]
[remotedatabase]
comes to mind...
You can an
Thanks everyone.
This was exactly what I needed. I went with connectby as Dante recommended
and it works like a charm.
UC
--
Open Source Solutions 4U, LLC 1618 Kelly St
Phone: +1 707 568 3056 Santa Rosa, CA 95401
Cell: +1 650 302 2405 United States
Fax:+1 707
Ok, something I've been toying around with for a while.
Here's the scenario:
Imagine a blogging app.
I have a table for blogs with a blog_id (primary key)
and a table blog_comments also with a comment_id as primary key and a foreign
key holding the blog_id the post belongs to.
The comments table
pg_dump -x -O -s [databasename] > outfile.sql
HTH
Uwe
On Sunday 09 December 2007, Ted Byers wrote:
> Is there a way to tell pg_dump to just dump the SQL
> statements required to create the tables, sequences,
> indeces, keys, &c.? I DON'T need to restore or
> recreate things like users,
On Monday 03 December 2007, Tom Allison wrote:
> is there much of a difference in performance between a XEON, dual
> core from intel and a dual core AMD 64 CPU?
>
> I need a bit of an upgrade and am not sure which, if any, have a
> significant advantage for postgres databases.
>
Personally I've ne
I haven't tried it with a view yet - so this may or may not work. But try
giving it a shot by declaring a view
create view vmovies as
select movie_id,movie_text from movies
and let your function return setof vmovies
Maybe that works - I think it should.
Uwe
On Wednesday 12 September 2007, C
Why do you create an extra type for that?
Just have your method return "movies"
i.e.
CREATE FUNCTION get_movies ()
RETURNS SETOF movies
...
...
HTH
Uwe
On Wednesday 12 September 2007, Cultural Sublimation wrote:
> Hi,
>
> I am not sure if this qualifies as a bug report or a feature request,
>
On Saturday 07 July 2007, Lew wrote:
> So if your RDBMS sorts NULLs after all other values, then from
>
> >> select start_date from show_date
> >> order by
> >> case when start_date > CURRENT_DATE then start_date end desc,
> >> case when start_date <= CURRENT_DATE then start_date end asc;
>
>
On Saturday 16 June 2007, John Smith wrote:
> guys,
> love both tools but php @ 2.5 *billion* google results is far more
> popular than postgresql @ 25 million google results. *if* somebody's
> gotto adapt it's not php. php does what it does best in a way that
> stuffy academics don't get.
Mhhh -
usually contrib is installed along with postgresql.
Look for
/usr/lib/pgsql/contrib or /usr/lib/postgresql/contrib
and maybe it resides in
/usr/share/pgsql/contrib
or just type
locate contrib
Uwe
On Thursday 17 May 2007, ABHANG RANE wrote:
> Hi,
> I have installed postgresql 8.2 on redhat ent
Yes it will. Everything INSIDE ONE transaction is visible to that exact
transaction. So in your scenario the val1 from the select will see what was
inserted - just any other transaction won't unless the current one is
committed.
Uwe
On Wednesday 09 May 2007, Harpreet Dhaliwal wrote:
> Hi,
>
Thanks Stuart.
I somehow overlooked it all the time. In the end I ran updatedb and locate :-)
Guess it's time to get some sleep.
Uwe
On Tuesday 13 March 2007 22:40, Stuart Cooper wrote:
> > this may be a very stupid question. I've always used the source rpms for
> > new versions. However now I'm
Never mind.
Dumb me.
Uwe
On Tuesday 13 March 2007 22:17, Uwe C. Schroeder wrote:
> Hi everyone,
>
> this may be a very stupid question. I've always used the source rpms for
> new versions. However now I'm faced with a ubuntu server and I never used a
> non-rpm system.
Hi everyone,
this may be a very stupid question. I've always used the source rpms for new
versions. However now I'm faced with a ubuntu server and I never used a
non-rpm system.
Since there is no up-to-date postgresql package I grabbed the source for 8.1.8
and compiled/installed it.
So far so
Well, in very short terms: a "idle" transaction is not committed. This means,
when it's a writing transaction, that in the best case you have one or more
row locks blocking access to the updated/inserted rows and in the worst case
one or more table locks, which will block access to a table compl
I think you're better off to use the official documentation.
http://www.postgresql.org/docs/
(chose the docs for the version you're running on the right side of that
page).
The docs you're currently referencing are for 7.0 - which is stone-age
postgresql.
On Wednesday 20 December 2006 11:57, B
On Monday 27 November 2006 02:38, Weerts, Jan wrote:
> Hi all!
>
> [EMAIL PROTECTED] wrote:
> > On Friday 24 November 2006 12:56, ben short wrote:
> >> I have a postgresql server setup on a Solaris 10 box. I can
> >> connect to the db via psql from the local machine. What I have
> >> been trying to
On Friday 24 November 2006 12:56, ben short wrote:
> Hi,
>
> I have a postgresql server setup on a Solaris 10 box. I can connect to
> the db via psql from the local machine. What I have been trying to do
> it connect with pgAdmin from my workstation. I have setup the tunnel
> correctly, local port
On Tuesday 07 November 2006 10:55, km wrote:
> > > Is it possible in a PLSQL function to call an external program/script
> > > residing at /usr/bin and return the result ?
> >
> > No, because plsql is a trusted language.
> > You can't run external commands from such a language.
>
> Is that a decid
On Thursday 02 November 2006 00:59, Richard Huxton wrote:
> Uwe C. Schroeder wrote:
> >> Ah, times and dates are wonderful things though. For example, '23:59:60'
> >> is a valid time (and not equal to 24:00:00 or 00:00:00) every so often.
> >>
>
On Thursday 02 November 2006 00:16, Richard Huxton wrote:
> Uwe C. Schroeder wrote:
> > why don't you just use < '00:00:00'::time
> > and avoid the issue?
> >
> > IMHO there shouldn't even be a 24:00:00, because that would imply that
> > th
why don't you just use < '00:00:00'::time
and avoid the issue?
IMHO there shouldn't even be a 24:00:00, because that would imply that there
is a 24:00:01 - which there is not.
It should go from 23:59 to 00:00
But then, I didn't write the spec for time in general, so maybe there is a
24:00 which
On Sunday 22 October 2006 12:32, Volkan YAZICI wrote:
> On Oct 20 05:07, [EMAIL PROTECTED] wrote:
> > I'm concerned about whether the usual parameter escaping mechanism is
> > enough in a LIKE or regular expression search.
> >
> > I run a recent Postgres version and use the Python connector psycopg
For your immediate needs I'd recommend slony.
It's a quite reliable replication solution that works quite nicely.
It will sync the replica in nearly real-time and you won't have any
transactional problems either.
Uwe
On Friday 20 October 2006 21:22, Tobias Brox wrote:
> I would eventually like
do a "ps -ef | grep transact"
and look for "idle in transaction" postmaster processes.
If you're certain that nobody else is running that transaction (i.e. nobody on
the system or the process with the idle transaction has been sitting there
for a while and normally the application doesn't have l
On Friday 13 October 2006 01:22, Martijn van Oosterhout wrote:
> > 1) I have a performance problem as I am trying to insert around 60
> > million rows to a table which is partitioned. So first I copied the
> > .csv file which contains data, with COPY command to a temp table
> > which was qu
On Wednesday 11 October 2006 10:42, A. Kretschmer wrote:
> am Wed, dem 11.10.2006, um 12:56:51 -0400 mailte Tom Lane folgendes:
> > Andreas Kretschmer <[EMAIL PROTECTED]> writes:
> > > Joe Kramer <[EMAIL PROTECTED]> schrieb:
> > >> I want to get:
> > >> item_id | last_update
> > >> ---
Well, you cast all those fields to be concatenated to text. Why should the db
make a varchar out of that? I seriously doubt that 7.x made a varchar of that
- but then, 7.2 is very very old.
So either cast your fields to varchar (i.e. c.refullname::varchar ||
d.enname::varchar) or cast the result
On Sunday 02 July 2006 01:42, Tino Wildenhain wrote:
> Uwe C. Schroeder wrote:
> > You can technically just copy & paste the postgresql data directory IF
> > YOU SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for
> > the same version of postgresql. Als
You can technically just copy & paste the postgresql data directory IF YOU
SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for the
same version of postgresql. Also: this is not a good way to do it and I'd
encourage you not to use this as general means of backup (it's ok if you
Hope nobody minds a job offer.
We have developed an application for the insurance market that is based on:
wxPython for the GUI
twisted pb as network layer
certainly python :-)
reportlab/OpenOffice/pyUno for printing
zope/plone as alternative web interface.
the database backend is postgresql.
On Thursday 30 March 2006 21:27, Tom Lane wrote:
> Chris <[EMAIL PROTECTED]> writes:
> > kurt _ wrote:
> >> My question: Is a text field just a varchar(Integer.MAX_VALUE)?
> >
> > varchar has a max of 255 characters,
>
> You must be using some other database ;-)
>
> The current Postgres code has a
There is the earthdistance package in the contrib directory. You may want to
look into that.
On Wednesday 08 March 2006 09:10, [EMAIL PROTECTED] wrote:
> I have the lat and long data. I have created the geom column based on the
> lat and long data as below.
>
>
> UPDATE property SET geom =Ge
As long as the SQL standard is supported, support for the "ancient" syntax
shouldn't be removed - at least not without a very long period of transition.
Do you have any idea how many applications the removal of something simple
like the cast operator :: will break?
It's not difficult to write sta
AFAIK NULL is not a value according to SQL spec, so it doesn't match in a "not
in" clause (or any other value comparing clause for that matter, i.e. blabla
>= 10 will not match rows where blabla is null). Therefor I'd say the result
of 30 is correct.
If you want to see null results too you shou
On Wednesday 15 February 2006 18:49, Chris wrote:
> > And since MySQL already has got the upperhand in terms of marketing,
> > Oracle would buy MySQL to make it as the low-end alternative. Never mind
> > the lack/immature features in MySQL such as stored proc or trigger.
>
> Mysql 5 has stored pro
I don't think you have duplicate databases - that would be the first time I
heard that postgreSQL supports that.
Are you sure you didn't create the database with a name that just doesn't
print?
I.e. a simple
createdb test
works.
do another
createdb "test "
(note the space)
works too, but when
Depending on your keys neither.
Rather let the DB handle the resultset. count(*) is quite slow.
How about something like
select blablabla from _complex_query order by _key_ (optional DESC or ASC)
OFFSET xxx LIMIT 15
where your offset would be a parameter from the php side and is basically the
Probably because the notice you see is a notice from the database engine, not
from the driver.
You can however turn off those notices in postgresql.conf
On Monday 06 February 2006 14:30, Tyler MacDonald wrote:
> I'm using the DBD::Pg driver and i've specifically turned "PrintWarn" off,
> yet I
I bet donations to support the project are appreciated.
Other than that, the postgreSQL license is BSD - which basically means you can
do whatever you want, you just can't sue anyone if it's not working.
This has been answered a thousand times, so checking mailing list archives and
the FAQ shou
On Friday 27 January 2006 08:25, Aaron Colflesh wrote:
> Hello folks,
> I've run into a challenge that doesn't appear to have been discussed in
> the archives anywhere.
>
> I'm designing a database that users need to have the ability to
> customize some. They just need the ability to add extra fiel
I don't really know what you're trying to accomplish here, but dropping and
creating thousands of tables is never a good idea with any database system.
You can certainly do that, just don't expect any query to run at their best
performance. You'd need to at least do a vacuum before starting to qu
On Saturday 07 January 2006 13:50, Michael Trausch wrote:
> Mike wrote:
> > Hi,
> >
> > I am trying to make a website where scalability matters. In my quest to
> > make my website more scalable I broke down the following SQL statement:
> >
> > select * from customers limit 100
> >
> > to:
> >
> > s
Try
CREATE FUNCTION .
On Tuesday 27 December 2005 09:41, Ted Byers wrote:
> I am puzzled. Can ayone explain why I get an error from Postgres on this
> simple stored procedure?
>
> The following is from the pgAdmin III History window:
> -- Executing query:
> CREATE PROCEDURE addEntity (
> f
the ctid seems to be the solution to my problem. I'm inserting the record in a
transaction so the ctid shouldn't change while the transaction isn't finished
(either rolled back or committed).
One question though. How would I get the ctid of the just inserted record. GET
DIAGNOSTICS only handles
On Thursday 01 December 2005 10:24, Jaime Casanova wrote:
> On 12/1/05, Uwe C. Schroeder <[EMAIL PROTECTED]> wrote:
> > Hi everyone,
> >
> > in 8.1 by default tables have no OID's anymore. Since OID's are 4 byte
> > it's probably a good idea to dis
Hi everyone,
in 8.1 by default tables have no OID's anymore. Since OID's are 4 byte it's
probably a good idea to discourage the use of them (they produced a lot of
trouble in the past anyways, particularly with backup/restores etc)
Now there's the issue with stored procs. A usual construct wou
How about reading the docs?
http://www.postgresql.org/docs/8.1/interactive/server-programming.html
is the chapter about stored procs
On Tuesday 29 November 2005 09:12, Brandon E Hofmann wrote:
> Does PostgreSQL include Stored Procedures supporting the CREATE PROCEDURE
> syntax. I notice pgAdmin
one full row - NOT two or more rows.
On Thursday 10 November 2005 17:23, Bob Pawley wrote:
> By 'one record' do you mean one full row or one column of one row??
>
> Bob
>
> - Original Message -
> From: "Uwe C. Schroeder" <[EMAIL PROTECTED]>
SELECT INTO
tries to create table
See: http://www.postgresql.org/docs/8.0/interactive/sql-selectinto.html
Why do you do the select into anyways? It does nothing.
If you try to update table pipe with the select result you have the wrong
command.
UC
On Thursday 10 November 2005 14:24,
if not found then
raise exception 'error creating record';
end if;
end loop;
return NULL;
END;
On Thursday 10 November 2005 15:56, Bob Pawley wrote:
> Thank you - what is the correct command???
>
> Bob
>
> - Original Message -
> From: &qu
how about using 2 tables with according unique/primary key constraints and a
view to actually access the data (mixing the 2 tables into one) ?
On Saturday 08 October 2005 22:36, Miles Keaton wrote:
> I'm stuck on a brain-teaser with CONSTRAINT:
>
> Imagine a table like "lineitems" in a bookstor
On Saturday 08 October 2005 21:07, Chris Browne wrote:
> [EMAIL PROTECTED] ("Uwe C. Schroeder") writes:
> > Didn't MySQL AB acquire SAPdb (which was Adabas D before)? AFAIK
> > (and you're welcome to correct me since I might very well be wrong)
> > SAPdb s
On Saturday 08 October 2005 17:35, Chris Browne wrote:
> [EMAIL PROTECTED] writes:
> > On Sat, Oct 08, 2005 at 10:31:30AM -0500, Scott Marlowe wrote:
> >> What it comes down to is this. MySQL is dual licensed. You can use
> >> the GPL version, or the commercial version. In order to sell the
> >>
On Wednesday 05 October 2005 07:37, L van der Walt wrote:
> Berend Tober wrote:
> > L van der Walt wrote:
> >> I would like to secure Postgres completly.
> >>
> >> Some issues that I don't know you to fix:
> >> 1. User postgres can use psql (...) to do anything.
> >> 2. User root can su to postgr
First of all: Happy Independence Day.
I've got a quick question for those with tsearch2 experience.
I set tsearch2 up and it works great (although I'd like to search for phrases
too, but I guess that's not supported at this time).
Anyways, I noted that the search seems to be case sensitive for s
I've solved this for my case in 7.4 by defining a view with the desired column
layout and the return setof the view. This certainly depends on what you're
trying to accomplish.
On Thursday 30 June 2005 09:21 am, Jason Tesser wrote:
> Can this return multiples? I thought when you dfined columns
point(''|| zc.longw
||'',''||zc.latn||''),point(z.longw, z.latn))::int <= ''||maxdistance ;
hope that helps
UC
On Monday 27 June 2005 02:08 am, you wrote:
> Uwe C. Schroeder wrote:
> >in the where clause use something like (re
in the where clause use something like (requires the earthdistance contrib to
be installed):
geo_distance(point([origin longitude],[origin latitude]),point([target
longitude column],[target latitude column])))::int <= 50
On Sunday 26 June 2005 04:40 pm, CSN wrote:
> If I have a table of items
Not quite correct. TCP needs to be turned on AND an according entry in
pg_hba.conf needs to be set up - otherwise the server will just decline to
talk to the client.
Also - if you're on XP you might want to check the "firewall" settings - which
if configured wrong could potentially block connec
On Wednesday 27 April 2005 15:17, Doug McNaught wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> > Is this just me or did anyone actually think about adding a UPS to
> > the machine and monitor it with NUT ? That way the machine would
> > shut down
Is this just me or did anyone actually think about adding a UPS to the machine
and monitor it with NUT ?
That way the machine would shut down properly, making the whole stale pid-file
issue irrelevant.
UC
On Wednesday 27 April 2005 13:41, Tom Lane wrote:
> Philip Hallstrom <[EMAIL PROTECTED]>
Well, you overlook one thing there. SUN has always has a really good I/O
performance - something far from negligible for a database application.
A lot of the PC systems lack that kind of I/O thruput.
Just compare a simple P4 with ATAPI drives to the same P4 with 320 SCSI drives
- the speed differ
On Monday 18 April 2005 12:16, Leif B. Kristensen wrote:
> On Monday 18 April 2005 21:07, Gavin M. Roy wrote:
> > Thank you for posting to a better list for these questions. Check
> > your postgresql.conf file and make sure it's accepting TCP/IP
> > connections on the IP you're looking for. If yo
have you enabled tcp in postgresql.conf ?
the parameter in question is pretty much on top of the file and should read
tcpip_socket = true
usually postgresql.conf is in /var/lib/pgsql/data/
on a RH system
UC
On Monday 18 April 2005 11:55, ElayaRaja S wrote:
> Hi,
> I am using Redhat linux 9. i
Don't see a problem pasting this one.
Neither to a local nor to a remote ssh (running psql certainly).
This is 7.4.7 on redhat and mandrake linux'es
I'd suspect it has nothing to do with psql. Can you paste that into a normal
ssh / terminal ?
On Thursday 14 April 2005 20:05, Joseph Shraibman w
ay 08 March 2005 09:02 pm, Edwin New wrote:
> I don't want to split hairs, but wasn't Firebird originally Interbase? If
> so, you'll find it was originally a *nix product before it was a Windows
> database (back in the Ashton-Tate days for those with long memories).
>
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 08 March 2005 07:24 pm, Tope Akinniyi wrote:
> Hi,
>
> I am wondering at this display of extreme Linux mentality being displayed
> by the 'top bras' of the PostgreSQL community. And I ask, are we
> encouraging Windows use of PostgreSQL at a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You missed something obvious. Executing this query in psql you have no
problem, because there is no structure created from the result. A view
behaves like a table - try creating a table like
create table blah (
id int,
id int
);
and you'll hit the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Maybe it's to late for me to think correctly (actually I'm sure of that). I'm
going to ask anyways.
I have a table like
id int4
user_id int4
photo varchar
image_type char(1)
where image_type is either G or X
What I want to do is have ONE query that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Although with your very little load a manual or cron based vacuum full once a
week will be more than enough.
I'm doing a biweekly vacuum full with one of my customer's machines (an
office application that uses pg as backend) and never had complaint
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
check out slony. works great
On Tuesday 21 December 2004 08:56 pm, Jamie Deppeler wrote:
> Can anyone suggest good open source replicator system for pgsql
>
> Thanks
> JD
>
> ---(end of broadcast)---
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 28 November 2004 10:49 pm, Greg Stark wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> > I could create a view for every node in the system which calculates the
> > distance in the result set, m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 28 November 2004 10:43 pm, Michael Fuhr wrote:
> On Sun, Nov 28, 2004 at 06:41:50PM -0800, Uwe C. Schroeder wrote:
> > I need to search a lot of locations based on distance (simple zipcode
> > match based on longitude and lat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
a (maybe/probably) stupid idea just popped to my mind:
Problem:
I need to search a lot of locations based on distance (simple zipcode match
based on longitude and latitude). However I need to calculate the distance
between each of the nodes, s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 27 November 2004 02:59 am, Konstantin Danilov wrote:
> Hello List!
> Do you know how many times can JOIN be used in a query? How many JOINs does
> PostgreSQL support in ONE query?
>
I think you will run out of memory before hitting the lim
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 11 November 2004 10:23 am, Franco Bruno Borghesi wrote:
> I think the best way would be not to use a SERIAL field, but an INTEGER
> field and a sequence:
a "serial" is just a convenient shortcut to an int with an automatically
created seq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 11 November 2004 07:04 am, Terry Lee Tucker wrote:
> Greetings,
>
> Here is a simple question:
>
> Is it ok to put a unique index on the oid for my tables? We are in the
> process of moving from Progress Software to PostgreSQL. In the Progr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
option 1) use a stored procedure to create the record. Within a transaction
the last value function will return the correct last value, not the one of a
concurrent insert.
option 2) if you know that this user uses the same connection for all his
qu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks for your answers Greg & Vincent.
Although I solved the problem by a change of schema - I'm happy that I have
something to digest I didn't know before. One never learns enough ...
U.C.
On Saturday 06 November 2004 03:13 pm, Uw
y has 3 fields)
so now I do:
table2 (
uid int FK to table1,
luid int FK to table1,
is_in_table3 boolean,
is_in_table4 boolean,
.
)
this just needs a simple select with a join against table1.
UC
On Saturday 06 November 2004 03:13 pm, Uwe C. Schroeder wrote:
> Here's a questio
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Here's a question for the SQL guru's out there, which I've been trying to
solve for the last couple of hours. There's got to be a solution to this, but
somehow I can't find it.
Tables:
table1 (
uid int PK,
uname varchar(64)
)
tabl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There is no version of this library linked to a newer postgres version.
Symlinking libpq.so.3 to libpq.so.2 doesn't work with 7.4 anymore - at least
not here on my mandrake box.
I found no way to get this working except for compiling a libpq from a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 29 October 2004 08:42 am, C G wrote:
> Dear All,
>
> I have a simple join query
>
> SELECT c1 FROM t1
> INNER JOIN
> t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
^
Your join doesn't alias anything
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
log in as root and edit the file
/var/lib/pgsql/data/postgresql.conf
Right on the top there is a line
#tcpip_socket=true
make sure this line has no # in front (comment)
and see that it has "true" as the value.
Second check out pg_hba.conf
At the en
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 03 October 2004 10:21 am, Scott Marlowe wrote:
> On Sun, 2004-10-03 at 08:58, David Garamond wrote:
> > Am I correct to assume that SERIAL does not guarantee that a sequence
> > won't skip (e.g. one successful INSERT gets 32 and the next migh
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I wasn't able to get a usable answer by googling: Is there a way to create a
view on a table that converts rows to columns ?
Example:
I have a table
create table blah (
id int4 serial,
parentid int4,
pname varchar(64
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
has anyone encountered an error when running a slony_setup.pl generated script
to set up a master?
The problem I hit is that the xxid.v73.sql file aborts with the following
error:
Aug 10 20:57:57 ibserver postgres[9749]: [12] ERROR: parser:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Why don't you just use a simple shell script run via cron.hourly:
#!/bin/sh
cd /opt/backups
pg_dump -R -O -a -i -Umyuser mydatabase > db_backup`date +'%Y%m%d'`.sql
gzip --best *.sql
I'm using the above for a daily backup in /etc/cron.daily. Look at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'd say you need to install the postgresql-devel package if you're on a rpm
based system.
On Thursday 10 June 2004 02:20 pm, Vitaly Belman wrote:
> Hello pgsql-general,
>
> When I am running "make" I get the following:
> > gcc -O2 -fno-strict-alia
würde dann also bei einem Zugriff auf Nr.2 nicht
> wie gewünscht "testdaten2" löschen, sondern "testdaten3".
> Wenn sich die Nummern nicht verschieben würden, also die Tabelle so
> aussieht:
>
> Nr daten
> 1 testdaten1
> 3 testdaten3
> d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bastian,
die liste [EMAIL PROTECTED] is 99% in englisch. Deine Anfrage hat
wesentlich mehr Aussicht auf Erfolg wenn die sie in englisch stellst.
Zum Problem: kannst du die Datensätze nicht eindeutig identifizieren ? Um
erfolgreich einen Lock zu se
1 - 100 of 119 matches
Mail list logo
