I was trying to dump data, drop then recreate table, and import data
back to the table. There were errors during the process and the
transaction was not committed.
The table is there when I do '\d' and the table definition is there.
However, I can't drop table nor select from this table. I always
"Michael Richards" <[EMAIL PROTECTED]> writes:
> Perhaps someone on the team could comment on this.
I doubt that whoever added pg_dump's sequence support thought very hard
about the "dump data only" case. Feel free to propose a different
behavior, especially if you're prepared to implement it ;-
> As I mentioned earlier, your solution worked great. I am a bit
> puzzled about the syntax that is created by my old method, using
> "pg_dump -D -u -a". I wonder why it creates "create sequence ..."
> commands instead of "update sequence ..."?
That is a good question. I do not know the answer
Hi:
Does anybody knows if the JDBC driver maps the
new SQL 3 types (ARRAY and STRUCT) with the proprietary array and user-defined
types of PostgreSQL? To put it another way: when I access an array (for
instance) in PostgreSQL through the JDBC driver, does the driver returns a SQL
3 ARRA
"Thomas Lockhart" <[EMAIL PROTECTED]> replied to:
"Itai Zukerman" <[EMAIL PROTECTED]>
> > I'm currently doing this:
> > SELECT symbol, date_trunc('minute', posted),
> > min(price), max(price), avg(price)
> > FROM trade
> > GROUP BY symbol, date_trunc('minute', posted);
> > to get a
> > SELECT symbol, date_trunc('minute', posted),
> > min(price), max(price), avg(price)
> > FROM trade
> > GROUP BY symbol, date_trunc('minute', posted);
Hmmm... I'm not sure how to go about doing this for, say, 5 minute
intervals. Basically, I want a function:
date_round( time
> I'm currently doing this:
> SELECT symbol, date_trunc('minute', posted),
> min(price), max(price), avg(price)
> FROM trade
> GROUP BY symbol, date_trunc('minute', posted);
> to get a list of minute-averages of trade prices. I get the feeling
> that this is bad form, that I should
Hi,
I'm currently doing this:
SELECT symbol, date_trunc('minute', posted),
min(price), max(price), avg(price)
FROM trade
GROUP BY symbol, date_trunc('minute', posted);
to get a list of minute-averages of trade prices. I get the feeling
that this is bad form, that I should be doi
On Tue, Aug 01, 2000 at 02:32:27PM -0400, Michael Richards wrote:
> I would consider running:
> pg_dump -D -u -c -f backup.dump
> This will dump the schema and drop the objects before creating them.
> -Michael
>
> > 4) I run pg_dump this way: "pg_dump -D -u -a -f backup.dump
> > main_v0_6" in ord
>>> Daryl Herzmann <[EMAIL PROTECTED]> 01.08.2000 22.38 Uhr >>>
> Hello,
> I hope this question is not too novice for this group.
>
> I have a table
>
> portfolio=# \d questions
> Table "questions"
> Attribute |Type | Modifier
10 matches
Mail list logo
