firstest doubts...

Roberto (SmartBit) wrote:

Hi all,

I'm beginning in PosgreSQL and until now I may say that it is incredible ...

I have some sort asks ... and ... I hope be helped here.
so, first of all I should say that I am coming from Interbase, then:

1: There is any Postgres Language to InterBase like pgPL-SQL???

Yes, PL/pgSQL.

2: There is any tools to convert from Interbase to Postgres???

Yes, see:

http://techdocs.postgresql.org

3: There is any Case tool like ER-Win that is compatible with Postgres??

No, but we do support ER-Win. Dbaccess is nice at dbaccess.org.

4: The Interbase's DOMAIN is the same thing as Postgres's TYPES ?? And could
I create a TYPE without set an INPUT/OUTPUT function??
(ex. CREATE DOMAIN myDomain NUMERIC(12,2)

We have DOMAIN in 7.3beta.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Hi all

Like I told before I'm beginning to work with Postgre... (for while living
in a paradise)
My next step is work with ASTA ... so, I'd like to know if anyone have an
AstaServer for Postgres? ... it may be using Zeos components connection or
any other...

TIA

Roberto de Amorim - +55 48 346-2243
software engineer at SmartBit Software
Delphi and Interbase consultant

hi all

How could I do to get de User Tables, System Tables, Stored Procedures,
Trigger, Views, etc???
I'd like to do the same as pgAdmin ... using a TreeView at left and at rigth
I'll show the items...

TIA

Roberto de Amorim

On 10 Oct 2002 at 5:31, Roberto (SmartBit) wrote:

How could I do to get de User Tables, System Tables, Stored Procedures,
Trigger, Views, etc???
I'd like to do the same as pgAdmin ... using a TreeView at left and at rigth
I'll show the items...

It's all there in pg meta data. Tora is one way I have discovered today to get
that information easily..

Bye
Shridhar

--
QOTD: Flash! Flash! I love you! ...but we only have fourteen hours to save
the earth!

How could I do to get de User Tables, System Tables, Stored Procedures,
Trigger, Views, etc???
I'd like to do the same as pgAdmin ... using a TreeView at left and at

rigth

I'll show the items...

It's all there in pg meta data. Tora is one way I have discovered today to

get

that information easily..

Sorry my ignorance, but, what is "Tora"???
How do I do to get the pg meta data using delphi??

I'm trying to do something like pgAdmim ....

Roberto de Amorim

Why not just grab the source code from pgAdmin and look at how it does
the sql calls. Actually you can probably just do psql -E and get the
source of the \d commands

Robert Treat

On 10 Oct 2002 at 7:57, Roberto (SmartBit) wrote:

Sorry my ignorance, but, what is "Tora"???

It's an application which stands for Tool for Oracle developers

How do I do to get the pg meta data using delphi??

I guess you have to fire direct queries against PG metadata.

I'm trying to do something like pgAdmim ....

Well there are other applications which do similar things. I remember seeing
couple of apps. in Qt and on windows to dig in PG metadata. Google around for
pgaccess and windows.

HTH

Bye
Shridhar

--
Ralph's Observation: It is a mistake to let any mechanical object realise that
you are in a hurry.

Yep, I've got my own custom Asta server up and running using the Zeos
components. I'm not too thrilled with Zeos though, and I've been
contemplating creating my own set. *If* I ever find the time.

If you have any questions about it, feel free to send me private email.

Greg

----- Original Message -----
From: "Roberto (SmartBit)" <roberto@smartbit.inf.br>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, October 09, 2002 3:32 PM
Subject: [GENERAL] Asta with PostgreSQL

Hi all

Like I told before I'm beginning to work with Postgre... (for while living
in a paradise)
My next step is work with ASTA ... so, I'd like to know if anyone have an
AstaServer for Postgres? ... it may be using Zeos components connection

or

"Gyorgy Molnar" <yuri@powercom.com.sg> writes:

I got an empty string for result. I think I got this result because the
string concatenation ("||") was created with "isstrict" flag. In this case
it will give back NULL object if one of the arguments was NULL object.

