Hi,
I have read the instruction, change warehouseid to text, spend several hours
to test many option but it doesn't help.
This is the new query :
SELECT *
FROM crosstab(
'SELECT produkid, warehousename, onhand
FROM vwtest
ORDER BY 1,2')
AS ct (Produkid text, Store1
Hello,
I'm trying to restore a database dumpfile I made of a small 9.3.4 database
using pg_dump -Fc -v -f db.dump db, but when I try to restore it on the
same or on another 9.3.4 system with pg_restore -C -d postgres db.dump I
get the following error message:
pg_restore: [archiver] unexpected
Hi,
I think I can find out the transaction ids of concurrent transactions
older than the current one by:
select * from txid_snapshot_xip(txid_current_snapshot())
union
select * from txid_snapshot_xmax(txid_current_snapshot());
Now, I want to map these transaction ids to backend process
On 25/04/14 13:26, Torsten Förtsch wrote:
I think I can find out the transaction ids of concurrent transactions
older than the current one by:
select * from txid_snapshot_xip(txid_current_snapshot())
union
select * from txid_snapshot_xmax(txid_current_snapshot());
Now, I want to
matthias.trauf...@bd.zh.ch writes:
I'm trying to restore a database dumpfile I made of a small 9.3.4 database
using pg_dump -Fc -v -f db.dump db, but when I try to restore it on the
same or on another 9.3.4 system with pg_restore -C -d postgres db.dump I
get the following error message:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/25/2014 12:19 AM, Hengky Liwandouw wrote:
I have read the instruction, change warehouseid to text, spend
several hours to test many option but it doesn't help.
Please send a complete, self-contained test case which reproduces your
error. By
Joe,
Thanks to give me the right direction to get help. Okay, here is the detail.
CREATE table test (id SERIAL, produkid TEXT, warehousename TEXT, onhand
INTEGER);
COPY test (id, produkid, warehousename, onhand) FROM stdin;
1 279140414 OFFICE 10
2 279140421 STORE2 10
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
(resending to the list as well for the sake of the archives)
On 04/25/2014 08:53 AM, Hengky Liwandouw wrote:
Thanks to give me the right direction to get help. Okay, here it
the detail.
CREATE table test (id SERIAL, produkid TEXT, warehousename
Hmm no, I wasn't able to find it. So I definitely didn't restart it in the
interim.
I'm thinking I must have used the command incorrectly since I didn't really
understand what it was doing. Maybe I invoked it from the wrong place? But
I was at the root, according to the prompt I pasted, so I
