? JPA SequenceGenerator and GeneratedValue: name / generator property unique only per class?

I use JPA + OpenJPA with PostgreSQL as backend RDBMS. The primary keys of my tables usually consist of a SERIAL / BIGSERIAL column. So PostgreSQL automatically generates IDs for new entries (strategy=
 ? Autogenerated primary key in postgresql which skips existing ones

I have existing entries in a table with primary keys starting with 300 and ending at 400. Now I would like to insert new entries with an auto generated primary key. The generation should skip the exi
 ? Autogenerated primary key in postgresql which skips existing ones

I have existing entries in a table with primary keys starting with 300 and ending at 400. Now I would like to insert new entries with an auto generated primary key. The generation should skip the exi
 ? Autogenerated primary key in postgresql which skips existing ones

I have existing entries in a table with primary keys starting with 300 and ending at 400. Now I would like to insert new entries with an auto generated primary key. The generation should skip the exi
 ? 'No Primary Key' error with INNER JOIN query in PostgreSQL

The thing is, both tables do have primary keys, and I haven't had any problems so far with any other standard SELECTS/INSERTS at all. I'm new to JOINS, but I can't see why this isn't working.I'm get t
 ? postgreSQL primary / foreign key not complying

Hi i current have two table a member table with the usual.members tablemember_id SERIAL, first_name varchar(20)last_name varchar(20).I have a second tableplannerday as varchartime as varcharactivity v
 ? CREATE TABLE AS with PRIMARY KEY in one statement (PostgreSQL)

Is there a way to set the PRIMARY KEY in a single "CREATE TABLE AS" statement?Example - I would like the following to be written in 1 statement rather than 2: CREATE TABLE "new_table_name" AS SELECT a
 ? How to insert a primary/foreign key row in PostgreSQL

I'm populating a database in PostgreSQL for a Newspaper Online. Now my doubt lies on how to insert a value into a table which only attribute is both a primary and a foreign key. In this context, the a
 ? How to fill a nullable integer column and convert it into a serial primary key in Postgresql?

My table contains an integer column (gid) which is nullable: gid | value------------- 0 |  a | b 1 | c 2 | d | eNow I would like to change the gid column into a SERIAL primary k
 ? Autogenerated primary key in postgresql with clsql

I'm trying to make a simple database with Common Lisp ORM. I use PostgreSQL and CLSQL. I could create classes and generate tables, but it doesn't work when I want to insert a value without primary key
 ? Displaying web based visualisation or graphing of data based on a postgresql database?

I am working on a web application for a client that uses a postgresql database. I want the client to be able to go to a certain area of the site where the data from the database is displayed in graph
 ? Single quotes stored in a Postgres database

I've been working on an Express app that has a form designed to hold lines and quotes. Some of the lines will have single quotes('), but overall it's able to store the info and I'm able to back it up
 ? Single quotes stored in a Postgres database

I've been working on an Express app that has a form designed to hold lines and quotes. Some of the lines will have single quotes('), but overall it's able to store the info and I'm able to back it up
 ? Single quotes stored in a Postgres database

I've been working on an Express app that has a form designed to hold lines and quotes. Some of the lines will have single quotes('), but overall it's able to store the info and I'm able to back it up
 ? Insert text with single quotes in PostgreSQL

I have a table test(id,name).I need to insert values like: user's log, 'my user', customer's. insert into test values (1,'user's log'); insert into test values (2,''my users''); insert into test valu
 ? Comparing two postgres dump files

How to compare postgres dump files?I have two dump files, dump1 and dump2 . And I want to compare these two dump files.Any help will be appreciated..Thank you You can use beyond compare if windows

Page 1 of 302  |  Show More Pages:  Top Prev Next Last