Actually, you got back a NULL, not an empty string. There is a big
difference (even if Oracle confuses the two concepts).

Is this feature will change in the future?

No. That's what the SQL standard says to do, and that's what we plan to
keep doing. You can make your own nonstandard concatenation function
if you feel like it, though.

regards, tom lane

plase take a look to the following small sample

CREATE FUNCTION test(TEXT) RETURNS TEXT AS '
DECLARE
cmd TEXT;
BEGIN
RETURN cmd || ''Hello'';
END;
' LANGUAGE 'plpgsql';

When I execute the function

select test('');
test
------

(1 row)

I got an empty string for result. I think I got this result because the
string concatenation ("||") was created with "isstrict" flag. In this case
it will give back NULL object if one of the arguments was NULL object.

In most of the cases I think it is ok, but specially for the string
concatenation is not really convinient.

Is this feature will change in the future? Any "smart" solution for this
problem? - I cannot use the IF..ENDIF statement before each string
concatenation, I have too many in my code.

Best Regards,
Yuri

I got an empty string for result. I think I got this result because the
string concatenation ("||") was created with "isstrict" flag. In this

case

it will give back NULL object if one of the arguments was NULL object.

Actually, you got back a NULL, not an empty string. There is a big
difference (even if Oracle confuses the two concepts).

Is this feature will change in the future?

No. That's what the SQL standard says to do, and that's what we plan to
keep doing. You can make your own nonstandard concatenation function
if you feel like it, though.

I see. I think the best way if I make my own concatenation operator and use
it as a temporary fix. In the long-run the best way to avoid this kind of
problems by desing at the beginning of the projects.
Thank you for your help.

Best Regards,
Yuri

Hi All,

I just wanted to know is it possible to create indexes on view and update
statement in postgres.
--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------

Hi all,

I have created the indexs on some table but still I am not getting the
performance as required.Some sql statements are taking very long time to
execute.

Is there any way to analyse the performance in postgre,I am able to analyses
it in MSSQL.

On 28 Oct 2002 at 11:52, Savita wrote:

Hi all,

I have created the indexs on some table but still I am not getting the
performance as required.Some sql statements are taking very long time to
execute.

Is there any way to analyse the performance in postgre,I am able to analyses
it in MSSQL.

What does explain tells about the query?

Bye
Shridhar

--
Robot, n.: University administrator.

Using explain I am not able to get the detailed information.

I want to know abotu optimizing the postgre.

Shridhar Daithankar wrote:

On 28 Oct 2002 at 11:52, Savita wrote:

Hi all,

I have created the indexs on some table but still I am not getting the
performance as required.Some sql statements are taking very long time to
execute.

Is there any way to analyse the performance in postgre,I am able to analyses
it in MSSQL.

What does explain tells about the query?

Bye
Shridhar

--
Robot, n.: University administrator.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------

On Mon, 28 Oct 2002, Savita wrote:

Using explain I am not able to get the detailed information.

What information are you looking to get?

Hi,

I was looking for something like this.

InMssql when I use a query like selece a,b from some table where
a.x=b.y,then if a is having say 30000 records and b is having 4 records then
it will compare all the 30000 records with the 4 records one by one,but if I
make it where b.y=a.x then it will be faster.

I know with index I could increase the performance by 50 %,but what other
possibilities are there to improve the performance

Stephan Szabo wrote:

On Mon, 28 Oct 2002, Savita wrote:

Using explain I am not able to get the detailed information.

What information are you looking to get?

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------

Hi,
i try to insert some information on database but when i arrive near 60 000
insertion i lose some information
how i can know why i lose information?
Is there a limit on database?

thanks
Florian

On Mon, Oct 28, 2002 at 10:18:53AM +0100, Florian Litot wrote:

Hi,
i try to insert some information on database but when i arrive near 60 000
insertion i lose some information
how i can know why i lose information?
Is there a limit on database?

There is no limit. You are obviously misunderstanding something. Please
supply the list with more details.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/