Hi, Stefan.
your second example should work for you.
INSERT INTO table_xx (field2, field3, field4) VALUES ('', '', '');
(keeping in mind, that your ID column is of type serial or has DEFAULT
NEXTVAL('some_sequence') ).
You can also insert values yourself:
INSERT INTO table_xx (ID, field2, fiel
am Mon, dem 16.06.2008, um 8:33:27 +0200 mailte Stefan Schwarzer folgendes:
> Hi,
>
> rahter dump question, I guess
>
> But I have a table with a sequential index field, into which I would
> like to add from time to time another line (via webbrowser), which in
> turn, stays first empty,
Hi,
rahter dump question, I guess
But I have a table with a sequential index field, into which I would
like to add from time to time another line (via webbrowser), which in
turn, stays first empty, before it's being filled in later (via
webbrowser).
Because the ID field is sequential
Hi,
I have been asked to specify a pair of HP PC's to set up a PostGreSQL server
(and backup) for a client. The HP model we are looking at has an AMD Phenom™
Quad Core Processor (9600B). The machines would be running Windows XP Pro (our
clients requirement). Can anyone tell me if PostgreSQL run
Peter Billen wrote:
> I would like to ask a question about outputting data as XML. Say I have two
> tables:
>
> team(integer id, text name);
> player_of_team(integer id, integer team_id, text name); (team_id is FK to
> team.id)
>
> I would like to query both tables to get following example XML outp
D. Dante Lorenso wrote on 15.06.2008 01:00:
I need a tool that will compare 2 database schemas and allow me to
migrate changes from one database to another. What tools do the rest of
you use to accomplish this task?
You can try my SQL Workbench/J:.
http://www.sql-workbench.net/manual/wb-comma
Hi Michael.
Thank you for your answer. I've checked - enable_nestloop is true. I did
ANALYZE, but that didn't help. The sequential scan is still used Any
more ideas why?
Julius Tuskenis
Michael Fuhr rašė:
On Sat, Jun 14, 2008 at 04:59:44PM +0200, Andreas Kretschmer wrote:
Julius T
加入简历库，让好工作找到你
信息时代，要的就是便捷。企业上网招人，浪费金钱，耽误时间。现在简单了，招聘人才上"中国行业人才网"（http://job.cnlinfo.net），一边招贤纳士，一边做生意，真正的一站通。
一、企业招聘：在中国行业人才网（http://job.cnlinfo.net）招聘，省时省力，自由彰显公司实力：1、免费，现在真的有免费的午餐了！2、开通网上商铺，展示公司形象，产品，让求职者投放简历更准确。3、招聘之外可进行电子商务，一边招兵买马一边做网上生意。说不定浏览您的招聘信息的，就是您将来的潜在客户！
只需三分钟，现在就免费注册吧：http://cnlinfo.ne
Hello, Tom.
So I think the OP's
problem is purely a statistical one, or maybe he's in a situation where
he should reduce random_page_cost.)
What could be done solving that "statistical problem"? :) Current value
for random_page_cost is 4. What value would you suggest?
Julius Tuskenis
-
All,
I used to rave about how great the EMS PostgreSQL tools were, but lately
I've been disappointed by the lack of support for their Database
Comparer 2007 for PostgreSQL.
I need a tool that will compare 2 database schemas and allow me to
migrate changes from one database to another. What
Michael Fuhr <[EMAIL PROTECTED]> schrieb:
> On Sat, Jun 14, 2008 at 04:59:44PM +0200, Andreas Kretschmer wrote:
> > Julius Tuskenis <[EMAIL PROTECTED]> schrieb:
> > > I have a question concerning performance. One of my queries take a long
> > > to execute. I tried to do "explain analyse" and I s
11 matches
Mail list logo
