Alban Hertroys wrote on 03.04.2011 11:17:
On 2 Apr 2011, at 12:44, Thomas Kellerer wrote:
Even after a plain SELECT you should issue a COMMIT (or ROLLBACK)
to end the transaction that was implicitely started with the
SELECT.
Sorry, but you're wrong about that. A statement that implicitly
on 03.04.2011 11:17:
On 2 Apr 2011, at 12:44, Thomas Kellerer wrote:
Even after a plain SELECT you should issue a COMMIT (or ROLLBACK)
to end the transaction that was implicitely started with the
SELECT.
Sorry, but you're wrong about that. A statement that implicitly
starts a transaction also
Sven Haag wrote on 02.04.2011 12:13:
if i'm trying to add an additional column to a table in pgadmin
while
clients are logged in, pgadmin hangs. only if all cients are logged
out it returns to the normal state. according to our consultant of
the application this behavior doesn't appear in
Alex, 22.03.2011 17:33:
Using Windows 7 64 bit. Tried to install 8.4 and 9.0and it fails right near the
end when it tries to create or read the conf file. If I transfer my postgres
8.4 file over the upgrade takes but the postgres service doesn't exist so no
communication occurs.
Is there
Ruben Blanco wrote on 08.03.2011 00:30:
Hi:
Is there anyway to create a unique index or constraint on part of a column?
Something like this, but something that works ;-)
ALTER TABLE invoices
ADD CONSTRAINT cons UNIQUE (EXTRACT(YEAR FROM invoice_date),
innvoice_number);
Thanks for any
Ioana Danes, 02.03.2011 21:35:
Hi Everyone,
I would like to ask for your help finding a temporary solution for my problem.
I upgraded postgres from 8.3 to 9.0.3 and I have an issue with the order of the
returned rows.
The database is free to return rows in any order it thinks is most
Melvin Davidson, 22.02.2011 15:42:
I know a function can be used, but the point is to log a table
whenever someone else does a SELECT on it.
It cannot be depended on that a user will include that (or any
specific function in a SELECT. iow, when any user does SELECT ...
FROM tablex; then logging
Gavrina, Irina, 16.02.2011 15:50:
Hi,
On Unix systems Postgres process list can beaccessible through‘ps’ utility:
ps auxww | grep ^postgres
$ ps auxww | grep ^postgres
postgres 9600.01.16104 1480 pts/1SN 13:17
0:00 postmaster -i
postgres 963
Royce Ausburn wrote on 10.02.2011 22:38:
I'm really interested to hear how you guys manage schema upgrades in
the face of branches and upgrading from many different versions of
the database.
We are quite happy with Liquibase. You can simply run it against a database and tell it
to migrate it
Bill Moran wrote on 10.02.2011 23:59:
The overview:
You store your schema and data as XML (this is easy to migrate to, because
it includes a tool that makes the XML from a live database)
Keep your XML schema files in some RCS.
When it's time for a new deployment, you run the dbsteward tool
Bill Moran wrote on 11.02.2011 00:37:
Anyway ... based on nothing more than a quick scan of their quickstart
page, here are the differences I see:
* Liquibase is dependent on you creating changesets. I'm sure this
works, but we took a different approach with dbsteward. dbsteward
expects
Szymon Guz, 08.02.2011 09:30:
Hi, is there any noticeable difference between a cluster with many
databases and a database with many schemas?
I've got a quite huge database on Oracle with about 400 logically
disjoint schemas. I could import that into PostgreSQL as many
different databases, or as
Kevin Grittner wrote on 04.02.2011 23:27:
PL/pgSQL seems tantalizingly close to being useful for developing a
generalized trigger function for notifying the client of changes. I
don't know whether I'm missing something or whether we're missing a
potentially useful feature here. Does anyone see
Uwe Schroeder, 26.01.2011 08:34:
I have a query like this:
SELECT a,b,c, (select problem from other_table where id=a) as problem FROM
mytable WHERE a=1
So far so good. Actually problem always resolves to one record, so it's not
the multiple records returned problem.
What I try to do is this:
Jerry LeVan, 19.01.2011 17:35:
So I guess the question is:
Given a bare table name, how can I recover the schema
qualified name with whatever the current search path happens
to be?
SELECT table_schema
FROM information_schema.tables
WHERE table_name = 'your_table'
;
--
Sent via
Tom Lane, 19.01.2011 19:19:
SELECT table_schema
FROM information_schema.tables
WHERE table_name = 'your_table'
;
That's not going to work, at least not in the interesting case where you
have more than one candidate table --- that SELECT will list all of 'em.
Ah, right. I was a buit too
Tom Lane, 19.01.2011 19:19:
Given a bare table name, how can I recover the schema
qualified name with whatever the current search path happens
to be?
SELECT table_schema
FROM information_schema.tables
WHERE table_name = 'your_table'
;
That's not going to work, at least not in the
Tomas Vondra wrote on 16.01.2011 23:41:
Yes, locking may in some cases lead to deadlocks, that's true. For
example creating several invoices (for different days) in a single
transaction may lead to a deadlock. But that's a feature, not a bug.
Hmm, a single transaction cannot deadlock itself as
Satish Burnwal (sburnwal) wrote on 07.01.2011 11:15:
I have 2 tables containing the data for same items:
STORE1
-
Id typeitems
-
1 FOOD10
2 FOOD15
3 SOAP20
STORE2
Rich Shepard wrote on 07.01.2011 18:56:
The data type is VARCHAR(), not character varying[].
character varying is a synonym for varchar, so the definition character
varying[] is valid.
It defines an array of varchar and is equivalent to varchar[]
But I doubt that this is what the OP meant ;)
Andre Lopes wrote on 03.01.2011 12:11:
array(
'name' = 'Don',
'age' = '31'
);
array(
'name' = 'Peter',
'age' = '28',
'car' = 'ford',
'km' = '2000'
);
In a specific website search I will store only name and age, and
in other website I will store name, age,
gvim wrote on 27.12.2010 02:47:
If a table representing contact details can have 2 but no more than 2
email addresses is it really worth factoring-out email addresses to a
separate table.
If you are absolutely sure you will never have more than two, then I agree, you
don't need to create a
Filip Rembiałkowski, 22.12.2010 14:28:
INSERT INTO tbl SELECT 1, '2010-01-01', '2010-12-31';
INSERT 0 1
I'm curious why you use this syntax as you have fixed values and could use the
standard VALUES construct without problems:
INSERT INTO tbl VALUES (1, '2010-01-01', '2010-12-31');
Regards
Alexander Farber, 10.12.2010 12:02:
I'm preparing a PHP-script to be run as a nightly cronjob
and will first find the latest qdatetime stored in my local
PostgreSQL database and then just select in remote Oracle,
insert into the local PostgreSQL database in a loop.
But I wonder if there is
Alexander Farber, 10.12.2010 12:53:
On Fri, Dec 10, 2010 at 12:33 PM, Thomas Kellererspam_ea...@gmx.net wrote:
And I'm not sure how to copy the Oracle's strange DATE
column best into PostgreSQL, without losing precision?
Oracle's DATE includes a time part as well.
So simply use a timestamp
Alexander Farber, 24.11.2010 08:49:
Why do you want to do anything like that?
Easier to read... login, logout
I understand the easier to read part.
But what do you mean with login, logout?
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Grzegorz Jaśkiewicz, 24.11.2010 10:37:
just never use SELECT *, but always call columns by names. You'll
avoid having to depend on the order of columns, which is never
guaranteed, even if the table on disk is one order, the return columns
could be in some other.
I always try to convince people
Alexander Farber, 24.11.2010 08:42:
is there a syntax to add a column not at the last place
No, because the order of the column is irrelevant (just as there is no order on
the rows in a table)
Simply select them in the order you like to have.
Thomas
--
Sent via pgsql-general mailing list
Hi,
I'm curious why the following is not working:
c:\psql postgres postgres
psql (9.0.1)
Type help for help.
postgres=# select version();
version
-
PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 32-bit
Tom Lane wrote on 22.11.2010 19:25:
Thomas Kellererspam_ea...@gmx.net writes:
I'm curious why the following is not working:
postgres=# show client_encoding;
client_encoding
-
UTF8
(1 row)
postgres=# create table umlaut_test_ö (id integer);
ERROR: invalid byte
Tom Lane wrote on 22.11.2010 20:36:
I had the idea that the Windows version of psql was smart enough to
set client_encoding based on the console encoding it finds itself
running under, but I might be wrong about that. Or maybe you did
something that overrode its default?
I changed to chcp
Grant Mckenzie wrote on 20.11.2010 07:00:
How do people implement insert or upate ( otherwise known as upsert )
behaviour in postgres i.e. insert a row if it's key does not exist in
the database else update the existing row?
You can simply send the UPDATE, if nothing was updated, it's safe to
Peter Bex, 12.11.2010 08:36:
What can also work extremely well is storing the data in an array.
If you need to access the array based on more meaningful keys you could
store key/index pairs in another table.
The hstore module would also be a viable alternative - and it's indexable as
well.
Aram Fingal wrote on 11.11.2010 22:45:
I was thinking of reporting back to this forum with
advantages/disadvantages of each tool, as I see it, but realized that
I was rapidly getting too far off topic for a list focused
specifically on PostgreSQL.
I don't think this woul be off-topic here if
Alexander Farber, 08.11.2010 15:50:
And then I realized that I actually want
medals smallint default 0 check (medals= 0)
So I've dropped the old constraint with
alter table pref_users drop constraint pref_users_medals_check;
but how can I add the new contraint please? I'm trying:
Carlos Mennens, 02.11.2010 22:37:
Before I move or rename '/var/lib/postgres/data', what version of
PostgreSQL should I be at? 8.4 or 9.0?
Actually both, because pg_upgrade needs the binaries of the old *and* new
version.
--
Sent via pgsql-general mailing list
Adrian Klaver, 02.11.2010 23:23:
Before I move or rename '/var/lib/postgres/data', what version of
PostgreSQL should I be at? 8.4 or 9.0?
Actually both, because pg_upgrade needs the binaries of the old
*and* new version.
Part of the confusion Carlos is experiencing is that he is caught
Hello,
I have created a temporary table using
create temporary table foo
(
id integer
);
and noticed this was created in a schema called pg_temp_2
My question is:
is this always pg_temp_2?
Or will the name of the temp schema change?
If it isn't always the same, is there a way I can
Thom Brown wrote on 01.11.2010 12:33:
You can use:
SELECT nspname
FROM pg_namespace
WHERE oid = pg_my_temp_schema();
to get the name of the current temporary schema for your session.
Thanks that's what I was looking for.
Regards
Thomas
--
Sent via pgsql-general mailing list
Jonathan Tripathy wrote on 01.11.2010 20:53:
Hi Everyone,
I'm looking for the best solution for Hot Standbys where once the
primary server fails, the standby will take over and act just like
the master did. The standby must support INSERTS and UPDATES as well
(once the master has failed)
Are
Jonathan Tripathy wrote on 01.11.2010 21:12:
9.0 has streaming replication and Hot Standby
http://www.postgresql.org/docs/current/static/hot-standby.html
http://www.postgresql.org/docs/current/static/warm-standby.html#STREAMING-REPLICATION
But does that not only allow read-only things to
Merlin Moncure wrote on 01.11.2010 21:13:
On Mon, Nov 1, 2010 at 6:46 AM, Thomas Kellererspam_ea...@gmx.net wrote:
Hello,
I have created a temporary table using
create temporary table foo
(
id integer
);
and noticed this was created in a schema called pg_temp_2
My question is:
is this
Merlin Moncure wrote on 01.11.2010 23:13:
On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellererspam_ea...@gmx.net wrote:
The problem is, that the JDBC driver only returns information about the temp
tables, if I specify that schema directly.
Have you filed a bug report to jdbc yet? :-D.
I thought
Alexander Farber wrote on 31.10.2010 09:22:
Hello Postgres users,
to mimic the MySQL-REPLACE statement I need
to try to UPDATE a record and if that fails - INSERT it.
There is actually an example of this in the PG manual ;)
Tim Uckun, 21.10.2010 07:05:
No, it isn't. This is a three-way join between consolidated_urls, cu,
and tu --- the fact that cu is the same underlying table as
cu is an alias for consolidated_urls. tu is an alias for trending_urls.
There are only two tables in the query.
Yes, but
Alban Hertroys, 21.10.2010 13:43:
I'm currently using WebFOCUS at work and they have a LAST operator,
referring to the value a column had in the last returned row. That's
pretty good for stuff like this, so I wonder if it wouldn't be
beneficial to have something like that in Postgres?
Already
Carlos Mennens, 13.10.2010 20:06:
OK so I have read the docs and Google to try and find a way to add a
new column to an existing table. My problem is I need this new column
to be created 3rd rather than just dumping this new column to the end
of my table. I can't find anywhere how I can insert
Vorpal, 07.10.2010 02:53:
PostgreSQL was installed as part of other software.
The data folder is a subfolder of D:\Program Files\
Specifically:
D:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe runservice -w -N
pgsql-8.3 -D D:\Program Files\PostgreSQL\8.3\data\
For various reasons I would like
Thom Brown wrote on 04.10.2010 20:40:
Hi all,
We're currently testing a new javascript change on the PostgreSQL
docs. This is to make sure monospaced fonts still appear at a
reasonable size between browsers. I'd appreciate it if some of you
could do some browser testing.
Thom Brown wrote on 04.10.2010 23:24:
Do you see the reduction in size compared to the live site an issue?
No, not at all.
I just wanted to mention it, in case you are interested.
I think both sizes are just fine.
Regards
Thomas
--
Sent via pgsql-general mailing list
(This is the second time I send this, as the first message apparently did not
make it)
Dr. Peter Voigt, 30.09.2010 14:42:
If there are no other users out there with comparable problems I could
give the ZIP-installer a try under:
http://www.enterprisedb.com/products/pgbindownload.do
There is a
Hi,
I would like to suggest to enhance the documentation of the CREATE VIEW
statement.
I think the fact that a SELECT * is internally stored as the expanded column
list (valid at the time when the view was created) should be documented together with the
CREATE VIEW statement. Especially
Carlos Mennens wrote on 10.09.2010 17:53:
On Fri, Sep 10, 2010 at 11:33 AM, Richard Broersma
richard.broer...@gmail.com wrote:
I don't believe there is a script like this. However, I would say
that out of the box, PostgreSQL is so secure that some people cannot
figure out how to log in. :)
Jayadevan M, 30.08.2010 11:26:
Hello all,
Has any one worked with Jira on PostgreSQL?
We are considering Jira implementation for our organization (about 1500
users).
The question is - Jira on MySQL or Jira on PostgreSQL? Any
tips/suggestions are welcome. We do not have much expertise in either
Jayadevan M, 30.08.2010 12:13:
Our admin team just moved our Jira from MySQL to PostgreSQL, but I
can't recall the exact reasons anymore. So far we do not have any
problems (from an end-user perspective that is)
Thanks for the reply. We plan to use it for our helpdesk, expecting it
to be up
Mike Christensen, 27.08.2010 11:39:
Hi all -
I've noticed my log files for Postgres are getting way too big, since
every single SQL statement being run ends up in the log. However,
nothing I change in postgresql.conf seems to make a bit of
difference.. I've tried restarting postgres, deleting
Stefan Wild wrote on 15.08.2010 10:36:
column is numeric, but upper() works on text, and returns
text, so your
numeric column got casted to text by using upper (which is
pointless
anyway - there is no upper version of digits).
remove upper() and you'll be fine.
Thank you guys! That was the
Sandeep Srinivasa wrote on 09.08.2010 08:54:
The way I see it - for those who want to truly learn, there is the
documentation. For those who dont, there are ORMs.
Another of those ORM myths ;)
ORMs are not an alternative to learning SQL or understand how a DBMS works.
You need to be good at
Alban Hertroys wrote on 08.08.2010 10:46:
On 7 Aug 2010, at 23:18, Thomas Kellerer wrote:
Or as an alternative:
SELECT tid, purchase_date
FROM orders
WHERE item in ('Laptop', 'Desktop')
GROUP BY tid, purchase_date
HAVING count(*) = 2
This one is incorrect, it will also find people who
aravind chandu wrote on 07.08.2010 21:40:
Hello every one,
I have encountered a problem while working .I have a sample table with
the following data
*TID* *Date* *Item*
T1008/1/2010Laptop
T1008/1/2010Desktop
T1018/1/2010Laptop
T1028/1/2010
John Gage wrote on 06.08.2010 04:41:
But most people, including myself, don't even want to know the
documentation exists (for anything). We just want to plunge in and do it.
That just doesn't work and is an attitude that won't get you far.
In order to do things properly you need to learn and
Howard Rogers, 28.07.2010 03:58:
Thanks to some very helpful input here in earlier threads, I was
finally able to pull together a working prototype Full Text Search
'engine' on PostgreSQL and compare it directly to the way the
production Oracle Text works. The good news is that PostgreSQL is
Craig Ringer wrote on 17.07.2010 03:13:
On 17/07/10 04:26, Thomas Kellerer wrote:
Hmm.
For years I have been advocating to always use fully qualified column
lists in INSERTs (for clarity and stability)
And now I learn it's slower when I do so :(
If you're not doing hundreds of thousands
Tom Lane wrote on 17.07.2010 16:36:
Thomas Kellererspam_ea...@gmx.net writes:
I'm till a bit surprised that parsing the statement _with_ a column list is
mesurably slower than withou a column list.
Well, nobody's offered any actual *numbers* here. It's clear that
parsing the column list
Thomas Kellerer wrote on 17.07.2010 18:29:
Want to do some experiments?
Apparently there *is* a substiantial overhead, but I suspected the
sending of the raw SQL literal to be a major factor here.
(Server and JDBC program were running on the same machine)
In case any one is interested.
Out
Tom Lane wrote on 17.07.2010 19:35:
Thomas Kellererspam_ea...@gmx.net writes:
Tom Lane wrote on 17.07.2010 16:36:
Well, nobody's offered any actual *numbers* here.
I measured the runtime as seen from the JDBC client and as reported by explain analyze
(the last line reading Total runtime:)
Hi,
the explanation of the --inserts option of pg_dumps states that
The --column-inserts option is safe against column order changes, though even
slower.
The way I read this is, that
INSERT INTO table (column, ...) VALUES ...
is slower than
INSERT INTO table VALUES ...
Is that really
Tom Lane wrote on 16.07.2010 18:40:
Thomas Kellererspam_ea...@gmx.net writes:
the explanation of the --inserts option of pg_dumps states that
The --column-inserts option is safe against column order changes, though even
slower.
The way I read this is, that
INSERT INTO table (column,
Craig Ringer, 13.07.2010 05:11:
On 13/07/10 05:29, Thomas Kellerer wrote:
I would suggest to either manually change the autocommit mode from
within pg_upgrade or to add a note in the manual to disable/remove this
setting from psqlrc.conf before running pg_upgrade. Personally I think
the first
Thomas Kellerer, 12.07.2010 23:29:
Hi,
I'm trying pg_upgrade on my Windows installation and I have two
suggestions for the manual regarding pg_upgrade:
When specifying directories, pg_upgrade *requires* a forward slash as
the path separator. This is (still) uncommon in the Windows world
Thomas Kellerer, 12.07.2010 23:29:
Hi,
I'm trying pg_upgrade on my Windows installation and I have two
suggestions for the manual regarding pg_upgrade:
I found another problem and I'm not sure if this is a bug or a user error :)
My batch file to start pg_upgrade looks like
Bruce Momjian wrote on 12.07.2010 21:34:
Thom Brown wrote:
Could someone clarify the info in this paragraph:
Note that, due to a system catalog change, an initdb and database
reload will be required for upgrading from 9.0Beta1. We encourage
users to use this opportunity to test pg_upgrade for
Hi,
I'm trying pg_upgrade on my Windows installation and I have two suggestions
for the manual regarding pg_upgrade:
When specifying directories, pg_upgrade *requires* a forward slash as the path
separator. This is (still) uncommon in the Windows world (although Windows does
support it) and
Hi,
I'm trying to download the ZIP archive for Postgres 8.3 on Windows, but I can't
find a download location where I do not need to register with EnterpriseDB
When I go to http://www.enterprisedb.com/products/download.do and click on the Windows
link for Postgres 8.3 I end up on the Please
Dave Page, 09.07.2010 10:20:
So how do I download the binaries only (no installer) bundle of Postgres
8.3 for windows?
EnterpriseDB don't produce one for 8.3. There is a copy from the old
MSI installer at http://www.postgresql.org/ftp/binary/v8.3.11/win32/,
but it's not binary-compatible with
Dennis Gearon, 05.07.2010 23:43:
I belong to MANY email listservers, probably like all of us.
All of them, I am on digest.
The CONTENT from all of you contributors is superior, more mature,
and more directly helpful than all the other lists. I think it has
something to do with the
GrGsM, 06.07.2010 09:06:
Now i need a column in the same result of the query which shows the
difference between the two columns .
For Example :
the result shoud be
Closedate , status , NT028, NT031, NT050,NT062 , NT028-NT031
Please note the last column in bold, i need the difference .
Hi,
I was playing around with schemas and noticed that that the owner of a the
database (specified with the CREATE DATABASE command) is not the owner of the
database's public schema:
(Connect as super user)
c:\temppsql postgres postgres
Password for user postgres:
psql (8.4.3)
Type help for
Ravi Kariparmbil - Epistiuum Solutios, 28.06.2010 14:40:
Hello,
I am looking for a PostGre SQL trainer who can do a training program for
a client of mine in Bangalore.
I think this if off-topic here
And you should learn how to write the name correctly :)
Writing PostGre is like writing
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and
plan to watch a
John Gage, 25.06.2010 11:50:
Replying to my own post, and on further examination of the MySQL
documentation, I am astonished to discover that MySQL does not support
regular expressions much less something like tsvector. Please disabuse
me of this idea if I am mistaken.
Getting really off-topic
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and
plan to watch a
Thomas Kellerer, 25.06.2010 14:32:
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki
mai fawzy, 22.06.2010 10:38:
I have a table that has the following fields:
IDMoney Date State
1 20 2010-01-01 done
2 10 2010-01-02done
I need to select the values from this table to join them 2 another
select statement but the
David Goodenough wrote on 20.06.2010 11:08:
I don't support anyone has written a how to write database agnostic
code guide? That way its not a matter of porting, more a matter of
starting off right.
I don't believe in database agnostic code.
In the end it basically means that the application
Magnus Hagander, 07.06.2010 15:52:
Some AV software probably behaves fine.
Probably.
In case anyone is interested:
I have two development computers that run Postgres on Windows XP.
One with Avira the other with Sophos.
Neither has or had any problems installing or running Postgres
Regards
Magnus Hagander, 07.06.2010 16:15:
On Mon, Jun 7, 2010 at 15:58, Thomas Kellererspam_ea...@gmx.net wrote:
Magnus Hagander, 07.06.2010 15:52:
Some AV software probably behaves fine.
Probably.
In case anyone is interested:
I have two development computers that run Postgres on Windows XP.
Dennis Gearon wrote on 18.05.2010 19:05:
select * from pg_class where relkind IN IN (‘r’, ‘v’, ‘S’);
^^ ^ ^
You repeated the keyword IN, and you are using the wrong quotes (unless this is a
copy paste problem of a broken email client)
select *
Yan Cheng CHEOK, 17.05.2010 03:21:
Recently, I try to introduce my friend to use PostgreSQL.
However, he first impression is that. PostgreSQL is much slower
compared to MySQL. He realize he has to wait for 7 seconds, to create
a tmp database.
Why on earth would anybody compare database
Scott Marlowe, 17.05.2010 10:58:
Why on earth would anybody compare database performance using a command that
is usually executed only once in the lifetime of a database?
It's like saying The car from manufacturer A is slower than the one from
manufacturer B, because it takes 1 second longer to
Dino Vliet wrote on 16.05.2010 18:07:
Dear postgresql experts,
I want to know if postgresql has facilities for getting the first and or
the last in a by group.
Suppose I have the following table:
resnr,dep,arr,cls,dbd meaning reservationsnumber, departure station,
arrival station, the class
Richard Broersma wrote on 12.05.2010 17:45:
I'm considering using the windows version PostgreSQL in the following
conditions:
at least 10 years of up time (with periodic power failures= 1 a year)
I don't think you can get 10 years of up time on a Windows Server.
Most of the security patches
Ovid wrote on 09.05.2010 15:33:
My apologies. This isn't PG-specific, but since this is running on
PostgreSQL 8.4, maybe there are specific features which might help.
I have a tree structure in a table and it uses materialized paths to
allow me to find children quickly. However, I also need to
Sofer, Yuval wrote on 02.05.2010 09:27:
Hi
Postgres crashes with -
PG FATAL: could not reattach to shared memory (key=5432001,
addr=0210): Invalid argument.
The version is 8.2.4, the platform is win32
Does someone know the reason/workaround ?
I think this is supposed to be fixed with
Greg Smith wrote on 02.05.2010 01:16:
Scott Ribe wrote:
PG's locking scheme, MVCC, basically precludes certain specific
optimizations that means a small number of very specific queries don't
perform as well, while at the same time it means that throughput with
multiple simultaneous connections
Andy Colson wrote on 29.04.2010 23:51:
Here is my query, which works:
select organization,
state,
(select max(idate) from times where customers.custid=times.custid and
taskid = 27) as lastdate,
age( (select max(idate) from times where customers.custid=times.custid
and taskid = 27) )
from
Luís de Sousa, 26.04.2010 12:09:
Hello everyone,
I have an OpenOffice dabatase that I'd like to convert to Postgres.
More specifically I need to replicate tables, not null constraints,
primary keys, foreign keys, autonumbers and data. There's a tool that
does this with Microsoft databses:
dipti shah, 23.04.2010 13:17:
Thanks but I don't have text type in my table.
sysdb=# \d changelogtest
techdb=# INSERT INTO changelogtest (id, txid, txtime) values (5, 123, 'now')
except select id, txid, txtime
from changelogtest
where id=5;
'now' *is* a text type value
Thomas
--
Sent via
Andy, 21.04.2010 01:44:
No I haven't. I'm using MySQL right now. But I want to learn more
about Postgresql's Hot Standby and see if it offers a better
replication solution.
Can anyone share their experience about Postgresql replication
performance impact? Thanks.
You might be interested in
Ognjen Blagojevic, 21.04.2010 17:08:
More precisely, to run it without using TCP/IP port
No
and without installing as a service?
Yes (simply run pg_ctl manually from the command line)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
401 - 500 of 803 matches
Mail list logo