On Thursday 25 October 2001 03:41, John Hasler wrote:
> Josh writes:
> > I'm sure you could make your own GUID, whatever one is.
>
> Globally Unique IDentifier, probably. Just hash a 128 bit random number
> with the current date.
That gives you no gurantee it will be unique.
What we are using i
On Wed, 24 Oct 2001, Joseph Shraibman wrote:
> Can I just set tgenabled to false?
I'm not sure if it works now (in 7.2 devel) but I'm pretty
sure that doesn't work in past versions unfortunately.
---(end of broadcast)---
TIP 5: Have you checked
Can I just set tgenabled to false?
Stephan Szabo wrote:
> On Tue, 23 Oct 2001, Joseph Shraibman wrote:
>
>
>>I have to drop a froeign key from one of my tables. The problem is that I have
>another
>>table that has a foreign key on the first one, so I can't do the select to
>temp-table
>>
Josh writes:
> I'm sure you could make your own GUID, whatever one is.
Globally Unique IDentifier, probably. Just hash a 128 bit random number
with the current date.
--
John Hasler
[EMAIL PROTECTED]
Dancing Horse Hill
Elmwood, Wisconsin
---(end of broadcast)
Hi.
I'm trying to write a select statement that does the following;
select all tables in my database;
for each table, select all columns, and tell me if the column is a
primary key
in the table.
I've tried this by querying pg_class, pg_index and pg_attribute, but I
have a problem when I this
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> Please do not cross-post to two different lists. It annoys those of us
> who are subscribed to both lists, and you are less likely to get help.
Just FYI, the Postgres mail server has a very nifty feature you can set
so that you get only one copy of cro
thanks. your reply
--
""Josh Berkus"" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó·s»D
:[EMAIL PROTECTED]
> Guard,
>
> First, this kind of beginner question is more appropriate for the NOVICE
> list.
>
> > IF update table set field='c:\windows'
> > but
> >
> > c:\windows -> c:windows
>
> That's because "\"
dear all
I want lock full tables,how to write SQL command?
thanks
--
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Dinesh,
Please do not cross-post to two different lists. It annoys those of us
who are subscribed to both lists, and you are less likely to get help.
> Is there any concept of sys_Guid in postgres.
> If yes what is that ??
> As i am using GUID in sql and oracle, then what is counterpart of
> t
Hey, Dado,
> Hi Josh!
> Once you have your usq, how do you get more info about that row?
> How do you know which table it came from?
Well, if you have to go at it from that angle (hey, I have this USQ,
where did it come from) then you're in trouble. However, I never use it
that way. Let me giv
create table mytable (
myfield serial primary key,
myotherfield integer);
Using the SERIAL data type automatically creates the sequence and default
statements for you.
-Original Message-
From: Mayuresh Kadu [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:36 AM
To: [EMAIL PROT
From [EMAIL PROTECTED] Tue Oct 23 18:33:27 2001
Content-Disposition: inline
From: "Aasmund Midttun Godal" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] PL/pgSQL triggers ON INSERT OR UPDATE
Date: Tue, 23
On Tue, 23 Oct 2001, Joseph Shraibman wrote:
> I have to drop a froeign key from one of my tables. The problem is that I have
>another
> table that has a foreign key on the first one, so I can't do the select to
>temp-table
> thing and move it back.
>
> Is there any way I can remove it by
Hi,
Is there any concept of sys_Guid in
postgres.
If yes what is that ??
As i am using GUID in sql and oracle, then
what is counterpart of this in postgres. It is urgent.
Thanks in advance
Bye
Dinesh Parikh
14 matches
Mail list logo
