Hi,
I am trying to port from oracle database to postgres. I was not able to
port Oracle synonyms to postgres. I appriciate if anybody can give a
solution.
Thanks and Regards
Sachdev
-
This email was sent using DACafeMail.
Get Your FREE 25 MB eMail Accoun
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Olivier Hubaut wrote:
| Hi,
|
| I need to use the cross database reference form some select closes. I've
| install PG 7.3.4 using the 'make all' option, but it seems that the
| functionnality isn't set anyway.
|
| Is there another package I need to inst
Olivier Hubaut wrote:
Hi,
I need to use the cross database reference form some select closes. I've
install PG 7.3.4 using the 'make all' option, but it seems that the
functionnality isn't set anyway.
Is there another package I need to install or some commands I need to do?
You can do db cross s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I used to run oid2name to find the relation between database names and
> .../data/base/ but i'm interested also to identify relation between table
> names, index names and files number as would try to decrease Wait I/O by
> setting tables on one
I think you have misunderstood... autocommit works as it always has in
7.4, the difference is that the logic to turn it off is now left to the
client side instead of trying to manage it within the server.
ie.
phppgadmin=# select version();
version
On Mon, Dec 08, 2003 at 18:36:57 +0530,
Somasekhar Bangalore <[EMAIL PROTECTED]> wrote:
> There is no harm in having a field size of 1000 character provided u use the proper
> datatype. Don't user char(1000). Try using varchar(1000).
And if the 1000 limit is just a large number you picked rathe
I never thought of something like this, but it's a good question.
I will look in the next days to this problem, if I find something I will
post it.
Post on the forum, everyone may be interested.
Best Regards.
Andy.
- Original Message -
From: "Ashok Chauhan" <[EMAIL PROTECTED]>
To: "An
On Mon, 2003-12-08 at 13:55, Ashok Chauhan wrote:
> I make the following code with the make command but give the following
> the errors:-
>
> /tmp/ccUWs9W9.o: In function `main':
> /tmp/ccUWs9W9.o(.text+0x19): undefined reference to `PQconnectdb'
> /tmp/ccUWs9W9.o(.text+0x2f): undefined reference
hi
*
# include
# include
# include
# include
int main()
{
PGresult *result;
PGconn *conn;
int feild;
conn = PQconnectdb ("ashok");
result = PQexec (conn, "select * from bill");
feild = PQntuples (result);
p
Hi,
I don't know if there is such a command, with my experience I think there
isn't such one.
Do you need it for all the tables?? Put a field like timestamp and put the
default value: now()... it will update automatically, so you don't have to
bother with it.
Best Regards.
Andy.
- Original M
hi
there is any command to see the timestamp of any record that is stored
in a table already.
Except that add a field of timestamp type in that table.
plz help me.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
There is no harm in having a field size of 1000 character provided u use
the proper datatype. Don’t user char(1000). Try using varchar(1000).
For character data it is recommended to
use the VARCHAR type, since PostgreSQL manages it very well. On the
contrary, if you use the CHAR dataty
If you define the field as CHAR, 1000 bytes will be consumed.
If you define the field as VARCHAR, on sufficient bytes to store the contents will be used.
Marc
--Original Message Text---
From: Ganesan Kanavathy
Date: Mon, 8 Dec 2003 20:56:06 +0800
Clean Clean DocumentEmail MicrosoftI
Can anyone
tell me, what harm would setting a field size to 1000 characters do to the size?
By increasing the size, will the
database require more space? Or does it only consume space if there is data in
the field only?
Regards,
Ganesan
Hi the list,
I used to run oid2name to find the relation between database names and
.../data/base/ but i'm interested also to identify relation between table
names, index names and files number as would try to decrease Wait I/O by
setting tables on one disk and indexes on another one.
The tables p
Hi,
I need to use the cross database reference form some select closes. I've
install PG 7.3.4 using the 'make all' option, but it seems that the
functionnality isn't set anyway.
Is there another package I need to install or some commands I need to do?
Thanks,
--
Ci-git une signature avortee.
16 matches
Mail list logo
