> I think you should just go with what Vadim suggested and use:
> select currval('my_sequence');
> This will be the same within a transaction, even if there is another
> transaction using the same sequence.
Sorry, I wasn't thinking of it happening in the same transaction. In that
case
> At 2:58 +0300 on 29/7/98, Andrew Gibson wrote:
>
> > Has anyone achieved Macintosh connectivity to PostgreSQL?
> >
> > If so, any details would be appreciated i.e. which ODBC driver
>
> Not by ODBC, but generally you can do it with Java or TCL. I had a bit of a
> problem with the TCL interface,
> The other problem with trying to implement RAW devices, and,
> granted, I could be over cmplicating it, but how do you implement it
> across X operating systems running Y platforms? Doesn't each of them
> access drives differently? And, in some cases, multiply that by two for
> IDE vs
>
>
> I don't like doing that because I don't want to store the entire
> name in every other table which needs to be linked with this one.
> So, for instance, in the table that keeps track of what authors go
> to what book, I want it to just have two fields, the Book's primary
> key and the Autho
> I think only doing it the SQL way would be fine. Documentation would, of
> course, have to cover it
That last sentence says it all..."Documentations would, of course, have to cofver
it." The reason I used createdb to generate the my database, is that is what the
man page said to do. Unfortun
> > My experience with paid support vs mailings lists tends to have me
> > much preferring mailing lists. At least on a mailing list, you have a
> > good chance of finding someone that has already hit that same problem.
>
>
Actually, I tend to end up supporting the product for which I am
> Use following syntax:
> alter table rename to
>
>
I don't think that will work for the entire database. Remember a table is
part of the database. So I don't think alter will change the actual
database's name...
> >
> > How do I rename an existing database? Is it enough to just rename the
