[pgadmin-support] On 19010 pgAdmin doesn't run

[Ezequias Rodrigues da Rocha]

Hi list,

My computer is with a baterry problem and sometimes the Year of Windows
shows 19010.

On this date PgAdmin doesn't run. I don't know if you already noticed it but
you could try.

Regards ...

--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/

Re: [pgadmin-support] On 19010 pgAdmin doesn't run

[Andy Shellam]

I would like more to why your computer shows 19010 as the year, as 
that's a completely invalid date.  I don't think Windows currently 
handles years after 2099.


I don't know what the developers think, but I think this is a problem 
outside of the developer's control.


Andy.

Ezequias Rodrigues da Rocha wrote:

Hi list,

My computer is with a baterry problem and sometimes the Year of 
Windows shows 19010.


On this date PgAdmin doesn't run. I don't know if you already noticed 
it but you could try.


Regards ...

--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/ 
 !DSPAM:37,45f400a4103001014560638! 



---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[pgadmin-support] Alternative Serial

[Ezequias Rodrigues da Rocha]

Hi list,

I know that serials must be created like this.

Create the Serial

Create a field table and reffers to the pre-created serial.

Now I noticed that it is possible to use the default value. I am almost
quite sure that this is an alternative way and non polite.

I would like to know if I am correct and what does it means:

nextval('mySerial_id'::regclass)

What is regclass ?

Regards ,
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/

Re: [pgadmin-support] On 19010 pgAdmin doesn't run

[Ezequias Rodrigues da Rocha]

Ok,

Thank you.
Ezequias

2007/3/11, Andy Shellam <[EMAIL PROTECTED]>:


I would like more to why your computer shows 19010 as the year, as
that's a completely invalid date.  I don't think Windows currently
handles years after 2099.

I don't know what the developers think, but I think this is a problem
outside of the developer's control.

Andy.

Ezequias Rodrigues da Rocha wrote:
> Hi list,
>
> My computer is with a baterry problem and sometimes the Year of
> Windows shows 19010.
>
> On this date PgAdmin doesn't run. I don't know if you already noticed
> it but you could try.
>
> Regards ...
>
> --
> Ezequias Rodrigues da Rocha
> http://ezequiasrocha.blogspot.com/
> use Mozilla Firefox:http://br.mozdev.org/firefox/
>  !DSPAM:37,45f400a4103001014560638!





--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/

Re: [pgadmin-support] Alternative Serial

[Milen A. Radev]

Ezequias Rodrigues da Rocha написа:
> Hi list,
> 
> I know that serials must be created like this.

Actually no.

> Create the Serial

There is no db object 'Serial' you could create independently - you
probably mean 'sequence'.

> 
> Create a field table and reffers to the pre-created serial.

You could and should create a field of (pseudo-)type 'serial' and be
done with it.

> 
> Now I noticed that it is possible to use the default value. I am almost
> quite sure that this is an alternative way and non polite.


The old and still working way to create a field that would function as
surrogate key is to create a sequence, create a field in the table, mark
it integer and set its default value to be the 'nextval' of the created
sequence. That was too much typing for some (I'm included) and later a
syntax sugar was added - the pseudo-type 'serial'.

So the following syntax:

CREATE TABLE example (
   example_sid SERIAL NOT NULL PRIMARY KEY,
   ...
)

is equivalen to:


CREATE SEQUENCE example_example_sid_seq;

CREATE TABLE example (
   example_sid INTEGER PRIMARY KEY DEFAULT
NEXVAL)('example_example_sid_seq'),
   ...
)


As you could see - very convenient for the 99.9% of the cases.

> 
> I would like to know if I am correct and what does it means:
> 
> nextval('mySerial_id'::regclass)
> 
> What is regclass ?

Read here about 'regclass' (there is a note about it) -
http://www.postgresql.org/docs/8.2/static/functions-sequence.html, but
that should not be important to you.


-- 
Milen A. Radev


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [pgadmin-support] Alternative Serial

[Ezequias Rodrigues da Rocha]

Yes you are right, I means sequences.

The second way is better for me that have Id (PK) fields not  defined  as
Sequences. Now it is much more difficult to change the  type of my PK than
define a Default value. I am just concerned about the consistency of this
sequence. Could you make me more easy ?

And about the cast I have found ?

nextval('mySerial_id'::regclass)

I ask again. What is regclass ? What does it really is.

Ezequias

2007/3/11, Milen A. Radev <[EMAIL PROTECTED]>:


Ezequias Rodrigues da Rocha написа:
> Hi list,
>
> I know that serials must be created like this.

Actually no.

> Create the Serial

There is no db object 'Serial' you could create independently - you
probably mean 'sequence'.

>
> Create a field table and reffers to the pre-created serial.

You could and should create a field of (pseudo-)type 'serial' and be
done with it.

>
> Now I noticed that it is possible to use the default value. I am almost
> quite sure that this is an alternative way and non polite.


The old and still working way to create a field that would function as
surrogate key is to create a sequence, create a field in the table, mark
it integer and set its default value to be the 'nextval' of the created
sequence. That was too much typing for some (I'm included) and later a
syntax sugar was added - the pseudo-type 'serial'.

So the following syntax:

CREATE TABLE example (
   example_sid SERIAL NOT NULL PRIMARY KEY,
   ...
)

is equivalen to:


CREATE SEQUENCE example_example_sid_seq;

CREATE TABLE example (
   example_sid INTEGER PRIMARY KEY DEFAULT
NEXVAL)('example_example_sid_seq'),
   ...
)


As you could see - very convenient for the 99.9% of the cases.

>
> I would like to know if I am correct and what does it means:
>
> nextval('mySerial_id'::regclass)
>
> What is regclass ?

Read here about 'regclass' (there is a note about it) -
http://www.postgresql.org/docs/8.2/static/functions-sequence.html, but
that should not be important to you.


--
Milen A. Radev


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org





--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/

Re: [pgadmin-support] Alternative Serial

[Milen A. Radev]

Ezequias Rodrigues da Rocha написа:
> Yes you are right, I means sequences.
> 

Please re-read my reply!

> The second way is better for me that have Id (PK) fields not  defined  as
> Sequences. Now it is much more difficult to change the  type of my PK than

A field could not be defined as 'sequence', but as 'serial', because
'sequence' is a db object and 'serial' is a (pseudo-)type. The actual
type of a field defined as 'serial' is 'integer' (or 'bigint' in case of
'bigserial'). You could change the type of a field (defined as sequence
earlier) as easy as you could any other field. Or you could just change
its default value. Or anything else.

> define a Default value. I am just concerned about the consistency of this
> sequence. Could you make me more easy ?

What do you mean by 'consistency' here? Guaranteed uniqueness of the
numbers generated by the sequence? Pleas read the fine documentation
here - http://www.postgresql.org/docs/8.2/static/sql-createsequence.html.


> 
> And about the cast I have found ?
> 
> nextval('mySerial_id'::regclass)
> 
> I ask again. What is regclass ? What does it really is.

I already answered that one, please re-read my reply and the pages it
mentions.

[...]



-- 
Milen A. Radev


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

[pgadmin-support] Build wxWidgets-2.8.0 in Cygwin

[QuanZongliang]

hi!
 
I had compiled wxWidgets-2.8.0 in Cygwin with command:
./configure --with-gtk --enable-gtk2 --enable-unicode --enable-mimetype=no
but got warning message:
checking for backtrace() in ... noconfigure: WARNING: 
backtrace() is not available, wxStackWalker will not be available
 
Can the pgAdmin be built without wxStackWalker?
How to correct it?
 
Thanks
Quan