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 don
-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, warehousen
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
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
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 messag
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 wan
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 ids
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] unexpecte
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, "Store
